1Z0-062 Practice Questions

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

You want to load data from a large file into your database without causing an overhead on the SGA. Which tool would you use.

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database. Which two tools or utilities would you use to achieve this? (Choose two.)

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

All of your database instances use SPFILES. You executed this command in one of them: ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M; Which statement is true?

Which two utilities can NOT configure a new listener on port 1526? (Choose two.)

In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three.)

One of your databases runs in ARCHIVELOG mode. Examine this command: Now examine these steps executed from RMAN: 1) SHUTDOWN IMMEDIATE 2) STARTUP MOUNT 3) BACKUP DATABASE; 4) BACKU...

Which are three of the input sources for the SQL Tuning Advisor? (Choose three.)

Which two can be recommendations given by SQL Access Advisor? (Choose two.)