Data Base Questions & Answers (Compiled from UPSC, SSC ,PSC ,IBPS previous question papers)

  • A ROLLBACK command in a transaction…………..

  • Aundoes the effects of the last UPDATE command
  • Brestores the content of the database to its state at the end of the previous day
  • Cdoes nothing
  • Dmakes sure that all changes to the database are in effect
  • Eundoes all changes to the database resulting from the execution of the transaction
  • Web servers should be configured so that :

  • Aunauthorized access is always possible
  • Bunauthorized access is restricted
  • Cany form of access is impossible
  • Dunauthorized access is sometimes possible
  • Eunauthorized access is unrestricted
  • Which of the following is a CASE SQL statement

  • AA way to establish a data definition in SQL.
  • BA way to establish an IF-THEN-ELSE in SQL.
  • CEstablish a loop in SQL or establish an IF-THEN-ELSE in SQL.
  • DA way to establish a loop in SQL.
  • EA way to establish a data definition in SQL or establish a loop in SQL.
  • To define what columns should be displayed in an SQL, SELECT statement ………..

  • Ause USING to name the source table(s)
  • Buse SELECT to name the source table(s) and list the columns to be shown after USING.
  • Cuse USING to name the source table(s) and list the columns to be shown after SELECT.
  • Duse FROM to name the source table(s) and list the columns to be shown after SELECT.
  • Euse USING to name the source table(s) and list the columns to be shown after WHERE.