ITS Databases Practice Exam #16

University:
American Baptist College
Course:
CIT370 | Database Design and Processing
Academic year:

2024
Views:

466

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. A database developer is creating an orderdetails table. As part of the table, orderids should come from the orders table. Which SQL statement satisfies this requirement for creating the table? A. CREATE TABLE OrderDetails ( OrderID int OrderDetailID int NOT NULL PRIMARY KEY FOREIGN KEY (OrderID) REFERENCES Orders(OrderID) ) B. CREATE TABLE OrderDetails ( OrderDetailID int NOT NULL PRIMARY KEY OrderID int PRIMARY KEY (OrderDetailID) REFERENCES Orders(OrderID) ) C. CREATE TABLE OrderDetails ( OrderID int OrderDetailID int NOT NULL PRIMARY KEY CONSTRAINT FOREIGN KEY (OrderID) REFERENCES Orders (OrderID) ) D. CREATE TABLE OrderDetails ( OrderDetailID int NOT NULL PRIMARY KEY OrderlD int FOREIGN KEY REFERENCES Orders(OrderID) ) 2. Evaluate the following SQL statement, used to create a signups table: CREATE TABLE SIGNUPS ( studentID INT NOT NULL, classID INT NOT NULL, signupdate DATETIME PRIMARY KEY (studentID, classID) ) The studentID is the primary key for the students table. The classID is the primary key for the classes table. Which type of primary key has been created using these two fields for this table? A. Foreign Key B. Composite Key C. Candidate Key D. Compound Key 3. The UPDATE keyword falls under which category of data languages in SQL? A. DQL B. DCL C. DDL D. DML 4. For each of the following statements regarding the use and purpose of views, select Yes if the statement is true and No if it is false. a. Views can help limit what people can see within a database. (YES) b. Views can be created from multiple tables. (YES) c. Views can be altered using an ADD COLUMN clause. (NO) d. Views can temporarily store copies of data from tables. (NO) 5. For each of the following statements, select Yes if the statement is true and No if the statement is false. e. A foreign key in one table points to a primary key in another table. (YES) f. A NULL value in a foreign key means it has no relations to other tables. (YES) g. Foreign keys are used to lookup items in another table. (YES) a. Foreign keys must have unique values. (NO)