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 remove a table from the database in SQL?

A) DELETE TABLE B) DROP TABLE C) ERASE TABLE D) UNATTACH TABLE E) None of the above

Discuss

Answer & Solution

Answer: Option B

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

A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?

A) Specialized file B) Log file C) Master file D) Update file E) None of the above

Discuss

Answer & Solution

Answer: Option C

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

A file produced by a spreadsheet

A) is generally stored on disk in an ASCII text format B) can be used as it by the DBMS C) can be used for graphic 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 form defines

A) where data is placed on the screen B) the width of each field C) both (a) and (b) 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

Which of the following is true of a network structure?

A) It is a physical representation of the data B) It allows a many-to-many relationship C) It is conceptually simple D) It will be the dominant data base of the future 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, GRANT command is used to

A) allow user to access databases B) allow user to create databases C) grant system privileges, roles, and object privileges to uses and roles D) choose auditing for specific SQL commands E) None of the above

Discuss

Answer & Solution

Answer: Option C

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

The highest level in the hierarchy of data organization is called

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

Discuss

Answer & Solution

Answer: Option B

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

The logical data structure with a one-to-many relationship is a :

A) network B) tree C) chain D) relational E) None of the above

Discuss

Answer & Solution

Answer: Option B

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

Updating a database means

A) revising the file structure B) reorganizing the database C) modifying or adding record occurrences 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, which command(s) is(are) used to enable/disable all triggers on a table?

A) ALTER TRIGGERS B) ALTER TABLE C) MODIFY TRIGGERS IN TABLE 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 6 7 8 9 10

Database Systems MCQ Questions & Answers | Computer Science