1Z0-060 Online Practice Questions and Answers

Which three are true about the large pool for an Oracle database instance that supports shared server connections?

A. Allocates memory for RMAN backup and restore operations

B. Allocates memory for shared and private SQL areas

C. Contains a cursor area for storing runtime information about cursors

D. Contains stack space

E. Contains a hash area performing hash joins of tables

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.

Which three storage options support the use of HCC? (Choose three.)

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B. ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array

C. ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files

D. Database files stored in ZFS and accessed using conventional NFS mounts.

E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

1.

Create a policy to capture the privilege used by a user for privilege analysis.

2.

Generate a report with the data captured for a specified privilege capture.

3.

Start analyzing the data captured by the policy.

4.

Revoke the unused privileges.

5.

Compare the used and unused privileges' lists.

6.

Stop analyzing the data.

Identify the correct sequence of steps.

A. 1, 3, 5, 6, 2, 4

B. 1, 3, 6, 2, 5, 4

C. 1, 3, 2, 5, 6, 4

D. 1, 3, 2, 5, 6, 4

E. 1, 3, 5, 2, 6, 4

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)

A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.

B. All the user-defined tablespaces must be in read-only mode on the source database.

C. The export dump file must be created before starting the import on the target database.

D. The source and target database must be running on the same platform with the same endianness.

E. The path of data files on the target database must be the same as that on the source database.

F. The impdp operation must be performed by the same user that performed the expdp operation.

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

What must you do to activate the new default value for numeric full redaction?

A. Re-enable redaction policies that use FULL data redaction.

B. Re-create redaction policies that use FULL data redaction.

C. Re-connect the sessions that access objects with redaction policies defined on them.

D. Flush the shared pool.

E. Restart the database instance.

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.

Identify three possible reasons for this.

A. Missing or stale histogram statistics

B. Undersized shared pool

C. High clustering factor for the indexes

D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

E. Oversized buffer cache

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).

The characteristics of the non-CDB are as follows: Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit Character Set: AL32UTF8 National Character Set: AL16UTF16 O/S: Oracle Linux 6 64-bit

The characteristics of the CDB are as follows: Version: Oracle Database 12c Release 1 64-bit Character Set: AL32UTF8 National Character Set: AL16UTF16 O/S: Oracle Linux 6 64-bit

Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A. Transportable database

B. Transportable tablespace

C. Data Pump full export/import

D. The DBMS_PDB package

E. RMAN

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.

What are two effects of not using the "ENABLE PLUGGABLE database" clause?

A. The database is created as a non-CDB and can never contain a PDB.

B. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).

C. The database is created as a non-CDB and can never be plugged into a CDB.

D. The database is created as a non-CDB but can be plugged into an existing CDB.

E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

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?

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.

You execute the following commands to audit database activities:

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

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

You executed this command to create a password file:

$ orapwd file = orapworcl entries = 10 ignorecase = N

Which two statements are true about the password file?

A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

B. It contains username and passwords of database users who are members of the OSOPER operating system group.

C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.

D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.

B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

C. The C # # A_ADMIN user can perform wallet operations.

D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

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.

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?

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

B. Sessions are waiting to find free buffers in the buffer cache.

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

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

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

Examine this set of commands to perform data pump export and import operations: On the source database:

$> expdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp VIEWS_AS_TABLE=sales_q1

On the target database:

$> impdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp VIEWS_AS_TABLE=sales_q1

Which three statements are true? (Choose three.)

A. This impdp operation creates the view as a table and populates it with data from the export dump file.

B. The exdp operation exports data that satisfies the conditions of the defining query used when the view was created.

C. Metadata for dependent objects required to create the SALES_Q1 view is exported.

D. All rows from the dependent objects that are required are exported along with the metadata to create the SALES_Q1 view.

E. The impdp operation creates the view and the dependent object.