7CIS 3050 final SQL and Different types Of SQL Statements
) A database is an organized collection of ________ related data. A) physically B) logically C) None of the above D) Both of the above
Answer: B
2) ________ is a set of commands used to update a database. A) DDL B) DML C) DCL D) TCL
Answer: B
6) INSERT INTO is an example of ________ code. A) DDL B) DML C) DCL D) TCL
Answer: B
7) After performing a DELETE operation you need to ------------ to undo it. A) Redo B) Rollback C) Commit D) all of the above
Answer: B
9) ------------------- is a collection of related fields. A) Column B) Row C) Table D) All of the above
Answer: B
3) ________ is a set of commands used to control a database, including security. A) DML B) DDL C) DCL D) TCL
Answer: C
5) How to make changes permanent after manipulating a table? A) Rollback B) Update C) Commit D) Drop
Answer: C
8) ------------- withdraws access privileges given with the GRANT command. A) Rollback B) Revise C) Revoke D) All of the above
Answer: C
4) Any create command may be reversed by using a(n) ________ command. A) undo B) delete C) rollback D) drop
Answer: D
13) The CREATE SCHEMA, the DDL command is used to create a table. T/F
Answer: FALSE CREATE TABLE
10) DCL is used to update the database with new records. T/F
Answer: FALSE DML
15) The DELETE TABLE, DDL command is used to remove a table from the database. T/F
Answer: FALSE DROP
12) A database is maintained and queried using the data mapping language (DML). T/F
Answer: FALSE data manipulation language
11) A database table is defined using the data definition language (DDL). T/F
Answer: TRUE
14) SQL is a standard language for database access. T/F
Answer: TRUE
A field is a single piece of informa"on. T/F
False
The DROP command deletes rows from a table individually or in groups. T/F
False
RDBMS is the basis for SQL, and for all modern database systems. T/F
Ture
The SQL command used to populate tables with data is the INSERT command. T/F
Ture
