SQL Queries for Practice with Answers PDF Download - 25

MCQ 121: In SQL, constraints can be specified that is followed and must be satisfied by the data stored in the database is known to be

1. Authorization
2. View definition
3. Integrity
4. View declaration

MCQ 122: SQL have introduced a predicate to be followed by the relations being joined, is known to be

1. ON
2. IN
3. AS
4. Like

MCQ 123: SQL allows handling the exceptions with the declaration of

1. Operations
2. Functions
3. Handlers
4. Interfaces

MCQ 124: The elimination of executing multiple statements in a single call took place because of the

1. SQL reader
2. SQL injection
3. SQL active listener
4. SQL passive listener

MCQ 125: The state of the database marked by the transaction becomes permanent by using

1. Back work
2. Trace work
3. Rollback work
4. Commit work