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 is used to add a column/integrity constraint to a table

A) ADD COLUMN B) INSERT COLUMN C) MODIFY TABLE D) ALTER TABLE 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) ALTER TRIGGER B) ALTER DATABASE C) ALTER TABLE D) MODIFY TRIGGER E) All of the above

Discuss

Answer & Solution

Answer: Option A

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

In a relational schema, each tuple is divided into fields called

A) Relations B) Domains C) Queries 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

In SQL, which command is used to changes data in a table?

A) UPDATE B) INSERT C) BROWSE D) APPEND E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

What name is given to the collection of facts, items of information or data which are related in some way?

A) Database B) Directory information C) Information tree D) Information provider E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

In a large DBMS

A) each user can "see" only a small part of the entire database B) each user can access every sub¬schema C) each subschema contains every field in the logical 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

Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

A) COMPILE PROCEDURE B) ALTER PROCEDURE C) MODIFY PROCEDURE id) All of the above D) None 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

Internal auditors should review data system design before they are

A) developed B) implemented C) modified 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 _____ means that one record in a particular record type may be related to more than one record of another record type.

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 B

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

Which command(s) is(are) used to redefine a column of the table in SQL ?

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