Database Management System (DBMS) MCQs with answers Page - 146

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Given the following relation Student (roll no, name, course no, course max. marks, year of study, address) The corresponding 3 NF relations are

  • (A) student (roll no, name, year of study, address) course (course no, course max. marks)
  • (B) student ( roll no, name, year of study, address) student (roll no, course no) course (course no, course max. marks)
  • (C) student (roll no , name, address) year (roll no, year of study) course (course no, course max. marks)
  • (D) student (roll no, name, address) course (course no, course max. marks, year of study)

A

Admin • 833.24K Points
Coach

Q. BoyeCodd Normal Form (BCNF) is needed when

  • (A) two non-key attributes are dependent
  • (B) there is more then one possible composite key
  • (C) there are two or more possible composite overlapping keys and one attributeof a composite key is dependent on an attribute of another composite key
  • (D) there are two possible keys and they are dependent on one another

A

Admin • 833.24K Points
Coach

Q. A relation is said to be in BCNF when

  • (A) it has overlapping composite keys
  • (B) it has no composite keys
  • (C) it has no multivalued dependencies
  • (D) it has no overlapping composite keys which have related attributes

A

Admin • 833.24K Points
Coach

Q. A 3 NF relation is converted to BCNF by

  • (A) removing composite keys
  • (B) removing multivalued dependencies
  • (C) dependent attributes of overlapping composite keys are put in a separateRelation
  • (D) dependent non-key attributes are put in a separate table

A

Admin • 833.24K Points
Coach

Q. BCNF is needed because

  • (A) otherwise tuples may be duplicated
  • (B) when a data is deleted tuples may be lost
  • (C) updating is otherwise difficult
  • (D) when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples

A

Admin • 833.24K Points
Coach

Q. Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation

  • (A) i and ii
  • (B) ii and iii
  • (C) i and iv
  • (D) i and iii

A

Admin • 833.24K Points
Coach

Q. A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are

  • (A) Prof_Project (professor, st_name, dept) Proj_stud (project, student no.)
  • (B) Prof_stud (professor, student no) Proj_stud (project, student no)
  • (C) Student (student no, st_name, dept) Student (student no, st_name, dept)
  • (D) Professor(professor, project) Professor( professor, project, dept) Student (student no, st_name, dept)

A

Admin • 833.24K Points
Coach

Q. A 3 NF relation is split into 4 NF

  • (A) by removing overlapping composite keys
  • (B) by splitting into relations which do not have more than one independent multi valued dependency
  • (C) removing multivalued dependency
  • (D) by putting dependent non-key attribute in a separate table

A

Admin • 833.24K Points
Coach

Q. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

  • (A) The multivalue, multicolumn problem
  • (B) The inconsistent values problem
  • (C) The missing values problem
  • (D) The general-purpose remarks column problem

A

Admin • 833.24K Points
Coach

Q. What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

  • (A) ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
  • (B) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
  • (C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
  • (D) None of the above is correct.

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.