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

Back to Parent Category
Create QuestionPDF  
.
Question: Relational calculus is a

Answer:Non- Procedural language.


Question: Which one of the following is provided by a data dictionary ?

Answer:Database structure data


Question: In an ER model, ……………. is described in the database by storing its data.

Answer:Entity


Question: To drop a column that is used as a foreign key, first

Answer:drop the foreign key constraint.


Question: NULL is

Answer:not a value


Question: How many copies of the database schema are typically used in the redesign process?

Answer:three


Question: DBMS helps achieve

Answer:both (A) and (B)


Question: SET concept is used in _________

Answer:Network Model


Question: The method of access which uses key transformation is known as _________

Answer:hash


Question: Union operator is a ____________

Answer:Binary Operator


Question: Changing cardinalities in a database is ____________

Answer:a common database design task.


Question: The data model that is produced from reverse engineering is _________

Answer:None of the above is correct


Question: The overall design of a database is called ____________

Answer:Scheme of the database


Question: Which of the following relational algebra operations do not require the participating tables to be union-compatible?

Answer:Join


Question: Transaction processing is associated with everything below except

Answer:confirming an action or triggering a response.


Question: In case of entity integrity, the primary key may be

Answer:not Null


Question: The _________ operator preserves unmatched rows of the relations being joined.

Answer:Outer join


Question: Data are ________ in client/server computing.

Answer:sent only upon the client's request


Question: The RDBMS terminology for a row is _________

Answer:tuple


Question: The ____________ is essentially used to search for patterns in target string.

Answer:Like predicate