Database Concepts

The number of rows in a relation

• degree

• tuple

• cardinality

• domain

SQL stands for

(a)  

What type of commands are GRANT and REVOKE?

• DML

• DDL

• TCL

• DCL

Data about data is ______________

• Data Description

• Metadata

• Data redundancy

• Data inconsistency

Which of these could be a primary key?

• Centre number
• Surname
• Teacher name
• Students addresses

How many records are in this database?

• 8

• 5

• 9

• 12

What is the primary key in this database?

• Emp_Id

• Last Name

• Gender

• Title

Which SQL statement is used to extract data from a database?

• OPEN

• GET

• EXTRACT

• SELECT

Which SQL statement is used to delete data from a database?

• COLLAPSE

• DELETE

• REMOVE

• DROP

Which SQL statement is used to update data in a database?

• SAVE

• SAVE AS

• UPDATE

• MODIFY