7CIS 3050 final SQL and Different types Of SQL Statements

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

) 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


Ensembles d'études connexes

CMST210 - Exam One (Chapter Three)

View Set

SOCL 2501 Jenn LaRose - Exam 3 Review

View Set

MO L&H - Chapter 3: Life Policy Provisions, Riders and Options

View Set

3. Brunner Chapter 11 Shock Prep-U

View Set

Holt World Geography Today Chapter 8 & 9 Questions

View Set