Bihar STET Computer Science – DBMS Practice Test-1

Questions 86-90 of 100

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

Question 86

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

Which SQL constraint ensures that a column automatically receives a specified value if no value is explicitly provided during INSERT?

Answers for question 86

Question 87

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

In SQL, which predicate tests whether a column value is NULL?

Answers for question 87

Question 88

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

Which SQL set operator combines query outputs and preserves duplicate rows?

Answers for question 88

Question 89

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

Which SQL clause restricts rows before GROUP BY aggregation occurs?

Answers for question 89

Question 90

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

A functionally dependent attribute set whose closure contains ALL attributes of relation R is a -

Answers for question 90
Scroll to Top