SQL Test: Trivia Quiz Questions!

20 Questions | Total Attempts: 820

SettingsSettingsSettings
SQL Test: Trivia Quiz Questions! - Quiz

.


Questions and Answers
  • 1. 
    A pointer is
    • A. 

      A keyword used to create variables

    • B. 

      A variable that stores address of an instruction

    • C. 

      A variable that stores address of other variable

    • D. 

      All of the above

  • 2. 
    A page fault occurs when:
    • A. 

      The page is corrupted by application software

    • B. 

      The page is in main memory

    • C. 

      The page is not in main memory

    • D. 

      One tries to divide a number by 0

  • 3. 
    The keyword used to transfer control from a function back to the calling function is
    • A. 

      Switch

    • B. 

      Goto

    • C. 

      Go back

    • D. 

      Return

  • 4. 
    Specify the 2 library functions to allocate memory dynamically?     
    • A. 

      Malloc() and memalloc()

    • B. 

      Alloc() and memalloc()

    • C. 

      Malloc() and calloc()

    • D. 

      Memalloc() and faralloc()

  • 5. 
    System calls are invoked by using:
    • A. 

      Software interrupts

    • B. 

      Polling

    • C. 

      Indirect jump

    • D. 

      A privileged instruction

  • 6. 
    What is a shell?
    • A. 

      It is a hardware component

    • B. 

      It is a command interpreter

    • C. 

      It is a part in compiler

    • D. 

      It is a tool in CPU scheduling

  • 7. 
    Unix Operating System is an __________.
    • A. 

      Time Sharing Operating System

    • B. 

      Multi-User Operating System

    • C. 

      Multi-tasking Operating System

    • D. 

      All the Above

  • 8. 
    Which of the following cannot be checked in a switch-case statement?      
    • A. 

      Character

    • B. 

      Integer

    • C. 

      Float

    • D. 

      Enum

  • 9. 
    The primary job of the operating system of a computer is to ________.
    • A. 

      Command Resources

    • B. 

      Manage Resources

    • C. 

      Provide Utilities

    • D. 

      Be user friendly

  • 10. 
    Does there any function exist to convert the int or float to a string?
    • A. 

      True

    • B. 

      False

  • 11. 
    CPU performance is measured through ________.
    • A. 

      Throughput

    • B. 

      MHz

    • C. 

      Flaps

    • D. 

      None of the above

  • 12. 
    How would you round off a value from 1.66 to 2.0?
    • A. 

      Ceil(1.66)

    • B. 

      Floor(1.66)

    • C. 

      Roundup(1.66)

    • D. 

      Roundto(1.66)

  • 13. 
    Which one of the following is not a feature of c?
    • A. 

      Structures

    • B. 

      Pointers

    • C. 

      Unions

    • D. 

      Inheritance

  • 14. 
    Which one among the following is not a storage class?
    • A. 

      Auto

    • B. 

      Extern

    • C. 

      Register

    • D. 

      Global

  • 15. 
    You can add a row using SQL in a database with which of the following?
    • A. 

      ADD

    • B. 

      CREATE

    • C. 

      INSERT

    • D. 

      MAKE

  • 16. 
    The command to remove rows from a table 'CUSTOMER' is:
    • A. 

      REMOVE FROM CUSTOMER ...

    • B. 

      DROP FROM CUSTOMER ...

    • C. 

      DELETE FROM CUSTOMER WHERE ...

    • D. 

      UPDATE FROM CUSTOMER ...

  • 17. 
    The command to eliminate a table from a database is:
    • A. 

      REMOVE TABLE CUSTOMER;

    • B. 

      DROP TABLE CUSTOMER;

    • C. 

      DELETE TABLE CUSTOMER;

    • D. 

      UPDATE TABLE CUSTOMER;

  • 18. 
    The DROP TABLE statement:
    • A. 

      Deletes the table structure only.

    • B. 

      Deletes the table structure along with the table data.

    • C. 

      Works whether or not referential integrity constraints would be violated.

    • D. 

      It is not an SQL statement.

  • 19. 
    Which of the following is NOT a type of SQL constraint?
    • A. 

      PRIMARY KEY

    • B. 

      FOREIGN KEY

    • C. 

      ALTERNATE KEY

    • D. 

      UNIQUE

  • 20. 
    Which one of the following sorts of rows in SQL?
    • A. 

      SORT BY

    • B. 

      ALIGN BY

    • C. 

      ORDER BY

    • D. 

      GROUP BY

Related Topics
Back to Top Back to top