SQL Fundamental Questions and Answers

Here are some important questions and answers

answers are in bold

  • Which is not a DDL command?

  1. rename

  2. update

  3. create

  4. alter

  5. drop

  • Which of the following command is not a SQL statement ?

  1. merge

  2. revoke

  3. commit

  4. savepoint

  5. non of these

  • Which statement is a Transaction Control statement ?

  1. alter

  2. rename

  3. truncate

  4. savepoint

  5. non of these

  • Which statement is a data retrieval statement ?

  1. select

  2. insert

  3. insert into

  4. update

  5. merge

  • The statement  used to define the database structure or schema  is

  1. DDL

  2. DML

  3. DCL

  4. TCL

  5. non of these

  • By using which command ,if we’ll delete data from a table that  we can get rollback  ?

  1. delete

  2. drop

  3. truncate

  4. all the above

  5. non of these

  • The command we do use to delete rows is delete drop truncate all of above

  1. delete

  2. drop

  3. truncate

  4. all of above

  5. non of these

  • What does SQL stand for?

  1. Structured Queries Language

  2. Structured Query Language

  3. Structured Question Language

  4. Structured Questions Language

  5. non of these

  • Which statement is not a transaction control statement?

  1. grand

  2. commit

  3. rollback

  4. savepoint

  5. non of these

  • ‘Having’ clause is used with

  1. Where

  2. Group By

  3. Order By

  4. Both of above

  5. non of these

 

Facebook Comments

Author Profile

IBPS Preparation Team
IBPS Preparation Team
At IBPS Preparation,We provide pathway for any candidate who wishes to shine in the recruitment process of IBPS.
© Copyright 2017 - All Rights Reserved | DesignzRush (OPC) Pvt. Ltd.
Complete Solution for Banking Exams in India
Inline
Inline