Online Access Free 1z1-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 ops$user1.
• B.Grant SYSDBA to ops$user1
• C.Grant SYSRAC to user1.
• D.Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.
• E.Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.

Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)

• A.It automatically resets the COMPATIBLE parameter value to 12.0.0
• B.It modifies or creates new tablespaces as required
• C.It calls the catctl.pl script to perform the upgrade process in parallel
• D.It drops all the invalid objects
• E.It changes Oracle kernel parameters if required
• F.It creates a restore point to restore the database if the upgrade fails

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

• A.to specify the total number of parallel execution servers available
• B.to enforce a limit on I/O throughput per second
• 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 specify the maximum percentage of the parallel execution server pool that a particular application container can use
• E.to enforce a limit on the number of I/OS issued per second

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 uncompressed format
• B.T1 is in compressed format
• C.T1 is in the TBS_CMP tablespace
• D.T1 is in the TBS_UNCMP tablespace
• E.The primary key constraints on T1 are dropped
• F.All indexes on T1 remain valid

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

• A.It always executes triggers that are fired recursively in FULLDML mode.
• B.It recommends the creation of indexes for regressed SQL statements.
• C.It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).
• D.It generates execution plans for each SQL statement in an STS.
• E.It recommends the use of SQL Tuning Advisor for regressed SQL statements.