1Z0-060 Online Practice Questions and Answers

Which statement is true about Oracle Net Listener?

A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

B. A single listener can service only one database instance and multiple remote client connections.

C. Service registration with the listener is performed by the listener registration process (LREG) process of each database instance.

D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directory.

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

B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

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. It results in an error because these parameter settings are invalid.

B. One 64G flash cache file will be used.

C. Two 64G flash cache files will be used.

D. Two 32G flash cache files will be used.

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

E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

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? (Choose two.)

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.

In which two scenarios do you use SQL* Loader to load data?

A. Transform the data while it is being loaded into the database.

B. Use transparent parallel processing without having to split the external data first.

C. Load data into multiple tables during the same load statement.

D. Generate unique sequential key values in specified columns.

Oracle Data Redaction is active on the SCOTT.EMP table.

You queried the table twice.

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

Which is guaranteed to be true concerning the redaction policy?

A. FULL redaction is active on the SAL column

B. RANDOM redaction is active on the MGR column

C. RANDOM redaction is active on the HIREDATE column

D. PARTIAL redaction is active on the MGR column.

E. PARTIAL redaction is active of the HIREDATE column.

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges: Which statement is true about the common user created by the command?

A. The user cannot connect any database because the CONTAINER clause is missing.

B. The user can connect only to the root database.

C. The user can connect to the root and all PDBs.

D. The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.

Your database uses Automatic Memory Management, and has the large pool configured.

You issue the following command:

SQL> ALTER SYSTEM SET SHARED_SERVERS = 5;

Which statement is true about the shared server configuration?

A. It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured.

B. It is enabled and the UGA is located in the large pool for connections that use the shared server configuration.

C. It is enabled only if at least five dispatchers are configured.

D. It is enabled and all the DBA and non-DBA sessions function in shared server mode.

Your multitenant container database (CDB) contains several pluggable databases (PDBs).

A common user C##A_ADMIN, is created with connect privileges.

You execute this command from the root container:

SQL> GRANT create tablespace to C##A_ADMIN;

Which statement is true?

A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root container.

B. The command fails because the CONTAINER=ALL clause is not used.

C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root container as well as in the PDBs.

D. The command fails because the CONTAINER=CURRENT clause is not used.