Home › Quizzes/Exams › Course Database Technology-16SP quiz

Course Database Technology-16SP quiz

Posted on Posted in Quizzes/Exams

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.

 

Related Posts