-
A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?()
A . Any row inserted or updated through view V1 must meet the condition that col4 > 1000.
B . From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked.
C . At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected.
D . Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.
-
A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?()
A . When view V1 is created
B . Each time the REFRESH VIEW v1 statement is executed
C . Each time an SQL statement is executed against view V1
D . Only the first time an SQL statement is executed against view V1
-
Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?()
A . Tracking the most recent read time for a table segment in a user tablespace
B . Tracking the most recent write time for a table segment in a user tablespace
C . Tracking insert time by row for table rows
D . Tracking the most recent write time for a table block
E . Tracking the most recent read time for a table segment in the SYSAUX tablespace
F . Tracking the most recent write time for a table segment in the SYSAUX tablespace
-
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?()
A . Use the DROP DATAFILE command.
B . Use the DROP TABLESPACE command.
C . Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
D . Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
-
When a critical error occurs, which module in Enterprise Manager will automatically collect diagnostics data from WebLogic Server?()
A . Reports
B . Compliance
C . Support Workbench
D . Asset Discovery
E . visual creation of JDBC DataSource object to Oracle RAC
-
Col质粒
-
You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?()
A . DEFAULT STORAGE
B . EXTENT MANAGEMENT
C . AUTOEXTEND
D . DATAFILE
-
龈谷gingival col
-
英译中:Automatic Data Collection
-
对于表A(col1 int,col2 char(1)),表B(col1 int,col2char(1)),为确保表A的数据全部被保留,下面正确的联接方式是()
A . A inner join B
B . A left join B
C . A right join B
D . Across join B
-
英译中:Automatic data collection(ADC)
-
对于表A(col1 int,col2 char(1))更新col1=1的数据col2值为N,下面语句正确的是()
A . update table A setcol2=’N’ where col1=1
B . modify table A setcol2=N where col1=1
C . update A set col2=’N’ where col1=1
D . modify A set col2=N where col1=1
-
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?()
A . Create and populate a SQL Tuning Set from the AWR on every Monday.
B . Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
C . Create a repeating baseline template.
D . Insert a finding directive for future ADDM tasks.
-
Automatic data conversion will occur if which of the following happens?()
A . The client and server have different NLS_LANGUAGE settings.
B . The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
C . The client and server are in different time zones.
D . The client requests automatic data conversion.
E . The AUTO_CONVERT initialization parameter is set to TRUE.
-
Given two collection objects referenced by col1 and col2,which of these statements are true?()
A . The operation col1.retainAll(col2) will not modify the col1 object.
B . The operation col1.removeAll(col2) will not modify the col2 object.
C . The operation col1.addAll(col2) will return a new collection object, containing elements from both col1 and col2.
D . The operation col1.containsAll(Col2) will not modify the col1 object.
-
Periodic checks are automatically performed to insure that the entire system is operating correctly and that no failures have occurred, unnoticed, that would affect the count data.
-
设:有一个表T1,分别由以下字段组成:col1(NUMBER),col2(DATE),col3(VACHAR2),以下insert语句合法的是哪两项?()
A.insertintoT1(col1,col2,col3)values(568,'2-3月-2009','HUNTER')
B.insertintoT1values(568,'2-3月-2009','HUNTER')
C.insertintoT1(col1,col2,col3)values(568,2-3月-2009,'HUNTER')
D.insertintoT1(col1,col2,col3)values('568','2-3月-2009',HUNTER)
-
<franeset 框架集cols 列=>是用来指定()。
A.混合分框
B.纵向分框
C.横向分框
D.任意分框
-
The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TA
The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, ‘a‘), (1, ‘b‘), (2,‘c‘); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;()
A.4
B.3
C.1
D.0
-
.col-sm-3代表的含义是()
A.布局了一个在小型设备中占3个单位宽度的栅格。
B.布局了一个在中型设备中占3个单位宽度的栅格。
C.布局了一个在大型设备中占3个单位宽度的栅格。
D.布局了一个在大型设备中占5个单位宽度的栅格。
-
<frameset cols=>,.表示()
A.框架的行高
B.框架的行数
C.框架的列高
D.框架的列数
-
Bootstrap布局中,col-md-*定义的是()。
A.中型显示设备(≥992px且<1200px)下显示的
B.超小设备手机(<768px)下显示的
C.大型显示尺寸(≥1200px)的设备下显示的
D.小型设备,平板电脑等(≥768px且<992px)下显示的
-
以下程序运行结束后,CX寄存器的内容是 。(请用4位表示) DATA SEGMENT ABC DB 61H,02H,0FFH,0FEH,13H,0FDH,34H COUNT EQU $-ABC RESULT DW 0000H DATA ENDS CODE SEGMENT ASSUME CS:CODE,DS:DATA START:PUSH DS MOV AX,DATA MOV DS,AX XOR DX,DX MOV CX,COUNT LEA SI,ABC LEA BX,RESULT AA:MOV AL,[SI] OR AL,AL JNS NEXT2 NEG AL NEXT2:ADD AL,DL DAA MOV DL,AL MOV AL,DH ADC AL,00H DAA MOV DH,AL INC SI LOOP AA MOV [BX],DX MOV AH,4CH INT 21H CODE ENDS END START
-
执行以下程序后,RESULT字单元的内容是 H 。 DATA SEGMENT ABC DB 90H, 12H, 43H, 56H, 04H, 01H COUNT EQU $-ABC RESULT DW ? DATA ENDS CODE SEGMENT ASSUME CS:CODE, DS:DATA START: MOV AX, DATA MOV DS, AX XOR AX, AX MOV CX, COUNT LEA SI, ABC LEA DI, RESULT AA: MOV BL, [SI] INC SI CMP BL, 80H JC NEXT1 NEG BL NEXT1: ADD AL, BL ADC AH, 00H LOOP AA MOV [DI], AX MOV AH, 4CH INT 21H CODE ENDS END START