1Z0-074 Online Practice Questions and Answers

Your CDB has a PDB, EMP_PDB.

You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

Which two statements are true about C##USR1? (Choose two.)

A. It can connect to EMP_PDB and view the data only in tables created by common users.

B. It can connect to EMP_PDB but cannot view the data in any table in it.

C. It can connect only to the root.

D. It is a common user.

E. It is a local user.

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.

BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with

invoker's right.

BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.

When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to

update?

A. CUST_RECORDS table in Bixby's schema

B. CUST_RECORDS table in Murdok's schema

C. CUST_RECORDS table in Rlayton's schema

D. CUST_RECORDS table in the schema of Bixby and Rlayton

E. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

Which two statements are true about a band join? (Choose two.)

A. The optimizer always uses the smaller of the two row sources to build a hash table on the join key.

B. It returns rows for SQL statements that contain an equijoin.

C. It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.

D. For each row in the first row source, Oracle probes the second row source for matching rows and joins them.

E. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.

The TESTDB container database (CDB) running in ARCHIVELOG mode contains two pluggable

databases (PDBs) PDB1 and PDB2. A connect descriptor for TESTDB is mapped to the TNS alias testdb

in tnsnames.ora.

The default RMAN configuration is used.

Examine these commands:

Which files are backed up?

A. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and FLASHBACKLOGS

B. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and ARCHIVELOGS

C. all root and PDB1 data files, and the CONTROLFILE and SPFILE

D. all root and PDB1 data files, and the CONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS

E. all root and PDB1 data files

The EMP_CDB1 and EMP_CDB2 CDBs are in ARCHIVELOG mode.

Oracle Managed Files is enabled in both CDBs.

EMP_CDB1 has a PDB, EMP_PDB1.

In EMP_CDB2, you log in as the SYS user.

You plan to execute this statement:

CREATE PLUGGABLE DATABASE emp_pdb2 FROM emp_pdb1@emp_link RELOCATE;

Which two statements are true? (Choose two.)

A. The AVAILABILITY MAX clause should be added to the command to ensure transaction consistency during the relocation process.

B. SYSOPER privilege should be granted to the user defined in EMP_LINK and used to connect to the remote database.

C. EMP_PDB2 should be opened in read-write mode to complete the relocation process.

D. EMP_PDB1 should be dropped manually from EMP_CDB1 after executing the relocating command.

E. EMP_LINK should exist as a public link in EMP_CDB1 and EMP_CDB2.

F. Only EMP_PDB1 should be in local undo mode.

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?

A. for parallel query performance only

B. for query performance and space saving

C. for query performance and space saving with greater bias toward space saving

D. for query performance only

E. for space saving only

You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

The SCOTT user has the SELECT privilege on HR.EMP.

Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?

A. All their queries display blanks for LAST_NAME and the true contents of the SALARY column.

B. Only SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.

C. All their queries display blanks for LAST_NAME and zeroes for SALARY.

D. Only SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.

E. Only SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.

Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

A. It analyzes only those memory components of the database instance that are impacting performance.

B. It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.

C. It analyzes the performance of the database instance based on the latest two AWR snapshots.

D. It determines SQL statements that are performing poorly.

E. It recommends implementing SQL profiles to generate better execution plans.

F. It analyzes only the components and waits that are impacting database performance.

Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

A. subpartitions

B. clustered tables

C. materialized views

D. index-organized tables

E. heap tables

F. any SYS owned objects

You execute this command in your database: ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;

How does this affect the creation of tablespaces?

A. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are not encrypted anywhere.

B. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud.

C. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise database.

D. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in an on- premise database.

E. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in the cloud.