High quality 1Z0-060 Exam Questions 2021

NEW QUESTION 1
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12C.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A. The valid time columns employee_time_start and employee_time_end are automatically create
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is describe
• E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABE

NEW QUESTION 2
Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?

• A. System privileges apply only to the PDB in which they are use
• B. Local users cannot use local system privileges on the schema of a common user.
• C. The granter of system privileges must possess the set container privilege.
• D. Common users connected to a PDB can exercise privileges across other PDBs.
• E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

Answer: ACE

NEW QUESTION 3
The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

• A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
• C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
• D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• F. BACKUP SPFILE SECTION SIZE 1M;
• G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Answer: ABEG

NEW QUESTION 4
On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);
Which two statement are correct?

• A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
• B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
• C. Only the ORD_CUSTOMER_IX1 index is create
• D. Only the ORD_CUSTOMER_IX2 index is create
• E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

Answer: AE

NEW QUESTION 5
You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true?

• A. Corrupted blocks, if any, are repaire
• B. Checks are performed for physical corruptions.
• C. Checks are performed for logical corruptions.
• D. Checks are performed to confirm whether all database files exist in correct locations
• E. Backup sets containing both data files and archive logs are create

Answer: BD

NEW QUESTION 6
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?

• A. SYSTEM
• B. SYSAUX
• C. EXAMPLE
• D. UNDO
• E. TEMP
• F. USERS

Answer: ABE

NEW QUESTION 7
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

• A. Tracking the most recent read time for a table segment in a user tablespace
• B. Tracking the most recent write time for a table segment in a user tablespace
• C. Tracking insert time by row for table rows
• D. Tracking the most recent write time for a table block
• E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
• F. Tracking the most recent write time for a table segment in the SYSAUX tablespace

Answer: ABD

NEW QUESTION 8
Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

• A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
• B. It succeeds only if memory is available from the autotuned components if SG
• C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
• D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: D

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

• 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 logge
• E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Answer: C

NEW QUESTION 10
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename
VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

• A. Create the CREATE_TEST procedure with definer’s rights.
• B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
• C. Create the CREATE_TEST procedure with invoker’s rights.
• D. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

Answer: C

NEW QUESTION 11
You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE
tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

• A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
• B. It generates an error when creating the table because the wallet is close
• C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Answer: B

NEW QUESTION 12
Your 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 database fully operational?

• A. Mount the container database (CDB) and restore the control file from the control file auto backup.
• 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 control file auto backup.

Answer: CDF

NEW QUESTION 13
Which three statements are true about Oracle Data Pump export and import operations?

• A. You can detach from a data pump export job and reattach later.
• B. Data pump uses parallel execution server processes to implement parallel import.
• C. Data pump import requires the import file to be in a directory owned by the oracle owner.
• D. The master table is the last object to be exported by the data pump.
• E. You can detach from a data pump import job and reattach later.

Answer: ADE

NEW QUESTION 14
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

• A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
• B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
• C. All the components may be moved into SYSAUX tablespace.
• D. All the components may be moved from the SYSAUX tablespace.

Answer: AB

NEW QUESTION 15
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 16
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapseD.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?

• A. Increase the value of the ASM_POWER_LIMIT parameter.
• B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
• C. Specify the statement that adds the disk back to the disk group.
• D. Increase the number of ASMB processes.
• E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Answer: AC

NEW QUESTION 17
A 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 to
TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

• A. Execute the query and view Active Session History (ASH) for information about the query.
• 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 monitor query execution and view the information from the V$SESSION_LONGOPS view.

Answer: C

NEW QUESTION 18
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?

• A. The index remains invisible.
• B. The index is not updated by the DML statements on the indexed table.
• C. The index automatically becomes visible in order to have it updated by DML on the table.
• D. The index becomes unusable but the table is updated by the DML.
• E. The index is updated by the DML on the table.

Answer: AE

NEW QUESTION 19
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?

• A. The database must have multiplexed redo logs for the flashback to succee
• B. The database must be MOUNTED for the flashback to succee
• C. The database must use block change tracking for the flashback to succee
• D. The database must be opened in restricted mode for the flashback to succee
• E. The database must be opened with the RESETLOGS option after the flashback is complete.
• F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Answer: BE