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

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

  • undoes the effects of the last UPDATE command
  • restores the content of the database to its state at the end of the previous day
  • does nothing
  • makes sure that all changes to the database are in effect
  • undoes all changes to the database resulting from the execution of the transaction

  • Web servers should be configured so that :

  • unauthorized access is always possible
  • unauthorized access is restricted
  • any form of access is impossible
  • unauthorized access is sometimes possible
  • unauthorized access is unrestricted

  • Which of the following is a CASE SQL statement

  • A way to establish a data definition in SQL.
  • A way to establish an IF-THEN-ELSE in SQL.
  • Establish a loop in SQL or establish an IF-THEN-ELSE in SQL.
  • A way to establish a loop in SQL.
  • A 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 ………..

  • use USING to name the source table(s)
  • use SELECT to name the source table(s) and list the columns to be shown after USING.
  • use USING to name the source table(s) and list the columns to be shown after SELECT.
  • use FROM to name the source table(s) and list the columns to be shown after SELECT.
  • use USING to name the source table(s) and list the columns to be shown after WHERE.
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
Data Base Question Answers, PSC, UPSC, IBPS, SSC Previous Papers
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges