Which of the following is true concerning a procedure?

Which of the following is true concerning the following statement: class Manager extends Employee

A

Manager is a concrete class and a superclass.

B

Manager is a concrete class and a subclass.

C

Manager is an abstract class and a superclass.

D

Manager is an abstract class and a subclass.

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.

Which of the following is true concerning QBE?

A

An official standard has been defined for QBE.

B

QBE cannot be used for client/server systems.

C

QBE does not give the programmer a visual programming environment.

D

Complete applications can be written using QBE.

Which of the following is true concerning a global transaction?

A

The required data are at one local site and the distributed DBMS routes requests as necessary.

B

The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.

C

The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.

D

The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

Which of the following is true concerning an ODBMS?

A

They have the ability to store complex data types on the Web.

B

They are overtaking RDBMS for all applications.

C

They are most useful for traditional, two-dimensional database table applications.

D

All of the above.

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

A

Both consist of procedural code.

B

Both have to be called to operate.

C

Both run automatically.

D

Both are stored in the database.

Which of the following is true concerning systems information in an RDBMS?

A

RDBMS store database definition information in system-created tables.

B

This information can be accessed using SQL.

C

This information often cannot be updated by a user.

D

All of the above.

Which of the following is true concerning a procedure?

Related Questions