Oracle 1Z0-060 Free Practice Questions 2021

NEW QUESTION 1
Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

• A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEE
• B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEE
• C. Use the DBMS_PDB package to clone an existing PD
• D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CD
• E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CD

Answer: AD

NEW QUESTION 2
Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

• A. All database operations performed by the impdp command are logge
• B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logge
• C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logge
• D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logge

Answer: C

NEW QUESTION 3
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1.Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement.
2.Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure.
3.Execute the required queries on the CUSTOMERS table.
4.Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.
Identify the correct sequence of steps.

• A. 3, 2, 1, 4
• B. 2, 3, 4, 1
• C. 4, 1, 3, 2
• D. 3, 2, 4, 1

Answer: B

NEW QUESTION 4
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?

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

Answer: D

NEW QUESTION 5
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?

• 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

Answer: BC

NEW QUESTION 6
Examine these two statements:

Which three are true about the MRKT tablespace?

• A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• B. The MRKT tablespace may be dropped if it has no contents.
• C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• D. No more data files can be added to the tablespace.
• E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Answer: CDE

NEW QUESTION 7
Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback?

• A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
• B. The optimizer can re optimize a query only once using cardinality feedback.
• C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enable
• E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Answer: ACD

NEW QUESTION 8
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
1snrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

• 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 starte

Answer: B

NEW QUESTION 9
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

Answer: ACE

NEW QUESTION 10
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?

• 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

Answer: ABD

NEW QUESTION 11
Identify three benefits of Unified Auditing.

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

Answer: BDE

NEW QUESTION 12
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A. Reduced logical I/O
• B. Reduced virtual memory utilization
• C. Improved parallel Execution performance
• D. Improved Serial Execution performance
• E. Reduced physical I/O
• F. Reduced CPU utilization

Answer: BCF

NEW QUESTION 13
Which three operations can be performed as multipartition operations in Oracle?

• A. Merge partitions of a list partitioned table
• B. Drop partitions of a list partitioned table
• C. Coalesce partitions of a hash-partitioned global index.
• D. Move partitions of a range-partitioned table
• E. Rename partitions of a range partitioned table
• F. Merge partitions of a reference partitioned index

Answer: ABF

NEW QUESTION 14
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true?

• A. The C # # ROLE1 role is created in the root database and all the PDBs.
• B. The C # # ROLE1 role is created only in the root database because the container clause is not use
• C. Privileges are granted to the C##A_ADMIN user only in the root database.
• D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
• E. The statement for granting a role to a user fails because the CONTAINER clause is not use

Answer: AC

NEW QUESTION 15
Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);
Which two statements are true?

• A. Database operations will be monitored only when they consume a significant amount of resource.
• B. Database operations for all sessions will be monitore
• C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
• D. Only DML and DDL statements will be monitored for the session.
• E. All subsequent statements in the session will be treated as one database operation and will be monitore

Answer: CE

NEW QUESTION 16
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?

• 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

Answer: B

NEW QUESTION 17
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?

• A. Thread creation must be routed through a dispatcher process
• B. The local listener may spawn a now process and have that new process create a thread
• C. Each Oracle process runs an SCMN threa
• D. Each multithreaded Oracle process has an SCMN threa
• E. The local listener may pass the request to an existing process which in turn will create a threa

Answer: ADE

NEW QUESTION 18
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 DB_SMART_FLASH_FILE 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_ZISE = 64G.
• B. Set DB_FLASH_CACHE_ZISE = 64G, 64G
• C. Set DB_FLASH_CACHE_ZISE = 128G.
• D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Answer: B

NEW QUESTION 19
Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?

• A. An EMP table is created if a table does not exis
• B. Otherwise, if the EMP table is appended with the loaded dat
• C. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
• D. The SQL* Loader operation fails because no record terminators are specifie
• E. Field names should be the first line in the both the SQL* Loader data files.
• F. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

Answer: ABE

NEW QUESTION 20
Which 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: ACE