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

Back to Parent Category
Create QuestionPDF  
.
Question: To select all column from the table the syntax is ____________

Answer:select * from table_name


Question: Versatile report generator can provide ?

Answer:ALL


Question: When an E-R diagram is mapped to tables, the representation is redundant for ____________

Answer:weak relationship sets


Question: In E-R Diagram total participation is represented by

Answer:double lines


Question: It is possible to define a schema completely using

Answer:DDL and DML.


Question: Referential integrity controls relationships between _________

Answer:tables in a database


Question: ____________ joins are SQL server default

Answer:inner


Question: Which of the following is a technique for hiding the internal implementation details of an object?

Answer:Encapsulation


Question: The language used in application programs to request data from the DBMS is referred to as the ____________

Answer:DML


Question: Which of the following is true concerning Web services standards?

Answer:Important so that the web can flourish


Question: Which of the following is correct?

Answer:None of these


Question: ____________ allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.

Answer:Cursor


Question: Database redesign is not terribly difficult if the ____________

Answer:database has no data


Question: The normal form that is not necessarily dependency preserving is _________

Answer:2NF


Question: The benefits of object-oriented modeling are which of the following?

Answer:All of the above.


Question: Tree structures are used to store data in _________

Answer:Hierarchical model


Question: In SQL the word ‘natural’ can be used with

Answer:inner join


Question: The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is ____________

Answer:Procedural DML


Question: Common Gateway Interface (CGI) is which of the following?

Answer:An interface that accepts and returns data that may be written in any language that produces an executable file.


Question: The metadata is created by the _________

Answer:DDL interpreter