database mcq1

 Question: 1

In a large DBMS

(A) each user can access every sub schema

(B) each sub schema contains every field in the logical schema

(C) each user can “see” only a small part of the entire database

(D) all of these

Ans: C

each user can “see” only a small part of the entire database

Question: 2

A network schema

(A) stores data in tables

(B) restricts the structure to a one-to-many relationship

(C) permits many-to-many relationships

(D) none of these

Ans: C

permits many-to-many relationships

Question: 3

Administrative supervision of database activities is the responsibility of the

(A) DB manager

(B) DP manager

(C) VP-DP administration

(D) Database administrator

Ans: D

Database administrator

Question: 4

A file consists of

(A) Fields and records

(B) Records and sorts

(C) Fields and sorts

(D) Databases and fields

Ans: A

Fields and records

Question: 5

An entry in the telephone book can be compared to a

(A) Field

(B) Record

(C) File

(D) Database

Ans: B

Record

Question: 6

In a database, a network structure

(A) allows many-to-many relationship

(B) is a physical representation of the data

(C) allows only one-to-one relationship

(D) none of these

Ans: A

allows many-to-many relationship

Question: 7

Which of the following is at the highest level in the hierarchy of data organization?

(A) Database

(B) Data bank

(C) Data file

(D) Data record

Ans: A

Database

Question: 8

Which language is used by most of DBMSs for helping their users to access data?

(A) HLL

(B) Query language

(C) SQL

(D) 4 GL

Ans: B

Query language

Question: 9

The relational database management (RDBM) system manages data in more than one file at once. How does it organize these files?

(A) Relations

(B) Tables

(C) Tuples

(D) Both (a) and (b)

Ans: D

Both (a) and (b)

Question: 10

A table consists of

(A) Rows and cells

(B) Rows and columns

(C) Fields and columns

(D) None of these

Ans: B

Rows and columns

Question: 11

A command that lets you change one or more fields in a record is

(A) Look-up

(B) Insert

(C) Modify

(D) None of these

Ans: C

Modify

Question: 12

A database management system

(A) is a collection of programs for managing data in a single file

(B) can do more than a record management system

(C) allows simultaneous access to multiple file

(D) both (b) and (c)

Ans: D

both (b) and (c)

Question: 13

The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in a/an

(A) Sequential file

(B) Hashed file

(C) Indexed file

(D) B-tree file

Ans: B

Hashed file

Question: 14

Information can be transferred between DBMS and a

(A) Graphics program

(B) Word processor program

(C) Spreadsheet program

(D) All of these

Ans: D

All of these

Question: 15

The management information system (MIS) structure with one main computer system us called a

(A) Centralized MIS structure

(B) Decentralized MIS structure

(C) Distributed MIS structure

(D) Hierarchical MIS structure

Ans: A

Centralized MIS structure

 

Question: 16

A collection of interrelated files in a computer is a  _____

(A) Record

(B) Database

(C) Field

(D) File manager

Ans: B

Database

Question: 17

_____ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorized access of data.

(A) Tables

(B) DBMS

(C) Production passwords

(D) Database

Ans: B

DBMS

Question: 18

What does the data dictionary identify?

(A) Field formats

(B) Field types

(C) Field names

(D) All of the above

Ans: D

All of the above

Question: 19

Periodically adding, changing and deleting file records is called file

(A) Renewing

(B) Updating

(C) Upgrading

(D) Restructuring

Ans: B

Updating

Question: 20

The name of the location of a particular piece of data is its ____

(A) Memory name

(B) Data location

(C) Storage site

(D) Address

Ans: D

Address