Online Access Free 1z0-074 Exam Questions

USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;
How can USER1 be given the SYSRAC privilege?

• A.Grant SYSRAC to user1.
• B.Grant SYSRAC to ops$user1.
• C.Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.
• D.Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.
• E.Grant SYSDBA to ops$user1

A multi-tenant container database (CDB) contains three PDBs.
Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

• A.The CDB must use Automatic Memory Management.
• B.Flashback database must be enabled for the CDB.
• C.The source and target platforms must have the same endianness.
• D.The CDB should be in MOUNT state.
• E.The source PDBs must be closed for a cross-platform PDB backup.
• F.The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.

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.Regrant SYSDBA to U1.
• B.Recreate the password file with the password set to Oracle_4U.
• C.Restart the database instance.
• D.Change the password of U1 to Oracle_123.
• E.Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.

Examine these statements:

Which statement is true?

• A.Only statement 3 will validate the conversion
• B.All the statements will validate the conversion
• C.Statement 1 will return an error
• D.Only statement 1 will validate the conversion
• E.Statements 2 and 3 will validate the conversion

Identify a situation where performance profiles can be used for application containers.

• A.to enforce a limit on the number of I/OS issued per second
• B.to specify the total number of parallel execution servers available
• C.to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out
• D.to enforce a limit on I/O throughput per second
• E.to specify the maximum percentage of the parallel execution server pool that a particular application container can use