1z1-072 무료 덤프문제 온라인 액세스

Which two are true about incomplete recovery? (Choose two.)

• A.Incremental backups cannot be used to roll forward the database while performing it.
• B.It is possible only when the database is in MOUNT state.
• C.The database must have FLASHBACK enabled in order to perform it.
• D.Uncommitted transactions will be rolled back after it completes.
• E.Only RMAN backupsets can be used to restore a database as part of it.

Which two are true about the AL32UTF8 character set? (Choose two.)

• A.It is used to encode data for columns of any data type.
• B.It supports multilingual databases.
• C.It is used to store PL/SQL source code.
• D.It improves the I/O performance of a database compared to other character sets.
• E.It uses less space than other character sets, for all data types.

Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

• A.Users granted either SYSDBA or SYSOPER can mount or open a database.
• B.Users granted either SYSDBA or SYSOPER can query data in all user schemas.
• C.Only users granted SYSDBA can query or update tables in all user schemas.
• D.Users granted either SYSDBA or SYSOPER connect to an instance as SYS.
• E.Only users granted SYSDBA can take a complete backup of a database.
• F.Only users granted SYSDBA can start up and shut down a database instance.

Which two are true about the default listener for a single instance database? (Choose two.)

• A.It uses the settings of the INSTANCE_NAME and SERVICE_NAMES parameters from all databases using that listener.
• B.It must support at least one service on startup.
• C.It must be defined by using the Listener Control utility.
• D.It must be defined in the LISTENER.ORA file.
• E.It listens on the default port 1521.

Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)

• A.They display how often a database instance performs particular operations.
• B.They are maintained at the session and system level.
• C.They reveal the cause of performance problems.
• D.They are grouped into classes.
• E.All events might be used by an instance regardless of parameter settings.