1z0-062

1z0-062 practice questions, page 14 of 16, with answer review and explanations.

Question 66

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

  1. It will create a multitenant container database (CDB) with only the root opened.
  2. It will create a CDB with root opened and seed read only.
  3. It will create a CDB with root and seed opened and one PDB mounted.
  4. It will create a CDB that must be plugged into an existing CDB.
  5. It will create a CDB with root opened and seed mounted.

Question 67

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= /dev/flash_device_1 , /dev/flash_device_2 How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

  1. Set DB_FLASH_CACHE_ZISE = 64G.
  2. Set DB_FLASH_CACHE_ZISE = 64G, 64G
  3. Set DB_FLASH_CACHE_ZISE = 128G.
  4. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Question 68

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 - MEMORY_TARGET=0 - SGA_TARGET=0 - PGA_AGGREGATE_TARGET=500m - Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

  1. LOG_BUFFER
  2. SORT_AREA_SIZE
  3. JAVA_POOL_SIZE
  4. STREAMS_POOL_SIZE
  5. DB_16K_CACHE_SZIE
  6. DB_KEEP_CACHE_SIZE

Question 69

Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)

  1. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
  2. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
  3. The SQL* Loader operation fails because no record terminators are specified.
  4. Field names should be the first line in the both the SQL* Loader data files.
  5. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

Question 70

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container: SQL > REVOKE create table FROM C # # A_ADMIN; What is the result?

  1. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
  2. It fails and reports an error because the CONTAINER=ALL clause is not used.
  3. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
  4. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
  5. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.