1
1. The terms “bitmap,” “b-tree,” and “hash” refer to which type of database structure?
. At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?
You need to perform a restore on a database? In which situation do you need to perform a restore on a database?
Which command should you use to give a user permission to read the data in a table?
Which keyword can be used in a create table statement?
A. ORDER BY
B. DISTINCT
C. GROUP BY
D. UNIQUE
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use?
Which permission does a user need in order to run a stored procedure?
You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?
What constraint ensures a unique value in the ID column for each customer?
The component that holds information for a single entry in a table is called a
. A database contains two tables named Customer and Order. You execute the following statement: DELETE FROM Order WHERE CustomerID = 209 What is the result?
You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student’s first name in the table? a. UPDATE b. CHANGE c. SELECT d. INSERT
You execute the following statement:
SELECT departmentName
FROM Department
Where DepartmentID =
(SELECT DEpartmentID
FROM Employee
WHERE EmployeeID = 1234)
This statement is an example of a/an:
Which keyword would you use in a select statement to return rows that meet a specific condition? a. WHERE b. UNION c. ORDER BY d. FROM
Which command should you use to remove a table from a database? a. REMOVE TABLE b. UPDATE TABLE c. DROP TABLE d. DELETE TABLE
Which category of SQL statements is used to add, remove, and modify database structures? a. Data access language (DAL) b. Data manipulation language (DML) c. Data control language (DCL) d. Data definition language (DDL)
What is d.
What is Data Definition language
What is DDL
You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include: All customers and their orders Customers who have no orders Which type of join do these results represent? a. Complete join b. Partial join c. Inner join d. Outer join
You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement: DELETE FROM Student. What is the result? a. All rows in the table will be deleted. b. All rows containing a NULL value in the FirstName column will be deleted. c. You will receive an error message. d. All rows and the table definition will be deleted.
Which database term is used to describe the process of applying a backup to a damaged or corrupt database? a. Recover b. Restore c. Commit d. Attach
Denormalization is performed in order to: a. Reduce redundancy. b. Eliminate repeating groups. c. Create smaller tables. d. Improve query performance
You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product’s unique ID. What will make this type of search more efficient?
. The ProductID column is the primary key. The CategoryID column is a foreign key to a separate table named Category. You execute the following statement: INSERT INTO Product VALUES (3296, ‘Table’, 4444) What is the result?
You need to remove a view named EmployeeView from your database. Which statement should you use? a. DELETE VIEW EmployeeView b. DELETE EmployeeView c. DROP EmployeeView d. DROP VIEW EmployeeView
. Which two elements are required to define a column?