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 .

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

A) DEFINE TABLE B) MODIFY TABLE C) ALTER TABLE 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

In SQL, the ALTER TABLESPACE command is used

A) to add/rename data files B) to change storage characteristics C) to take a tablespace online/offline D) to begin/end a backup E) All of the above

Discuss

Answer & Solution

Answer: Option E

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

The language used in application programs to request data from the DBMS is referred to as the

A) DML B) DDL C) query language 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

A database management system might consist of application programs and a software package called

A) FORTRAN B) AUTOFLOW C) BPL D) TOTAL E) None of the above

Discuss

Answer & Solution

Answer: Option C

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

An audit trail

A) is used to make back-up copies B) is the recorded history of operations performed on a file C) can be used to restore lost information D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option B

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

A race condition occurs when

A) Two concurrent activities interact to cause a processing error B) two users of the DBMS are interacting with different files at the same time C) both (a) and (b) 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

An indexing operation

A) sorts a file using a single key B) sorts file using two keys C) establishes an index for a file D) both (b) and (c) E) None of the above

Discuss

Answer & Solution

Answer: Option C

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

The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a

A) forecasting report B) exception report C) regularly scheduled report D) on demand report 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 create a synonym for a schema object?

A) CREATE SCHEMA B) CREATE SYNONYM C) CREATE SAME D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option B

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

If you want your database to include methods, you should use a _____ database.

A) Network B) Distributed C) Hierarchical D) Object-Oriented 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