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、View
  • B、Alias
  • C、Table
  • D、Package

相关考题:

Which of the following DB2 data types has a fixed length?() A.XMLB.BLOBC.DOUBLED.DBCLOB

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 DB2 data types has a fixed length?()A、XMLB、BLOBC、DOUBLED、DBCLOB

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?()ADB2 for i5/OSBDB2 Runtime ClientCDB2 Connect Enterprise EditionDDB2 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?()ADesign AdvisorBVisual ExplainCPerformance AdvisorDConfiguration Assistant

单选题Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?()ADB2 Express EditionBDB2 Personal EditionCDB2 Workgroup Server EditionDDB2 Enterprise Server Edition

单选题Which of the following best describes how locks are used in DB2?()ATo maintain control of updated rows for commit processingBTo ensure only committed changes are altered by another applicationCTo allow two applications to update the same row of data simultaneouslyDTo prevent multiple applications from accessing the same data simultaneously

单选题An Alias can be an alternate name for which DB2 object?()ASequenceBTriggerCSchemaDView

单选题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?()AThe next value will be 0 and the sequence will never use the values 101 to 105.BThe next value will be 101 to ensure uniqueness between existing and newly generated sequence values.CPreviously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.DThe 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?()ADB2 Express EditionBDB2 Personal EditionCDB2 Workgroup Server EditionDDB2 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?()ADB2 will no longer allow updating the value of IDCOL1 in TABLE1.BWhen inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.CWhen inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.DWhen a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.