DBMS MCQs Quiz Multiple Choice Questions & Answers

DBMS MCQs questions answers

Test Your Skills in DBMS Quiz Online

MCQ quiz on DBMS multiple choice questions and answers on DBMS MCQ questions quiz on DBMS objectives questions with answer test pdf.

DBMS Questions with Answers

1. _____________ function divides one numeric expression by another and returns theremainder.

2. Which of the operations constitute a basic set of operations for manipulating relational data?

3. Key to represent relationship between tables is called

4. Relational calculus is a

5. Transaction processing is associated with everything below except

6. Which of the following operation is used if we are interested in only certain columns of atable?

7. _________ data type can store unstructured data

8. In an E-R diagram attributes are represented by

9. In an E-R diagram an entity set is represent by a

10. A file manipulation command that extracts some of the records from a file is called

11. A data manipulation command the combines the records from one or more tables is called

12. Which of the following is a legal expression in SQL?

13. AS clause is used in SQL for

14. The users who use easy-to-use menu are called

15. It is better to use files than a DBMS when there are

16. An entity set that does not have sufficient attributes to form a primary key is a

17. A DBMS query language is designed to

18. The DBMS language component which can be embedded in a program is

19. Which one of the following statements is false?

20. A subschema expresses

21. A data dictionary is a special file that contains:

22. NULL is

23. Hierarchical model is also called

24. The RDBMS terminology for a row is

25. In a relational model, relations are termed as

26. Architecture of the database can be viewed as

27. What is a relationship called when it is maintained between two entities?

28. Cross Product is a:

29. Which of the following operations need the participating relations to be unon compatible?

30. To delete a particular column in a relation the command used is:

31. A report generator is used to

32. The database environment has all of the following components except:

33. Count function in SQL returns the number of

34. It is possible to define a schema completely using

35. _________ is a virtual table that draws its data from the result of an SQLSELECT statement.

36. Which one of the following is not true for a view:

37. A relational database developer refers to a record as

38. Which of the following is correct:

39. Cartesian product in relational algebra is

40. The result of the UNION operation between R1 and R2 is a relation that includes

41. The statement in SQL which allows to change the definition of a table is

42. A set of possible data values is called

43. Which of the following database object does not physically exist?

44. The ______ operator is used to compare a value to a list of literals values that have beenspecified.

45. The physical location of a record is determined by a mathematical formula that trAnsformsa file key into a record location is :

46. _______ produces the relation that has attributes of R1 and R2

47. The natural join is equal to :

48. Which of the following is a valid SQL type?

49. Which of the following is another name for weak entity?

50. The view of total database content is


Multiple Choice Questions and Answers on DBMS

DBMS Multiple Choice Questions and Answers

DBMS Trivia Quiz

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 ...