单选题What is true regarding direct-load insert？（）A A direct-load insert can be invoked by suing the APPEND hint.B Inserting using the NOLOGGING option is the default for direct-load inserts.C All data loaded using direct-load insert is loaded below the high

第1题：

Which of the following can be used to insert a new line below the current line inside a vi session?（）

• A、o
• B、a
• C、p
• D、A

第2题：

Which two statements are true with regard to policy ordering? （）(Choose two.)

• A、The last policy is the default policy, which allows all traffic.
• B、The order of policies is not important.
• C、New policies are placed at the end of the policy list.
• D、The insert command can be used to change the order.

第3题：

Which object privileges can be granted on a view? （）

• A、none
• B、DELETE, INSERT,SELECT
• C、ALTER, DELETE, INSERT, SELECT
• D、DELETE, INSERT, SELECT, UPDATE

第4题：

Which two statements are true regarding the USING and ON clauses in table joins?（）

• A、Both USING and ON clauses can be used for equijoins and nonequijoins 
• B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
• C、The ON clause can be used to join tables on columns that have different names but compatible data types 
• D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

第5题：

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）

• A、The command fails because SCOTT still has privileges.
• B、The command succeeds and privileges are revoked from JIM.
• C、The command fails because HR cannot revoke the privileges from JIM.
• D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

第6题：

Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）

• A、The constraint remains valid.
• B、The index on the constraint is dropped.
• C、It allows the loading of data into the table using SQL *Loader.
• D、New data conforms to the constraint， but existing data is not checked.
• E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which two statements are true regarding rescue configurations?（）

• A、Once saved, a rescue configuration is loaded using the rollback 0 command.
• B、The rescue configuration must contain the minimal elements necessary to restore network connectivity.
• C、A minimal rescue configuration is defined by default.
• D、A rescue configuration must include a root password.

第14题：

Which three are true?（）

• A、A MERGE statement is used to merge the data of one table with data from another.
• B、A MERGE statement replaces the data of one table with that of another.
• C、A MERGE statement can be used to insert new rows into a table.
• D、A MERGE statement can be used to update existing rows in a table.

第15题：

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）

• A、GRANT select, insert, update ON student_grades TO manager
• B、GRANT select, insert, update ON student_grades TO ROLE manager
• C、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
• D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
• E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;  
• F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;

第16题：

What is true regarding direct-load insert？（）

• A、A direct-load insert can be invoked by suing the APPEND hint.
• B、Inserting using the NOLOGGING option is the default for direct-load inserts.
• C、All data loaded using direct-load insert is loaded below the high-water mark.
• D、An object that is modifies using parallel direct-load can be queried within the same Transaction.

第17题：

Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

• A、The constraint remains valid.
• B、The index on the constraint is dropped.
• C、It allows the loading of data into the table using SQL*Loader.
• D、New data conforms to the constraint， but existing data is not checked
• E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

第18题：

You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）

• A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
• B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
• C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.
• D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：