Oracle Oracle Certifications 1Z0-060 Questions & Answers

• Question 121:

  In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.

  Which statement is true?

  A. The CDB must be open.

  B. The CDB must be in the mount stage.

  C. The CDB must be in the nomount stage.

  D. Alt existing PDBs must be closed.

  Correct Answer: A

  * Creating a PDB Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.

• Question 122:

  Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

  A. Change in the Oracle Database version

  B. Change in your network infrastructure

  C. Change in the hardware configuration of the database server

  D. Migration of database storage from non-ASM to ASM storage

  E. Database and operating system upgrade

  Correct Answer: ACE

  Oracle 11g/12c makes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change. The database change can be as major or minor as you like, such as:

  (E) Database, operating system, or hardware upgrades.

  (A, C) Database, operating system, or hardware configuration changes.

  Database initialization parameter changes.

  Schema changes, such as adding indexes or materialized views.

  Refreshing optimizer statistics.

  Creating or changing SQL profiles.

• Question 123:

  Which two statements are true about the RMAN VALIDATE DATABASE command? (Choose two.)

  A. It checks the database for intrablock corruptions.

  B. It can detect corrupt pfiles.

  C. It can detect corrupt spfiles.

  D. It checks the database for interblock corruptions.

  E. It can detect corrupt block change tracking files.

  Correct Answer: AC

  Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock corruption. th?corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption.

  (key word) * The VALIDATE command checks for intrablock corruptions only. Only

  DBVERIFY and the ANALYZE statement detect Interblock corruption.

  VALIDATE Command Output ••andgt; List of Control File and SPFILE.

  File TYPE >»» SPFILE or Control File.

  Status >»» OK if no corruption, or FAILED If block corruption is found.

  Blocks Failing »»» The number of blocks that fail the corruption check. These

  blocks are newly corrupt.

  Blocks Examined »»» Total number of blocks in the file.

  Oracle' Database Backup and Recovery User's Guide

  12c Release 1 (12.1) - 16 Validating Database Files and Backups

• Question 124:

  Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

  A. OMF cannot be used in a database that already has data files created with user-specified directions.

  B. The file system directions that are specified by OMF parameters are created automatically.

  C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

  D. OMF automatically creates unique file names for table spaces and control files.

  E. OMF may affect the location of the redo log files and archived log files.

  Correct Answer: DE

  D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures: Tablespaces Redo log files Control files Archived logs Block change tracking files Flashback logs RMAN backups

  Note:

  * Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle-managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle- managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's datafile with the DATAFILE clause.

  References: http://www.oracle-base.com/articles/9i/oracle-managed-files.php http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm

• Question 125:

  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

  Correct Answer: ACDF

• Question 126:

  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.

  Correct Answer: A

  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 31- MAR-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 127:

  A senior DBA asked you to execute the following command to improve performance:

  

  You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.

  What could be a reason for this recommendation?

  A. The keep pool is not configured.

  B. Automatic Workarea Management is not configured.

  C. Automatic Shared Memory Management is not enabled.

  D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

  E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

  Correct Answer: D

  The most of the rows in SUBSCRIBE_LOG table are accessed once a week.

• Question 128:

  Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

  A. Tracking the most recent read time for a table segment in a user tablespace

  B. Tracking the most recent write time for a table segment in a user tablespace

  C. Tracking insert time by row for table rows

  D. Tracking the most recent write time for a table block in a table segment

  E. Tracking the most recent read time for a table segment in the SYSAUX tablespace

  F. Tracking the most recent write time for a table segment in the SYSAUX tablespace

  Correct Answer: ABC

  *

  To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and

  modification.

  Heat Map provides data access tracking at the segment-level and data modification tracking at the

  segment and row level.

  *

  To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and

  modification. You can also use Automatic Data Optimization (ADO) to automate the compression and

  movement of data between different tiers of storage within the database.

• Question 129:

  Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

  A. ALTER TABLE SPLIT PARTITION

  B. ALTER TABLE MERGE PARTITION

  C. ALTER TABLE TRUNCATE PARTITION

  D. ALTER TABLE ADD PARTITION

  E. ALTER TABLE DROP PARTITION

  F. ALTER TABLE MOVE PARTITION

  Correct Answer: CE

  Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.

• Question 130:

  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

  Correct Answer: AC

  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.