Alien head

DBMS (Database) Quiz

Description: DBMS (Database) Quiz
Number of Questions: 10
Created by:
Tags: database dbms

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

Answer: 3

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.

Answer: 4

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

Answer: 4

How many fields can be specified in the SELECT clause?

  1. 1

  2. 2

  3. 3

  4. As many as needed.

Answer: 4

How many records are specified in the SELECT clause?

  1. 1

  2. 2

  3. 3

  4. As many as needed.

Answer: 4

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

  1. @

  2. #

  3. ^

  4. *

Answer: 4

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.

Answer: 2

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.

Answer: 2

The ORDER BY clause is used to sort:

  1. fields.

  2. records.

  3. tables.

  4. Both a and b.

  5. All of the above.

Answer: 2

Which property of the database must the connection object contain?

  1. Location

  2. Type

  3. Query

  4. All of the above

Answer: 4
+ View questions