Quiz  /  Sql Quiz Questions MCQ Quiz Questions and Answers

  • 1. 
    The primary key is selected from the

  • Composite keys
  • Candidate keys
  • Foreign keys
  • Determinants

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

  • DML
  • DDL
  • XML
  • HTML

  • 3. 
    In the _______ normal form, a composite attribute is converted to individual attributes.

  • 1
  • 2
  • 3
  • 4

  • 4. 
    The SQL keywords(s) _____ is used with wildcards.

  • LIKE only
  • IN only
  • NOTIN only
  • IN and NOT IN

  • 5. 
    SQL query and modification commands make up

  • DDL
  • DML
  • HTML
  • XML

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

  • File
  • Table
  • Report
  • Form

  • 7. 
    Second normal form should meet all the rules for

  • 1 NF
  • 2 NF
  • 3 NF
  • 4 NF

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

  • ADD
  • INSERT
  • CREATE
  • MAKE

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

  • SORTBY
  • ALIGNBY
  • ORDERBY
  • GROUPBY

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

  • QUERY
  • READ
  • SELECT
  • QUERY

  • 11. 
    Which normal form is considered adequate for relational database design?

  • 1 NF
  • 2 NF
  • 3 NF
  • 4 NF

  • 12. 
    SQL can be used to

  • Create database structures only
  • Modify database data only
  • All of the above can be done by SQL
  • Query database data only
Report Question
warning
access_time
  Time