Question 1

The DELETE TABLE DDL command is used to remove a table from the database.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  SQL 
B)  schema 
C)  catalog 
D)  master view 
A)  SQL 
B)  schema 
C)  catalog 
D)  master view

Question 4

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

Accepted Answer

A)  vector aggregates. 
B)  scalar aggregates. 
C)  agates. 
D)  summations. 
A)  vector aggregates. 
B)  scalar aggregates. 
C)  agates. 
D)  summations.

Question 5

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.

Accepted Answer

A) True 
 B)False

Question 6

The WHERE clause is always processed before the GROUP BY clause when both occur in a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 7

Discuss the pros and cons of using dynamic views.

Accepted Answer

A dynamic view is useful, since it provi

Question 8

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)  A listing of all drivers who made deliveries to state = 'MA', sorted by driver number 
B)  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 
C)  A count of all of the deliveries made to state = 'MA' by all drivers 
D)  An error message will be generated 
A)  A listing of all drivers who made deliveries to state = 'MA', sorted by driver number 
B)  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 
C)  A count of all of the deliveries made to state = 'MA' by all drivers 
D)  An error message will be generated

Question 9

The following INSERT command would work fine:
INSERT INTO budget values 121,222,111;

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  Implementation 
B)  Physical design 
C)  Analysis 
D)  Evaluation 
A)  Implementation 
B)  Physical design 
C)  Analysis 
D)  Evaluation

Question 11

What are some of the advantages and disadvantages to an SQL standard?

Accepted Answer

Some of the advantages are: reduced trai

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The command for creating a database is:

Accepted Answer

A)  CREATE TABLE. 
B)  CREATE VIEW. 
C)  CREATE SCHEMA. 
D)  CREATE AUTHORIZATION. 
A)  CREATE TABLE. 
B)  CREATE VIEW. 
C)  CREATE SCHEMA. 
D)  CREATE AUTHORIZATION.

Question 14

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

A)  It would work just fine. 
B)  You must specify the fields to insert if you are only inserting some of the fields. 
C)  There is no table keyword. 
D)  INSERT INTO should be INSERT to. 
A)  It would work just fine. 
B)  You must specify the fields to insert if you are only inserting some of the fields. 
C)  There is no table keyword. 
D)  INSERT INTO should be INSERT to.

Question 15

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

Accepted Answer

A)  Order By 
B)  Group By 
C)  Having 
D)  Sort 
A)  Order By 
B)  Group By 
C)  Having 
D)  Sort

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  Deletes all records from Customer_t where the state is equal to HI 
B)  Removes the Customer_T table from the database 
C)  Deletes all records from the Customer_T table 
D)  Doesn't delete anything because of a syntax error 
A)  Deletes all records from Customer_t where the state is equal to HI 
B)  Removes the Customer_T table from the database 
C)  Deletes all records from the Customer_T table 
D)  Doesn't delete anything because of a syntax error

Question 18

INSERT INTO is an example of ________ code.

Accepted Answer

A)  DDL 
B)  DML 
C)  DCL 
D)  TIO 
A)  DDL 
B)  DML 
C)  DCL 
D)  TIO

Question 19

The command for removing a table is:

Accepted Answer

A)  CREATE TABLE. 
B)  REMOVE TABLE. 
C)  DROP TABLE. 
D)  TRUNCATE TABLE. 
A)  CREATE TABLE. 
B)  REMOVE TABLE. 
C)  DROP TABLE. 
D)  TRUNCATE TABLE.

Question 20

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

Accepted Answer

A) True 
 B)False

The DELETE TABLE DDL command is used to remove a table from the database.

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

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

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

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.

The WHERE clause is always processed before the GROUP BY clause when both occur in a SELECT statement.

Discuss the pros and cons of using dynamic views.

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;

The following INSERT command would work fine: INSERT INTO budget values 121,222,111;

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

What are some of the advantages and disadvantages to an SQL standard?

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

The command for creating a database is:

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

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

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

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

INSERT INTO is an example of ________ code.

The command for removing a table is:

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 5: Introduction to SQL

The DELETE TABLE DDL command is used to remove a table from the database.

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

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

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

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.

The WHERE clause is always processed before the GROUP BY clause when both occur in a SELECT statement.

Discuss the pros and cons of using dynamic views.

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;

The following INSERT command would work fine: INSERT INTO budget values 121,222,111;

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

What are some of the advantages and disadvantages to an SQL standard?

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

The command for creating a database is:

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

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

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

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

INSERT INTO is an example of ________ code.

The command for removing a table is:

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

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;