EX Problems

Question 1

What is a null value?

a. An outdated value
b. A known value
c. A value that represents missing/ unknown data
d. Numerical value

Answer 1

c. A value that represents missing/ unknown data

Question 2

What is accept data for a column declared as a BIT and NOT NULL?

a. yes
b. 5
c. 3.14
d. 1

Answer 2

d. 1

Question 3

What sort of statement retries data in a SQL code?

a. RETRIEVE
b. READ
c. SELECT
d. GET

Answer 3

c. SELECT

Question 4

When creating a student roster, a school can’t enroll more than 20 students per course. This is an example of what data modeling building block?

a. attribute
b. entity
c. relationship
d. constraint

Answer 4

d. constraint

Question 5

Which function determines the number of rows in a table?

a. ROW
b. CALCULATE
c. COUNT
d. NUMBER

Answer 5

c. COUNT

Question 6

Which is the statement about how logical operators are resolved in SQL queries is true?

a. AND is always evaluated before OR
b. AND is always evaluated before OR
c. Conditions are evaluated in the order they occur in code
d. Both B and C

Answer 6

d. Both B and C

Question 7

Which of these is NOT a type of relationship in a relational database?

a. two-to-one
b. many-to-one
c. many-to-many
d. one-to-many

Answer 7

a. two-to-one

Question 8

Which result is NOT possible when you apply the following filter? WHERE number BETWEEN 5 AND 8

a. 6
b. 5
c. NULL
d. 8

Answer 8

c. NULL

Question 9

Which statement about primary keys is true?

a. Primary keys must be unique
b. Both A and C
c. Primary keys can be made up of one or more columns
d. Primary key value is required for every table

Answer 9

b. Both A and C

Question 10

Unnormalized tables yield no simple strategies for creating virtual tables known as ___

a. views
b. attributes
c. entities
d. keys

Answer 10

a. views

Question 11

The ___ command will delete all data from a table, while the ___ command is used to delete a table from the database.

a. REMOVE; DROP
b. TRUNCATE; DROP
c. RESET; DELETE
d. TRUNCATE; REMOVE

Answer 11

b. TRUNCATE; DROP

Question 12

Raw data in its original state that has data anomalies such as redundant or multivalued data is ___ data?

a. consistent
b. normalized
c. unnormalized
d. relational

Answer 12

c. unnormalized

Question 13

In the SELECT clause, you can indicate that you want to include all columns using the ___

a. \
b. /
c. *
d. ?

Answer 13

c. *

Question 14

Determine which of the following simple-language expressions represents a valid constraint.

a. EMPLOYEE manages STORE
b. CUSTOMER generates INVOICE
c. STUDENT takes CLASS
d. Each CONTAINER contains between 0 and 100 UNITS

Answer 14

d. Each CONTAINER contains between 0 and 100 UNITS