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

BPSC TRE – DBMS | Full Length Mock Test 1

Questions 11-15 of 100

0% completed (0/100 answered)

Question 11

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 2.0 PYQ

For designing a normal relational database, which of the following normal forms is generally considered practically adequate?

A (A) 3NF B (B) 2NF C (C) 4NF D (D) More than one of the above E (E) None of the above

Question 12

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 2.0 PYQ

What happens if a piece of data is stored in two places in the database?

A (A) Storage space is wasted and changing data in one spot can cause data inconsistency B (B) Changing the data in one spot will cause data inconsistency C (C) Storage space is wasted D (D) More than one of the above E (E) None of the above

Question 13

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 2.0 PYQ

Which data type can store unstructured or raw binary data such as byte strings in a column?

A (A) VARCHAR B (B) RAW / BLOB C (C) Numeric D (D) More than one of the above E (E) None of the above

Question 14

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 1.0 PYQ

Which SQL command will delete the structure as well as the content of a table named EMPLOYEE?

A (A) DELETE FROM EMPLOYEE; B (B) ERASE EMPLOYEE; C (C) DROP TABLE EMPLOYEE; D (D) More than one of the above E (E) None of the above

Question 15

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 1.0 PYQ

Which of the following is NOT an example of an application of a Database Management System?

A (A) Video Editing Rendering B (B) Result Management System C (C) Profile Management System D (D) More than one of the above E (E) None of the above