Microsoft Database Fundamentals - 98-364 Exam Practice Test
DRAG DROP
You have a database table that stores information about school attendance. You have a data set that is defined as follows:
---
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.
You have a database table that stores information about school attendance. You have a data set that is defined as follows:
---
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.
Correct Answer:
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?
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?
Correct Answer: A
Which keyword must be included in a create view statement?
Correct Answer: D
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?
You need to ensure that a column or combination of columns uniquely identifies each row of a table.
Which constraint should you define?
Correct Answer: D
You are writing an SQL statement to retrieve rows from a table.
Which data manipulation language (DML) command should you use?
Which data manipulation language (DML) command should you use?
Correct Answer: B
Which command should you use to add a column to an existing table?
Correct Answer: C
On which database structure does an insert statement operate?
Correct Answer: E