Verified 1Z0-060 Dumps Questions 2021

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

Answer: ABC

NEW QUESTION 2
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;
What is the result?

• A. It executes successfully and creates an UNDO tablespace in HR_PD
• B. It falls and reports an error because there can be only one undo tablespace in a CD
• C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the comman
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the comman
• E. It executes successfully but neither tablespace nor the data file is create

Answer: E

NEW QUESTION 3
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 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.

Answer: E

NEW QUESTION 4
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.
Examine the following command and its output:

You execute the following command:
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
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

NEW QUESTION 5
You notice that the performance of your production 24/7 Oracle database significantly degradeD. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

• A. Enable Memory Access Mode, which reads performance data from SG
• B. Use emergency monitoring to fetch data directly from SGA analysis.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
• E. Run ADDM in diagnostic mode.

Answer: B

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

Answer: ACD

NEW QUESTION 7
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

• A. Setting a metric threshold
• B. Implementing Database Resource Manager
• C. Enabling resumable timeout for user sessions
• D. Decreasing the value of the IDLE_TIME resource limit in the default profile

Answer: D

NEW QUESTION 8
Which two statement is true concerning dropping a pluggable database (PDB)?

• A. The PDB must be open in read-only mode.
• B. The PDB must be in mount state.
• C. The PDB must be unplugge
• D. The PDB data files are always removed from disk.
• E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Answer: CD

NEW QUESTION 9
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?

• 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 command details are removed from the alert log file.
• D. Only DDL commands that resulted in the creation of new database files are logge

Answer: A

NEW QUESTION 10
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;
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 use
• 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 use

Answer: D

NEW QUESTION 11
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 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 of for maintenance?

• 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 for failure group is brought back online.
• C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiate
• D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
• E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succee

Answer: B

NEW QUESTION 12
Which two are true concerning a multitenant container database with three pluggable database?

• A. All administration tasks must be done to a specific pluggable database.
• B. The pluggable databases increase patching time.
• C. The pluggable databases reduce administration effort.
• D. The pluggable databases are patched together.
• E. Pluggable databases are only used for database consolidation.

Answer: CE

NEW QUESTION 13
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 14
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.

Answer: AD

NEW QUESTION 15
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table?

• A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
• B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
• C. VPD policies are copied from the original table to the new table during online redefinition.
• D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

Answer: AC

NEW QUESTION 16
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 PD
• 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 CD
• D. The database is created as a non-CDB but can be plugged into an existing CD
• E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

Answer: AD

NEW QUESTION 17
Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Category_id number(30),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTS table?

• A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
• B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
• C. Referential integrity constraint cannot be set on the invisible column.
• D. The invisible column cannot be made visible and can only be marked as unuse
• E. A primary key constraint can be added on the invisible column.

Answer: ABE

NEW QUESTION 18
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

• A. Database replay
• B. SQL Tuning Advisor
• C. SQL Access Advisor
• D. SQL Performance Analyzer
• E. Automatic Workload Repository compare reports

Answer: D

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