최신IBM Certified Database Administrator - IBM IMS - C2090-548무료샘플문제

A. You can only execute PL/SQL statements using the CLPPIus interface.

B. PL/SQL support is only enabled when using federation to access other vendor databases.

C. The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.

D. DB2 requires third party software to execute PL/SQL statements.

A. DB2 pureScale transfers log files from a primary database to a standby database.

B. In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.

C. HADR persists data in the cluster caching facilities (CFs).

D. In both DB2 pureScale and HADR environments data is available all the time.

A. Tables exist outside of the DB2 database with a single attribute called the table diagonal.

B. Tables are comprised of main attributes called platform and legs.

C. Tables are made up attributes called columns and rows.

D. Tables are comprised of 3 attributes in DB2. These are the top, the bottom, and the sides.

A. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.

B. DB2 Express is designed for development and testing. It is not used as a production database.

C. DB2 Express is fastest and most powerful DB2 edition.

D. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.

A. Automatic storage does not exist in DB2.

B. Automatic storage is a function of DB2 that allows for tables to be backed up automatically ona regularly scheduled basis.

C. Automatic storage is an option which is set when you create a DB2 database that allows fortransitions that are written to the database to be automatically committed.

D. Automatic storage simplifies storage management by allowing you to specify storage pathswhere the database manager can place tablespace data, and where the database managerallocates space for various uses.

A. The initial primary authorization ID is unchanged as the DB2 primary ID, and the SQL ID ismade equal to the DB2 primary ID, and one secondary ID exists and is the name passed byCICS or IMS.

B. The initial primary authorization ID is set to the same value as the first secondary ID.

C. The initial primary authorization ID remains the primary ID, the SQL ID is set equal to theRACF ID of the DB2 subsystem.

D. The initial primary authorization ID remains the primary ID, the SQL ID is set equal to theprimary ID, and the list of DB2 secondary IDs is set to the list of group names to which theRACF user ID is connected.

A. The SQL SELECT statement is used to return rows of data from your database table or tables.

B. The SQL SELECT statement is used to return the status of the health of the database in thehealth DB2 health center application.

C. The SQL SELECT statement is not used in DB2 because DB2 is a hierarchical database.

D. The SQL SELECT statement allows the DBA to create table structures and pre-populate thosetable structures with database metadata.

A. DB2 wizards are DBAs that are considered the top of their field in DB2.

B. DB2 wizards programs are automated in DB2. They run as background processes of thedatabase and they automatically configure database parameters.

C. DB2 wizards are programs that assist you in completing a single task by stepping you throughthe task.

D. DB2 does not have wizard functionality.

A. DB2 can only be installed from a command prompt using command-line entries.

B. DB2 must be installed on RAM drive on the server to speed up performance of the database.

C. DB2 can be installed using the DB2 installation wizard.

D. DB2 can only be purchased pre-installed on an IBM server. There is no need to ever installDB2.