Database Management System Question Bank - 2

Question: 6

The most popular commercial DBMS is

(A) Oracle

(B) MySQL

(C) Microsoft Access

(D) Microsoft SQL Server

Question: 7

Which of the following is a set of one or more attributes taken collectively to uniquely identify a record?

(A) Foreign key

(B) Super key

(C) Sub key

(D) Candidate key

Question: 8

A _____ consists of a collection of interrelated data and a collection of programs to access that data.

(A) DBA

(B) DBMS

(C) Schema

(D) Database

Question: 9

The ____ provides a set of operations that take one or more relations as input and return a relation as an output.

(A) Relation flow

(B) Scheme diagram

(C) Relational algebra

(D) Schematic representation

Question: 10

The feature that database allows to access only certain records in database is

(A) Tables

(B) Reports

(C) Forms

(D) Query