Database Management System (DBMS)

A relational database consists of a collection of:

  • (A) Tables
  • (B) Fields
  • (C) Records
  • (D) Keys
Check Answer
  • (A) Tables

A ______ in a table represents a relationship among a set of values.

  • (A) Row
  • (B) Column
  •  (C) Entry
  • (D) Key
Check Answer
  • (B) Column

The Term______ is used to refer to a row:

  • (A) Attribute
  • (B) Tuple
  • (C) Field
  • (D) Instance
Check Answer
  • (C) Field

The term attribute refers to a ______ table.

  • (A) Record
  • (B) Column
  • (C) Tuple
  • (D) Key
Check Answer
  • (B) Column

For each attribute of a relation, there is a of permitted values, called the ______that attribute.

  • (A) Domain
  • (B) Relation
  • (C) Set
  • (D) Schema
Check Answer
  • (A) Domain

Which of the following is a tuple-generator dependency?

  • (A) Functional dependency
  • (B) Equality-generating dependencies
  • (C) Multi-valued dependencies
  • (D) Non-functional dependency
Check Answer
  • (C) Multi-valued dependencies

The main task carried out in the ________to remove repeating attributes to separate tables.

  • (A) First Normal Form
  • (B) Second Normal Form
  • (C) Third Normal Form
  • (D) Fourth Normal Form
Check Answer
  • (A) First Normal Form

Which of the normal form is based on m valued dependencies?

  • (A) First
  • (B) Second
  • (C) Third
  • (D) Fourth
Check Answer
  • (D) Fourth

Which forms has a relation that possesses data about an individual entity?

  • (A) 4NF
  • (B) 2NF
  • (C) 5NF
  • (D) 3NF
Check Answer
  • (A) 4NF

Which of the following has each related set has its own schema and there is an additional schema for the relationship set:

  • (A) A many-to-many relationship set
  • (B) A multi-valued attribute of an entity set
  • (C) A one-to-many relationship set
  • (D) Both A and B
Check Answer
  • (A) A many-to-many relationship set

1 2 ... 4NEXT »

You cannot copy content of this page

Scroll to Top