网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which of the following DB2 data types has a fixed length?（）
- A、XML
- B、BLOB
- C、DOUBLE
- D、DBCLOB
参考答案
更多 “Which of the following DB2 data types has a fixed length?（）A、XMLB、BLOBC、DOUBLED、DBCLOB” 相关考题
考题
An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?()
A.GRAPHICB.BINARYC.IMAGED.BLOB
考题
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
考题
For which of the following is a data warehouse optimized?()
A.Backup and recoveryB.TransactionsC.SecurityD.Queries
考题
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 devices replicates and passes data to all devices connected to it?（）A、SwitchB、RouterC、BridgeD、Hub
考题
Which of the following is the BEST recovery method for a server that only aggregates report data and stores data on separate servers?（）A、FullB、Disk imagingC、IncrementalD、Tape backup
考题
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 used to connect existing Notes Forms to XPages？（）A、Data SourceB、Schema DefinitionC、Domino DocumentD、Data Binding
考题
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 commands should be run to verify that file system /data is not corrupted?（）A、fsck /dtaB、fsck datavgC、lqueryvg datavgD、stat /data
考题
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 system administrator is attempting to unmount filesystem /dev/data and receives the following message： umount： 0506-349 Cannot unmount /dev/data： The requested resource is busy. Which of the following commands can be used to determine which process has open references within the filesystem？（）A、lsfsB、topasC、fuserD、mount
考题
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 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 are all valid DB2 data types?（）A、LONG VARCHAR, SMALLINT, NUMBER, BLOBB、DECIMAL, DATE, DBCLOB, INTERVALC、NUMERIC, TIMESTAMP, BYTE, FLOATD、NUM, TIME, XML, DOUBLE
考题
An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?（）A、GRAPHICB、BINARYC、IMAGED、BLOB
考题
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 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
考题
单选题For which of the following is a data warehouse optimized?（）A
Backup and recoveryB
TransactionsC
SecurityD
Queries
考题
多选题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
热门标签
最新试卷