最新的Oracle Database 11g: Administration I - 1Z1-052免費考試真題
You want to configure and schedule offline database backups to run automatically.
Which tool or utility would you use to achieve this?
Which tool or utility would you use to achieve this?
正確答案: D
Which structure can span multiple data files?
正確答案: D
說明：（僅 Fast2test 成員可見）
Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)
正確答案: C,D,F
說明：（僅 Fast2test 成員可見）
Which two are true about data dictionary views? (Choose two.)
正確答案: C,D
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:
1) Shut down the instance.
2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3) Execute the ALTER DATABASE FLASHBACK OFF command.
4) Start up the instance and mount the database.
5) Execute the ALTER DATABASE FLASHBACK ON command.
6) Open the database.
Select the correct order in which these tasks need to be performed.
1) Shut down the instance.
2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3) Execute the ALTER DATABASE FLASHBACK OFF command.
4) Start up the instance and mount the database.
5) Execute the ALTER DATABASE FLASHBACK ON command.
6) Open the database.
Select the correct order in which these tasks need to be performed.
正確答案: A
說明：（僅 Fast2test 成員可見）
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
What is the effect of this command?
正確答案: A
View the Exhibit and examine the privileges granted to the SL_REP user.
The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command?
The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command?
正確答案: A
In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:
1 . The user account must be locked after four unsuccessful login attempts.
2 . The user must be prompted to change the password at regular intervals.
3 . The user may not have more than three simultaneous sessions.
4 . The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?
1 . The user account must be locked after four unsuccessful login attempts.
2 . The user must be prompted to change the password at regular intervals.
3 . The user may not have more than three simultaneous sessions.
4 . The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?
正確答案: B
Identify the logical structure that will never have more than one data segment created for it.
正確答案: E
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.
Which constraints will remain enabled by default during this operation? (Choose all that apply.)
Which constraints will remain enabled by default during this operation? (Choose all that apply.)
正確答案: A,C,D
Which two affect the time taken for instance recovery? (Choose two.)
正確答案: A,F
說明：（僅 Fast2test 成員可見）
Which two are true about consistent database backups? (Choose two.)
正確答案: A,E
說明：（僅 Fast2test 成員可見）