12) The following commands defines, alter or remove the structure of a Table, but they do not add, modify or remove rows from a table.

a) DDL b) DML c) Define Table Structure

13) The following commands add, modify or remove rows from a table. They do not define, alter or remove the structure of a table

a) DDL b) DML c) modify

14) A query in MS-Access is the same as

a) A virtual table b) a view in Oracle

c) may provide simplicity because the user only sees the columns he/she needs

d) may provide security because the user only sees the columns he/she is authorized to

e) all of the above

15) When we create a new database in MS-Access, we must start our database by first:

a) Creating Queries b) Creating Tables

c) Creating Forms d) Inserting Data into the Tables

16) We have two tables: Customers and Orders. We want that every time a user logs in, they can see the name of the customer and the sum of the orders that a customer ordered without having to type in a query. This can be done with the following command

a) A CREATE Temporary table b) CREATE NEW TABLE ON LOGIN

c) CREATE View d) ALTER TABLE

17) To view the names of all our tables in MySQL we use the command

a) View Tables b) Show Tables c) Show Databases d) Describe All

18) CREATE, ALTER, DROP

a) DDL Commands b) DML Commands

c) DCL Commands d) Commands built to terrify students

19) INSERT, UPDATE, DELETE, SELECT

a) DDL Commands b) DML Commands

c) DCL Commands d) Commands built to terrify students

20) Which of the following actions can be done with the CREATE Command ?

a) Remove a table from a database b) Insert a new row into an existing table

c) Creates a new table d) Add a column or a Foreign Key to an existing table

e) Modify the value of a field f) Remove a row from a table

21) Which of the following statements contain a syntax error:

a) SELECT ename FROM Employees; b) SELECT ssn, city FROM Employees;

c) SELECT ename WHERE city = Dubai

22) Which of the following statements generates the error Ambiguous column name:

a) SELECT dname, ename FROM Employees e, Departments d WHERE d.did=e.did;

b) SELECT did, d.dname FROM Employees e, Departments d;

23) Which of the following statements contain a syntax error:

a) SELECT Departments; b) SELECT * FROM Employees;

c) SELECT * FROM Employees WHERE city = Al Ain;