Database Systems MCQ Questions & Answers

Home

Competitive Exams MCQs

Aptitude English Verbal Reasoning Non Verbal Reasoning General Knowledge(GK) General Science(GS) Data Interpretation(DI) Banking Awareness Current Affairs

Computer Fundatmental MCQs

Computer Fundamentals Microsoft Word Microsoft Excel MS Power Point Tally Operating System Python AI(Artificial Intelligence)

Engineering Subjects MCQs

Computer Science Electronics & Communication Mechanical Engineering Civil Engineering Electrical Engineering

More Engineering MCQs

Chemical Engineering Automobile Engineering Biotechnology Mining Engineering Geological Engineering Metallurgical Engineering

Engineering Core

Engineering Mathematics Engineering Physics Engineering Chemistry

Computer Fundamentals MCQs

Computer Fundamentals Microsoft Word Microsoft Excel MS Power Point Tally Operating System Networking Database SQL MySQL

Programming MCQs

C Programming C++ Programming Java Python PHP JavaScript

Advanced Programming MCQs

Artificial Intelligence Machine Learning Data Science Cloud Computing Hadoop IoT

Graduation & PG

Commerce Management Law Agriculture Sociology Psychology Home Science Mass Communication Political Science Psychology

Resources

Current Affairs Interview Blog

Exam Categories

SSC Exams Railway Exams All Exams

SSC Exams

SSC CGL SSC CHSL SSC MTS SSC CPO SSC GD SSC JHT SSC Selection Post SSC Stenographer SSC JE

Railway Exams

RRB ALP RRB Technician RRB Section Controller RRB JE RRB Paramedical RRB Group D

Popular Exams

SSC CGL SSC CHSL SSC MTS RRB NTPC (Graduate) RRB Group D RRB ALP RRB Technician RRB Section Controller

Each section contains 100 MCQs on Database Systems .

Sort/report generators

A) are faster than index/report generators B) require more disk space than index/report generators C) do not need to sort before generating a report D) both (a) and (b) E) None of the above

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

The data dictionary tells the DBMS

A) what files are in the database B) what attribute are possessed by the data C) what these files contain D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

In SQL, which command(s) is(are) used to enable/disable a database trigger?

A) MODIFY USER B) CHANGE USER C) ALTER TRIGGER D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

If the record management system allows you to edit values before they are recorded on disk, you can

A) correct spelling changes before they are recorded B) change the name of a field C) change the width of a field D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

The relational model uses some unfamiliar terminology. A tuple is equivalent to a:

A) record B) field C) file D) data base E) data item

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

A) Bits B) Characters C) Data field D) Schema E) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

Which command is used to remove an index from the database in SQL?

A) DELETE INDEX B) DROP INDEX C) REMOVE INDEX D) ROLL BACK INDEX E) None of the above

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

An-owner-member set in the CODASYL specifications may have

A) only one owner but many owner occurrences B) only one member but many member occurrence C) more than one member but only one occurrence per member D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

A) Full media B) Graphics media C) Multimedia D) Hypertext E) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

A top-to-bottom relationship among the items in a database is established by a

A) Hierarchical schema B) Network schema C) Relational schema D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

1 2 3 4 5 6 7 8 9 10

Database Systems MCQ Questions & Answers | Computer Science