WorksheetsSQL and Database Concepts Quiz
Total questions: 15
Worksheet time: 8mins
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
Authentication modes in SQL Server:
Windows
Mixed mode
Both A & B
None
Keyword to raise error in SP:
THROW
THROWERROR
RAISERROR
ERROR
Wildcard to exclude names starting with e to g:
[^e-g]%
[e-g]%
[e^g]%
[efg]%
DBA coordinates between:
DB, users
App, DB
DBMS, DB
App, users
Executable statement to access data is:
Query
Transaction
Operation
Statement
