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

Which two are true about Oracle recovery and data protection solutions? (Choose two.)

• A.RMAN can be used to roll back committed transactions.
• B.Data Recovery Advisor can be used to validate backup strategies.
• C.RMAN can be used to FLASHBACK a database.
• D.Oracle Data Guard can prevent data loss caused by a site failure.
• E.Data Recovery Advisor can be used to restore a single file from an RMAN backupset.

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression.
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• B.COLUMN STORE COMPRESS FOR QUERY LOW
• C.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D.ROW STORE COMPRESS BASIC
• E.ROW STORE COMPRESS ADVANCED

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

• A.V$SYSTEM_EVENT
• B.V$SESSION_WAIT
• C.V$SESSION
• D.V$SESSION_WAIT_CLASS
• E.V$SESSION_EVENT

Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)

• A.Make all user tablespaces "read only" before starting the upgrade.
• B.Run the Parallel Upgrade utility from the new Oracle home.
• C.Run Oracle Net Configuration Assistant (NETCA) to configure the listening protocol address and service information for the new release of Oracle Database.
• D.Run the Pre-Upgrade information tool on the source database.
• E.Start the existing database in upgrade mode.
• F.Take all user tablespaces offline before starting the upgrade.
• G.Copy the network configuration files from the existing database home to the new Oracle home location.

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

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