SQL and Database Concepts Quiz

ROLLBACK in a database is a ____ statement.

• DDL

• DML

• DCL

• TCL

Which SQL statement should you use to retrieve data from a database table?

• Insert

• Update

• Delete

• Select

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

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

• A listing of each driver who made deliveries to 'MA' and number of deliveries

• A count of all deliveries to 'MA' by all drivers

• An error message

SELECT * FROM A UNION SELECT * FROM B (with different column counts)

• All fields of both tables displayed

• Returns error: number of rows different

• Returns error: number of columns different

• All fields from table A displayed

Select invalid type of Trigger.

• Select

• Insert

• Update

• Delete

Which is NOT an advantage of using Stored Procedures?

• Reduce client traffic

• Reuse of code

• Maintainability

• Testing of encapsulated logic

Choose the WRONG statement.

• PL/SQL is Oracle's extension

• T-SQL is procedural

• Transact-SQL is MS extension

• SQL is a procedural language

Most common type of join?

• Left Join

• Inner Join

• Right Join

• Full Join

____ represents raw facts, ____ is meaningful data.

• Information, bits

• Information, reporting

• Data, information

• Records, bytes

A data warehouse:

• Contains naming conventions

• Used for reporting & analysis

• Current data only

• End-user updates