Which of the following is an incorrect statement?

Select one:

a. Access plans for dynamic SQL statements are generated only at runtime.

b. Dynamic SQL applications are slower than static SQL applications.

c. The access plan generated for a static SQL statement is stored in advance.

d. If the static SQL part of the application is modified, then the regeneration of access plans is not needed.

Clear my choice

Question 22

Not yet answered

Marked out of 1.00

Flag question

Question text

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

Select one:

a. Equi-join

b. Natural join

c. Outer Join

d. Cartesian Join

Clear my choice

Question 23

Not yet answered

Marked out of 1.00

Flag question

Question text

tblProducts Table

ProductID	SupplierID	CategoryID	ProductName
1	1	1	Chai
2	1	1	Chang
3	1	2	Aniseed Syrup
4	2	2	Chef Anto's Cajun

Using the tblProducts Table shown above, which of the following SQL statements returns just the ProductID and ProductName of all the products whose CategoryID is either 2 or 3?

Select one:

a. Select ProductID, ProductName from tblProducts;

b. Select ProductID, ProductName from tblProducts Where CategoryID = 2 and CategoryID = 3;

c. Select ProductID, ProductName from tblProducts Where CategoryID <> 1;

d. Select ProductID, ProductName from tblProducts Where CategoryID = 2 or CategoryID = 3;

Clear my choice

Question 24

Not yet answered

Marked out of 1.00

Flag question

Question text

ODBC can be directly used with Java because it uses a C interface.

Select one:

True

False

Question 25

Not yet answered

Marked out of 1.00

Flag question

Question text

Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date, Primary Key (SUB_NO) );

The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following table contents cant be inserted to the EXAMS table (assume date format is correct)?

Select one:

a.

SUB_NO	STUDENT_NO	MARK	DATE_TAKEN
1	1
2	2	85

b.

SUB_NO	STUDENT_NO	MARK	DATE_TAKEN
1	1		05-23-2020
2	1	85	02-23-2020

c.

SUB_NO	STUDENT_NO	MARK	DATE_TAKEN
1	1		05-23-2020
1	2

d.

SUB_NO	STUDENT_NO	MARK	DATE_TAKEN
1	1
2	2