If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table
When using DB2 Connect, which of the following commands specifies the protocol information on how to connect to the host or to the server? A. CATALOG DCS B. CATALOG NODE C. CATALOG DATABASE D. CATALOG
Latest Answer: Catalog Node ...
Given the following transaction in an embedded SQL application: CREATE TABLE dwaine.mytab (col1 INT, col2 INT) INSERT INTO dwaine.mytab VALUES (1,2) INSERT INTO dwaine.mytab VALUES (4,3) ROLLBACK What
Latest Answer: Table itself is rolled back if it is included statement in the transaction ...
Given a read-only application that requires consistent data for every query, which isolation levels should it use to provide the most concurrency with other applications doing updates?
Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates?
Which of the following can duplicate the structure and related objects of a database table? A. Copy table B. Alter table C. Export table D. Generate DDL
Latest Answer: Generate DDL [using db2look utility] ...
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column?
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which of the following can limit read access to the phone_number column? A. Using a view to access the table B. Using
Which of the following DB2 components allows references to Oracle and DB2 databases in a single query? A. DB2 Query Patroller B. DB2 Warehouse Manager C. DB2 Relational Connect D. DB2 Connect Enterprise
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column?
Latest Answer: Bind the database to avoid the -805 error.The package was not bound or it was dropped. If attempting to run a DB2 utility or CLI application, the DB2 utilities may need to be rebound to the database.'%.pkgname' if the CURRENT PACKAGE PATH is set ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
