to support PUSH-based active database duplication
to support synchronization of a standby database with the primary database in a Data environment
To support PULL-based active database duplication
To support file restores over the network in a Data Guard environment
To support file recovery over the network in a Data Guard environment
第1题：
A.A
B.B
C.C
D.D
E.E
第2题：
A.A table referenced in the FROM clause has no indexed column.
B.The table referenced in the FROM clause has more than 200 columns.
C.Two or more tables in the FROM clause have identical column names.
D.The FROM clause contains two or more tables in the SELECT statement.
第3题：
What would Hilary expect most from modern life in the three months? [ ]
A To play computer games
B To make phone calls
C To listen to music
D To chat on the Internet
第4题：
What is the purpose of the catalog command？（）
第5题：
In which of the following situations should correlation names be used?（）
第6题：
You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.
You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.
You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.
What should you do?
A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.
B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.
C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.
D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
第7题：
In which four clauses can a subquery be used?（）
第8题：
A. in the INTO clause of an INSERT statement
B. in the FROM clause of a SELECT statement
C. in the GROUP BY clause of a SELECT statement
D. in the WHERE clause of a SELECT statement
E. in the SET clause of an UPDATE statement
F. in the VALUES clause of an INSERT statement
第9题：
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）
第10题：
You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command： RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS； When a backup is performed， what would be the status of this backup after seven days？（）