Monday, October 28, 2013

CHAPTER 3 (WORKING WITH DATABASE&DATABASE OBJECT) DB2 9 Exam 730 certification Dumps

Q.While attempting to connect to a database stored on an iSeries server from a Windows client, the following message was displayed:
SQL1013N The database alias name or database name "TEST_DB" could not be found.

Which of the following actions can be used to help determine why this message was displayed?
A. Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database
B. Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database
C. Execute the LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database
D. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database

Q.A database named TEST_DB resides on a z/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.20 and the TCP/IP host name is MYHOST. Which of the following commands is required to make this database accessible to a Linux client?
A. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;
B. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
C. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 446;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
D. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 446;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;


Q.Which of the following statements will catalog the database MYDB on the node MYNODE and assign it the alias MYNEWDB?
A. CATALOG DATABASE mynewdb AT NODE mynode
B. CATALOG DATABASE mynewdb AS mydb AT NODE mynode
C. CATALOG DATABASE mydb AT NODE mynode
D. CATALOG DATABASE mydb AS mynewdb AT NODE mynode

Q.Which of the following tools can NOT be used to catalog a database?
A. Control Center
B. SQL Assist
C. Configuration Assistant
D. Command Line Processor

Q.Which of the following tools can NOT be used to catalog a database?
A. Visual Explain
B. Alert Center
C. Journal
D. Configuration Assistant

Q.In which of the following scenarios would a stored procedure be beneficial?
A. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa
B. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables
C. An application running on a remote client needs to track every modification made to a table that contains sensitive data
D. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number

Q.CREATE TABLE orders
     (order_num      INTEGER NOT NULL,
       buyer_name    VARCHAR(35),
       amount        NUMERIC(5,2));

CREATE UNIQUE INDEX idx_orderno ON orders(order_num);
Which of the following describes the resulting behavior?
A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values
B. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order
C. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column
D. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column

Q.An alias can be an alternate name for which two of the following DB2 objects?
A. Sequence
B. Trigger
C. View
D. Schema
E. Table

Q.Which of the following events will NOT cause a trigger to be activated?
A. A select operation
B. An insert operation
C. An update operation
D. A delete operation

Q.If a view named V1 is created in such a way that it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?
A. View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do not acquire SALARY information
B. View V1 can be used as a data source for other views
C. View V1 does not have to reside in the same schema as the EMPLOYEE table
D. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1
 
Q.Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?
A. An alias named T1 that references table TABLE1
B. A view named T1 that references table TABLE1
C. A schema named T1 that references table TABLE1
D. An alias named T1 that references a view named V1 that references table TABLE1

Q.Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?
A. Sequence
B. Identity column
C. Trigger
D. Table function

Q.A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10
User USER1 successfully executes the following statements in the order shown:
VALUES NEXT VALUE FOR my_seq INTO :hvar;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
User USER2 successfully executes the following statements in the order shown:
ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
After users USER1 and USER2 are finished, user USER3 executes the following query:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
What value will be returned by the query?
A. 5
B. 10
C. 20
D. 30

Q.Given the following statements:
CREATE TABLE tab1 (c1 INTEGER, c2 CHAR(5));
CREATE VIEW view1 AS SELECT c1, c2 FROM tab1 WHERE c1 < 100;
CREATE VIEW view2 AS SELECT c1, c2 FROM view1
        WITH CASCADED CHECK OPTION;
Which of the following INSERT statements will fail to execute?
A. INSERT INTO view2 VALUES(50, 'abc')
B. INSERT INTO view1 VALUES (100, 'abc')
C. INSERT INTO view2 VALUES(150, 'abc')
D. INSERT INTO view1 VALUES(100, 'abc')

Q.Given the following statements:
CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));
CREATE TABLE t1audit (user VARCHAR(20), date DATE, action
VARCHAR(20));

CREATE TRIGGER trig1 AFTER INSERT ON t1
FOR EACH ROW
MODE DB2SQL
INSERT INTO t1audit VALUES (CURRENT USER, CURRENT DATE,
'Insert');
If user USER1 executes the following statements:
INSERT INTO t1 VALUES (1, 'abc');
INSERT INTO t1 (c1) VALUES (2);
UPDATE t1 SET c2 = 'ghi' WHERE c1 = 1;
How many new records will be written to the database?
A. 0
B. 2
C. 3
D. 4

Q.Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?
A. Each application that defines a DGTT has its own instance of the DGTT
B. Two different applications cannot create DGTTs that have the same name
C. DGTTs can only be used by the application that creates them, and only for the life of the application
D. Data stored in a DGTT can exist across transaction boundaries

Q.Which of the following is an accurate statement about packages?
A. Packages provide a logical grouping of database objects.
B. Packages contain control structures that are considered the bound form for SQL statements
C. Packages describe the objects in a DB2 database and their relationship to each other
D. Packages may be used during query optimization to improve the performance for a subset of SELECT queries

Q.Given the following information:
Protocol: TCP/IP
Port Number: 5000
Host Name: DB_SERVER
Database Name: TEST_DB
Database Server Platform: Linux
Which of the following will allow a client to access the database stored on the server?
A. CATALOG DATABASE test_db AS test_db REMOTE TCPIP SERVER db_server PORT 5000 OSTYPE LINUX;
B. CATALOG TCPIP NODE 5000 REMOTE SERVER db_server OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
C. CATALOG TCPIP NODE db_server REMOTE db_server SERVER 5000 OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

D. CATALOG TCPIP NODE db_server REMOTE db_server PORT 5000 OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

Q.A declared temporary table is used for which of the following purposes?
A. Backup purposes
B. Storing intermediate results
C. Staging area for load operations
D. Sharing result data sets between applications

Q.Which of the following DB2 objects is NOT considered executable using SQL?
A. Routine
B. Function
C. Procedure
D. Trigger

Q.Which of the following is NOT an accurate statement about views?
A. Views are publicly referenced names and no special authority or privilege is needed to use them.
B. Views can be used to restrict access to columns in a base table that contain sensitive data
C. Views can be used to store queries that multiple applications execute on a regular basis in a database
D. Views support INSTEAD OF triggers

Q.Which of the following SQL statements can be used to create a DB2 object to store numerical data as EURO data?
A. CREATE NICKNAME euro FOR DECIMAL (9,3)
B. CREATE ALIAS euro FOR DECIMAL (9,3)
C. CREATE DISTINCT TYPE euro AS DECIMAL (9,3)
D. CREATE DATA TYPE euro AS DECIMAL (9,3)




No comments:

Post a Comment