Online Access Free 1z1-074 Exam Questions

The COMPATIBLE parameter is set to 12.2.0.0.0.
Which two statements are true about SQL identifier lengths? (Choose two.)

• A.Database link names can be as long as 30 bytes.
• B.Disk group, PDB, and tablespace names are limited to 30 bytes.
• C.Database names can be as long as 128 bytes.
• D.Table names can be as long as 128 bytes.
• E.Database names can be as long as 30 bytes.

U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace, TBS_CMP with default compression for query low.
You execute commands:

Which three statements are true? (Choose three.)

• A.T1 is in the TBS_UNCMP tablespace
• B.T1 is in compressed format
• C.All indexes on T1 remain valid
• D.T1 is in the TBS_CMP tablespace
• E.The primary key constraints on T1 are dropped
• F.T1 is in uncompressed format

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

• A.They can be created only if shared undo is enabled
• B.They require a clone instance to be created when used in a PDB flashback operation
• C.They require backups to be restored when used in a PDB flashback operation
• D.They can be created for a PDB when connected to either the PDB or to the root
• E.They are created as guaranteed restore points
• F.They can be created only for a PDB in the mount state

In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U.
You recreate the password file:
$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5
Examine the command and result:
$ sqlplus u1/Oracle_4U@testdb as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
What can you do to fix this error?

• A.Change the password of U1 to Oracle_123.
• B.Restart the database instance.
• C.Regrant SYSDBA to U1.
• D.Recreate the password file with the password set to Oracle_4U.
• E.Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.

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

• A.heap tables with composite primary key constraints
• B.index-organized tables stored in system-defined tablespaces
• C.sys-owned objects stored in sysaux-defined tablespaces
• D.heap tables with dependent materialized views
• E.clustered tables with dependent materialized views