Class 12 RDBMS

In a database, what is one piece of information called?

• Field

• Record

• Table

• Entry

What is a database?

• A piece of software to do calculations

• A device to load information onto the computer.

• A structured collection of records

• A calculator

One specific piece of information about a person or thing is called:

• Field

• File

• Record

• Table

What data type would be used to store the following item code: 0024

• Text

• Numeric

• Calculated

• Boolean

Text, Integer, Decimal, Boolean ,Date and Time are all examples of...

• Data Types

• Filters

• Sorts

• Validations

A unique identifying field.

• Primary Key

• Integer

• Verification

• Boolean

SQL is

• Structured Query Language

• Simple Query Language

• Structured Question Language

• Structure Quality Language

Which is the correct DDL group

• CREATE, DELETE, DROP

• ALTER , DROP, INSERT

• UPDATE, SELECT, DROP

• CREATE, DROP, ALTER

Which SQL statement would add a record to the database?

• INSERT INTO Designer VALUES ('SMI01', 'M Smith', '[e-mail]', '01224123456');

• INSERT INTO Designer ('SMI01', 'M Smith', '[e-mail]', '01224123456') ;

• INSERT Designer VALUES ('SMI01', 'M Smith', '[e-mail]', '01224123456') ;

• INSERT INTO Designer VALUES (SMI01, 'M Smith', '[e-mail]', '01224123456');

Where does the CREATE Command belong?

• DML

• DDL

• DCL

• DQL