Oracle-1z0-060new(4)

Oracle 1z0-060 : Practice Test

B. They are created only in the Fast Recovery Area.

C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameterand in the default location $ORACLE_HOME/dbs/arch.

D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameterand the location specified by the DB_RECOVERY_FILE_DEST parameter.

Answer: A

Explanation: You can choose to archive redo logs to a single destination or to multipledestinations.

Destinations can be local—within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group—or remote (on a standby database). When you archive to multiple destinations, a copy of each filled redo log file is written to each destination. These redundant copies help ensure that archived logs are always available in the event of a failure at one of the destinations.

To archive to only a single destination, specify that destination using the

LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters. ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can

choose to archive to two or more locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using the LOG_ ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.

Question No : 19Your multitenant container database (CDB) is running in ARCHIVELOG mode. Youconnect to the CDB RMAN.

Examine the following command and its output:

You execute the following command:

RMAN > BACKUP DATABASE PLUS ARCHIVELOG;

16

Oracle 1z0-060 : Practice Test

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

Answer: B

Explanation: Backing Up a Whole CDB

Backing up a whole CDB is similar to backing up a non-CDB. When you back up a wholeCDB, RMAN backs up the root, all the PDBs, and the archived redo logs. You can thenrecover 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. Youcan back up logs with BACKUP ARCHIVELOG, or back up logs while backing up datafilesand control files by specifying BACKUP ... PLUS ARCHIVELOG.

Question No : 20You are administering a database stored in Automatic Storage management (ASM). Thefiles are stored in the DATA disk group. You execute the following command:

SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data/prod/myfile.dbf’

What is the result?

A. The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as‘myfile.dbf’.

B. The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’. C. The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is

17

Oracle 1z0-060 : Practice Test

created.

D. The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ inthe data dictionary removed.

Answer: C

Explanation: ADD ALIAS

Use this clause to create an alias name for an Oracle ASM filename. The alias_nameconsists of the full directory path and the alias itself.

Question No : 21Which three functions are performed by the SQL Tuning Advisor?

A. Building and implementing SQL profiles

B. Recommending the optimization of materialized views C. Checking query objects for missing and stale statistics

D. Recommending bitmap, function-based, and B-tree indexes

E. Recommending the restructuring of SQL queries that are using bad plans

Answer: A,C,E

Explanation: The SQL Tuning Advisor takes one or more SQL statements as an input andinvokes the Automatic Tuning Optimizer to perform SQL tuning on the statements. Theoutput of the SQL Tuning Advisor is in the form of an advice or recommendations, alongwith a rationale for each recommendation and its expected benefit. The recommendationrelates to collection of statistics on objects (C), creation of new indexes, restructuring of theSQL statement (E), or creation of a SQL profile (A). You can choose to accept therecommendation to complete the tuning of the SQL statements.

Question No : 22Examine the following command:

ALTER SYSTEM SET enable_ddl_logging=FALSE;

Which statement is true?

18

Oracle 1z0-060 : Practice Test

A. None of the data definition language (DDL) statements are logged in the trace file. B. Only DDL commands that resulted in errors are logged in the alert log file.

C. A new log.xml file that contains the DDL statements is created, and the DDL commanddetails are removed from the alert log file.

D. Only DDL commands that resulted in the creation of new database files are logged.

Answer: A

Explanation: ENABLE_DDL_LOGGING enables or disables the writing of a subset of datadefinition language (DDL) statements to a DDL alert log.

The DDL log is a file that has the same format and basic behavior as the alert log, but itonly contains the DDL statements issued by the database. The DDL log is created only forthe RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter isset to true. When this parameter is set to false, DDL statements are not included in any log.

Question No : 23Your multitenant container database (CDB) contains three pluggable database (PDBs).You find that the control file is damaged. You plan to use RMAN to recover the control file.There are no startup triggers associated with the PDBs.

Which three steps should you perform to recover the control file and make the databasefully operational?

A. Mount the container database (CDB) and restore the control file from the control file autobackup.

B. Recover and open the CDB in NORMAL mode.

C. Mount the CDB and then recover and open the database, with the RESETLOGS option. D. Open all the pluggable databases. E. Recover each pluggable database.

F. Start the database instance in the nomount stage and restore the control file from controlfile auto backup.

Answer: C,D,F

Explanation: Step 1: F Step 2: D

Step 3: C: If all copies of the current control file are lost or damaged, then you must restoreand mount a backup control file. You must then run the RECOVERcommand, even if nodata files have been restored, and open the database with the RESETLOGS option.

19

Oracle 1z0-060 : Practice Test

Note:

* RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full supportfor backup and recovery in a multitenant environment. You can back up and recover awhole multitenant container database (CDB), root only, or one or more pluggabledatabases (PDBs).

Question No : 24A new report process containing a complex query is written, with high impact on the

database. You want to collect basic statistics about query, such as the level of parallelism,total database time, and the number of I/O requests.

For the database instance STATISTICS_LEVEL, the initialization parameter is set toTYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set toDIAGNOSTIC+TUNING.

What should you do to accomplish this task?

A. Execute the query and view Active Session History (ASH) for information about thequery.

B. Enable SQL trace for the query.

C. Create a database operation, execute the query, and use the

DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.

D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitorquery execution and view the information from the V$SESSION_LONGOPS view.

Answer: C

Explanation: The REPORT_SQL_MONITOR function is used to return a SQL monitoringreport for a specific SQL statement. Incorrect:

Not A: Not interested in session statistics, only in statistics for the particular SQL query. Not B: We are interested in statistics, not tracing. Not D: SET_SESSION_LONGOPS Procedure

This procedure sets a row in the V$SESSION_LONGOPS view. This is a view that is usedto indicate the on-going progress of a long running operation. Some Oracle functions, suchas parallel execution and Server Managed Recovery, use rows in this view to indicate the

20

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Oracle-1z0-060new(4)在线全文阅读。