CPP Database Programming & SQL 2

Question 1

What is the primary benefit of using a stored procedure in a database application?

Accepted Answer

It encapsulates SQL logic on the server, reducing network traffic

Answer

Stored procedures reside on the database server, so complex SQL logic executes server-side, reducing the amount of data and round-trips over the network.

Question 2

A database VIEW is best described as:

Accepted Answer

A named, saved SQL query that behaves like a virtual table

Answer

A view is a stored query that presents data from one or more underlying tables as if it were a table itself, without storing the data redundantly.

Question 3

Which database isolation level prevents dirty reads but still allows non-repeatable reads?

Accepted Answer

READ COMMITTED

Answer

READ COMMITTED ensures a transaction only reads data that has been committed, preventing dirty reads, but another transaction can still modify and commit rows between reads within the same transaction.

Question 4

What does an ORM (Object-Relational Mapper) primarily accomplish in application development?

Accepted Answer

Maps database tables to programming language objects, eliminating manual SQL

Answer

An ORM bridges the gap between object-oriented code and relational databases by automatically translating between objects/classes and database rows/tables.

Question 5

Which SQL statement type is classified as DDL (Data Definition Language)?

Accepted Answer

CREATE TABLE

Answer

DDL statements define or modify database structure; CREATE TABLE creates a new table schema and is therefore DDL, whereas SELECT/INSERT/UPDATE are DML.

CPP - Certified Professional Programmer Practice Test

CPP - Certified Professional Programmer Practice Test

CPP Database Programming & SQL 2