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 is used to select distinct subject (SUB) from the table (BOOK)?

A) SELECT ALL FROM BOOK B) SELECT DISTINCT SUB FROM BOOK C) SELECT SUB FROM BOOK 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

The master list of an indexed file

A) is sorted in ascending order B) contains only a list of keys and record numbers C) has a number assigned to each record 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

Which of the following is not the responsibility of the utilities component of DBMS software?

A) creating the physical and logical designs B) removing flagged records for deletion C) creating and maintaining the data dictionary D) monitoring performance E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

In SQL, the CREATE TABLESPACE is used

A) to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace B) to create a database trigger C) to add/rename data files, to change storage 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

In SQL, which command is used to remove a stored function from the database?

A) REMOVE FUNCTION B) DELETE FUNCTION C) DROP FUNCTION D) ERASE FUNCTION E) None of the above

Discuss

Answer & Solution

Answer: Option C

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

The database administration function includes

A) application programming B) computer operations management C) database access planning 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

A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As

A) tables B) relations C) tuple 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 command that lets you change one or more fields in a record is

A) Insert B) Modify C) Look-up 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

1 2 3 4 5

Database Systems MCQ Questions & Answers | Computer Science