all the data files belonging to the USERS tablespace
password file
online redo log files
the current control file
archived redo log files
the current server parameter file
data files belonging to the USERS tablespace and all the default tablespaces
第1题：
A. It collects statistics into the pending area in the data dictionary
B. It creates a virtual hidden column in the CUSTOMERS_OBE table
C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT
D. It creates a histogram to hold skewed information about the data in the columns
第2题：
Which of the following will occur if %temp% is executed from the run command?（）
第3题：
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
第4题：
tony would like to make it easier for users of the video application to enter new doc using the “video form”, he’d like users to be able to create new “video” doc form within the view. Which one of the following should tony so to build this interface?（）
第5题：
The command frame-relay map ip 10.121.16.8 102 broadcast was entered on the router. Which of the following statements is true concerning this command（）。
第6题：
The command frame-relay map ip 10.121.16.8 102 broadcast was entered on the router. Which of the following statements is true concerning this command？（）
第7题：
Which of the following command allows you to view the UDI information for a Cisco device?（）
第8题：
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）
A. The command performs the recovery and closes the failures.
B. The command only displays the advice and the RMAN script required for repair.
C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
第9题：
A site administrator is configuring Command-level access control. Which of the following statements about Command-level access control are true？ Command level access control policies： （）
第10题：
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）