IBM Certification SQL Database 5

Question 1

In IBM Db2, which catalog view can you query to list all tables in the current database?

Accepted Answer

SYSCAT.TABLES

Answer

SYSCAT.TABLES is the Db2 system catalog view that contains metadata about every table in the database.

Question 2

What is the purpose of a database index?

Accepted Answer

Speed up data retrieval by creating a sorted pointer structure on columns

Answer

An index creates a sorted data structure on one or more columns so the database can find rows faster without scanning the entire table.

Question 3

Which SQL function returns the current date and time from the database server?

Accepted Answer

NOW() / CURRENT TIMESTAMP

Answer

In IBM Db2, CURRENT TIMESTAMP (ANSI standard) and NOW() return the current date and time from the server.

Question 4

What is a materialized view (also called a Materialized Query Table in Db2)?

Accepted Answer

A precomputed, physically stored result of a query that can be refreshed

Answer

A Materialized Query Table (MQT) in Db2 stores the query result physically on disk, improving query performance at the cost of storage and refresh overhead.

Question 5

Which SQL statement grants a user the privilege to read data from a table?

Accepted Answer

GRANT SELECT ON table TO user

Answer

The GRANT statement is used to give database privileges; GRANT SELECT ON tablename TO username provides read access.

IBM Certification Practice Test

IBM Certification Practice Test

IBM Certification SQL Database 5