BPSC TRE – DBMS | Full Length Mock Test 2 ⋆ CSE Study247

BPSC TRE – DBMS | Full Length Mock Test 2

Questions 31-35 of 100

0% completed (0/100 answered)

Question 31

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 1.0 PYQ

In SQL, what is the effect of executing: DELETE FROM Student; without a WHERE clause?

A (A) An error is raised because DELETE requires a mandatory WHERE clause B (B) All records in the Student table are removed, but the table structure and its constraints remain intact C (C) The table definition is completely dropped from the database catalog D (D) More than one of the above E (E) None of the above

Question 32

MCQ · Single Correct 1 mark

Which of the following SQL constraints ensures that a column cannot accept duplicate values, but can accept multiple NULLs (in standard SQL)?

A (A) PRIMARY KEY B (B) CHECK C (C) UNIQUE D (D) More than one of the above E (E) None of the above

Question 33

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 3.0 PYQ

Which SQL clause is used to filter aggregated group records produced by a GROUP BY clause?

A (A) ORDER BY B (B) GROUP BY C (C) WHERE D (D) More than one of the above E (E) None of the above

Question 34

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 2.0 PYQ

In SQL, what is the output of the query: SELECT 10 + NULL; ?

A (A) 10 B (B) 0 C (C) NULL D (D) More than one of the above E (E) None of the above

Question 35

MCQ · Single Correct 1 mark

Which SQL function replaces a NULL value with a specified replacement value?

A (A) COALESCE() B (B) IFNULL() (in MySQL) C (C) NVL() (in Oracle) D (D) More than one of the above E (E) None of the above