1z0-074 Free Practice Test

InTESTDB, U1hasSYSDBAprivileges and the passwordOracle_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?

1. A. Recreate the password file with the password set toOracle_4U.
2. B. Change the password ofU1 to Oracle_123.
3. C. Set theREMOTE_LOGIN_PASSWORDFILEparameter value to NONE.
4. D. RegrantSYSDBA to U1.
5. E. Restart the database instance.

Correct Answer: A

Which two statements are true about FLEX ASM? (Choose two.)

1. A. A database instance on any node can connect to an ASM instance on any node.
2. B. A separate ASM network is required.
3. C. It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.
4. D. Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
5. E. Database instances that depend on an ASM instance that is terminated connect to a surviving ASMinstance.

Correct Answer: DE

You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?

1. A. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are not encrypted anywhere.
2. B. TEMPandUNDOtablespaces are transparently encrypted with AES128 by default only in the cloud.
3. C. TEMPandUNDOtablespaces are transparently encrypted with AES128 by default in an on-premise database.
4. D. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are transparently encrypted with AES128 only in an on-premise database.
5. E. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are transparently encrypted with AES128 only in the cloud.

Correct Answer: B

USER1is an OS user with the passwordoracleand is only a member of theoinstallgroup. In theORCLdatabase, theOS_AUTHEN_PREFIXvalue isops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally; SQL> GRANT create session TO ops$user1;
How canUSER1be given theSYSRACprivilege?

1. A. MakeUser1a member of the OSDBA group in Linux or theORA_%HOMENAME%_SYSDBAgroup in Windows only.
2. B. GrantSYSRACtouser1.
3. C. GrantSYSRACtoops$user1.
4. D. MakeUSER1a member of theOSRACDBAgroup in Linux or theORA_%HOMENAME%_SYSRACgroup in Windows.
5. E. GrantSYSDBAtoops$user1

Correct Answer: C

Identify two operations for which thebkup_apiutility can be used. (Choose two.)

1. A. to define the retention period for backups
2. B. to define which system files are backed up
3. C. to define which database configuration files are backed up
4. D. to define the cycle period for backups
5. E. to define the frequency of automatic backups

Correct Answer: AD