Data Triggs Round 1

22 Questions | Total Attempts: 58

SettingsSettingsSettings
Please wait...
Data Triggs Round 1

.


Questions and Answers
  • 1. 
    Who proposed the relational model?
    • A. 

      Herman Hollerith

    • B. 

      Raymond F Boyce

    • C. 

      Charles Babbage

    • D. 

      Edgar F Codd

  • 2. 
    Who proposed the relational model?
    • A. 

      Herman Hollerith

    • B. 

      Raymond F Boyce

    • C. 

      Charles Babbage

    • D. 

      Edgar F Codd

  • 3. 
    Who proposed the relational model?
    • A. 

      Herman Hollerith

    • B. 

      Raymond F Boyce

    • C. 

      Charles Babbage

    • D. 

      Edgar F Codd

  • 4. 
    With SQL, how do you select all the records from a table named "Persons"  from the column  "FirstName" starting with  "a"?
    • A. 

      SELECT * FROM Persons WHERE FirstName='a';

    • B. 

      SELECT * FROM Persons WHERE FirstName LIKE 'a%';

    • C. 

      SELECT * FROM Persons WHERE FirstName LIKE '%a';

    • D. 

      SELECT * FROM Persons WHERE FirstName LIKE'%a'%;

  • 5. 
    Which of the following is true regarding NULL?
    • A. 

      NULL=0

    • B. 

      NULL

    • C. 

      NULL>0

    • D. 

      NULL0

  • 6. 
    ____________ was adopted as a national standard by ANSI in 1992?
    • A. 

      Oracle

    • B. 

      SQL

    • C. 

      DBase

    • D. 

      Microsoft Access

  • 7. 
    Which of the following is a group of one or more attributes that uniquely identify a row?
    • A. 

      Key

    • B. 

      Determinant

    • C. 

      Tuple

    • D. 

      Relation

  • 8. 
    Which of the following is NOT a unary operation?
    • A. 

      SELECT

    • B. 

      UNION

    • C. 

      RENAME

    • D. 

      PROJECT

  • 9. 
    What output will the following query produce?SELECT NVL2(NULL, 'NOT NULL', NULL) FROM DUAL;
    • A. 

      NULL

    • B. 

      NOT NULL

    • C. 

      Function NVL2 is not defined

    • D. 

      None of the Above

  • 10. 
    What are ACID properties of transactions?
    • A. 

      Atomicity, Consistency, Isolation, Database

    • B. 

      Atomicity, Consistency, Isolation, Durability

    • C. 

      Atomicity, Concurrency, Inconsistent, Durability

    • D. 

      Atomicity, Concurrency, Isolation, Durability

  • 11. 
    The SQL -92 wildcards are __________ and __________.
    • A. 

      Asterisk(*) ; percent sign(%)

    • B. 

      Percent sign(%) ; underscore(_)

    • C. 

      Underscore(_) ; question mark(?)

    • D. 

      Question mark(?) ; asterisk(*)

  • 12. 
    Which of the following is considered as DBMS?
    • A. 

      Access

    • B. 

      Oracle

    • C. 

      FoxPro

    • D. 

      All of these

  • 13. 
    Which of the following locks the item from change but not from read?
    • A. 

      Implicit Lock

    • B. 

      Explicit Lock

    • C. 

      Exclusive Lock

    • D. 

      Shared Lock

  • 14. 
    What is the result of the following query?select case when null = null then 'Yup' else 'Nope' end as Result; 
    • A. 

      Yup

    • B. 

      Nope

    • C. 

      Null

    • D. 

      Error

  • 15. 
    Which of the following is NOT a DDL statement?
    • A. 

      UPDATE

    • B. 

      ALTER

    • C. 

      CREATE

    • D. 

      RENAME

  • 16. 
    Which of the following is an example for network database?
    • A. 

      Unify

    • B. 

      Ingress

    • C. 

      IDMS

    • D. 

      None of the above

  • 17. 
    Which of the following query would display names of all the students whose email ids are not provided?
    • A. 

      Select name from students where email = 0;

    • B. 

      Select name from students where email = ' ';

    • C. 

      Select name from students where email is null;

    • D. 

      Select name from students where email = 'null';

  • 18. 
    Transactions are initiated by BEGIN TRANSACTION and terminated by:
    • A. 

      COMMIT TRANSACTION

    • B. 

      ROLLBACK TRANSACTION

    • C. 

      Either by COMMIT TRANSACTION or by ROLLBACK TRANSACTION

    • D. 

      NONE

  • 19. 
    Which SQL statement is used to extract data from a database?
    • A. 

      FROM

    • B. 

      GET

    • C. 

      CHOOSE

    • D. 

      SELECT

  • 20. 
    Mathematically row is referred to as ___________
    • A. 

      Relation

    • B. 

      Attribute

    • C. 

      Tuple

    • D. 

      Domain

  • 21. 
    Which statement allows conditional update or insertion of data into a table simultaneously?
    • A. 

      INSERT

    • B. 

      MERGE

    • C. 

      UPDATE

    • D. 

      None of the above

  • 22. 
    Which of the following is an SQL query to get third maximum salary of an employee from a table named employee_table?
    • A. 

      SELECT TOP 1 SALARY FROM ( SELECT TOP 3 SALARY FROM employee_table ORDER BY SALARY ASC) AS EMP ORDER BY SALARY DESC;

    • B. 

      SELECT TOP 1 SALARY FROM ( SELECT TOP 3 SALARY FROM employee_table ORDER BY SALARY DESC) AS EMP ORDER BY SALARY ASC;

    • C. 

      SELECT TOP 3 SALARY FROM ( SELECT TOP 1 SALARY FROM employee_table ORDER BY SALARY DESC) AS EMP ORDER BY SALARY ASC;

    • D. 

      SELECT TOP 3 SALARY FROM ( SELECT TOP 1 SALARY FROM employee_table ORDER BY SALARY ASC) AS EMP ORDER BY SALARY DESC;

Back to Top Back to top