Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 21:

  Examine these parameter values: There are currently no user defined tablespaces with an 8K or 16K blocksize. Which statement would return an error?

  

  A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;

  B. ALTER SYSTEM SET DB_16K_CACHE_SIZE=0;

  C. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;

  D. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

  E. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;

  Correct Answer: D

• Question 22:

  Which two statements are true about Enterprise Manager (EM) Express in Oracle Database 12c? (Choose two.)

  A. You can perform basic administrative tasks for all pluggable databases hosted by the same container database using a single instance of EM Express

  B. You can create and configure pluggable databases by using EM Express

  C. You can use a single instance of EM Express to manage multiple databases running on the same server

  D. You cannot start up or shut down a database instance by using EM Express

  E. By default, EM Express is available for a database after database creation using DBCA

  Correct Answer: CD

• Question 23:

  Which three statements are true about common roles? (Choose three.)

  A. A common role can be granted only to a common user

  B. Only system privileges can be granted to a common role to a container database (CDB)

  C. Object privileges can be granted to a common role in a pluggable database (PDB)

  D. A common rule cannot be created by a local user

  E. A common user that is granted a common role can grant the role to other common and local users in a PDB

  Correct Answer: CDE

• Question 24:

  Which two are prerequisites for performing Flashback Transaction? (Choose two.)

  A. Fast Recovery Area must be enabled for the database

  B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package

  C. Undo retention guarantee must be configured for the database

  D. A supplemental log must be enabled for the primary key

  E. Row movement must be enabled

  Correct Answer: BD

• Question 25:

  You administer a database that was created using Oracle Database 10g.

  The default tablespace type property was not changed. You execute this statement to create a tablespace,

  mytbs:

  CREATE TABLESPACE mytbs DATAFILE `/u1/data/mytbs.dbf' SIZE 100M;

  Which two statements are correct regarding the mytbs tablespace? (Choose two.)

  A. It is a bigfile tablespace

  B. It is a locally managed tablespace with uniform size of 8m

  C. It is a locally managed tablespace with autoallocate

  D. It is a dictionary-managed tablespace

  E. It is a smallfile tablespace

  Correct Answer: CE

• Question 26:

  You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs). You execute the command to start up the CDB: SQL>STARTUP

  Which statement is true?

  A. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode

  B. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state

  C. CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode

  D. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode

  E. CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode

  Correct Answer: B

• Question 27:

  You regularly take backups of your database using RMAN with a recovery catalog. Your database is

  currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.

  Identify two methods to recover the temp file with the least disruption to database availability. (Choose

  two.)

  A. Restart the database instance to create the temp file automatically

  B. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp files that is corrupted

  C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file

  D. Drop the TEMP tablespace, and then re-create it with new temp files

  Correct Answer: AB

• Question 28:

  You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceed during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation. How would you achieve this?

  A. Implement a Database Resource Manager plan

  B. Implement a profile for these users

  C. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions

  D. Specify the maximum amount of quota a user can be allocated in the undo tablespace

  Correct Answer: A

• Question 29:

  You want to create a database and you have the following: Oracle Grid Infrastructure is installed and configured Oracle Database Vault is installed in ORACLE_HOME to be used for this database Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server

  Examine the requirements:

  1.

  Configuring the database instance to support shared server mode

  2.

  Using Automatic Storage Management (ASM) for storing database files

  3.

  Configuring a naming method to help a remote user connect to a database instance

  4.

  Configuring the Fast Recovery Area

  5.

  Configuring Database Vault

  6.

  Configuring Enterprise Manager (EM) Database Express

  7.

  Registering with EM Cloud Control

  8.

  Configuring remote log archive destinations

  9.

  Enabling daily incremental backups 10.Configuring a nondefault block size for nondefault block size tablespaces

  Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

  A. 1,2,3,4,5,6,8,9, and 10

  B. 1,2, 4,5,6,7, and 8

  C. 1, 2, 3, 8, 9, and 10

  D. 1, 2, 4, 5, 7, 8, 9, and 10

  E. 1, 2, 4, 5, 6, and 7

  Correct Answer: E

• Question 30:

  Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

  A. Only one nested subplan is allowed per parent plan

  B. The plans can be nested up to four levels.

  C. Nested plans only control resources used by recursive SQL

  D. Nested plans control only the degree of parallelism and I/O requests

  E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.

  Correct Answer: E