Database Management System - DBMS MCQs Quiz Multiple Choice Questions & Answers

Database Management System - DBMS MCQs questions answers


Test Your Skills in Database Management System - DBMS Quiz Online

Database Management System DBMS multiple choice questions and answers on DBMS MCQ questions quiz on DBMS objective type questions with answer for competitive exams and written test preparations for online DBMS quiz

Database Management System - DBMS Questions with Answers

1. If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ----------------- is needed

2. A relation is in this form if it is in BCNF and has no multivalued dependencies:

3. ……………..specifies a search condition for a group or an aggregate.

4. ……………..specifies a search condition for a group or an aggregate.

5. ………………….operator is basically a join followed by a project on the attributes of first relation.

6. FD stands for:

7. The different classes of relations created by the technique for preventing modification anomalies are called:

8. ……………… clause is an additional filter that is applied to the result.

9. In which model of database data is stored in tables:

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

11. ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

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

13. The data in the database at a particular moment in time is called a ………………

14. ACID properties of transactions are

15. If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.

16. An attribute is a(n):

17. Retrieval of data is done by using a………………

18. Which of the following is not a level of data abstraction?

19. In which ways two tables may be related:

20. A data dictionary is a repository that manages ………………

21. …………… database is used as template for all databases

22. The DBMS utility..................... allows reconstructing the correct state of database from the backup and history of transactions.

23. The DBMSutility,………………allows to reconstruct the correct state of database from the backup and history of transactions.

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

25. A ……………… does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.

26. Which is proper subset designed to support ‘views belonging to different classes of users in order to hid or protect information:

27. For some relations, changing the data can have undesirable consequences called:

28. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

29. Which is the process of breaking a relation into multiple relations:

30. …………… is used to determine whether of a table contains duplicate rows.

31. Which of the following is a Data Model?

32. The main interface that a naive user uses is a form interface using………………

33. In a ……………… lock, the DBMS will lock an entire disk page.

34. PJNF stands form:

35. …………….is the complex search criteria in the where clause.

36. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

37. DBMS is a collection of ………… that enables user to create and maintain a database.

38. Which of the following is not unary operation?

39. In a relational schema, each tuple is divided into fields called

40. Which of the following is Database Language?

41. When a program is abnormally terminated, the equivalent of a ……………… command occurs.

42. The method of access which uses key transformation is known as

43. Which rules are defined in relational models they from as an essential part of any relation database:

44. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

45. A top-to-bottom relationship among the items in a database is established by a

46. A functional dependency is a relationship between or among:

47. In RDBMS, Data is presented as a collection of ............

48. In RDBMS, Data is presented as a collection of............

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

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

Tags

Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Multiple Choice Questions and Answers

Database Management System - DBMS Trivia Quiz

Database Management System - DBMS Question and Answer PDF Online


Spreading Knowledge Across the World

United States, United Kingdom, India, Nigeria, Philippines, Pakistan, Nepal, Singapore, Indonesia, Bangladesh, Ghana, United Arab Emirates, Kenya, Canada, Malaysia, Australia, Iran, South Africa, Uganda, France, Ireland, Egypt, Tanzania, Ethiopia, Thailand, Sri Lanka, Cameroon, Hong Kong, Spain, Vietnam, New Zealand, Japan, Brazil, Saudi Arabia, Zambia, Czechia, Italy, Russia, Myanmar (Burma), Netherlands, Germany, Romania, Mexico, Rwanda, Sierra Leone, Turkey, Zimbabwe, Poland, Iraq, Cyprus, Algeria, Liberia, Greece, Jamaica, Malawi, Qatar, Portugal, South Korea, Argentina, Colombia, Morocco, Peru, Kuwait, Lithuania, Finland, Somalia, Israel, Bulgaria, Chile, Hungary, Trinidad & Tobago, Uzbekistan, Ukraine, Sweden, Kazakhstan, Norway, Macedonia, Benin, Switzerland, Oman, Botswana, Belgium, Ecuador, Slovakia, China, Croatia, Brunei, Serbia, Papua New Guinea, Bahrain, Guyana, Denmark, Lesotho, Lebanon, Jordan, Azerbaijan, Latvia, Cambodia, Namibia, Mauritius, Austria, Mongolia, Albania, Libya, Gambia, Taiwan, Bhutan, Venezuela, Dominican Republic, Tunisia, Luxembourg, Bosnia & Herzegovina, Guatemala, Solomon Islands, Guam, Costa Rica, Yemen, Bolivia, and many more ...