Online Access Free 1z0-062 Exam Questions

Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback?
(Choose three.)

• A.After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
• B.The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• C.The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
• D.The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
• E.The optimizer can re optimize a query only once using cardinality feedback.

Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)

• A.At least one TCP/IP dispatcher must be configured
• B.A SYSMAN user with SYSDBA privilege must be created
• C.A port number for Oracle HTTP Server must be configured
• D.The Oracle HTTP Server must be installed
• E.The APEX_PUBLIC_USER role must be granted to SYSMAN

Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)

• A.All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
• B.All data definition language (DDL) statements are written to the control file
• C.Some data definition language (DDL) statements are written to the control file
• D.The Alert Log still contains some DDL statements
• E.Some DDL statements are written to an XML file in the ADR home
• F.Some DDL statements are written to a text file in the ADR home

Which three statements are true concerning the multitenant architecture? (Choose three.)

• A.Instance recovery is always performed at the CDB level.
• B.Different PDBs can have different default block sizes.
• C.A PDB can have a private temp tablespace.
• D.PDBs share a common system tablespace.
• E.Log switches occur only at the multitenant container database (CDB) level.
• F.PDBs can share the sysaux tablespace.
• G.Each pluggable database (PDB) has its own set of background processes.

What is pre-requisite to alter a role?

• A.You should have the ALTER ANY ROLE system privilege.
• B.You should be granted the DBA role.
• C.You should be granted the role with the GRANT OPTION.
• D.You should set the OS_ROLES parameter to true.