Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 61:

  In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.

  How does real-time Automatic Database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

  A. It collects data from SGA and compares it with a preserved snapshot.
  B. It collects data from SGA, analyzes it, and provides a report.
  C. It collects data from SGA and compares it with the latest snapshot.
  D. It collects data from both SGA and PGA, analyzes it, and provides a report.
  B. It collects data from SGA, analyzes it, and provides a report.

  ---

  Note:

  *

  The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.

  *

  The System Global Area (SGA) is a group of shared memory areas that are dedicated to an Oracle "instance" (an instance is your database programs and RAM).

  *

  The PGA (Program or Process Global Area) is a memory area (RAM) that stores data and control information for a single process.

• Question 62:

  A redaction policy was added to the SAL column of the SCOTT.EMP table:

  

  All users have their default set of system privileges.

  For which three situations will data not be redacted? (Choose three.)

  A. SYS sessions, regardless of the roles that are set in the session
  B. SYSTEM sessions, regardless of the roles that are set in the session
  C. SCOTT sessions, only if the MGR role is set in the session
  D. SCOTT sessions, only if the MGR role is granted to SCOTT
  E. SCOTT sessions, because he is the owner of the table
  F. SYSTEM session, only if the MGR role is set in the session
  A. SYS sessions, regardless of the roles that are set in the session
  B. SYSTEM sessions, regardless of the roles that are set in the session
  D. SCOTT sessions, only if the MGR role is granted to SCOTT

  ---

  Both users SYS and SYSTEM automatically have the EXEMPT REDACTION POLICY system privilege. (SYSTEM has the EXP_FULL_DATABASE role, which includes the EXEMPT REDACTION POLICY system privilege.) This means that the SYS and SYSTEM users can always bypass any existing Oracle Data Redaction policies, and will always be able to view data from tables (or views) that have Data Redaction policies defined on them

• Question 63:

  You plan to drop the column of a table that has Flashback Archiving enabled.

  You want to ensure minimal service disruption.

  How would you do this in your Oracle 12c Database?

  A. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
  B. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.
  C. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.
  D. Drop the column using the ALTER TABLE statement.
  E. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.
  D. Drop the column using the ALTER TABLE statement.

• Question 64:

  In which two scenarios do you use SQL* Loader to load data?

  A. Transform the data while it is being loaded into the database.
  B. Use transparent parallel processing without having to split the external data first.
  C. Load data into multiple tables during the same load statement.
  D. Generate unique sequential key values in specified columns.
  C. Load data into multiple tables during the same load statement.
  D. Generate unique sequential key values in specified columns.

  ---

  http://docs.oracle.com/cd/B28359_01/server.111/b28319/ldr_concepts.htm

• Question 65:

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

  A. The unplugged PDB can be plugged into the same multitenant container database (CDB).
  B. The unplugged PDB can be plugged into another CDB.
  C. The PDB must be open in read-only mode.
  D. The PDB data files are automatically removed from disk.
  E. The unplugged PDB becomes a non-CDB.
  F. The PDB must be closed.
  A. The unplugged PDB can be plugged into the same multitenant container database (CDB).
  B. The unplugged PDB can be plugged into another CDB.
  F. The PDB must be closed.

  ---

  Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_unplug_plug/pdb_unplug_plug.html

• Question 66:

  You performed an incremental level 0 backup of a database:

  RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;

  To enable block change tracking after the incremental level 0 backup, you issued this command:

  SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/rman_change_track.f';

  To perform an incremental level 1 cumulative backup, you issued this command:

  RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

  Which three statements are true? (Choose three.)

  A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  B. The change tracking file must always be backed up when you perform a full database backup.
  C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
  D. More than one database block may be read by an incremental backup for a change made to a single block.
  E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
  A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  D. More than one database block may be read by an incremental backup for a change made to a single block.
  E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

  ---

  A: In a cumulative level 1 backup, RMAN backs up all the blocks used since the most recent level 0 incremental backup.

  E: Oracle Block Change Tracking Once enabled; this new 10g feature records the modified since last backup and stores the log of it in a block change tracking file using the CTW (Change Tracking Writer) process. During backups RMAN uses the log file to identify the specific blocks that must be backed up. This improves RMAN's performance as it does not have to scan whole datafiles to detect changed blocks. Logging of changed blocks is performed by the CTRW process which is also responsible for writing data to the block change tracking file.

  Note:

  * An incremental level 0 backup backs up all blocks that have ever been in use in this database.

• Question 67:

  You configure your database Instance to support shared server connections.

  Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

  A. User session data
  B. Stack space
  C. Private SQL area
  D. Location of the runtime area for DML and DDL Statements
  E. Location of a part of the runtime area for SELECT statements
  A. User session data
  C. Private SQL area

  ---

  A: PGA itself is subdivided. The UGA (User Global Area) contains session state information, including stuff like package-level variables, cursor state, etc. Note that, with shared server, the UGA is in the SGA. It has to be, because shared server means that the session state needs to be accessible to all server processes, as any one of them could be assigned a particular session. However, with dedicated server (which likely what you're using), the UGA is allocated in the PGA.

  C: The Location of a private SQL area depends on the type of connection established for a session. If a session is connected through a dedicated server, private SQL areas are located in the server process' PGA. However, if a session is connected through a shared server, part of the private SQL area is kept in the SGA.

  Note:

  *

  System global area (SGA)

  The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Examples of data stored

  in the SGA include cached data blocks and shared SQL areas.

  *

  Program global area (PGA)

  A PGA is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is

  one PGA for each server process. Background processes also allocate their own PGAs. The total memory used by all individual PGAs is known as the total instance PGA memory, and the collection of individual PGAs is referred to as the

  total instance PGA, or just instance PGA. You use database initialization parameters to set the size of the instance PGA, not individual PGAs.

• Question 68:

  You configure your database Instance to support shared server connections.

  Which two memory areas that are part of PGA are stored in SGA instead, for shared server connections?

  A. User session data
  B. Stack space
  C. Persistent area containing bind variable values that are supplied to a SQL statement at run time
  D. Location of the runtime area for DML and DDL Statements
  E. Location of a part of the runtime area for SELECT statements
  A. User session data
  C. Persistent area containing bind variable values that are supplied to a SQL statement at run time

• Question 69:

  Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.

  You want to issue the following RMAN command:

  RMAN > BACKUP TABLESPACE hr_pdb:userdata;

  Which task should you perform before issuing the command?

  A. Place the root container in ARHCHIVELOG mode.
  B. Take the USERDATA tablespace offline.
  C. Place the root container in the nomount stage.
  D. Ensure that HR_PDB is open.
  A. Place the root container in ARHCHIVELOG mode.

  ---

  RMAN> select name,open_mode from v$pdbs; using target database control file instead of recovery catalogNAME OPEN_MODE-------------------- -------PDB$SEED READ ONLYORA12P1 READ WRITEORA12P2 MOUNTED RMAN> backup tablespace ora12p2:users; Starting backup at 31-MAR-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=137 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00013 name=/appl/oradata/cdbroot/ORA12C1/F5D05369C4B23E83E0430100007F6D99/datafile/o1_mf_users_9mhr0o5l_.dbfchannel ORA_DISK_1: starting piece 1 at 31-MAR-14channel ORA_DISK_1: finished piece 1 at 31MAR-14piece handle=/appl/oradata/flash_recovery/ORA12C1/F5D05369C4B23E83E0430100007F6D99/backupset/2014_03_31/o1_mf_nnndf_TAG20140331T001832_9mhzdb6w_.bkp tag=TAG20140331T001832 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 31-MAR-14 Starting Control File and SPFILE Autobackup at 31-MAR-14piece handle=/appl/oradata/flash_recovery/ORA12C1/autobackup/2014_03_31/o1_mf_s_843610715_9mhzdcv8_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 31-MAR-14 RMAN> The above example illustrates that if root container is open and in archivelog it can do the backup of tablespace whether the pdb is mounted or open.

• Question 70:

  In which two scenarios is an RMAN recovery catalog automatically resynchronized? (Choose two.)

  A. when a registered database is opened with the RESETLOGS option
  B. when a redo log is archived
  C. when backup metadata records are aged out of the control file based on the CONTROL_FILE_RECORD_KEEP_TIME parameter value
  D. when the backup retention policy configuration is changed for a registered database
  E. when a manual redo log switch is performed
  A. when a registered database is opened with the RESETLOGS option
  C. when backup metadata records are aged out of the control file based on the CONTROL_FILE_RECORD_KEEP_TIME parameter value