Search Header Logo

SQL and Database Concepts Quiz

Authored by Tuấn Đình

Engineering

University

Used 1+ times

SQL and Database Concepts Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

ROLLBACK in a database is a ____ statement.

DDL

DML

DCL

TCL

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Insert

Update

Delete

Select

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select invalid type of Trigger.

Select

Insert

Update

Delete

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is NOT an advantage of using Stored Procedures?

Reduce client traffic

Reuse of code

Maintainability

Testing of encapsulated logic

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the WRONG statement.

PL/SQL is Oracle's extension

T-SQL is procedural

Transact-SQL is MS extension

SQL is a procedural language

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?