网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）
- A、View
- B、Alias
- C、Table
- D、Package
参考答案
更多 “Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）A、ViewB、AliasC、TableD、Package” 相关考题
考题
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?()
A.ViewB.AliasC.TableD.Package
考题
A stored procedure object is created into which DB2 object?()
A.AliasB.SchemaC.PackageD.Routine Space
考题
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
考题
Which ONE of the following statements about Domino Enterprise server is true？（）A、Can host Active Server Pages Web sitesB、Can host PHP Web sitesC、Includes a DB2 serverD、Includes an integrated Web application server
考题
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）A、Control CenterB、Development CenterC、Developer WorkbenchD、Stored Procedure Builder
考题
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
考题
When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）A、createB、importC、loadD、sqlimportE、update
考题
Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）A、DB2 for i5/OSB、DB2 Runtime ClientC、DB2 Connect Enterprise EditionD、DB2 for i5/OS SQL Development Kit
考题
Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?（）A、DB2 Express EditionB、DB2 Personal EditionC、DB2 Workgroup Server EditionD、DB2 Enterprise Server Edition
考题
A stored procedure object is created into which DB2 object?（）A、AliasB、SchemaC、PackageD、Routine Space
考题
Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?（）A、DB2 for z/OSB、DB2 Run-Time Client for z/OSC、DB2 Connect Enterprise Edition for z/OSD、z/OS Application Connectivity to DB2 for z/OS and OS/390
考题
Which of the following are all valid DB2 data types?（）A、LONG VARCHAR, SMALLINT, NUMBER, BLOBB、DECIMAL, DATE, DBCLOB, INTERVALC、NUMERIC, TIMESTAMP, BYTE, FLOATD、NUM, TIME, XML, DOUBLE
考题
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）A、DB2 will no longer allow updating the value of IDCOL1 in TABLE1.B、When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.C、When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.D、When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
考题
Which of the following describes the objects of a DB2 database and their relationships?（）A、InstanceB、Table spaceC、System catalogD、Schema repository
考题
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）A、TableB、ColumnsC、Table and AliasD、Columns and Alias
考题
Which of the following best describes how locks are used in DB2?（）A、To maintain control of updated rows for commit processingB、To ensure only committed changes are altered by another applicationC、To allow two applications to update the same row of data simultaneouslyD、To prevent multiple applications from accessing the same data simultaneously
考题
单选题Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）A
DB2 for i5/OSB
DB2 Runtime ClientC
DB2 Connect Enterprise EditionD
DB2 for i5/OS SQL Development Kit
考题
单选题Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?（）A
Design AdvisorB
Visual ExplainC
Performance AdvisorD
Configuration Assistant
考题
单选题Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?（）A
DB2 Express EditionB
DB2 Personal EditionC
DB2 Workgroup Server EditionD
DB2 Enterprise Server Edition
考题
单选题Which of the following best describes how locks are used in DB2?（）A
To maintain control of updated rows for commit processingB
To ensure only committed changes are altered by another applicationC
To allow two applications to update the same row of data simultaneouslyD
To prevent multiple applications from accessing the same data simultaneously
考题
单选题An Alias can be an alternate name for which DB2 object?（）A
SequenceB
TriggerC
SchemaD
View
考题
单选题Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）A
The next value will be 0 and the sequence will never use the values 101 to 105.B
The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.C
Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.D
The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
考题
单选题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
考题
多选题When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）AcreateBimportCloadDsqlimportEupdate
考题
单选题Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）A
DB2 will no longer allow updating the value of IDCOL1 in TABLE1.B
When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.C
When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.D
When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
热门标签
最新试卷