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

It stores data more efficiently than regular tables

Answer

It automatically indexes all referenced columns

Answer

It prevents any SQL injection by design

Question 2

A database VIEW is best described as:

Accepted Answer

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

Answer

A physical copy of a table stored on disk for fast access

Answer

A type of index that spans multiple tables

Answer

A database trigger that fires on SELECT statements

Question 3

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

Accepted Answer

READ COMMITTED

Answer

READ UNCOMMITTED

Answer

REPEATABLE READ

Answer

SERIALIZABLE

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

Optimizes SQL query execution plans automatically

Answer

Provides a caching layer in front of the database

Answer

Converts SQL schemas to NoSQL document formats

Question 5

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

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

UPDATE

Answer

INSERT

Question 6

When using a database connection pool, what happens when all connections in the pool are in use and a new request arrives?

Accepted Answer

The request waits in a queue until a connection becomes available

Answer

A new permanent connection is created immediately

Answer

The request is silently dropped without error

Answer

The pool automatically doubles its maximum size

Question 7

A correlated subquery differs from a regular subquery in that it:

Accepted Answer

References a column from the outer query and re-executes for each outer row

Answer

Returns multiple result sets instead of one

Answer

Can only be used in the SELECT clause

Answer

Always executes faster than a JOIN