Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 141:

  An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.

  A multitenant container database (CDB) instant has the following parameter set:

  THREADED_EXECUTION = FALSE

  Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode? (Choose four.)

  A. You can connect as a common user by using the CONNECT statement.
  B. You can connect as a local user by using the CONNECT statement.
  C. You can connect by using easy connect.
  D. You can connect by using OS authentication.
  E. You can connect by using a Net Service name.
  F. You can connect as a local user by using the SET CONTAINER statement.
  A. You can connect as a common user by using the CONNECT statement.
  C. You can connect by using easy connect.
  D. You can connect by using OS authentication.
  E. You can connect by using a Net Service name.

  ---

  http://docs.oracle.com/database/121/ADMIN/cdb_admin.htm

• Question 142:

  You are the DBA for an Oracle Database 11g Release 1 data warehouse database running on Oracle Linux with little endianness.

  You want to plug in a transportable tablespace with a 16K blocksize from an Oracle Database 10g database that is running on a SPARC-based Oracle Solaris system with big endianness.

  The data warehouse database has the following parameters set:

  

  The following parameters are not explicitly set:

  

  What action must you perform on the data warehouse database to prepare it for the transportable tablespace plug in operation?

  A. Do nothing, because Automatic Memory Management will size DB_16K_CACHE_SIZE automatically
  B. Set ALTER SYSTEM SET DB_CACHE_SIZE=192M followed by ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M;
  C. Do nothing, because you cannot transport a tablespace between databases with different endian formats.
  D. Do nothing, because Automatic Shared Memory Management will size DB_16K_CACHE_SIZE automatically.
  E. Set ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M and leave other parameters set to their current settings.
  B. Set ALTER SYSTEM SET DB_CACHE_SIZE=192M followed by ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M;

• Question 143:

  You plan to use the Flashback Drop feature to recover the SALES_EMP table that was dropped in error.

  No other table with the same name exists in the SH schema, which owns the table.

  You query the RECYCLEBIN and find multiple entries for the SALES_EMP table:

  

  You then issue this statement to recover the table:

  

  What would be the best?

  A. It retrieves the least recently dropped version of the table from the recycle bin for which undo is still available.
  B. It retrieves the most recently dropped version of the table.
  C. It retrieves the most recently dropped version of the table from the recycle bin for which indo is still available.
  D. It returns an error because the table name in the OBJECT_NAME column is not specified.
  E. It retrieves the least recently dropped version of the table.
  A. It retrieves the least recently dropped version of the table from the recycle bin for which undo is still available.

• Question 144:

  An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?

  A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
  B. Increase the database buffer cache size.
  C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
  D. Configure Automata Shared Memory Management.
  E. Configure Automatic Memory Management-
  A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

  ---

  Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer pools enable you to address these differences. You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools.

• Question 145:

  You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.

  Which three findings would you get from the report?

  A. It shows the resource usage for CPU, memory, and I/O in both time periods.
  B. It identifies any workload change that caused a performance difference in both time periods
  C. It detects any configuration change that caused a performance difference in both time periods.
  D. It gives information about statistics collection in both time periods.
  E. It detects the top wait events causing performance degradation.
  A. It shows the resource usage for CPU, memory, and I/O in both time periods.
  B. It identifies any workload change that caused a performance difference in both time periods
  C. It detects any configuration change that caused a performance difference in both time periods.

• Question 146:

  Which four actions are possible during an Online Data file Move operation?

  A. Creating and dropping tables in the data file being moved
  B. Performing file shrink of the data file being moved
  C. Querying tables in the data file being moved
  D. Performing Block Media Recovery for a data block in the data file being moved
  E. Flashing back the database
  F. Executing DML statements on objects stored in the data file being moved
  A. Creating and dropping tables in the data file being moved
  C. Querying tables in the data file being moved
  D. Performing Block Media Recovery for a data block in the data file being moved
  F. Executing DML statements on objects stored in the data file being moved

• Question 147:

  You issue the following commands:

  

  The directories '/u0l/app/oracle/oradata/orcl' and '/u0l/app/oracle/mydata' exist. Which statement describes the outcome?

  A. The AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST location and the TEMP101 tablespace is created with its temp file in the '/u01/app/oracle/mydata' location.
  B. The TEMP101 tablespace is created with its temp file in the DB_CREATE_FILE_DEST location and the AUGUST_SALES tablespace is created with its data file in the '/u01/app/oracle/mydata/mysales.dbf' location.
  C. The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.
  D. Tablespace creation ignores the data file and temp file locations specified in the CREATE commands, and creates both the tablespaces in the DB_CREATE_FILE_DEST location.
  C. The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.

• Question 148:

  Examine the memory-related parameters of an Oracle database instance:

  

  Which statement is true?

  A. The value of the memory_target parameter cannot be changed dynamically.
  B. PGA size can grow automatically beyond 500 MB.
  C. Only the components of SGA are managed automatically.
  D. Memory is dynamically re-allocated between SGA and PGA as needed.
  B. PGA size can grow automatically beyond 500 MB.

• Question 149:

  Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.

  Examine the following command and its output:

  

  You execute the following command:

  RMAN > BACKUP DATABASE PLUS ARCHIVELOG;

  Which data files will be backed up?

  A. Data files that belong to only the root container
  B. Data files that belong to the root container and all the pluggable databases (PDBs)
  C. Data files that belong to only the root container and PDB$SEED
  D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
  B. Data files that belong to the root container and all the pluggable databases (PDBs)

  ---

  Backing Up a Whole CDB

  Backing up a whole CDB is similar to backing up a non-CDB. When you back up a whole CDB, RMAN backs up the root, all the PDBs, and the archived redo logs. You can then recover either the whole CDB, the root only, or one or more

  PDBs from the CDB backup.

  Note:

  *

  You can back up and recover a whole CDB, the root only, or one or more PDBs.

  *

  Backing Up Archived Redo Logs with RMAN

  Archived redo logs are the key to successful media recovery. Back them up regularly. You can back up logs with BACKUP ARCHIVELOG, or back up logs while backing up datafiles and control files by specifying BACKUP ... PLUS ARCHIVELOG.

• Question 150:

  Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

  A. You cannot have multiple SQL*Loader data files.
  B. The DEGREE_OF_PARALLELISM parameter is set to AUTO.
  C. If no data file is specified, it uses table-name.dat and assumes it is in the current directory.
  D. A new table is created and data is inserted into the table if it does not exist in a schema.
  B. The DEGREE_OF_PARALLELISM parameter is set to AUTO.
  C. If no data file is specified, it uses table-name.dat and assumes it is in the current directory.

  ---

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-sql-loader-express-mode.html#GUID-0F35B551-861B-450D-8BF3-2312893A67D7