SQL Interview Questions for Testing Freshers FAQ PDF Download

Learn sql interview questions for testing freshers FAQ, sql FAQ, competency based interview questions with MCQs based online test prep. These frequently asked questions has multiple choice questions (MCQ), sql quiz questions and answers: attributes can be added to an existing relation in sql by using command, answer key with options alter, modify, tailor and ammend for competitive exam preparation. Free FAQ, situational interview questions are to learn sql interview questions for testing freshers quiz online with MCQs to practice test questions with answers.

FAQ: SQL Interview Questions for Testing Freshers PDF Download

MCQ: Attributes can be added to an existing relation in SQL by using command

  1. Alter
  2. Modify
  3. Tailor
  4. Ammend

A

MCQ: A SQL command that deletes all tuples of relation along with its schema is called

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

B

MCQ: In SQL, most drastic option used for a delete operation is

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

C

MCQ: Correct SQL command to drop some relation from database is

  1. Drop about *example*
  2. Drop from *example*
  3. Delete from *example*
  4. Delete about *example*

B

MCQ: A SQL command through which structure of a relation is retained but may delete all of its tuples is called

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

C