Oracle 1Z0-060 Study Guides 2021

NEW QUESTION 1
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 2
Which three actions are possible during an Online Data file Move operation?

• A. Creating and dropping tables in the data file being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the data file being moved
• D. Performing Block Media Recovery for a data block in the data file being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the data file being moved

Answer: ACF

NEW QUESTION 3
Which three statements are true about using flashback database in a multitenant container database (CDB)?

• A. The root container can be flashed back without flashing back the pluggable databases (PDBs).
• B. To enable flashback database, the CDB must be mounte
• C. Individual PDBs can be flashed back without flashing back the entire CD
• D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CD
• E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Answer: BDE

NEW QUESTION 4
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?

• A. The keep pool is not configure
• B. Automatic Workarea Management is not configure
• C. Automatic Shared Memory Management is not enable
• D. The data blocks in the SUBSCRIBE_LOG table are rarely accesse
• E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

Answer: D

NEW QUESTION 5
Which two statements are true about the Oracle Direct Network File system (DNFS)?

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

Answer: CE

NEW QUESTION 6
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 7
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 8
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

• A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
• D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• E. Re-create the password file in the Oracle Database 12c format.

Answer: BD

NEW QUESTION 9
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 10
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 11
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 12
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 13
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

• A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• B. It fails and reports an error because the CONTAINER=ALL clause is not use
• C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not use
• E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Answer: A

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

• 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 15
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A. By default, EM express is available for a database after database creation.
• B. You can use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database Instance by using EM express.
• E. You can create and configure pluggable databases by using EM express.

Answer: D

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