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

Question 1

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 2.0 PYQ

In the ANSI-SPARC three-schema architecture, mappings between the external and conceptual levels define:

A (A) How external views correspond directly to physical disk blocks and storage pages B (B) How conceptual records are mapped to physical storage blocks and indexes on disk C (C) How secondary indexes are physically partitioned across disk blocks D (D) More than one of the above E (E) None of the above

Question 2

MCQ · Single Correct 1 mark

Which module of a relational database management system is specifically responsible for translating high-level declarative SQL statements into an executable low-level access plan?

A (A) Buffer Manager B (B) Recovery Manager C (C) Query Processor (comprising parser, optimizer, and code generator) D (D) More than one of the above E (E) None of the above

Question 3

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 1.0 PYQ

The conceptual schema of a database is primarily designed using which of the following models?

A (A) Low-level operating system block layout B (B) Entity-Relationship (ER) model or Relational model C (C) Physical B-tree index representation model D (D) More than one of the above E (E) None of the above

Question 4

MCQ · Single Correct 1 mark

Which of the following database users interacts with the system solely by invoking pre-written application programs without writing SQL statements directly?

A (A) Naive or Parametric End Users B (B) Sophisticated Users C (C) Database Administrators (DBA) D (D) More than one of the above E (E) None of the above

Question 5

MCQ · Single Correct 1 mark

In a two-tier client-server DBMS architecture, application logic typically runs on the:

A (A) Client machine, which communicates directly with the database server using API drivers (like ODBC or JDBC) B (B) Intermediate application server exclusively C (C) Secondary storage disk controller D (D) More than one of the above E (E) None of the above