单选题You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tab

第1题：

第2题：

Which statement is true about a forwarding table?（）

• A、It stores a subset of information from the routing table.
• B、It contains routes learned from all protocols to a destination.
• C、It provides a database for routes selected and placed into the routing table.
• D、Every routing protocol maintains its own forwarding table.

第3题：

You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）

• A、CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));
• B、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));
• C、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));
• D、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));

第4题：

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）

• A、ALTER TABLE students ADD PRIMARY KEY student_id;
• B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);
• C、ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
• D、ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);

第5题：

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;

第6题：

Which statement explicitly names a constraint?（）

• A、ALTER TABLE student_grades   ADD   FOREIGN KEY (student_id) REFERENCES students(student_id);
• B、ALTER TABLE student_grades   ADD CONSTRAINT NAME = student_id_fk   FOREIGN KEY (student_id) REFERENCES students(student_id);
• C、ALTER TABLE student_grades   ADD CONSTRAINT student_id_fk   FOREIGN KEY (student_id) REFERENCES students(student_id);
• D、ALTER TABLE student grades   ADD NAMED CONSTRAINT student_id_fk   FOREIGN KEY (student_id) REFERENCES students(student_id);
• E、ALTER TABLE student grades   ADD NAME student_id_fk   FOREIGN KEY (student_id) REFERENCES students(student_id);

第7题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?（）  

• A、On the Products table, you should create a view. 
• B、On the RadioSize column, you should create a clustered index 
• C、On the RadioSize column, you should create a filtered index 
• D、On the RadioSize column, you should create a unique clustered index

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.  What should you do？（）

• A、Implement a stored procedure that writes data about schema changes to a log table.
• B、Implement DDL AFTER triggers that write user and schema information to a log table.
• C、Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.
• D、Implement a DML AFTER trigger that writes data about schema changes to a log table.

第15题：

Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）

• A、Allocates memory for RMAN backup and restore operations
• B、Allocates memory for shared and private SQL areas
• C、Contains a cursor area for storing runtime information about cursors
• D、Contains stack space
• E、Contains a hash area performing hash joins of tables

第16题：

You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

• A、Information about each Oracle Net connection.
• B、Information about each entry in theLinstener.orafile
• C、Information about the changed done in the database
• D、Information about the different listeners in your system
• E、Information about all thenondatabasefiles required to operate the database

第17题：

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）

• A、ALTER TABLE students ADD PRIMARY KEY _ id;
• B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
• C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
• D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
• E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

第18题：

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）

• A、ALTER TABLE students ADD PRIMARY KEY student_id;
• B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
• C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
• D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
• E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

第19题：

第20题：

第21题：

第22题：

第23题：