Database System Exam Quiz Questions

40 Questions | Total Attempts: 96

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

.


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

  • 26. 
    ___ was adopted as a national standard by ANSI in 1992
    • A. 

      Oracle

    • B. 

      SQL

    • C. 

      Microsoft Access

    • D. 

      DBase

  • 27. 
    What type of join is needed when you wish to include rows that do not have matching values?
    • A. 

      Equi-join

    • B. 

      Natural join

    • C. 

      Outer join

    • D. 

      All of the above

  • 28. 
    The following SQL is which type of join:SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM, CUSTOMER_T, ORDER_T.CUSTOMER_ID=ORDER_T.CUSTOMER_ID
    • A. 

      Equi-join

    • B. 

      Natural join

    • C. 

      Outer join

    • D. 

      Cartesian join

  • 29. 
    Which of the following statements is true concerning subqueries?
    • A. 

      Involves the use of an inner and outer query.

    • B. 

      Cannot return the same result as a query that is not a subquery.

    • C. 

      Does not start with the word SELECT.

    • D. 

      All of the above.

  • 30. 
    Which SQL statement is used to update data in a database?
    • A. 

      SAVE

    • B. 

      UPDATE

    • C. 

      MODIFY

    • D. 

      SAVE AS

  • 31. 
    Which SQL statement us used in insert new data in a database?
    • A. 

      ADD RECORD

    • B. 

      INSERT INTO

    • C. 

      ADD NEW

    • D. 

      INSERT NEW

  • 32. 
    With SQL, how do you select a column named “FirstName” from a table named “Persons”?
    • A. 

      SELECT FirstName FROM Persons

    • B. 

      SELECT Persons FirstName

    • C. 

      EXTRACT FirstName FROM Persons

    • D. 

      Option 4

  • 33. 
    With SQL, how do you select a column named “FirstName” from a table named “Persons”?
    • A. 

      SELECT Persons

    • B. 

      SELECT * Persons

    • C. 

      SELECT * FROM Persons

    • D. 

      SELECT [all] FROM Persons

  • 34. 
    With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?
    • A. 

      SELECT [all] FROM Persons WHERE FirstName='Peter'

    • B. 

      SELECT*FROM Persons WHERE FirstName='Peter'

    • C. 

      SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

    • D. 

      SELECT * FROM Persons WHERE FirstName'Peter'

  • 35. 
    With SQL, how do you select all the records from a table named “Persons where the “FirstName” is “Peter” and the “LastName” is “Jackson”?
    • A. 

      SELECT * FROM Persons WHERE FirstName'Peter' AND LastName'Jackson'

    • B. 

      SELECT FirstName='Peter', LastName='Jackson' FROM Persons

    • C. 

      SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

    • D. 

      Option 4

  • 36. 
    With SQL, how can you return all the records from a table named “Person” sorted descending by “FirstName”?
    • A. 

      SELECT * FROM Persons SORT 'FirstName' DESC

    • B. 

      SELECT * FROM Persons ORDER BY FirstName DESC

    • C. 

      SELECT * FROM Persons ORDER FirstName DESC

    • D. 

      SELECT * FROM Persons SORT BY 'FirstName' DESC

  • 37. 
    With SQL, how can you insert a new record into the “Persons” table?
    • A. 

      INSERT ('Jimmy', 'Jackson') INTO Persons

    • B. 

      INSERT INTO Person VALUES ('Jimmy', 'Jackson')

    • C. 

      INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

    • D. 

      Option 4

  • 38. 
    With SQL, how can you delete the records where the “FirstName” is “Peter” in the Persons Table?
    • A. 

      DELETE FROM Persons WHERE FirstName = 'Peter'

    • B. 

      DELETE ROW FirstName='Peter' FROM Persons

    • C. 

      DELETE FirstName='Peter' FROM Persons

    • D. 

      Option 4

  • 39. 
    With SQL, how can you return the number of records in the “Persons” table?
    • A. 

      SELECT COUNT(*) FROM Persons

    • B. 

      SELECT COLUMNS() FROM Persons

    • C. 

      SELECT COLUMNS(*) FROM Persons

    • D. 

      SELECT COUNT() FROM Persons

  • 40. 
    In a database, student registration information is stored as a C++ structure. This information is at 
    • A. 

      External level

    • B. 

      Conceptual level

    • C. 

      Internal level

    • D. 

      Option 4