Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Modern Database Management Study Set 2

Computing

Quiz 5 :

Introduction to SQL

Quiz 5 :

Introduction to SQL

Question Type
search
arrow
The ________ is the structure that contains descriptions of objects such as tables and views created by users.
Free
Multiple Choice
Answer:

Answer:

B

Tags
Choose question tag
close menu
arrow
________ is a set of commands used to update and query a database.
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
Relational databases are heavily based on the mathematical concept of:
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? INSERT INTO store values ('234 Park Street')
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The SQL command ________ adds one or more new columns to a table.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
INSERT INTO is an example of ________ code.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The command for removing a table is:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What does the following SQL statement do? UPDATE Product_T SET Unit_Price = 775 WHERE Product_ID = 7
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following is a technique for optimizing the internal performance of the relational data model?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Any create command may be reversed by using a(n) ________ command.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
DDL is typically used during which phase of the development process?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The command for creating a database is:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
________ is a set of commands used to control a database, including security.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What does the following SQL statement do? ALTER TABLE Customer_T ADD (Type Varchar (2));
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In an SQL statement, which of the following parts states the conditions for row selection?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What does the following SQL statement do? DELETE FROM Customer_T WHERE state = 'HI';
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The main concept of relational databases was published in 1970 by:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What does the following SQL command do? INSERT INTO Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The first in a series of steps to follow when creating a table is to:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Indexes are created in most RDBMSs to:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 102