Advanced Database System

Question 1

Identified at a compile time using preprocessor, which translates expressed in this into function calls.

Answer 1

Embedded SQL

Question 2

defines (API) that Java programs use that can connect to database servers

Answer 2

Java Database Connectivity

Question 3

A pre-complied SQL statement

Answer 3

PreparedStatement

Question 4

Allows program to construct a SQL query as a character string at run time

Answer 4

Dynamic SQL

Question 5

calculates the rank of a value in a group of values

Answer 5

Rank

Question 6

They prevent SQL injection attack

Answer 6

PreparedStatement

Question 7

a statement that the system executes automatically as a side effect of a modification to the database

Answer 7

Trigger

Question 8

defines an API that application can use to open a connection with a database, send queries and updates, and get back results

Answer 8

Open Database Connectivity (ODBC)

Question 9

allows you to write cross-tabulation queries which transpose rows into columns, aggregating data in the process of the transporting.

Answer 9

Pivot