Special Discount Limited Time 65% Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Oracle 1z0-060 Upgrade to Oracle Database 12c Exam Practice Test

Page: 1 / 21
Total 208 questions

Upgrade to Oracle Database 12c Questions and Answers

Question 1

Which statement is true concerning compression during an Online Datafile Move?

Options:

A.

Uncompressed data files may be moved online to compress the entire file with Hybrid Columnar Compression.

B.

All objects In a data file to be moved will always be be compressed.

C.

The DBA may choose which objects In the datafile to be moved get compressed.

D.

If an object is already compressed in the source location, then the compression type for that object remains unchanged after the move.

E.

Only tables may be compressed during the Online Datafile Move.

Question 2

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:

  • RANDOM redaction on the SAL and COMM columns
  • PARTIAL redaction on the HIREDATE column
  • FULL redaction on the MGR column

What would you define to implement this?

Options:

A.

several redaction policies, with one redaction policy for each data type defined for the table that must be redacted

B.

several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type

C.

one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted

D.

several redaction policies, with one redaction policy for each table column that must be redacted

Question 3

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?

Options:

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.

Question 4

You enabled an audit policy by issuing the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

For which database users and for which executions is the audit policy now active? Select two.

Options:

A.

SYS, SYSTEM

B.

SCOTT

C.

Only for successful executions

D.

Only for failed executions

E.

Both successful and failed executions

Question 5

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:

lsnrctl > STOP

What happens to the sessions that are presently connected to the database Instance?

Options:

A.

They are able to perform only queries.

B.

They are not affected and continue to function normally.

C.

They are terminated and the active transactions are rolled back.

D.

They are not allowed to perform any operations until the listener LISTENER is started.

Question 6

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?

Options:

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.

Question 7

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

Which method or feature should you use?

Options:

A.

Compare Period ADDM report

B.

AWR Compare Period report

C.

Active Session History (ASH) report

D.

Taking a new snapshot and comparing it with a preserved snapshot

Question 8

You run a script that completes successfully using SQL*Plus that performs these actions:

1. Creates a multitenant container database (CDB)

2. Plugs in three pluggable databases (PDBs)

3. Shuts down the CDB instance

4. Starts up the CDB instance using STARTUP OPEN READ WRITE

Which two statements are true about the outcome after running the script? (Choose two.)

Options:

A.

The seed will be in MOUNT state.

B.

The seed will be opened read-only.

C.

The seed will be opened read/write.

D.

The other PDBs will be in mount state.

E.

The other PDBs will be opened read-only.

F.

The PDBs will be opened read/write.

Question 9

In which two scenarios is an RMAN recovery catalog automatically resynchronized?

Options:

A.

when a registered database is opened with the resetlogs option

B.

when the backup retention policy configuration is changed for a registered database

C.

when a redo log Is archived

D.

when a manual redo log switch is performed

E.

when backup metadata records are aged out of the control file based on the control_file_record_keep_time parameter value

Question 10

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.

Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? (Choose two.)

Options:

A.

The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

B.

Setting the target tablespace to read-only

C.

The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D.

Setting the target tablespace offline

E.

The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Question 11

Which three activities are supported by the Data Recovery Advisor? (Choose three.)

Options:

A.

Advising on block checksum failures

B.

Advising on inaccessible control files

C.

Advising on inaccessible block change tracking files

D.

Advising on empty password files

E.

Advising on invalid block header field values

Question 12

You execute the following commands to audit database activities:

Which statement is true about the audit record that is generated when auditing starts after the instance restarts?

Options:

A.

One audit record is created for every successful execution of a SELECT, INSERT, or DELETE command on a table, and contains the SQL text for the SQL Statements.

B.

One audit record is created for every successful execution of a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

C.

One audit record is created for the whole session if JOHN successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D.

One audit record is created for the whole session if JOHN successfully executes a SELECT, INSERT, or DELETE command, and contains the SQL text and bind variables used.

E.

One audit record is created for the whole session if JOHN successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

Question 13

A database is stored in an Automatic Storage Management (ASM) disk group, DGROUP1, created with SQL:

There is enough free space in the disk group for mirroring to be done.

What happens if the CONTROLLER1 failure group becomes unavailable due to error or for maintenance?

Options:

A.

Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

B.

Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 failure group is brought back online.

C.

The data in the CONTROLLER1 failure group is copied to the CONTROLLER2 failure group and rebalancing is initiated.

D.

ASM does not mirror any data until the CONTROLLER1 failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group, without mirroring.

Question 14

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.

You issue the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

For which database users is the audit policy now active?

Options:

A.

All users except SYS

B.

All users except SCOTT

C.

All users except SYS and SCOTT

D.

All users except SYS, SYSTEM, and SCOTT

Question 15

You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.

For which three reasons would you use the Compare Period ADDM report after the replay? (Choose three.)

Options:

A.

to check the database time consumed for the two time periods

B.

to review the change in the initialization parameters between the two runs

C.

to find the resource consumption by SQL statements that are common to both periods

D.

to check the performance improvement and degradation caused during the change

E.

to review the hardware resources used during the two runs

F.

to compare the performance change of top SQL statements for the two runs

Question 16

You executed startup restrict foe a multitenant container database (CDB) containing several LUGGABLE databases (PDBs).

You then attempt an alter PLUGGABLE database PDBI open for a PDB called PDB1.

What is the result?

Options:

A.

PDB1 opens read-only with restricted sessions enabled.

B.

PDB1 opens read-only with restricted sessions disabled.

C.

PDB1 opens read/write with restricted sessions disabled.

D.

The statement will fail because PDBs may not be opened read write when the CDB is In restricted session mode.

E.

PDBI opens read/write with restricted sessions enabled.

Question 17

Examine the portion of this Active Session History (ASH) report that is marked with a red rectangle:

Which two inferences can be drawn from the report?

Options:

A.

Sessions attempting to read blocks Images in the buffer cache are waiting while other sessions are reading the same block images

B.

Sessions are waiting for writes of modified block images in the buffer cache to complete

C.

Sessions attempting to modify blocks images In the buffer cache are waiting while other sessions are reading the same block images

D.

Sessions attempting to read blocks images in the buffer cache are waiting while other sessionsare modifying the same block images

Question 18

Which three statements are true about SQL plan directives? (Choose three.)

Options:

A.

They are tied to a specific statement or SQL ID.

B.

They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

C.

They are used to gather only missing statistics.

D.

They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

E.

They instruct the optimizer to create only column group statistics.

F.

Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Question 19

Your multitenant container database (CDB) contains several pluggable databases (POBs). A common user c##a_admin, Is created with connect privileges. You execute this command from the root container: SQL> GRANT create tablespace to C##A_ADMIN; Which statement is true?

Options:

A.

The command fails because the container=all clause is not used.

B.

The command executes successfully, enabling the c*#a_admin user to create a tablespace only In the root container.

C.

The command executes successfully, enabling the c*#a_admin user to create tablespaces in the root container as well as In the PDBs.

D.

The command fails because the CONTAINER=CURRENT clause is not used.

Question 20

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.

You have set the parameter:

DB_FLASH_CACHE_FILE='/dev/flash_device_1','/dev/flash_device_2'

How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

Options:

A.

Set DB_FLASH_CACHE_SIZE = 64G.

B.

Set DB_FLASH_CACHE_SIZE = 64G,64G

C.

Set DB_FLASH_CACHE_SIZE = 128G.

D.

DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Question 21

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.

After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.

How do you accomplish this?

Options:

A.

Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.

B.

Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.

C.

Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.

D.

Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

Question 22

Your database uses Automatic Memory Management, and has the large pool configured.

You issue the following command:

SQL> ALTER SYSTEM SET SHARED_SERVERS = 5;

Which statement is true about the shared server configuration?

Options:

A.

It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured.

B.

It is enabled and the UGA is located in the large pool for connections that use the shared server configuration.

C.

It is enabled only if at least five dispatchers are configured.

D.

It is enabled and all the DBA and non-DBA sessions function in shared server mode.

Question 23

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.

The steps to recover the tablespace are as follows:

1. Mount the CDB.

2. Close all the PDBs.

3. Open the database.

4. Apply the archive redo logs.

5. Restore the data file.

6. Take the SYSAUX tablespace offline.

7. Place the SYSAUX tablespace online.

8. Open all the PDBs with RESETLOGS.

9. Open the database with RESETLOGS.

10. Execute the command SHUTDOWN ABORT.

Which option identifies the correct sequence to recover the SYSAUX tablespace?

Options:

A.

6, 5, 4, 7

B.

10, 1, 2, 5, 8

C.

10, 1, 2, 5, 4, 9, 8

D.

10, 1, 5, 8, 10

Question 24

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.)

Options:

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

Question 25

Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)

Options:

A.

It utilizes the OS file system cache.

B.

A traditional NFS mount is not required when using Direct NFS.

C.

Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.

D.

Direct NFS is available only in UNIX platforms.

E.

Direct NFS can load-balance I/O traffic across multiple network adapters.

Question 26

Examine the following command:

ALTER SYSTEM SET enable_ddl_logging=TRUE;

Which statement is true?

Options:

A.

Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

B.

All DDL commands are logged in the alert log file.

C.

All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

D.

Only DDL commands that resulted in the creation of new segments are logged.

E.

All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Question 27

On your Oracle 12c database, you issue the following commands to create indexes:

SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;

SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);

Which two statements are true? (Choose two.)

Options:

A.

The optimizer evaluates index access from both the indexes before deciding on which index to use for a query execution plan.

B.

Both the indexes are created: however, only ORD_CUSTOMER_IX2 index is visible.

C.

Only the ORD_CUSTOMER_IX1 index is created.

D.

Only the ORD_CUSTOMER_IX2 index is created.

E.

Both the indexes are updated when a new row is inserted, updated, or deleted in the ORDERS table.

Question 28

Identify three benefits of Unified Auditing. (Choose three.)

Options:

A.

Decreased use of storage to store audit trail rows in the database.

B.

It improves overall auditing performance.

C.

It guarantees zero-loss auditing.

D.

The audit trail cannot be easily modified because it is read-only.

E.

It automatically audits Recovery Manager (RMAN) events.

Question 29

Which three statements are true about the use of the query result cache? (Choose three.)

Options:

A.

Results obtained from a query rewrite to a materialized view may be stored in the query result cache.

B.

Stale results may still be obtained from the query result cache, if the query session's query_rewrite_integrity parameter is set to stale_tolerated.

C.

Results obtained from a join between a table and a view may be stored in the query result cache.

D.

Results from distributed queries are never stored in the query result cache.

E.

Results may not be obtained from the query result cache, when the query_rewrite_enabled parameter is set to false.

F.

Results from remote queries may sometimes be stored in the query result cache.

Question 30

Your database is running In archivelog mode. You back up the control file by executing alter database backup controlfile to trace noresetlogs, whenever you make structural changes to the database. A media failure has damaged all the control files, but the online redo log files are Intact. You issue a shutdown abort.

How would you recover the control file to Its default location?

Options:

A.

Issue the startup nomount command, restore the backup control file only to the default location, issue recover database using backup controlfile until cancel, and open the database with the resetlogs option.

B.

Restore the backup control file to all the locations specified in the control_files parameter file, start a new instance and mount the database, recover the database, and then open the database with the resetlogs option.

C.

Issue the startup nomount command, re-create the control file manually by using the create controlfile command, Issue the recover database command, and then issue the alter database open command.

D.

Issue the startup mount command, restore the backup control file to all the locations specified

in the control_files parameter file, and then issue recover database using backup controlfile.

Question 31

In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.

Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.)

Options:

A.

The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

B.

The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

C.

The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D.

Setting the target tablespace to read-only after the segments are moved

E.

Taking the target tablespace offline after the segments are moved

Page: 1 / 21
Total 208 questions