Oracle Oracle Certifications 1Z0-074 Questions & Answers

• Question 61:

  The ORCL CDB has a PDB, ORCL_PDB. Examine these parameters in ORCL:

  

  Examine these parameters in ORCL_PDB:

  

  You switch to ORCL_PDB and plan to execute these commands:

  

  What will be the outcome?

  A. SGA_TARGET is set to 600M. The other values remain unchanged in both ORCL and ORCL_PDB.

  B. SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB. The other values remain unchanged in both ORCL and ORCL_PDB.

  C. SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB. SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to 200M in ORCL.

  D. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.

  E. Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.

  SGA_TARGET size is changed to 600 M.

  Correct Answer: D

• Question 62:

  Which statement is true about transportable tablespaces?

  A. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.

  B. The cannot be dictionary-managed tablespaces

  C. The source tablespace can be encrypted D. They can be administrative tablespaces such as SYSTEM or SYSAUX

  Correct Answer: A

• Question 63:

  You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks. Which statement is true about limiting PGA usage for those users' sessions?

  A. You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.

  B. You cannot limit PGA for a set of database user sessions.

  C. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.

  D. You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.

  E. You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

  Correct Answer: C

  Reference: https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1

• Question 64:

  In your database, DEFERRED_SEGMENT_CREATION is set to TRUE. You successfully execute this command:

  

  Which statement is true about the space allocated to the SALES_2016 table?

  A. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.

  B. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.

  C. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.

  D. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.

  E. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.

  Correct Answer: A

• Question 65:

  Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

  A. ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.

  B. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.

  C. ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.

  D. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.

  E. ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.

  Correct Answer: DE

• Question 66:

  The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2.

  USER1 is a local user in PDB1 and has the SYSBACKUP privilege.

  Connect descriptors for PDB1 and PDB2 are mapped to TNS aliases pdb1 and PDB2 in tnsnames.ora.

  Examine these commands executed by USER1 when all PDBs are open:

  

  What is the outcome and why?

  A. An error is returned because the user is connected to a pluggable database.

  B. The current date is displayed.

  C. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax: SQL"".

  D. An error is returned because the user is not SYS.

  E. An error is returned because the user is not a common user.

  Correct Answer: C

• Question 67:

  To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

  A. number of network interface cards (NICs)

  B. number of database instances

  C. number of CPUs

  D. amount of RAM

  E. number of storage LUNs

  Correct Answer: CD

  Reference: https://cloud.oracle.com/database/faq

• Question 68:

  From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)

  A. loss of ARCHIVELOGS

  B. loss of a redo log member

  C. loss of a noncritical data file

  D. loss of all copies of the control file

  E. loss of a critical data file such as SYSTEM, SYSAUX or UNDO

  F. loss of SPFILE

  Correct Answer: DE

  Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm#RCMRF199

• Question 69:

  APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.

  1.0 is the current version of the application. You execute this block in the application root:

  

  What is the outcome?

  A. An error is thrown because the version number should be sequential, either 1.1 or 2.0.

  B. An error is thrown because the CONTAINER=ALL clause is missing.

  C. An error is thrown because the c## prefix is missing in the role name.

  D. A common role is created only in the application root.

  E. A common role is created only in the application root and application seed.

  F. A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.

  Correct Answer: D

• Question 70:

  Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.

  BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with

  invoker's right.

  BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.

  When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to

  update?

  A. CUST_RECORDS table in Bixby's schema

  B. CUST_RECORDS table in Murdok's schema

  C. CUST_RECORDS table in Rlayton's schema

  D. CUST_RECORDS table in the schema of Bixby and Rlayton

  E. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

  Correct Answer: C