Course

Database Technology-16SP

Test Quiz 1
Started  
Submitted  
Status Completed
Attempt Score 94 out of 100 points
   
Instructions
  • Question 1

6 out of 6 points

Which of the following is not true about null values?

Answer

Selected Answer:  

Null values cannot be avoided.

Correct Answer:  

Null values cannot be avoided.

  • Question 2

6 out of 6 points

Microsoft SQL Server is an example of a:

Answer

Selected Answer:  

database management system.

Correct Answer:  

database management system.

  • Question 3

6 out of 6 points

Which of the following is not true about a relation?

Answer

Selected Answer:  

A relation may have duplicate column names.

Correct Answer:  

A relation may have duplicate column names.

  • Question 4

8 out of 8 points

This is an example of a relation:

Name Email Phone
Tim tim@j.com
bob@tim.com
2020224354
Bob null 1233225512
Joe bob@timmy.com 4105552121
4105551212
Time eee@emm.com 7035551212

Answer

Selected Answer:  False
Correct Answer:  False
  • Question 5

6 out of 6 points

Which of the following terms is synonymous with “relation”?

Answer

Selected Answer:  

Table

Correct Answer:  

Table

  • Question 6

6 out of 6 points

By separating data into tables containing data on only one theme each, making changes to the data is simplified.

Answer

Selected Answer:  True
Correct Answer:  True
  • Question 7

0 out of 6 points

A key must be unique.

Answer

Selected Answer:  True
Correct Answer:  False
  • Question 8

6 out of 6 points

Which of the following is true about a relation?

Answer

Selected Answer:  

All entries in any column must be of the same kind.

Correct Answer:  

All entries in any column must be of the same kind.

  • Question 9

6 out of 6 points

To represent a relationship in the relational model, the primary key of one relation is placed into a second relation.

Answer

Selected Answer:  True
Correct Answer:  True
  • Question 10

6 out of 6 points

SQL stands for:

Answer

Selected Answer:  

Structured Query Language.

Correct Answer:  

Structured Query Language.

  • Question 11

6 out of 6 points

Which of the following is not true of surrogate keys?

Answer

Selected Answer:  

They are meaningful to the users.

Correct Answer:  

They are meaningful to the users.

  • Question 12

6 out of 6 points

Every cell in a relation can hold only a single value.

Answer

Selected Answer:  True
Correct Answer:  True
  • Question 13

8 out of 8 points

This is a relation:

Name Shirt Color
Tim red
Eagle blue
bob white
jim red

Answer

Selected Answer:  True
Correct Answer:  True
  • Question 14

6 out of 6 points

Which of the following is true about a key?

Answer

Selected Answer:  

All of these

Correct Answer:  

All of these

  • Question 15

6 out of 6 points

A primary key is:

Answer

Selected Answer:  

All of these

Correct Answer:  

All of these

  • Question 16

6 out of 6 points

A relational database is:

Answer

Selected Answer:  

a self-describing collection of related tables.

Correct Answer:  

a self-describing collection of related tables.