1z0-062 無料問題集「Oracle Database 12c: Installation and Administration」

（A）The local naming method does not support connect-time failover and load-balancing options.

（B）Local naming supports multiple protocols, but for any one connection, the client and server must use the same protocol.

（C）In the Easy Connect method, clients can connect to a database server by using the host name of the database with an optional port and service name.

（D）In the Easy Connect method, the listener port and IP address must be provided for the connection to be successful.

（E）The directory naming method supports connect-time failover and load-balancing options.

（A）Resumable space allocation does not apply when a database instance uses asynchronous commit.

（B）Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.

（C）SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.

（D）A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.

（E）A resumable statement can be suspended and resumed only once during a session.

（F）Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.

（A）recommending optimization of materialized views

（B）recommending restructuring of SQL statements that have suboptimal plans

（C）checking schema objects for missing and state statistics

（D）generating SQL profiles

（E）recommending creation of indexes based on SQL workload

（A）The root container can be flashed back without flashing back the pluggable databases (PDBs).

（B）The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

（C）A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

（D）Individual PDBs can be flashed back without flashing back the entire CDB.

（E）To enable flashback database, the CDB must be mounted.

（A）inactive online redo log file group

（B）a data file belonging to the SYSAUX tablespace

（C）a data file belonging to the default temporary tablespace

（D）active online redo log le group

（E）server parameter le (SPFILE)

（F）all the control flies

（A）the Automatic Database Diagnostic Monitor (ADDM)

（B）the shared SQL area

（C）the AWR Compare Periods Report

（D）the SQL Access Advisor

（E）the private SQL area

（F）the Automatic Workload Repository (AWR)

（A）The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

（B）The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

（C）The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

（D）The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

（E）The MYTAB table is owned by the SYS user.

（A）Use transparent parallel processing without having to split the external data first.

（B）Load data into multiple tables during the same load statement.

（C）Transform the data while it is being loaded into the database.

（D）Generate unique sequential key values in specified columns.

（A）Flashback Database uses a restored control file to recover a database.

（B）Flashback Database can recover a database to the state that it was in before a reset logs operation.

（C）Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

（D）The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

（E）Flashback Database can recover a data file that was dropped during the span of time of the flashback.

（F）Flashback logs are written sequentially, and are archived.

（A）It can be used to perform database backup operations.

（B）It is available only when the database is open.

（C）It can use the HTTPS protocol.

（D）It can use the HTTP protocol.

（E）The same port number is used for multiple Database Express configurations on the same host.

（A）A SYSMAN user with SYSDBA privilege must be created

（B）The APEX_PUBLIC_USER role must be granted to SYSMAN

（C）At least one TCP/IP dispatcher must be configured

（D）A port number for Oracle HTTP Server must be configured

（E）The Oracle HTTP Server must be installed

（A）Oracle Net Configuration Assistant

（B）Oracle Enterprise Manager Database Express

（C）Oracle Enterprise Manager Cloud Control

（D）Listener Control Utility (LSNRCTL)

（E）Oracle Net Manager

（A）You should set the OS_ROLES parameter to true.

（B）You should be granted the role with the GRANT OPTION.

（C）You should be granted the DBA role.

（D）You should have the ALTER ANY ROLE system privilege.

（A）Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
OCP.EXAM_RESULTS; connected as SYSTEM.

（B）Recover the table using traditional Tablespace Point In Time Recovery.

（C）Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
EXAM_RESULTS; connected as the OCP user.

（D）Recover the table using Automated Tablespace Point In Time Recovery.

（E）Recovery the table using Database Point In Time Recovery.