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: ......... is critical in formulating database design.

Answer:functional dependency


Question: A primary key if combined with a foreign key creates

Answer:Parent-Child relationship between the tables that connect them


Question: A ............. represents the number of entities to which another entity can be associated

Answer:mapping cardinality


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

Answer:Data dictionary and transaction log


Question: The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….

Answer:Relations


Question: ……………….. contains information that defines valid values that are stored in a column or data type.

Answer:Index


Question: Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values


Answer:Both of them


Question: ………………. First proposed the process of normalization.

Answer:Edgar F. Codd


Question: For using a specific database …………… command is used.

Answer:use database


Question: Which of the following is not comparison operator?

Answer:=<


Question: An outstanding functionality of SQL is its support for automatic ………… to the target data.

Answer:navigation


Question: ……………..specifies a search condition for a group or an aggregate.

Answer:HAVING Clause


Question: ............... joins are SQL server default

Answer:Inner


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

Answer:Like Predicate


Question: Which of the following is/are the Database server functions?
i) Data management ii) Transaction management
iii) Compile queries iv) Query optimization


Answer:i, ii, and iv only


Question: To delete a database ................... command is used

Answer:drop database database_name


Question: .............. is a combination of two of more attributes used as a primary key

Answer:Composite Key


Question: Which of the following is not the function of client?

Answer:Query optimization


Question: ............. is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.

Answer:Trigger


Question: ................. requires that data should be made available to only authorized users.

Answer:Security