Bihar STET Computer Science – DBMS Practice Test-3

Questions 76-80 of 100

0% completed (0/100 answered)
Your score 0/100 0 answered
Correct 0 Incorrect 0 Unanswered 100 Accuracy 0%

Question 76

MCQ · Single Correct 1 mark
Previous Year Question Bihar STET C.S. 2024 (Shift-I) PYQ

What is the result of the CROSS JOIN (Cartesian Product) between Table A (5 rows) and Table B (4 rows)?

Answers for question 76

Question 77

MCQ · Single Correct 1 mark
Previous Year Question Bihar STET C.S. 18.09.2023 (Shift-I) PYQ

Which type of lock allows multiple transactions to read a database item simultaneously but prevents writes?

Answers for question 77

Question 78

MCQ · Single Correct 1 mark
Previous Year Question Bihar STET C.S. 18.09.2023 (Shift-I) PYQ

Which lock mode grants exclusive read and write access on a database item to a single transaction?

Answers for question 78

Question 79

MCQ · Single Correct 1 mark
Previous Year Question Bihar STET C.S. 18.09.2023 (Shift-II) PYQ

Which normal form requires that a table is in 1NF and contains no partial dependencies?

Answers for question 79

Question 80

MCQ · Single Correct 1 mark
Previous Year Question Bihar STET C.S. 2023 (Shift-I) PYQ

What constitutes a partial dependency in database normalization?

Answers for question 80
Scroll to Top