get the app get the app       get the app       get the app

Database Managment System QUESTIONS

Exam NameDatabase Managment System QUESTIONS
DescriptionDatabase Managment System QUESTIONS and Answers exams contains the questions from various competitive exams.These questions are the part of previous year paper.These kind of questions would be helpful in preparing for exams like IAS, PCS, UPSC, NDA, CDS SSC, RRB, PSC, IBPS
Exam TypeMASTER EXAM
Authenticity9999
creatorAnirudh(39272)

Back to Parent Category
Create QuestionPDF  
.
Question: Some of the utilities of DBMS are .............
i) Loading ii) Backup iii) File organization iv) Process Organization


Answer:i, ii and iii only


Question: Processed data is called ………………..

Answer:Information


Question: …………….. is a utility to capture a continuous record of server activity and provide auditing capability.

Answer:SQL server service manager


Question: Data items grouped together for storage purposes are called a

Answer:record


Question: …………. contains data assisting day to day activities of the organization.

Answer:Operational database


Question: ………………… approach reduces time and effort required for design and lesser risk in database management.

Answer:Multiple databases


Question: HSAM stands for ……….

Answer:Hierarchic Sequential Access Method


Question: SQL server stores index information in the ………… system table

Answer:sys indexes


Question: The one guideline to be followed while designing the database is

Answer:It should avoid/reduce the redundancy.


Question: Which of the following is not a logical database structure?

Answer:Chain


Question: Reflexivity property says that X - Y is true if Y is ………………….

Answer:Subset of X


Question: Anything that affects the database schema is a part of

Answer:DDL


Question: An instance of a relation is a time varying set of ………………….

Answer:Both of them


Question: In the ………………… mode any record in the file can be accessed at random

Answer:Random access


Question: Which can be used to delete all the rows if a table?

Answer:Delete * from table_name


Question: Which if the following is not the type of data integrity.

Answer:Key integrity


Question: 4NF stands for ..

Answer:Fourth Normal Form


Question: A ……………… allows to make copies of the database periodically to help in the cases of crashes & disasters.

Answer:Backup Utility


Question: ………………. Allows definitions and query language statements to be entered; query results are formatted and displayed.

Answer:Terminal Interface


Question: ............................ is the powerful language for working with RDBMS.

Answer:Query Language