©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
CS 430 Exam 5 Practice Questions and
Answers
A trigger is a procedure that is automatically invoked by the DBMS in response to a specified change to
the database. - Ans:✔✔-True
Recursion is not allowed in SQL. - Ans:✔✔-False
A special tool - called mdata - is used to support metadata retrieval such as querying about relations. -
Ans:✔✔-False
A database programmer must have access to a general-purpose programming for the following reasons:
- Ans:✔✔-- Non-declarative actions such as printing a report cannot be done within SQL.
- Not all queries can be expressed in SQL
A triggering event can be which of the following: - Ans:✔✔-- update
- delete
- insert
Page 1/6
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
rs.getString("name") and rs.getString(1) are equivalent if which of the following is true. - Ans:✔✔-name
is the first argument of the select result
Instead of executing a separate action in a trigger for each affected row, a single action can be executed
for all rows affected by a transaction. - Ans:✔✔-True
Which of the following are approaches to accessing DQL from a general-purpose language? - Ans:✔✔-- A
general purpose program can connect to a database server using a collection of functions.
- Embedded SQL
You can get the primary key of a relation by querying which of the following: - Ans:✔✔-Metadata
A trigger should not be used when loading data from a backup copy due to the risk of unintended
execution. - Ans:✔✔-True
JDBC is a Java API for communicating with database systems supporting SQL. - Ans:✔✔-True
By default, in JDBC each block of SQL statements (Start, end) is treated as a separate transaction that is
committed automatically. - Ans:✔✔-False
Identify the model for communicating with the database. - Ans:✔✔-- Execute queries using the
statement object.
- Open a connection
Page 2/6
FIRST PUBLISH OCTOBER 2024
CS 430 Exam 5 Practice Questions and
Answers
A trigger is a procedure that is automatically invoked by the DBMS in response to a specified change to
the database. - Ans:✔✔-True
Recursion is not allowed in SQL. - Ans:✔✔-False
A special tool - called mdata - is used to support metadata retrieval such as querying about relations. -
Ans:✔✔-False
A database programmer must have access to a general-purpose programming for the following reasons:
- Ans:✔✔-- Non-declarative actions such as printing a report cannot be done within SQL.
- Not all queries can be expressed in SQL
A triggering event can be which of the following: - Ans:✔✔-- update
- delete
- insert
Page 1/6
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
rs.getString("name") and rs.getString(1) are equivalent if which of the following is true. - Ans:✔✔-name
is the first argument of the select result
Instead of executing a separate action in a trigger for each affected row, a single action can be executed
for all rows affected by a transaction. - Ans:✔✔-True
Which of the following are approaches to accessing DQL from a general-purpose language? - Ans:✔✔-- A
general purpose program can connect to a database server using a collection of functions.
- Embedded SQL
You can get the primary key of a relation by querying which of the following: - Ans:✔✔-Metadata
A trigger should not be used when loading data from a backup copy due to the risk of unintended
execution. - Ans:✔✔-True
JDBC is a Java API for communicating with database systems supporting SQL. - Ans:✔✔-True
By default, in JDBC each block of SQL statements (Start, end) is treated as a separate transaction that is
committed automatically. - Ans:✔✔-False
Identify the model for communicating with the database. - Ans:✔✔-- Execute queries using the
statement object.
- Open a connection
Page 2/6
