Quiz about Topic 5

Question 1

The ________ is the structure that contains descriptions of objects such as tables and views created by users.

Accepted Answer

schema

Answer

SQL

Answer

catalog

Answer

master view

Question 2

________ is a set of commands used to control a database, including security.

Accepted Answer

DCL

Answer

DML

Answer

DDL

Answer

DPL

Question 3

________ is a set of commands used to update and query a database.

Accepted Answer

DML

Answer

DDL

Answer

DCL

Answer

DPL

Question 4

DDL is typically used during which phase of the development process?

Accepted Answer

Physical design

Answer

Implementation

Answer

Analysis

Answer

Evaluation

Question 5

The main concept of relational databases was published in 1970 by:

Accepted Answer

E.F.Codd.

Answer

Itzak Ben-Gan.

Answer

Hoffer.

Answer

Mills.

Question 6

Relational databases are heavily based on the mathematical concept of:

Accepted Answer

set theory.

Answer

bet theory.

Answer

get theory.

Answer

met theory.

Question 7

The command for creating a database is:

Accepted Answer

CREATE SCHEMA.

Answer

CREATE TABLE.

Answer

CREATE VIEW.

Answer

CREATE AUTHORIZATION.

Question 8

The command for removing a table is:

Accepted Answer

DROP TABLE.

Answer

CREATE TABLE.

Answer

REMOVE TABLE.

Answer

TRUNCATE TABLE.

Question 9

Any create command may be reversed by using a(n) ________ command.

Accepted Answer

drop

Answer

undo

Answer

delete

Answer

unpack

Question 10

The first in a series of steps to follow when creating a table is to:

Accepted Answer

identify each attribute and its characteristics.

Answer

identify columns that must be unique.

Answer

create an index.

Answer

identify columns that must be null.

Question 11

The SQL command ________ adds one or more new columns to a table.

Accepted Answer

ALTER TABLE

Answer

CREATE TABLE

Answer

CREATE VIEW

Answer

CREATE RELATIONSHIP

Question 12

What does the following SQL statement do? ALTER TABLE Customer_T ADD (Type Varchar (2));

Accepted Answer

Alters the Customer_T table by adding a field called "Type"

Answer

Alters the Customer_T table to accept Type 2 Varchars

Answer

Alters the Customer_T table to be a Type 2 Varchar

Answer

Alters the Customer_T table by adding a 2-byte field called "Varchar"

Question 13

INSERT INTO is an example of ________ code.

Accepted Answer

DML

Answer

DDL

Answer

DCL

Answer

TIO

Question 14

What does the following SQL command do? INSERT INTO Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');

Accepted Answer

Adds a new record to the Customer_T table

Answer

Creates the Customer_T table

Answer

Deletes the Customer_T table

Answer

Updates the Customer_T table

Question 15

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')

Accepted Answer

You must specify the fields to insert if you are only inserting some of the fields.

Answer

It would work just fine.

Answer

There is no table keyword.

Answer

INSERT INTO should be INSERT to.

Question 16

What does the following SQL statement do? DELETE FROM Customer_T WHERE state = 'HI';

Accepted Answer

Deletes all records from Customer_t where the state is equal to HI

Answer

Removes the Customer_T table from the database

Answer

Deletes all records from the Customer_T table

Answer

Doesn't delete anything because of a syntax error

Question 17

What does the following SQL statement do? UPDATE Product_T SET Unit_Price = 775 WHERE Product_ID = 7

Accepted Answer

Changes the unit price of Product 7 to 775

Answer

Changes the price of a unit called Product_T to 7

Answer

Changes the length of the Unit_Price field to 775

Answer

Updates the Product_T table to have a unit price of 775

Question 18

Which of the following is a technique for optimizing the internal performance of the relational data model?

Accepted Answer

Clustering data

Answer

Avoiding indexes on secondary keys

Answer

Not reporting statistics to save machine resources

Answer

Using random index organizations

Question 19

Indexes are created in most RDBMSs to:

Accepted Answer

provide rapid random and sequential access to base-table data.

Answer

provide a quicker way to store data.

Answer

decrease the amount of disk space utilized.

Answer

increase the cost of implementation.

Question 20

In an SQL statement, which of the following parts states the conditions for row selection?

Accepted Answer

WHERE

Answer

SELECT

Answer

FROM

Answer

GROUP BY

Question 21

The first part of an SQL query to be read is the ________ statement.

Accepted Answer

FROM

Answer

SELECT

Answer

WHERE

Answer

ORDER BY

Question 22

The last part of an SQL query to be read is the ________ statement.

Accepted Answer

ORDER BY

Answer

SELECT

Answer

FROM

Answer

WHERE

Question 23

What does the following SQL statement do? SELECT * From Customer WHERE Cust_Type = "Best"

Accepted Answer

Selects all the fields from the Customer table for each row with a customer labeled "Best"

Answer

Selects the "*" field from the Customer table for each row with a customer labeled "Best"

Answer

Selects fields with a "*" in them from the Customer table

Answer

Selects all the fields from the Customer table for each row with a customer labeled "*"

Question 24

What result will the following SQL statement produce? SELECT Avg(Standard_Price) as average from Product_V;

Accepted Answer

The average Standard_Price of all products in Product_V

Answer

The average of all products in Product_V

Answer

The average price of all products

Answer

The mode of all prices

Question 25

Which of the following questions is answered by the SQL statement? SELECT COUNT (Product_Description) FROM Product_T;

Accepted Answer

How many products have product descriptions in the Product Table?

Answer

How many products are in the table Product_T?

Answer

How many characters are in the field name "Product_Description"?

Answer

How many different columns named "Product_Description" are there in table Product_T?

Question 26

What results will be produced by the following SQL query? SELECT SUM(Standard_Price) as Total_Price from Product_V where Product_Type = 'WOOD';

Accepted Answer

The total price of all products that are of type wood

Answer

The total price of all products

Answer

The Standard_Price of the first wood product in the table

Answer

The Standard_Price of any wood product in the table

Question 27

Which of the following counts ONLY rows that contain a value?

Accepted Answer

COUNT

Answer

COUNT(*)

Answer

TALLY(*)

Answer

CHECKNUM

Question 28

Which of the following will produce the minimum of all standard prices?

Accepted Answer

SELECT MIN(Standard_Price) FROM Product_V;

Answer

SELECT Standard_Price FROM Product_V WHERE Standard_Price = min;

Answer

SELECT Standard_Price FROM min(Product_V);

Answer

SELECT MIN(Standard_Price) FROM Product_V WHERE Standard_Price = min(Standard_Price);

Question 29

What will result from the following SQL Select statement? SELECT MIN(Product_Description) FROM Product_V;

Accepted Answer

The first product description alphabetically in Product_V will be shown.

Answer

The minimum value of Product_Description will be displayed.

Answer

An error message will be generated.

Answer

SELECT @ will be displayed.

Question 30

Which of the following is the wildcard operator in SQL statements?

Accepted Answer

*

Answer

< >

Answer

=

Answer

&

Question 31

What result set will the following query return? SELECT Item_No FROM Order_V WHERE quantity > 10;

Accepted Answer

The Item_No of all orders that had more than 10 items

Answer

The Order_Id of all orders that had more than one item

Answer

The Order_Id of all orders that had more than 10 items

Answer

The Item_No of all orders that had 10 or more items

Question 32

What result set will the following query return? SELECT Item_No, description FROM item WHERE weight > 100 and weight < 200;

Accepted Answer

The Item_No and description for all items weighing between 101 and 199

Answer

The Item_No and description for all items weighing less than 100

Answer

The Item_No for all items weighing between 101 and 199

Answer

The Item_No for all items weighing more than 200

Question 33

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command.

Accepted Answer

DISTINCT

Answer

ALTER

Answer

CHECK

Answer

SPECIFIC

Question 34

What result set is returned from the following query? SELECT Customer_Name, telephone FROM customers WHERE city in ('Boston','New York','Denver');

Accepted Answer

The Customer_Name and telephone of all customers living in either Boston, New York or Denver

Answer

The Customer_Name and telephone of all customers

Answer

The Customer_Name and telephone of all customers living in Boston and New York and Denver

Answer

The Customer_Name of all customers living in Boston, New York or Denver

Question 35

To get all the customers from Hawaii sorted together, which of the following would be used?

Accepted Answer

ORDER BY

Answer

GROUP BY

Answer

HAVING

Answer

SORT

Question 36

A single value returned from an SQL query that includes an aggregate function is called a(n):

Accepted Answer

scalar aggregate.

Answer

agate.

Answer

vector aggregate.

Answer

summation.

Question 37

Multiple values returned from an SQL query that includes an aggregate function are called:

Accepted Answer

vector aggregates.

Answer

scalar aggregates.

Answer

agates.

Answer

summations.

Question 38

Which of the following can produce scalar and vector aggregates?

Accepted Answer

GROUP BY

Answer

ORDER BY

Answer

HAVING

Answer

SORT

Question 39

What will be returned when the following SQL statement is executed? SELECT driver_no,count(*) as num_deliveries FROM deliveries GROUP BY driver_no;

Accepted Answer

A listing of each driver as well as the number of deliveries that he or she has made

Answer

A listing of all drivers, sorted by driver number

Answer

A count of all of the deliveries made by all drivers

Answer

An error message

Question 40

What will be returned when the following SQL statement is executed? SELECT driver_no, count(*) as num_deliveries FROM deliveries WHERE state = 'MA' GROUP BY driver_no;

Accepted Answer

A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state

Answer

A listing of all drivers who made deliveries to state = 'MA', sorted by driver number

Answer

A count of all of the deliveries made to state = 'MA' by all drivers

Answer

An error message will be generated

Question 41

Which of the following finds all groups meeting stated conditions?

Accepted Answer

HAVING

Answer

SELECT

Answer

WHERE

Answer

FIND

Question 42

What will be returned when the following SQL query is executed? SELECT driver_no, COUNT(*) as num_deliveries FROM deliveries GROUP BY driver_no HAVING COUNT(*) > 2;

Accepted Answer

A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries

Answer

A listing of all drivers

Answer

A listing of the number of deliveries greater than 2

Answer

A listing of all drivers who made more than 2 deliveries

Question 43

Which of the following is true of the order in which SQL statements are evaluated?

Accepted Answer

The SELECT clause is processed before the ORDER BY clause.

Answer

The SELECT clause is always processed first.

Answer

The SELECT clause is always processed last.

Answer

The GROUP BY clause is processed before the WHERE clause.

Question 44

A view may not be updated directly if it contains:

Accepted Answer

the HAVING clause.

Answer

the SELECT clause.

Answer

the FROM clause.

Answer

the WHERE clause.

Question 45

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of:

Accepted Answer

referential integrity.

Answer

referential referring.

Answer

ethical integrity.

Answer

the Hoffer Principle.

Question 46

Which of the following is a purpose of the SQL standard?

Accepted Answer

To specify syntax and semantics of SQL data definition and manipulation languages

Answer

To specify maximum and incomplete standards

Answer

To define every operation for every SQL database

Answer

To permit no degrees of freedom for SQL DBMS

Question 47

The benefits of a standardized relational language include:

Accepted Answer

cross-system communication.

Answer

application turnover.

Answer

increased training costs.

Answer

confusing the SQL programmers.

Question 48

DCL is used to update the database with new records.

Accepted Answer

FALSE

Answer

TRUE

Question 49

A database table is defined using the data definition language (DDL).

Accepted Answer

TRUE

Answer

FALSE

Question 50

A database is maintained and queried using the data mapping language (DML).

Accepted Answer

FALSE

Answer

TRUE

Question 51

The content of dynamic views is generated when they are referenced.

Accepted Answer

TRUE

Answer

FALSE

Question 52

The views are created by executing a CREATE VIEW SQL command.

Accepted Answer

TRUE

Answer

FALSE

Question 53

When the SELECT clause in the create view statement contains the keyword DISTINCT, the view can be used to update data.

Accepted Answer

FALSE

Answer

TRUE

Question 54

The CREATE SCHEMA DDL command is used to create a table.

Accepted Answer

FALSE

Answer

TRUE

Question 55

SQL is both an American and international standard for database access.

Accepted Answer

TRUE

Answer

FALSE

Question 56

SQL has been implemented only in the mainframe and midrange environments.

Accepted Answer

FALSE

Answer

TRUE

Question 57

SQL originated from a project called System-S.

Accepted Answer

FALSE

Answer

TRUE

Question 58

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

Accepted Answer

TRUE

Answer

FALSE

Question 59

A major benefit of SQL as a standard is reduced training costs.

Accepted Answer

TRUE

Answer

FALSE

Question 60

Implementation of a standard can never stifle creativity and innovation.

Accepted Answer

FALSE

Answer

TRUE

Question 61

Applications can be moved from one machine to another when each machine uses SQL.

Accepted Answer

TRUE

Answer

FALSE

Question 62

Some DBMS can handle graphic data types as well as text and numbers.

Accepted Answer

TRUE

Answer

FALSE

Question 63

When creating tables, it's important to decide which columns will allow null values before the table is created.

Accepted Answer

TRUE

Answer

FALSE

Question 64

In databases, null values are equivalent to zero.

Accepted Answer

FALSE

Answer

TRUE

Topic 5

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Science