单选题 If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?()
Rollback the transaction in both applications.
Rollback the transaction in one of the two applications.
Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.
Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
单选题 If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?()
COL1 will accept NULL values and can be referenced in another table's foreign key specification.
COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.
COL1 will not accept NULL values and can be referenced in another tables foreign key specification.
COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.
单选题 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?()
Define the column MAINID as NOT UPDATABLE
Define the column MAINID as a PRIMARY KEY
Define the column MAINID as a FOREIGN KEY
Define an UPDATE trigger on table TABLEX
单选题 Which of the following is the main feature of an OLTP application?()
Summarized queries
Granular transactions
Voluminous historical data
Heterogeneous data sources
单选题 Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?()
Application B will read the row.
Applications A and B will cause a deadlock situation.
Application B will wait until application A releases the Update lock.
Application A will be terminated so that application B can read the row.
单选题 Which of the following is a characteristic of a schema?()
Foreign key references cannot cross schema boundaries.
A DB2 user must be created before a schema with the same name can be created.
If no schema is specified when an object is created, the default schema PUBLIC is used.
A schema enables the creation of multiple objects in a database without encountering namespace collisions.
单选题 Which of the following is a typical data warehouse query?()
What is this customers address?
Does this customer have any unpaid bills?
What is the balance in this customers account?
What are the total sales for each of the last 6 months?
单选题 Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?()
The cursor is only protected from updates and deletes by concurrent applications.
The row is only protected from positioned updates and deletes that reference another cursor of the same application.
The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.
单选题 Which of the following is a characteristic of a sequence?()
A sequence will never generate duplicate values
The MAXVALUE of a sequence can be equal to the MINVALUE
It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero
When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries
单选题 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?()
DB2 for i5/OS
DB2 Runtime Client
DB2 Connect Enterprise Edition
DB2 for i5/OS SQL Development Kit
公文的发文闭合程序?
初始评审的目的是为职业安全健康管理体系建立和实施提供基础,为职业安全健康管理体系的持续改进( )。
患儿,8岁女婴。因腹泻3天,发热39℃,于10月13日入院。查体:精神可,无明显脱水征,咽红,大便呈蛋花汤样,脂肪球(+)。其引起腹泻的最可能病因是()
抗体是由下列哪种细胞产生的()
营业外收入是指企业发生的与其日常活动无直接关系的利得。
对于PowerPoint2003中文本框内的文字,设置项目符号可以采用的是()。
牵引装置的分类,可分为()。
足月新生儿,出生体重2.3kg,羊膜早破,生后2天拒奶,呕吐,发绀,黄疸进行性加重。体检:体温不升,前囟平,颈软,全身黄染,心率150次/分,心音及心率正常,腹软,肝肋下3cm。化验:白细胞20×109/L,中性粒细胞占80%,胆红素308μmol/L,血型“O”,母亲血型为“A”,最大可能是()
引起肾盂肾炎最常见的致病菌是( )。
女性患者,54岁,劳动中突感头晕,随即左半身无力,右眼闭合不全,双眼向左侧凝视,10分钟后昏迷。高热、双瞳孔小、四肢软瘫,应考虑的诊断是()