Oracle 1Z0-072 問題集

質問 1：
Which two are responsibilities of an Oracle DBA regarding database availability, backup, and recovery?
A. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode
B. implementing FLASHBACK DATA ARCHIVE to decrease MTTR
C. decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode
D. ensuring that critical components are protected by implementing redundancy
E. implementing FLASHBACK DATA ARCHIVE to decrease MTBF
正解：A,D

質問 2：
What three are true about Oracle Flashback technology? (Choose three.)
A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
B. FLASHBACK DATABASE can be used to rewind a database back and forth in time.
C. FLASHBACK QUERY can be used to view committed data at any given point in time.
D. FLASHBACK TABLE can be used to undo dropping a column from a table.
E. FLASHBACK TABLE can be used to rewind a table back in time.
正解：A,B,D

質問 3：
You execute this command to connect to an instance from a client on a different machine:
CONNECT username/password@net_service_name
No name servers are configured.
Which two are true about net_service_name? (Choose two.)
A. It must contain the address protocol for only one listener.
B. It must be defined in the tnsnames.ora file on the client side.
C. It must be defined in the tnsnames.ora file on the server side.
D. It must contain only one address protocol for one listener.
E. It must have the same name as the SERVICE_NAME defined in it.
正解：C,E

質問 4：
Which three statements are true about an spfile? (Choose three)
A. It must exist for a database instance to start.
B. It is the first file processed at instance startup.
C. It can be used to create a pfile.
D. It contains only static initialization parameters.
E. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.
F. It can be edited by SYS when the database instance is shut down.
正解：A,C,E

質問 5：
Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter.
Examine these steps:
1. Shut down the database instance.
2. Modify the parameter in the spfile with scope = SPFILE.
3. Modify the parameter in a pfile.
4. Use the spfile to create a pfile.
5. Use the pfile to create a spfile.
6. Modify the parameter in the spfile with scope = BOTH.
7. Start up the database instance.
Which are the minimum required steps in the correct order?
A. 6, 1, 7
B. 1, 2, 7
C. 1, 4, 3, 5, 7
D. 1, 7, 2
E. 2, 1, 7
正解：B

質問 6：
Which statement is true about database links?
A. Private database link creation requires the same user to exist in both the local and the remote database.
B. A database link created in a database allows a connection from that database instance to another, but not vice versa.
C. A public database link can be used by a user in the local database to connect to any schema in the remote database.
D. A public database link can be created only by SYS.
E. A database link can be created only between Oracle databases.
正解：B

質問 7：
Which two types of files are opened by a database instance in the NOMOUNT state?
A. data files
B. control files
C. the initialization parameter file
D. online redo logs
E. the alert log
正解：A,C

質問 8：
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)
A. ADDM can recommend extending the buffer cache.
B. By default, AWR snapshots are automatically purged after eight days.
C. ADDM can recommend shrinking the buffer cache.
D. By default, MMON creates an AWR snapshot every 30 minutes.
E. ADDM performs its analysis only whenever a DBA requests it.
F. AWR snapshots must be deleted when no longer required by ADDM.
正解：B,C,E

質問 9：
Which two operations can be performed on external tables? (Choose two.)
A. creating public synonyms
B. creating invisible indexes
C. executing UPDATE statements
D. creating partitions
E. creating views
正解：A,E