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 .

A _____ Contains fields of data about one entity.

A) Record B) File C) Fields D) Document E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

A condition that led to the development of databases was

A) a demand for more data to support information needs B) an increase in the amount of data handled by organizations C) the proliferation of data files 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

The _____ command is used to allocates an extent for the table in SQL

A) MODIFY ALLOCATES B) MODIFY TABLE C) ALTER TABLE D) REDEFINE TABLE E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

Embedded pointer provide

A) a secondary access path B) a physical record key C) an inverted index 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

Which of the following is a type of DBMS software?

A) database manipulation language B) query language C) utilities D) report writer E) All of the above

Discuss

Answer & Solution

Answer: Option A

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

Data items grouped together for storage purposes are called a

A) record B) title C) list D) string E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

The activity of a file

A) is a low percentages of number of records added or deleted from a file B) if high, reduces processing efficiency for sequential and nonsequential files C) is a measure of the percentage of existing records updated during a run D) refers to how closely the files fits into the allocated E) None of the above.

Discuss

Answer & Solution

Answer: Option A

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

Versatile report generators can provide

A) Columnar totals B) Subtotals C) Calculations 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

Related fields in a data base are grouped to form

A) data file B) data record C) menu D) bank E) None of the above

Discuss

Answer & Solution

Answer: Option B

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

A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.

A) One-to-one relationship B) One-to-many relationship C) Many-to-one relationship D) Many-to-many relationship E) None of the above

Discuss

Answer & Solution

Answer: Option D

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

1 2 3 4 5

Database Systems MCQ Questions & Answers | Computer Science