DBMS (Database) Quiz

Description: DBMS (Database) Quiz
Number of Questions: 10
Created by:
Tags: database dbms
Attempted 0/10 Correct 0 Score 0

What does the term DBMS stand for?

  1. Database Management Schema

  2. Database Management Style

  3. Database Management System

  4. Database Manipulation Schema

  5. Database Manipulation Style


Correct Option: C

The normalization process is:

  1. used to remove redundant data.

  2. used to make the storage of data more efficient.

  3. not recommended for most databases.

  4. Both a and b.

  5. All of the above.


Correct Option: D

Which clause is required in an SQL query for getting information from a database?

  1. JOIN

  2. ON

  3. ORDER BY

  4. SELECT

  5. WHERE


Correct Option: D

How many fields can be specified in the SELECT clause?

  1. 1

  2. 2

  3. 3

  4. As many as needed.


Correct Option: D

How many records are specified in the SELECT clause?

  1. 1

  2. 2

  3. 3

  4. As many as needed.


Correct Option: D

Which is the wildcard symbol for selecting all the fields in a table?

  1. @

  2. #

  3. ^

  4. *


Correct Option: D

The WHERE clause is used to restrict the number of ____ retrieved by an SQL statement.

  1. fields

  2. records

  3. tables

  4. Both a and b.

  5. All of the above.


Correct Option: B

Which is not a valid type of JOIN?

  1. LEFT JOIN

  2. MIDDLE JOIN

  3. RIGHT JOIN

  4. INNER JOIN

  5. All of the above are valid types.


Correct Option: B

The ORDER BY clause is used to sort:

  1. fields.

  2. records.

  3. tables.

  4. Both a and b.

  5. All of the above.


Correct Option: B
  1. Location

  2. Type

  3. Query

  4. All of the above


Correct Option: D
- Hide questions