1Z1-060 by Oracle Actual Free Exam Q&As

Question 1

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 be plugged into a CDB. B. The database is created as a non-CDB and can never contain a PDB. C. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in. D. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB). E. The database is created as a non-CDB but can be plugged into an existing CDB.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

A. The optimizer used re-optimization cardinality feedback for the query. B. The optimizer used a dynamic plan for the query. C. The optimizer chose different plans because automatic dynamic sampling was enabled. D. The optimizer chose different plan because extended statistics were created for the columns used.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 3

What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)

A. The Oracle database can be created using Oracle Managed Files. B. The Oracle database will be automatically registered as a resource in Oracle Restart. C. It is the only way to have "automatic restart in place" after instance failure. D. The Oracle database will be easier to upgrade in the future. E. The Oracle database can be created using storage managed by ASM.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 4

Identify three valid methods of opening, pluggable databases (PDBs).

A. ALTER DATABASE OPEN issued from that PDB B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed D. ALTER DATABASE PDB OPEN issued from the root E. ALTER PLUGGABLE DATABASE OPEN issued from that PDB F. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB G. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB

Discussion 0

Correct Answer: A,B,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 5

To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = `/dev/flash_device_1' , `/dev/flash_device_2'
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

A. One 64G flash cache file will be used. B. It results in an error because these parameter settings are invalid. C. Two 32G flash cache files will be used. D. Two 64G flash cache files will be used.

Discussion 0

Correct Answer: B Vote an answer

Question 6

You use a recovery catalog for maintaining your database backups.
You execute the following command:

Which two statements are true? (Choose two.)

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

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 7

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 the hardware configuration of the database server C. Database and operating system upgrade D. Migration of database storage from non-ASM to ASM storage E. Change in your network infrastructure

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 8

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:

How can you prevent users having the EXECUTEprivilege on the CREATE_TESTprocedure from inserting values into tables on which they do not have any privileges?

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

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 9

Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (`SH', `CUSTOMERS', `PUBLISH',
`false');
Which three statements are true about the effect of this command?

A. Statistics collection is not done for the CUSTOMERS table when database stats are gathered. B. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. C. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics. D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics. E. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 10

Examine these two statements:

Which three are true about the MRKTtablespace? (Choose three.)

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

Discussion 0

Correct Answer: A,B,C Vote an answer

Oracle Upgrade to Oracle Database 12c - 1Z1-060 Exam Practice Test