Menu
Home / CSE / Database System 2 - CS :: Introduction to SQL

CSE :: Database System 2 - CS

Database System 2 - CS - Advanced SQL
Database System 2 - CS - SQL Server 2000
Database System 2 - CS - Data Warehousing
Database System 2 - CS - XML and ADO.NET
Database System 2 - CS - Database Redesign
Database System 2 - CS - Introduction to SQL
Database System 2 - CS - Distributed Databases
Database System 2 - CS - Client Server Database
Database System 2 - CS - Data Modeling with ER
Database System 2 - CS - Logical Database Design
Database System 2 - CS - Introduction to Database
Database System 2 - CS - Object Oriented Database
Database System 2 - CS - Physical Database Design
Database System 2 - CS - The Database Environment
Database System 2 - CS - ODBC, OLE DB, ADO, and ASP
Database System 2 - CS - ER Model and Business Rules
Database System 2 - CS - Database Processing for BIS
Database System 2 - CS - Managing Multiuser Databases
Database System 2 - CS - Object Oriented Data Modeling
Database System 2 - CS - Managing Databases with Oracle
Database System 2 - CS - SQL for Database Construction
Database System 2 - CS - Data and Database Administration
Database System 2 - CS - Data Models into Database Designs
Database System 2 - CS - Modeling Data in the Organization
Database System 2 - CS - The Database Development Process
Database System 2 - CS - The Internet Database Environment
Database System 2 - CS - JDBC, Java Server Pages, and MySQL
Database System 2 - CS - Database Design Using Normalization
Database System 2 - CS - The Relational Model and Normalization
  1. The SQL keyword(s) ________ is used with wildcards.

    2. A.

     LIKE only
    B.

     IN only
    C.

     NOT IN only
    D.

     IN and NOT IN

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Which of the following is the correct order of keywords for SQL SELECT statements?

    3. A.

     SELECT, FROM, WHERE
    B.

     FROM, WHERE, SELECT
    C.

     WHERE, FROM,SELECT
    D.

     SELECT,WHERE,FROM

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. A subquery in an SQL SELECT statement is enclosed in:

    4. A.

     braces -- {...}.
    B.

     CAPITAL LETTERS.
    C.

     parenthesis -- (...) .
    D.

     brackets -- [...].

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. The result of a SQL SELECT statement is a(n) ________ .

    5. A.

     report
    B.

     form
    C.

     file
    D.

     table

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Which of the following are the five built-in functions provided by SQL?

    6. A.

     COUNT, SUM, AVG, MAX, MIN
    B.

     SUM, AVG, MIN, MAX, MULT
    C.

     SUM, AVG, MULT, DIV, MIN
    D.

     SUM, AVG, MIN, MAX, NAME

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

    7. A.

     all columns of the table are to be returned.
    B.

     all records meeting the full criteria are to be returned.
    C.

     all records with even partial criteria met are to be returned.
    D.

     None of the above is correct.

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. The HAVING clause does which of the following?

    8. A.

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

     Acts like a 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. The SQL -92 wildcards are ____ and ____ .

    9. A.

     asterisk (*); percent sign (%)
    B.

     percent sign (%); underscore (_)
    C.

     underscore(_); question mark (?)
    D.

     question mark (?); asterisk (*)

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

    10. A.

     ONLY
    B.

     UNIQUE
    C.

     DISTINCT
    D.

     SINGLE

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. The benefits of a standard relational language include which of the following?

    11. A.

     Reduced training costs
    B.

     Increased dependence on a single vendor
    C.

     Applications are not needed
    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers