单选题You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employe

第1题：

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

• A、MERGE
• B、INSERT
• C、UPDATE
• D、ADD
• E、ENTER
• F、You cannot enter the phone numbers for the existing employee records.

第2题：

You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）

• A、You get an error because of a primary key violation.
• B、The data and structure of the EMPLOYEES table are deleted.
• C、The data in the EMPLOYEES table is deleted but not the structure.
• D、You get an error because the statement is not syntactically correct.

第3题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

• A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
• B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
• C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
• D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
• E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
• F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

第4题：

Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）

• A、CREATE INDEX NAME _IDX (first_name, last_name);
• B、CREATE INDEX NAME _IDX (first_name, AND last_name)
• C、CREATE INDEX NAME_IDX ON (First_name, last_name);
• D、CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
• E、CREATE INDEX NAME_IDX ON employees (First_name, last_name);
• F、CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

第5题：

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）

• A、CLOB
• B、BLOB
• C、BFILE
• D、LONG RAW

第6题：

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）

• A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
• B、Define the new column as NOT NULL with a default value of ’Undefined.’
• C、Define the new column as NULL. Use application logic to enforce the data constraint.
• D、Define the new column as NULL with a default value of ’Undefined.’

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）

• A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.
• B、Create a CHECK constraint.
• C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
• D、Create a DML AFTER trigger that writes the failed records to a file or table.

第14题：

You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）

• A、ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
• B、MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
• C、ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
• D、MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
• E、CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
• F、You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.

第15题：

Examine the data in the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA*DIR 6500 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: CREATE TABLE departments (department_id NUMBER PRIMARY KEY, department _ name VARCHAR2(30)); CREATE TABLE employees (EMPLOYEE_ID NUMBER PRIMARY KEY, EMP_NAME VARCHAR2(20), DEPT_ID NUMBER REFERENCES departments(department_id), MGR_ID NUMBER REFERENCES employees(employee id), MGR_ID NUMBER REFERENCES employees(employee id), JOB_ID VARCHAR2(15). SALARY NUMBER); ON the EMPLOYEES, On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: DELETE FROM departments WHERE department id = 40; What happens when you execute the DELETE statement?（）

• A、Only the row with department ID 40 is deleted in the DEPARTMENTS table.
• B、The statement fails because there are child records in the EMPLOYEES table with department ID 40.
• C、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
• D、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
• E、The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
• F、The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.

第16题：

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

• A、MERGE
• B、INSERT
• C、UPDATE
• D、ADD
• E、ENTER
• F、You cannot enter the phone numbers for the existing employee records.

第17题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

• A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
• B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
• C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
• D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
• E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
• F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：