Database Management System Set 3

Learning Mode Previous Next

On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 3

Q1 | How many types of keys in Database Design?

foreign key

all of the options

candidate key

primary key

Q2 | Which of the following is based on Multi Valued Dependency?

third

fourth

first

second

Q3 | Which of the following is the structure of the Database?

table

none of these

schema

relation

Q4 | The minimal set of super key is called

primary key

secondary key

foreign key

candidate key

Q5 | ______________ is a classical approach to database design?

bottom – up approach

top – down approach

left – right approach

right – left approach

Q6 | _____________ refers to the correctness and completeness of the data in a database?

data independence

data integrity

data security

data constraint

Q7 | A table that displays data redundancies yields ____________ anomalies

insertion

deletion

update

all of the options

Q8 | A lock that allows concurrent transactions to access different rows of the same table is known as a

row-level lock

database-level lock

field-level lock

table-level lock

Q9 | A type of query that is placed within a WHERE or HAVING clause of another query is called

multi-query

sub query

super query

master query

Q10 | A form defined

none of the options

where data is placed on the screen

the width of each field

both where data is placed on the screen and the width of each field

Q11 | If a piece of data is stored in two places in the database, then

in can be more easily accessed

both storage space is wasted and changing the data in one spot will cause data inconsistency

storage space is wasted

changing the data in one spot will cause data inconsistency

Q12 | Which of the following is a problem of file management system?

data redundancy and program dependence

all of the options

difficult to update

lack of data independence

Q13 | Which of the following is not an advantage of the database approach

elimination of data redundancy

ability of associate deleted data

increased security and program/data independence

all of the above

Q14 | An audit trail

none of the options

is the recorded history of operations performed on a file

is used to make backup copies

can be used to restore lost information

Q15 | One approach to standardization storing of data?

codasyl specification

none of the options

mis

structured programming

Q16 | Report generators are used to

store data input by a user

answer queries

both retrieve information from files and answer queries

retrieve information from files

Q17 | Which of the following is true of a network structure?

it will be dominant data base of the future

it allows a many-to-many relationship

it is a physical representation of the data

it is conceptually simple

Q18 | A record management system

can handle many files of information at a time

always uses a list as its model

both can handle many files of information at a time and always uses a list as its model

can be used to extract information stored in a computer file

Q19 | One data dictionery software package is called

db/dc dictionary

datapac

total

access

Q20 | The function of a database is ...

to check all input data

to output data

to collect and organize input data

to check all spelling

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

none of the options

modify

insert

lookup

Q22 | What is the language used by most of the DBMSs for helping their users to access data?

high level language

4gl

query language

sql

Q23 | Information can be transferred between the DBMS and a

spreadsheet program

word processor program

graphics program

all of the options

Q24 | The relational database environment has all of the following components except

users

database

query languages

separate files

Q25 | The ascending order of a data hirerchy is:

bit-byte-file-record-field-database

bit-byte-field-record-file-database

bit-byte-record-field-file-database

byte-bit-field-record-file-database

Previous Next