Free Oracle Database 12c Administration 1Z0-062 Exam Practice Test

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)

• backup pieces
  
• copies of all parameter files
  
• trace file generated using BACKUP CONTROLFILE TO TRACE
  
• control file autobackups
  

Which three statements are true about user account administration? (Choose three.)

• A user's current session is not affected when the user's profile is changed.
  
• Only users with the SYSDBA privilege can change the tablespace quota for other users.
  
• A new user account can be created only by SYS or SYSTEM users.
  
• A user's quota can be set for any permanent tablespace but not for the default temporary tablespace.
  
• A user requires only the CREATE SESSION privilege to change his or her own password.
  

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.Which two methods or commands would you use to accomplish this task? (Choose two.)

• RMAN CONVERT command
  
• Data Pump Export and import
  
• Conventional Export and Import
  
• The BACKUP AS COPY DATABASE . . . command of RMAN
  
• DBMS_FILE_TRANSFER with transportable tablespace
  

The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction.Which two types of lock exist in this situation? (Choose two.)

• exclusive lock on the EMPLOYEES table
  
• null lock on the row being updated
  
• null lock on the EMPLOYEES table
  
• row level lock on the row being updated
  
• shared lock on the EMPLOYEES table
  

You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario? (Choose two.)

• The database must have multiplexed redo logs for the flashback to succeed.
  
• The database must be MOUNTED for the flashback to succeed.
  
• The database must use block change tracking for the flashback to succeed.
  
• The database must be opened in restricted mode for the flashback to succeed.
  
• The database must be opened with the RESETLOGS option after the flashback is complete.
  
• The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
  

In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:$> sqlldr hr/hr table=employeesWhich two statements are true about this command? (Choose two.)

• It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.
  
• It fails because the SQL *Loader control file location is not specified.
  
• It fails because the SQL *Loader data file location is not specified.
  
• It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.
  
• It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
  

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?

• Setting a metric threshold
  
• Implementing Database Resource Manager
  
• Enabling resumable timeout for user sessions
  
• Decreasing the value of the IDLE_TIME resource limit in the default profile
  

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

• The PDB must be open in read only mode.
  
• The PDB must be dosed.
  
• The unplugged PDB becomes a non-CDB.
  
• The unplugged PDB can be plugged into the same multitenant container database (CDB)
  
• The unplugged PDB can be plugged into another CDB.
  
• The PDB data files are automatically removed from disk.
  

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

• It mounts databases and diskgroups to make ASM files available to database instances.
  
• It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.
  
• It automatically places each disk from an external redundancy diskgroup in its own failure group.
  
• It divides files into extents and allows an extent to span disks.
  
• It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.
  

Which two actions does an incremental checkpoint perform? (Choose two.)

• It signals CKPT to write the checkpoint position to the data file headers.
  
• It writes the checkpoint position to the data file headers.
  
• It advances the checkpoint position in the checkpoint queue.
  
• It writes the checkpoint position to the control file.