SQL Interview Questions for Experienced Professionals PDF Download - 11

MCQ 51: The SQL command used to delete all the information about the relation from the database is

1. Eliminate
2. Drop
3. Delete command
4. Abort

MCQ 52: Committing to the current state of transaction in SQL is known to be

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

MCQ 53: The process of type conversion in which values of one type of data can be converted to another domain, known to be

1. Conversion
2. Projecting
3. Alter
4. Cast

MCQ 54: For the storage of nvarchar type of multilingual data, SQL uses

1. Binary code representation
2. ANSI representation
3. Char-code representation
4. Unicode representation

MCQ 55: In SQL, the declaration of foreign keys can be marked as part of the

1. Select table statement
2. Define table statement
3. Create table statement
4. Describe table statement