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(39264)

Back to Parent Category
Create QuestionPDF  
.
Question: Count function in SQL returns the number of ____________

Answer:values


Question: Which of the following is not a property of transactions?

Answer:Concurrency


Question: The drawback of shadow paging technique are

Answer:All of these


Question: Which of the following database object does not physically exist?

Answer:view


Question: A file manipulation command that extracts some of the records from a file is called ____________

Answer:SELECT


Question: A subschema expresses

Answer:the external view


Question: Which two files are used during operation of the DBMS?

Answer:Data dictionary and transaction log


Question: Which of the following statement is true concerning objects and/or classes?

Answer:An object is an instance of a class.


Question: The users who use easy-to-use menu are called ____________

Answer:Naïve users


Question: Manager salary details are hidden from the employee . This is

Answer:Conceptual level data hiding.


Question: A tool that can help designers understand the dependencies of database structures is a _________

Answer:dependency graph.


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

Answer:Domain


Question: A relational database developer refers to a record as ____________

Answer:a tuple


Question: In the architecture of a database system external level is the ____________

Answer:view level


Question: The rule that a value of a foreign key must appear as a value of some specific table is called a ____________

Answer:Referential constraint


Question: Which of the following is a comparison operator in SQL?

Answer:All of the above


Question: Which of the following operations need the participating relations to be union compatible?

Answer:All of the above


Question: What is data integrity?

Answer:It is the data contained in database that is accurate and consistent


Question: A data dictionary is a special file that contains _________

Answer:All of the above.


Question: An intrusion detection system does not perform which of the following?

Answer:May transmit message packets to the correct destination.