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 .

In SQL, which command(s) is(are) used to redefine an index's future storage allocation

A) ALTER INDEX B) REDEFINE INDEX C) MODIFY INDEX D) DO INDEX 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 serious problem of file management systems?

A) difficult to update B) lack of data independence C) data redundancy D) program dependence E) All of the above

Discuss

Answer & Solution

Answer: Option E

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

With respect to data input, the most accurate description of batch control is

A) dividing documents to be entered into batches B) controlling the input of each input clerk C) comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system 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

The model for a _____ resembles the hierarchical model in many respects.

A) Network database B) Relational database C) Distributed database D) Hierarchical database E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

A set of programs that handle a firm's data base responsibilities is called a

A) Data Base Management System (DBMS) B) Data Base Processing System (DBPS) C) Data Management System (DMS) 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 any hierarchy of data organization, the smallest entity to be processed as a single unit is called

A) data field B) data record C) data file D) database E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

Long-range planning report produced in an MIS are primarily designed for

A) top management B) middle management C) lower management 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 model for a record management system might be

A) handwritten list B) a Rolodex card file C) a business form 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 designer of a form includes

A) filed designators B) prompts C) data D) both (a) and (b) E) None of the above

Discuss

Answer & Solution

Answer: Option D

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

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

A) report writer B) query language C) data manipulation language D) transaction log 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 6 7 8 9 10

Database Systems MCQ Questions & Answers | Computer Science