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, the _____ command is used to recompile a view

A) COMPILE VIEW B) DEFINE VIEW C) CREATE VIEW D) ALTER VIEW E) None of the above

Discuss

Answer & Solution

Answer: Option D

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

A list in alphabetical order

A) is in descending order B) is in ascending order C) is the result of a sort operation D) both (b) and (c) E) None of the above

Discuss

Answer & Solution

Answer: Option D

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

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

A) storage space is wasted B) changing the data is one spot will cause data inconsistency C) it can be more easily accessed 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

A data dictionary is a special file that contains

A) the names of all fields in all files B) the data types of all fields in all files C) the widths of all fields in all 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

A file that is organized in uniform format is formally referred to as a _____ or a database file.

A) Document B) Database C) Record D) Structured data file E) None of the above

Discuss

Answer & Solution

Answer: Option D

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

A form can be used to

A) modify records B) delete records C) format printed output 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

Which language has recently become the de-facto standard for interfacing application programs with relational database system?

A) Oracle B) SQL C) dBASE D) 4GL E) None of the above

Discuss

Answer & Solution

Answer: Option B

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

In SQL, the CREATE TABLE is used

A) to create a table, defining its columns, integrity constrains, and storage allocation B) to add a column/integrity constraint to a table C) to redefine a column D) to change a table's storage characteristics E) All 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 not true of the traditional approach to information processing?

A) There is common sharing of data among the various applications B) It is file-oriented C) Programs are dependent on the files D) It is inflexible E) All of the above are true

Discuss

Answer & Solution

Answer: Option A

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

Batch processing is appropriate if

A) a large computer system is available B) only a small computer system is available C) only a few transactions are involved D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option E

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

1 2 3 4 5

Database Systems MCQ Questions & Answers | Computer Science