当前分类： IBM(000-730)
问题：单选题Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL CLERK 3 If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1（）A 0B 1C 3D 6...
查看答案
问题：单选题Which of the following describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository...
问题：单选题Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）A Visual ExplainB Activity MonitorC SQL Performance MonitorD DB2 Performance Monitor...
问题：单选题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）A REVOKE DROP ON t1 FROM PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DEL...
问题：单选题Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）A Define the column MAINID as NOT UPDATABLEB Define the column MAINID as a PRIMARY KEYC Define the column ...
问题：单选题Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）A CLOBB BLOBC HierarchicallyD Rows and columns...
问题：单选题Given the following function: CREATE FUNCTION emplist （ ） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END ...
问题：单选题To which of the following resources can a lock be applied?（）A RowB AliasC BitmapD Column...
问题：单选题Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and t...
问题：单选题Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）A SELECT * FROM T1 MINUS SELECT * FROM T2B SELEC...
问题：单选题A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?（）A User ID/password fileB Communications layerC Client applicationsD Operating system...
问题：单选题Which of the following supports the XML data type?（）A A unique indexB A composite indexC A check constraintD A generated column...
问题：单选题A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so ...
问题：单选题Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）A SELECT * FROM t1 UNION SELECT * FROM t2B SELECT ...
问题：单选题Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?（）A DB2 Express EditionB DB2 Personal EditionC DB2 Workgroup Server EditionD DB2 Enterprise Server Edition...
问题：单选题On which of the following database objects may the SELECT privilege be controlled?（）A SequenceB SchemaC GroupD View...
问题：单选题Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）A MQTB TriggerC Read Only CursorD Stored Procedure...
问题：单选题Which of the following strings can be inserted into an XML column using XMLPARSE?（）A employee/B ?xml version='1.0' encoding='UTF-8' ?C !DOCTYPE hello SYSTEM 'hello_world.dtd'D x xmlns:ibmcert='http://www.ibm.com/certify'...
