1Z0-074 Online Practice Questions and Answers

Which statement is true about transportable tablespaces?

A. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.

B. The cannot be dictionary-managed tablespaces

C. The source tablespace can be encrypted D. They can be administrative tablespaces such as SYSTEM or SYSAUX

You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks. Which statement is true about limiting PGA usage for those users' sessions?

A. You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.

B. You cannot limit PGA for a set of database user sessions.

C. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.

D. You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.

E. You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2.

USER1 is a local user in PDB1 and has the SYSBACKUP privilege.

Connect descriptors for PDB1 and PDB2 are mapped to TNS aliases pdb1 and PDB2 in tnsnames.ora.

Examine these commands executed by USER1 when all PDBs are open:

What is the outcome and why?

A. An error is returned because the user is connected to a pluggable database.

B. The current date is displayed.

C. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax: SQL"".

D. An error is returned because the user is not SYS.

E. An error is returned because the user is not a common user.

Which statement is true about Trace File Analyzer (TFA) Collector?

A. TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.

B. If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.

C. It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.

D. In Oracle 12c Release 2, TFA installation can be done only while executing root.sh.

E. It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.

Examine this command:

Which statement is true?

A. Up to four worker processes are allocated to export data and metadata

B. Four worker processes are allocated to export only data

C. Four worker processes are active to export only metadata

D. Four worker processes are allocated to export data and metadata

E. Four worker processes are allocated when there is sufficient CPU available

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. Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.

B. Grant SYSRAC to user1.

C. Grant SYSRAC to ops$user1.

D. Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.

E. Grant SYSDBA to ops$user1

In which situation can the optimizer choose a hash join?

A. when a non-equijoin is used and the join column in at least one of the tables is a primary key

B. when a non-equijoin is used and the join column for both tables is a primary key

C. when a non-equijoin is used between a table and a sorted hash cluster

D. when an equality operator is used

E. when any self-join is done

Which statement is true about policy expressions?

A. A named policy expression is stored in the Data Masking format library.

B. A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.

C. A redacted table can have only one policy expression defined on it.

D. A policy expression can be applied to columns in different redacted tables.

E. A named policy expression is stored in the Enterprise Manager Database Express repository.

In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?

A. grid

B. oracle

C. opc

D. nobody

E. oinstall

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH

MODE EVERY 5 MINUTES clause.

What happens every five minutes?

A. An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.

B. PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.

C. PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.

D. PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.

E. An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)

A. It defers invalidating dependent cursor when possible.

B. It cannot be used for bitmap index creation.

C. The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause.

D. It always overrides the CURSOR_INVALIDATION setting.

E. It cannot be used for creating a secondary index on index organized tables

Which statement is true about the Automatic Diagnostic Repository (ADR)?

A. Space used by the ADR can be limited to a user-specified value.

B. Space used by the ADR is limited based only on the retention period.

C. The retention period for the ADR is set based on the space limit specified.

D. When the ADR reaches the space limit, it deletes incident dumps and metadata before deleting old core dumps.

E. Manual purging of all types of ADR files is allowed.

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A. number of parallel queries issued by a consumer group

B. maximum number of DML operations performed by a consumer group

C. sessions that are blocking other sessions

D. sessions that are not blocking other sessions

E. UNDO quota for a consumer group

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.

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

A. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

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 always executes triggers that are fired recursively in FULLDML mode.

E. It generates execution plans for each SQL statement in an STS.