logo

CuriousTab

CuriousTab

Discussion


Home Database Introduction to SQL Comments

  • Question
  • SQL can be used to:


  • Options
  • A. create database structures only.
  • B. query database data only.
  • C. modify database data only.
  • D. All of the above can be done by SQL.

  • Correct Answer
  • All of the above can be done by SQL. 


  • Introduction to SQL problems


    Search Results


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

    • Options
    • A. SORT BY
    • B. ALIGN BY
    • C. ORDER BY
    • D. GROUP BY
    • Discuss
    • 2. You can add a row using SQL in a database with which of the following?

    • Options
    • A. ADD
    • B. CREATE
    • C. INSERT
    • D. MAKE
    • Discuss
    • 3. The SQL WHERE clause:

    • Options
    • 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.
    • Discuss
    • 4. ________ was adopted as a national standard by ANSI in 1992.

    • Options
    • A. Oracle
    • B. SQL
    • C. Microsoft Access
    • D. DBase
    • Discuss
    • 5. The command to remove rows from a table 'CUSTOMER' is:

    • Options
    • A. REMOVE FROM CUSTOMER ...
    • B. DROP FROM CUSTOMER ...
    • C. DELETE FROM CUSTOMER WHERE ...
    • D. UPDATE FROM CUSTOMER ...
    • Discuss
    • 6. The SQL statement that queries or reads data from a table is ________ .

    • Options
    • A. SELECT
    • B. READ
    • C. QUERY
    • D. None of the above is correct.
    • Discuss
    • 7. Which of the following is the original purpose of SQL?

    • Options
    • 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.
    • Discuss
    • 8. Read-only databases are ________ updated.

    • Options
    • A. always
    • B. commonly
    • C. seldom
    • D. never
    • Discuss
    • 9. Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?

    • Options
    • A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
    • B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
    • C. Three rows have the values Brown, NULL, and Blue in the same column.
    • D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
    • Discuss
    • 10. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.

    • Options
    • A. advantage
    • B. disadvantage
    • C. either an advantage or disadvantage
    • D. neither an advantage nor disadvantage
    • Discuss


    Comments

    There are no comments.

Enter a new Comment