Page 74 - 2611_SmartGPT Pro V(5.0) C-8

1. Tick ( ) the correct option.

a. Identify the key used to specify a unique record in a table.
(i) Primary key (ii) Secondary key

(iii) Composite key (iv) None of these
b. Choose the SQL operators that returns TRUE if the subquery returns one or more records.
(i) ALL (ii) ANY

(iii) EXISTS (iv) BETWEEN
c. Mark the constraint that is used to specify a default value for a column.

(i) Default Constraint (ii) NOT NULL Constraint
(iii) Check Constraint (iv) NULL Constraint
d. Select the method used to organise the creation, editing and display of data in a table.

(i) Table (ii) Form
(iii) Query (iv) Report

e. Which SQL command is used to create a new table in MySQL?
(i) FORM TABLE (ii) MAKE TABLE
(iii) EXECUTE TABLE (iv) CREATE TABLE

2. Fill in the blanks using the words from the help box.

SHOW DATABASES, SELECT, DESC, Database, Constraints

a. The _______________ command describes the structure of the table.

b. _______________ are used to restrict the types of data that can be entered into a table.
c. The _______________ command retrieves zero or more rows from a table.

d. The _______________ command is used to view a list of existing databases.

e. A _______________ is defined as an organised collection of data that is stored and accessed
electronically.
3. Write 'T' for true and 'F' for false.

a. A row in a table is also called a tuple.

b. There can be more than one primary key in a table.

c. The TIMESTAMP data type stores only hour, minute and second values.

d. The WHERE clause specifies the criteria according to which rows are retrieved.

e. The DESCRIBE command is used to view the schema of an existing table.

72 Computer Science (V5.0)-VIII