Database System Exam Quiz Questions

40 Questions | Total Attempts: 164

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

Questions and Answers
  • 1. 
    The DBMS acts as an interface between what two components of an enterprise-class database system?
    • A. 

      Database application and the database

    • B. 

      Data and the database

    • C. 

      The user and the database application

    • D. 

      Database application and SQL

  • 2. 
    An application where only one user accesses the database at a given time is an example ofa(n)?
    • A. 

      Single-user database application

    • B. 

      Multiuser database application

    • C. 

      E-commerce database application

    • D. 

      Data mining database application

  • 3. 
    SQL stands for
    • A. 

      Structured Query Language

    • B. 

      Sequential Query Language

    • C. 

      Structured Question Language

    • D. 

      Sequential Question Language

  • 4. 
    You have run SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled “TableName,” “NumberofColumns” and “PrimaryKey.” You are looking at
    • A. 

      User data

    • B. 

      Metadata

    • C. 

      Report

    • D. 

      Indices

  • 5. 
    Which of the following is not considered to be a basic element of an enterprise-class database system?
    • A. 

      Users

    • B. 

      Database applications

    • C. 

      DBMS

    • D. 

      COBOL programs

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

      ADD

    • B. 

      CREATE

    • C. 

      INSERT

    • D. 

      MAKE

  • 7. 
    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...

  • 8. 
    The SQL WHERE clause:
    • A. 

      Limits the column data that are returned

    • B. 

      Limits the row data are returned

    • C. 

      Both A and B are correct

    • D. 

      Neither A nor B are correct

  • 9. 
    Which of the following is the original purpose of SQL?
    • A. 

      To specify the syntax and semantics of SQL data definition language

    • B. 

      To specify the syntax and semantics of SQL manipulation language

    • C. 

      To define the data structures

    • D. 

      All of the above

  • 10. 
    The wildcard is a WHERE clause is useful when?
    • A. 

      An exact math is necessary in a SELECT statement.

    • B. 

      An exact match is not possible in a SELECT statement.

    • C. 

      An exact match is necessary in a CREATE statement.

    • D. 

      An exact match is not possible in a CREATE statement.

  • 11. 
    A view is which of the following?
    • A. 

      A virtual table that can be accessed via SQL commands.

    • B. 

      A virtual table that cannot be accessed via SQL commands.

    • C. 

      A base table that can be accessed via SQL commands.

    • D. 

      A base table that cannot be accessed via SQL commands.

  • 12. 
    SQL data definition commands make up a(n)
    • A. 

      DDL

    • B. 

      DML

    • C. 

      HTML

    • D. 

      XML

  • 13. 
    Which of the following is the correct order of keywords for SQL SELECT statements?
    • A. 

      SELECT, FROM, WHERE

    • B. 

      FROM, WHERE, SELECT

    • C. 

      WHERE, FROM, SELECT

    • D. 

      SELECT, WHERE, FROM

  • 14. 
    A subquery in an SQL SELECT statement is enclosed in:
    • A. 

      Braces -- {...}.

    • B. 

      CAPITAL LETTERS.

    • C. 

      Parenthesis -- (...).

    • D. 

      Brackets -- [...].

  • 15. 
    The result of a SQL SELECT statement is a(n)
    • A. 

      Report

    • B. 

      Form

    • C. 

      File

    • D. 

      Table

  • 16. 
    Which of the following are the five built-in functions provided by SQL?
    • A. 

      COUNT, SUM, AVG, MAX, MIN

    • B. 

      SUM, AVG, MIN, MAX, MULT

    • C. 

      SUM, AVG, MULT, DIV, MIN

    • D. 

      SUM, AVG, MIN, NAME

  • 17. 
    The HAVING clause does which of the following?
    • A. 

      Acts like a WHERE clause but is used for groups rather than rows.

    • B. 

      Acts like WHERE clause but is used for rows rather than columns.

    • C. 

      Acts like a WHERE clause but is used for columns rather than groups.

    • D. 

      Acts EXACTLY like a WHERE clause.

  • 18. 
    The SQL-92 wildcards are
    • A. 

      Asterisk (*); percent sign(%)

    • B. 

      Percent sign(%); underscore(_)

    • C. 

      Underscore(_); question mark(?)

    • D. 

      Question mark(?); asterisk(*)

  • 19. 
    To remove duplicate rows from the results of an SQL select statement, the ___qualifier specified must be included.
    • A. 

      ONLY

    • B. 

      UNIQUE

    • C. 

      DISTINCT

    • D. 

      Option 4

  • 20. 
    SQL query and modification commands make up a(n)
    • A. 

      DDL

    • B. 

      DML

    • C. 

      HTML

    • D. 

      XML

  • 21. 
    Find the SQL statement below that is equal to the following:SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
    • A. 

      SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

    • B. 

      SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

    • C. 

      SELECT NAME IN CUSTOMER WHERE STATE = 'V';

    • D. 

      SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

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

      SORT BY

    • B. 

      ALIGN BY

    • C. 

      ORDER BY

    • D. 

      GROUP BY

  • 23. 
    To define what columns should be displayed in an SQL SELECT statement:
    • A. 

      Use FROM to name the source table(s) and list the columns to be shown after SELECT.

    • B. 

      Use USING to name the source table(s) and list the columns to be shown after SELECT.

    • C. 

      Use SELECT to name the source table(s) and list the columns to be shown after USING.

    • D. 

      Use USING to name the source table(s) and list the columns to be shown after WHERE.

  • 24. 
    The SQL statement that queries or reads data from a table is 
    • A. 

      SELECT

    • B. 

      READ

    • C. 

      QUERY

    • D. 

      None of the above is correct

  • 25. 
    The SQL keyword BETWEEN in used:
    • A. 

      For ranges.

    • B. 

      To limit the columns displayed.

    • C. 

      As a wildcard.

    • D. 

      None of the above is correct.

Related Topics
Back to Top Back to top