Enter Title

1

100

What key uniquely identifies a row in a table?

What is primary key

200

. 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:

What is Casade delete

300

. First normal form requires that a database excludes:

What is Repeating groups

2

100

Which keyword can be used in a create table statement?

A. order by

B. distinct

C. group by

D. Unique

What is D.

or

What is Unique

200

. On which database structure does an update statement operate?

What is Table

300

On which database structure does an insert statement operate?

What is Table

3

100

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

What is A

or

What is Improve performance

200

. You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column?

What is Char

300

. 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

What is drop table

4

100

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?

What is All rows in the table will be deleted

200

You have a table named Employee that includes four columns. You execute the following statement: SELECT * FROM Employee How many columns are returned?

What is all columns

300

. 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?

What is foreign key

5

100

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

what is Role

200

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

What is INSERT, DELETE, UPDATE

300

You need to add rows to a database table. Which Structured Query Language (SQL) keyword should you use?

What is insert