SQL Query Quiz

What is the name of the query that is placed within a WHERE or HAVING clause of another query?

• Multi query

• Subquery

• Super query

• Master query

What is NOLOCK IN SQL equivalent to?

• WRITE UNCOMMITTED

• READ COMMITTED

• WRITE COMMITTED

• READ UNCOMMITTED

To select some particular columns, which of the following commands is used?

• PROJECTION

• SELECTION

• JOIN

• UNION

SQL views are also known as?

• Schema

• Virtual Table

• Instance

• None of the above

Select the correct foreign key constraint?

• Referential Integrity

• Entity Integrity

• Domain Integrity

• None of the above

The program which performs some common action on database data and is also stored there is called?

• Trigger

• Stored Procedure

• Stored Function

• None of the above

NATURAL JOIN can also be termed as -

• Combination of Union and cartesian product

• Combination of selection and cartesian product

• Combination of projection and cartesian product

• None of the above

Identify the concurrency-based protocol?

• Lock based protocol

• Two-phase locking protocol

• Timestamp ordering protocol

• All the above

How can you view all the triggers currently in the database?

• SHOW

• VIEW

• READ

• None of the above

How can SQL injections occur?

• Data is used to dynamically construct an SQL Query

• Unintended data from an untrusted source enters the application

• Both A and B

• None of the above