Which of the following statements is true concerning routines and triggers?

Which of the following is true concerning triggers?

A

You do not create them with SQL.

B

They execute against only some applications that access a database.

C

They have an event, condition, and action.

D

They cannot cascade (cause another trigger to fire).

Which of the following statements is true concerning subqueries?

A

Involves the use of an inner and outer query

B

Cannot return the same result as a query that is not a subquery

C

Does not start with the word SELECT

D

All of the mentioned

Which of the following statements concerning business rules is true?

A

It should be complex.

B

It should not be convertible to computer code.

C

It may include restrictions.

D

All of the Mentioned

Which of the following statements is true concerning JDBC?

A

It is language independent.

B

It is similar in concept to ODBC.

C

It is useful for all object-oriented languages.

D

It consists of three main layers.

Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?

A

Each vendor desiring to be ODBC-complaint provides an ODBC driver.

B

Requires certain criteria to be met in order to establish an ODBC connection.

C

Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.

D

All of the above.

Out of the following statements, concerning an electric field, which statement is not true?

A

The electric intensity is a vector quantity

B

The electric field intensity at a point is numerically equal to the force exerted upon a charge placed at that point

C

An electric field is defined as a point in space at which an electric charge would experience a force

D

Unit field intensity in the exertion of a force of one newton on a charge of one coulomb

The following statements are true concerning gastric carcinoma

A

It can metastasis to the ovaries

B

It is twice as common in females as in males

C

It is linked to patients with type 'O' blood group

D

It often presents with a major gastrointestinal haemorrhage

E

It is sited mainly on the lesser curvature of the stomach

Which of the following attribute triggers event after the document is printed?

A

offlineprint

B

onprint

C

onafterprint

D

onbeforeprint

Which prefixes are available to Oracle triggers?

A

: new only

B

: old only

C

Both :new and : old

D

Neither :new nor : old

Which of the three possible types of triggers does SQL Server support?

A

INSTEAD OF only

B

AFTER only

C

BEFORE only

D

INSTEAD OF and AFTER only

Which of the following statements is true concerning routines and triggers?

Related Questions