Welcome to your Grade 12 Information Technology chapter 3
After carefully reading the following 30 questions, choose the correct answer.
1.
Which language is used by most DBMS for helping users access data?
2.
Microsoft Access is an example of a:
3.
Which SQL command is used to create a new table in a database?
4.
Which SQL command helps to insert new records into a table?
5.
Which clause in a SELECT statement specifies the criteria that data must match?
6.
What is the purpose of the SQL SELECT command?
7.
Which SQL clause is required to list the tables that contain the fields of interest?
8.
Which command is used to modify existing records in a table?
9.
To delete all records from a table, which command can be used?
10.
In SQL, which character is used to represent "all columns" in a SELECT statement?
11.
What must follow the table name in a CREATE TABLE command?
12.
While using the INSERT command, string values should be quoted with:
13.
Which SQL command is part of the Data Definition Language (DDL)?
14.
A relationship in MS Access helps combine data from:
15.
Which tool in MS Access can be used to create relationships visually?
16.
When using the DELETE statement, why should you refer to the record by primary key?
17.
Which command is used to remove a whole table from the database?
18.
What is the purpose of Data Query Language (DQL)?
19.
In SQL, which clause is used to sort the result of a query?
20.
When using the INSERT INTO command, the column value must match the:
21.
Which of the following is NOT a type of relationship in MS Access?
22.
What is the first step in starting to write an SQL query in MS Access?
23.
Which clause allows for filtering meaningful results in SQL?
24.
Each field definition in a CREATE TABLE command should be separated by a:
25.
What does the SQL ALTER command do?
26.
To delete a specific record, which clause must be used with DELETE?
27.
Which SQL statement is used to combine data from two tables using a link?
28.
Which SQL command is used to add a new column to an existing table?
29.
Data Definition Language (DDL) focuses on:
30.
In SQL, which part of the SELECT statement lists the fields of interest?
