wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database Certification

Total questions: 140

Worksheet time: 1hrs 12mins

Name
Class
Date
1.

The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

a)

View

b)

Function

c)

Index

d)

Stored Procedure

e)

Trigger

2.

One reason to add an index is to

a)

Decrease storage space.

b)

Increase database security.

c)

Improve performance of select statements.

d)

Improve performance of insert statements.

3.

This process is referred to as:

a)

defragmentation

b)

normalization

c)

fragmentation

d)

denormalization

4.

Which database term is used to describe the relationship between ProductID and ProductCategory?

a)

Cohort

b)

Relationally dependent

c)

Deterministic

d)

Functionally Dependent

e)

Compositional

5.

Which key uniquely identifies a row in a table?

a)

Foreign

b)

Primary

c)

Local

d)

Superkey

6.

Which statement creates a composite key?

a)

A

b)

B

c)

C

d)

D

7.

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?

a)

The Customer table no longer exists.

b)

The Customer table is unaffected.

c)

The Customer table exists but has no data.

d)

The script fails.

8.

In which situation do you need to perform a restore on a database?

a)

when data becomes corrupted in the database

b)

when you need to roll back a transaction

c)

when you encounter an error in your application

d)

when data needs to be deleted from the database

9.

Which command should you use to give a user permission to read the data in a table?

a)

ALLOW SELECT

b)

LET READ

c)

PERMIT READ

d)

GRANT SELECT

10.

You need to enable a new employee to authenticate to your database.

Which command should you use?

a)

ALLOW USER

b)

CREATE USER

c)

ADD USER

d)

INSERT USER

e)

ALTER USER

11.

Which keyword can be used in a create table statement?

a)

ORDER BY

b)

DISTINCT

c)

GROUP BY

d)

UNIQUE

12.

You need to store product quantities, and you want to minimize the amount of storage space that is used.

Which data type should you use?

a)

INTEGER

b)

DOUBLE

c)

COUNT

d)

FLOAT

13.

Which statement will result in the creation of an index?

a)

A

b)

B

c)

C

d)

D

14.

What is the result?

a)

an error stating that NULL values are not allowed

b)

a new row in the table

c)

an error stating that duplicate IDs are not allowed

d)

a syntax error

15.

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?

a)

VARCHAR (3, 30)

b)

CHAR (3, 30)

c)

VARCHAR (30)

d)

CHAR (30)

16.

One reason to create a stored procedure is to:

a)

Improve performance.

b)

Minimize storage space.

c)

Bypass case sensitivity requirements.

d)

Give the user control of the query logic.

17.

Which permission does a user need in order to run a stored procedure?

a)

EXECUTE

b)

ALLOW

c)

CALL

d)

RUN

18.

You have a table named Product. You create a view that includes all the products from the Product table that

are in the Furniture category.

You execute a statement on the Product table that deletes all the products in the Furniture category.

After you execute the statement, the result set of the view is:

a)

Empty

b)

Deleted

c)

Unchanged

d)

Archived

19.

In SQL, an insert statement is used to add a:

a)

User to a database.

b)

Row of data to a table.

c)

Table to a database.

d)

Column to a table definition.

20.

You have two tables. Each table has three rows.

How many rows will be included in the Cartesian product of these two tables?

a)

0

b)

3

c)

6

d)

9

21.

You are writing an SQL statement to retrieve rows from a table.

Which data manipulation language (DML) command should you use?

a)

READ

b)

SELECT

c)

OUTPUT

d)

GET

22.

Which constraint ensures a unique value in the ID column for each customer?

a)

DISTINCT

b)

FOREIGN KEY

c)

SEQUENTIAL

d)

PRIMARY KEY

23.

The component that holds information for a single entry in a table is called a:

a)

Data type

b)

Row

c)

Column

d)

View

24.

You execute the following statement:

SELECT EmployeeID, FirstName, DepartmentName

FROM Employee, Department

a)

Intersection

b)

Outer join

c)

Equi-join

d)

Cartesian product

25.

Which command should you use to add a column to an existing table?

a)

MODIFY

b)

ALTER

c)

UPDATE

d)

INSERT

e)

CHANGE

26.

How many rows are returned?

a)

0

b)

1

c)

2

d)

3

e)

4

27.

You are writing a select statement to find every product whose name contains a specific character.

Which keyword should you use in your where clause?

a)

FIND

b)

BETWEEN

c)

INCLUDES

d)

LIKE

28.

A database contains two tables named Customer and Order.

You execute the following statement:

DELETE FROM Order

WHERE CustomerID = 209

What is the result?

a)

The first order for CustomerID 209 is deleted from the Order table.

b)

All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the

Customer table.

c)

All orders for CustomerID 209 are deleted from the Order table.

d)

CustomerID 209 is deleted from the Customer table.

29.

You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.

You need to change the ProductCategory value for all the spoons in the Product table to 43.

Which statement should you use?

a)

A

b)

B

c)

C

d)

D

30.

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

31.

You need to populate a table named EmployeeCopy with data from an existing table named Employee.

Which statement should you use?

a)

A

b)

B

c)

C

d)

D

32.

This statement is an example of a/an:

a)

Subquery

b)

Union

c)

Outer join

d)

Cartesian product

33.

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

34.

You have a table named Employee that includes the following columns:

EmployeeID

Smp1oyeeName

Which statement should you use to return the number of rows in the table?

a)

A

b)

B

c)

C

d)

D

35.

What is the value returned by this statement?

a)

1

b)

2

c)

3

d)

4

36.

Which command should you use to remove a table from a database?

a)

REMOVE TABLE

b)

UPDATE TABLE

c)

DROP TABLE

d)

DELETE TABLE

37.

You need to store the contact information for each student in your school database.

You should store each student's information in a:

a)

Stored procedure

b)

Function

c)

Row

d)

Variable

38.

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)

39.

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

40.

Data in a database is stored in:

a)

Tables

b)

Queries

c)

Data types

d)

Stored procedures

41.

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.

42.

You need to establish a set of permissions that you can routinely assign to new users.

What should you create?

a)

Resource

b)

Group

c)

List

d)

Role

43.

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

44.

You need to disable User1's access to view the data in the Customer table.

Which statement should you use?

a)

A

b)

B

c)

C

d)

D

45.

Denormalization is performed in order to:

a)

Reduce redundancy.

b)

Eliminate repeating groups.

c)

Create smaller tables.

d)

Improve query performance

46.

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?

a)

A cursor

b)

A subquery

c)

A trigger

d)

An index

47.

What is the result?

a)

a foreign key constraint violation

b)

a syntax error

c)

a new row in the Product table

d)

primary key constraint violation

e)

a new row in the Category table

48.

Which two keys establish a relationship between two tables? (Choose two.)

a)

candidate

b)

foreign

c)

superkey

d)

local

e)

primary

49.

One difference between a function and a stored procedure is that a function:

a)

Must be called from a trigger

b)

Must return a value.

c)

Cannot contain a transaction.

d)

Cannot accept parameters.

50.

Which keyword must be included in a create view statement?

a)

WHERE

b)

ORDER BY

c)

UPDATE

d)

SELECT

51.

You have a table named Customer. You need to add a new column named District.

Which statement should you use?

a)

A

b)

B

c)

C

d)

D

52.

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

53.

A named group of SQL statements that can be executed in a database is called a:

a)

Subroutine

b)

Formula

c)

Stored procedure

d)

Method

54.

A view can be used to:

a)

Save an extra copy of data stored in a separate table.

b)

Limit access to specific rows or columns of data in a table.

c)

Ensure referential integrity.

d)

Save historical data before deleting it from the base table

55.

On which database structure does an update statement operate?

a)

Table

b)

User

c)

Trigger

d)

Role

56.

You need to list the name and price of each product, sorted by price from highest to lowest. Which statement

should you use?

a)

A

b)

B

c)

C

d)

D

57.

You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically

deleted. This process is an example of a/an:

a)

Inherited delete

b)

Cascade delete

c)

Functional delete

d)

Waterfall delete

e)

Domino delete

58.

Which statement deletes the rows where the employee's phone number is not entered?

a)

A

b)

B

c)

C

d)

D

59.

You need to insert two new products into the Product table. The first product is named Book and has an ID of

125. The second product is named Movie and has an ID of 126.

Which statement should you use?

a)

A

b)

B

c)

C

d)

D

e)

E

60.

You have a table named Employee that includes four columns.

You execute the following statement:

SELECT *

FROM Employee

Which columns are returned?

a)

all columns

b)

only the last column

c)

only the first column

d)

only the first and last columns

61.

Which two elements are required to define a column?

a)

A name

b)

A Key

c)

An Index

d)

A Data type

62.

What defines the amount of storage space that is allocated to a value in a column?

a)

Format

b)

Key

c)

Data Type

d)

Validator

63.

You are creating a table to store customer data. The Account Number column uses values that always consist

of one letter and four digits. Which data type should you use for the Account Number column?

a)

CHAR

b)

BYTE

c)

DOUBLE

d)

SMALLINT

64.

What is one difference between an update statement and a delete statement?

a)

An Update statement can change only one row.

b)

A delete statement cannot use a where clause.

c)

An update statement does not remove rows from a table.

d)

A Delete statement works only within a stored procedure.

65.

You have a Department table and an Employee table in your database.

You need to ensure that an employee can be assigned to only an existing department.

What should you apply to the Employee table?

a)

A Primary Key

b)

An Index

c)

A Foreign Key

d)

A unique constraint

e)

A Data type

66.

You need to store the first name, last name, and student ID for 100 students.

This information will be stored in a table as:

a)

100 Items and Three Cells

b)

100 Rows and three columns

c)

Three rows and 100 Columns

d)

Three items and 100 cells

67.

What are three valid data manipulation language (DML) commands?(Choose three.)

a)

INSERT

b)

COMMIT

c)

DELETE

d)

OUTPUT

e)

UPDATE

68.

You assign User1 a set of permissions that include the WITH GRANT OPTION.

The WITH GRANT OPTION enables User1 to:

a)

request a log of permission use.

b)

delegate permissions to other users.

c)

create new database users.

d)

view other users' permissions

69.

Which type of index changes the order in which the data is stored in a table?

a)

non-sequential

b)

sequential

c)

non-clustered

d)

clustered

70.

Which statement should you use to remove a foreign key?

a)

ALTER TABLE

b)

DELETE TABLE

c)

DELETE FOREIGN KEY

d)

ALTER FOREIGN KEY

71.

First normal form requires that a database excludes:

a)

Foreign keys

b)

Composite keys

c)

Duplicate rows

d)

Repeating groups

72.

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.

What is the result in the database?

a)

The table will be corrupted.

b)

Forty (40) rows will be deleted from the table.

c)

The transaction will restart.

d)

No rows will be deleted from the table.

73.

You have a table that contains product IDs and product names.

You need to write an UPDATE statement to change the name of a specific product to glass.

What should you include in the update statement

a)

SET ProduetName = 'glass'

b)

LET ProduetName = 'glass'

c)

EXEC ProduetName = 'glass'

d)

ASSIGN ProduetName = 'glass'

74.

Your database contains a table named Customer.

You need to delete the record from the Customer table that has a CustomerID of 12345.

Which statement should you use?

a)

A

b)

B

c)

C

d)

D

75.

On which database structure does an insert statement operate?

a)

Role

b)

Trigger

c)

User

d)

Stored procedure

e)

Table

76.

You have a table of products with fields for ProductID, Name, and Price.

You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.

Which clause should you use in your update statement?

a)

THAT

b)

WHERE

c)

GROUP BY

d)

HAVING

77.

You have the following table definition:

CREATE TABLE Product

(ProductID INTEGER,

Name VARCHAR(20))

You need to insert a new product. The product's name is Plate and the product's ID is 12345.

Which statement should you use?

a)

A

b)

B

c)

C

d)

D

78.

HOTSPOT

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Each correct selection is worth one point.

a)

YES, NO, YES, NO

b)

YES, YES, NO, NO

c)

YES, NO, NO, YES

d)

NO, NO, YES, YES

79.

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each

correct selection is worth one point.

a)

client
s01.contoso.com

b)

www.contoso.com
client

c)

www.contoso.com
s01.contoso.com

80.

How many rows are returned by the SQL statement?

a)

4

b)

5

c)

6

d)

7

81.

Which query should you use?

a)

b)

c)

d)

82.

Which statement should you choose?

a)

b)

c)

d)

83.

This question requires that you evaluate the underlined text to determine if it is correct.

Use the FROM keyword in a SELECT statement to return rows that meet a specific condition.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

ORDER BY

c)

UNION

d)

WHERE

84.

You need to combine the results of two queries into a single result that contains all of the rows from both

queries.

Which Structured Query Language (SQL) statement should you use?

a)

TRUNCATE

b)

JOIN

c)

EXCEPT

d)

UNION

85.

This question requires that you evaluate the underlined text to determine if it is correct.

The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers,

constraints, and permission specifications for those tables.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

DROP TABLE

c)

TRUNCATE TABLE

d)

ALTER TABLE

86.

You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements.

You need to ensure that a column or combination of columns uniquely identifies each row of a table.

Which constraint should you define?

a)

Primary key

b)

Secondary key

c)

Foreign key

d)

Default Key

87.
a)

return large result sets

are accessed sequentially

b)

do not use ORDER BY or GROUP BY clauses

are accessed randomly

c)

return a range of values by using the = operator

are accessed randomly

d)

do not use ORDER BY or GROUP BY clauses

are not unique or contain many common values

88.

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each

correct selection is worth one point.

a)

foreign key
nonclustered index

b)

foreign key
clustered index

c)

clustered index
nonclustered index

d)

nonclustered index
foreign key

89.

While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.

You need to establish a relationship between the data that is in the two tables.

Which constraint should you define?

a)

Foreign key

b)

Index key

c)

Link key

d)

Default key

90.

This question requires that you evaluate the underlined text to determine if it is correct.

A view can be used to ensure referential integrity.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

Save an extra copy of data stored in a separate table.

c)

Limit access to specific rows or columns of data in a table.

d)

Save historical data before deleting it from the base table

91.

You need to set up a database to provide a view of North American mammals.

Match the Structured Query Language (SQL) statements to the SQL query.

Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL

query on the right Each SQL statement may be used once, more than once, or not at all. Each correct match is

worth one point.

a)

CREATE
AS JOIN
FROM

b)

GENERATE
AS SELECT
JOIN

c)

CREATE
AS SELECT
FROM

d)

GENERATE
FROM
JOIN

92.

You have the following requirements:

StudentName must consist of a string of characters.

GradeLevel must be only a whole number.

DaysAbsent can have one number after the decimal.

Match the data types to the column names.

Instructions: To answer, drag the appropriate data type from the column on the left to its column name on the

right Each data type may be used once, more than once, or not at all. Each correct match is worth one point.

a)

INT
CHAR
BIT

b)

CHAR
VARCHAR
DATETIME

c)

VARCHAR
INT
DECIMAL

d)

DECIMAL
INT
CHAR

93.

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Each correct selection is worth one point.

a)

NO
YES
NO

b)

NO
YES
YES

c)

YES
NO
NO

d)

YES
NO
YES

94.

This question requires that you evaluate the underlined text to determine if it is correct.

In a database table, each column represents a unique record.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

Table

c)

Index

d)

Row

95.

This question requires that you evaluate the underlined text to determine if it is correct.

You have two tables. Each table has three rows. You create a SQL query that uses a cross join. The query

does not include a WHERE clause.

Nine rows will be included in the Cartesian product of these two tables.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement corrector.

a)

No change is needed

b)

Zero

c)

Three

d)

Six

96.

You have two tables named Salesperson and Sales.

You need to ensure that each record in the Sales table has a valid associated salesperson record in the

Salesperson table.

Which database object should you add to the Sales table?

a)

Nonclustered index

b)

Primary Key

c)

Foreign Key

d)

Clustered Index

97.

Your class project requires that you help a charity set up a website.

The website collects information about volunteers. Each volunteer record must be uniquely identified.

The following information is stored for each volunteer:

Given name

Surname

Date of birth

Phone number

Photo

You need to create a table to meet the requirements.

Match the Structured Query Language SQL statements to the SQL query.

a)

DATE
INT (FK)
INT (PK)

b)

DATE
TIMESTAMP
XML

c)

INT (PK)
DATE
IMAGE

d)

INT (FK)
DATE
INT (PK)

98.

This question requires that you evaluate the underlined text to determine if it is correct.

Use the ALTER statement to add a new table in a database.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct.

a)

No change is needed

b)

UPDATE

c)

INSERT

d)

CREATE

99.

You need to rename a column in a database table.

Which data definition language (DDL) statement should you use?

a)

ALTER

b)

INSERT

c)

CREATE

d)

UPDATE

100.

Match the CourseName to the StudentName.

Instructions: To answer, drag the appropriate CourseName from the column on the left to its StudentName on

the right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one

point.

a)

MATH
SCIENCE
HISTORY

b)

READING
MATH
SCIENCE

c)

GEOGRAPHY
HISTORY
SCIENCE

d)

MATH
HISTORY
GEOFRAPHY

101.

This question requires that you evaluate the underlined text to determine if it is correct.

Use indexing to create, remove, or change database objects.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

Data manipulation language (DML) statements

c)

Data definition language (DDL) statements

d)

A unique constraint

102.

You need to add rows to a database table.

Which Structured Query Language (SQL) keyword should you use?

a)

JOIN

b)

INSERT

c)

CREATE

d)

UPDATE

103.

You need to retrieve data from two related database tables based on a column that exists in both tables.

Which command should you use in a query?

a)

INTERSECT

b)

UNION

c)

JOIN

d)

TRUNCATE

104.

Which two Structured Query Language (SQL) statements can you use? (Choose two.)

a)

b)

c)

d)

105.

The JOIN keyword combines the results of two queries and returns only rows that appear in both result sets.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

INTERSECT

c)

ALL

d)

UNION

106.

You work at a restaurant and they ask you to help them with a data issue.

They provide you with the following recipe data.
You need to normalize the data to third normal form.

How many tables should you create?

a)

1

b)

2

c)

3

d)

4

107.

You create a third table named ChapterLanguage to relate the Chapter table and the Language table.

You need to select columns from the Chapter and Language tables to create a composite primary key for the

ChapterLanguage table.

Which two columns should you select? (Choose two.)

a)

CHapterId

b)

LanguageId

c)

Country

d)

Region

e)

City

108.

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Each correct selection is worth one point.

a)

NO
YES
YES
NO

b)

YES
NO
YES
YES

c)

NO
NO
YES
NO

d)

YES
YES
NO
NO

109.

This question requires that you evaluate the underlined text to determine if it is correct.

You combine data from three tables into one table. The new table includes redundancy to optimize read

performance.

The data in the new table has been denormalized.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

Normalized

c)

Truncated

d)

Indexed

110.

You need to delete a database table.

Which data definition language (DDL) keyword should you use

a)

ALTER

b)

DELETE

c)

DROP

d)

TRUNCATE

111.

This question requires that you evaluate the underlined text to determine if it is correct.

Create a query that returns a set of table data by using the UPDATE statement.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

INSERT

c)

REPLACE

d)

SELECT

112.

Your class project requires that you help a charity to create a website that registers volunteers.

The website must store the following data about the volunteers:

Given name

Surname

Telephone number

Email address

You need to recommend a correct way to store the data.

What do you recommend?

a)

Create a table that contains columns that are named given name, surname, phone number, and email

b)

Create a table that contains rows that are named given name, surname, phone number, and email

c)

Create a view that contains columns that are named given name surname, phone number, and email

d)

Create a view that contains rows that are named given name surname, phone number, and email

113.

This question requires that you evaluate the underlined text to determine if it is correct.

Truncate is a database term used to describe the process of applying a backup to a damaged or corrupt

database.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement corrector

a)

Change is needed

b)

Commit

c)

Attach

d)

Restore

114.

This question requires that you evaluate the underlined text to determine if it is correct.

Use the ALLOW SELECT command to give a user permission to read the data in a table.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

GRANT SELECT

c)

LET HEAD

d)

PERMIT HEAD

115.

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each

correct selection is worth one point

a)

No
No

b)

Read-only
Unlimited

c)

Unlimited
Configuration

d)

Unlimited
Unlimited

116.

The following illustration shows backup strategies that use the simple recovery model and the full recovery

model:

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each

correct selection is worth one point

a)

More
Less

b)

Less
The same

c)

Less
More

d)

More
The same

117.

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Each correct selection is worth one point

a)

NO
YES
YES

b)

YES
YES
YES

c)

YES
YES
NO

d)

NO
YES
NO

118.

This question requires that you evaluate the underlined text to determine if it is correct.

Views are database objects that contain all of the data in a database.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No changes needed

b)

Queries

c)

Stored procedures

d)

Tables

119.

You have two tables named Cars and Color as defined below. The two tables are related by ColorId. How many rows does the SQL statement return?

a)

0

b)

2

c)

3

d)

6

120.

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a

database table named Volunteer.

When volunteers ask to be removed from mailing lists, the table must be updated.

You need to use a transaction to ensure that the database has data integrity and referential integrity.

Which statement should you use?

a)

b)

c)

d)

121.

This question requires that you evaluate the underlined text to determine if it is correct.

ALTER TABLE removes all rows from a table without logging the individual row deletions.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct.

a)

No change is needed

b)

DROP TABLE

c)

TRUNCATE TABLE

d)

CREATE TABLE

122.

You work at a coffee shop. They ask you to set up a website that stores charges on purchases.

You need to recommend a data type in a database table to run financial functions against the charged

amounts.

Which data type should you recommend?

a)

Money

b)

Bit

c)

Varchar

d)

Binary

123.

This question requires that you evaluate the underlined text to determine if it is correct.

A row holds information for a single record in a table.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

Column

c)

Data type

d)

View

124.

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Each correct selection is worth one point.

a)

YES
NO
YES

b)

NO
NO
NO

c)

NO
YES
YES

d)

YES
YES
NO

125.

This question requires that you evaluate the underlined text to determine if it is correct.

Ports 20 and 21 are the default ports to secure a SQL Server.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct.

a)

No change is needed

b)

1433 and 1434

c)

411 and 412

d)

67 and 68

126.

Which syntax should you use to create the object?

a)

b)

c)

d)

127.

You develop a database to store data about textbooks. The data must be stored to process at a later time.

Which database object should you use to store the data?

a)

View

b)

Table

c)

Function

d)

Stored Procedure

128.

This question requires that you evaluate the underlined text to determine if it is correct.

First normal form requires that a database excludes repeating groups.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct.

a)

No change is needed

b)

Composite keys

c)

Duplicate rows

d)

Foreign keys

129.

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each

correct selection is worth one point.

a)

index
primary key

b)

primary key
foreign key

c)

union
foreign key

d)

index
union

130.

You have the following SQL query

SELECT * FROM dbo.ProAthlete WHERE Salary > 500000

The query takes too much time to return data.

You need to improve the performance of the query.

Which item should you add to the Salary column?

a)

Non-null constraint

b)

Default constraint

c)

Index

d)

Foreign key

131.

All of the car’s parts are custom made, so they each have a row in every table. Cascading deletes are not

enabled but referential integrity is.

From which table must you first make your deletion?

a)

Make

b)

Model

c)

Engine

d)

ModelEngine

132.

You have a table that contains information about all students in your school.

You use the INSERT SQL keyword to change a student’s given name in the table.

Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the

statement is incorrect, select the answer choice that makes the statement correct.

a)

CHANGE

b)

UPDATE

c)

No change is needed

d)

SELECT

133.

You create the following table, which lists how many books you have on loan to your friends
Harry in San Francisco returns your books.

Which statement will update your table correctly?

a)

b)

c)

d)

134.

You are developing a SQL query.

Which two SQL constructs represent data manipulation language (DML) statements? Choose two.

a)

b)

c)

d)

135.

You need to create a view to filter rows of data from an underling table.

Which type of clause must be included in the CREATE VIEW statement?

a)

CONSTRAINT

b)

WHERE

c)

JOIN

d)

FILTER

136.

A key defines the amount of storage space that is allocated to a value in a column.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

format

c)

data type

d)

validator

137.

A relational database management system employs the concept of an attribute to ensure that data entered into

a field in a column is valid.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

a primary key

c)

a constraint

d)

an index

138.

You are structuring a table in a relational database.

Instructions: For each of the following statement, select Yes if the statement is true. Otherwise, select No. Each

correct selection is worth one point.

a)

NO
YES
NO

b)

YES
YES
NO

c)

NO
NO
NO

d)

NO
YES
YES

139.

You have a database that contains 10 terabytes of data. You need to back up the database every two hours.

Which type of backup should you use?

a)

archive

b)

incremental

c)

partial

d)

full

140.

The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the

statement is incorrect, select the answer choice that makes the statement correct

a)

No change is needed

b)

INTERSECT

c)

ALL

d)

JOIN