网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “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.” 相关考题
考题
Giventwocollectionobjectsreferencedbycol1andcol2,whichofthesestatementsaretrue?()
A.Theoperationcol1.retainAll（col2）willnotmodifythecol1object.B.Theoperationcol1.removeAll（col2）willnotmodifythecol2object.C.Theoperationcol1.addAll（col2）willreturnanewcollectionobject，containingelementsfrombothcol1 andcol2.D.Theoperationcol1.containsAll（Col2）willnotmodifythecol1object.
考题
You plan to execute the following command to perform a Flashback Database operation in your database:SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE －5／24);Which two statements are true about this?()
A. The database must have multiplexed redo log filesB. The database must be in the MOUNT state to execute the commandC. The database must be in the NOMOUNT state to execute the commandD. The database must be opened in RESTRICTED mode before this operationE. The database must be opened with the RESETLOGS option after the flashback operation
考题
Which two statements regarding the Flashback Table feature are correct?()
A. Flashback Table can be performed on system tables.B. Flashback Table operation does not shrink the segments.C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.
考题
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 createdB.Each time the REFRESH VIEW v1 statement is executedC.Each time an SQL statement is executed against view V1D.Only the first time an SQL statement is executed against view V1
考题
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.4B.3C.1D.0
考题
YouworkwithadatabasenamedDB1，whichislocatedonaSQLServer2005computer.YoudiscoverthatatablescanonTable1inDB1causesaslowquery.Table1isaverylargetablethatisusedfrequently.Youascertainthatthequerycontainsthefollowingstatement.SELECTcol1，col2FROMtable1WHEREcol3=Youneedtoprovidemaximumqueryperformance.Table1mustremainavailabletousers.Whatshouldyoudo？（）A.UpdateallstatisticsonTable1inDB1.B.UsetheCREATESTATISTICSstatementinDB1tocreatemissingstatisticsoncol3ofTable1.C.Setthepriorityboostserveroptionto1.D.Executethefollowingstatement.USEDB1GOCREATEINDEXindex1ONtable1（col3）INCLUDE（col1，col2）WITH（ONLINE=ON）GO
考题
客服业务受到SQL语句的影响非常大，以下哪些是执行效率比较低的SQL语句，可以进行优化（）A、select*from record where substrb（CardNo，1，4）=’5378’；B、表tab1中的列col1是字符型（char），执行select col1，col2 from tab1 where col1’10’；C、select count（*）from stuff where id_no in（’0’，’1’）；D、UPDATE SERVICEINFO SET STATE=0WHERE STATE0。
考题
If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?（）A、COL1 will accept NULL values and can be referenced in another table's foreign key specification.B、COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.C、COL1 will not accept NULL values and can be referenced in another tables foreign key specification.D、COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.
考题
对于表A（col1 int，col2 char（1）），表B（col1 int，col2char（1）），为确保表A的数据全部被保留，下面正确的联接方式是（）A、A inner join BB、A left join BC、A right join BD、Across join B
考题
对于表A（col1 int，col2 char（1））更新col1=1的数据col2值为N，下面语句正确的是（）A、update table A setcol2=’N’ where col1=1B、modify table A setcol2=N where col1=1C、update A set col2=’N’ where col1=1D、modify A set col2=N where col1=1
考题
存在两个结构相同的数据库表T1（col1，col2，col3）、T2（col1，col2，col3），写出一SQL语句将所有T1数据导入到T2表（）A、select col1，col2，col3 from T1 into T2（col1，col2，col3）B、insert T1 （col1，col，col3） into T2（col1，col2，col3）C、insert into T2 （col1，col2，col3） as select col1，col2，col3 from T1D、insert into T2（col1，col2，col3） select col1，col2，col3 from T1；
考题
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、4B、3C、1D、0
考题
Which of the following statements are true？（） A、 The equals（） method determines if reference values refer to the same object.B、 The == operator determines if the contents and type of two separate objects match.C、 The equals（） method returns true only when the contents of two objects match.D、 The class File overrides equals（） to return true if the contents and type of two separate objects match.
考题
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）A、SYSDATE should not be used with TIMESTAMP.B、The database must have multiplexed redo log files.C、The database must be in the MOUNT state to execute the command.D、The database must be opened with the RESETLOGS option after the flashback operation.E、The entire database needs to be restored from the most recent backup before the flashback operation.
考题
You plan to execute the following command to perform a Flashback Database operation in your database： SQL FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
考题
Which statements are true regarding the Oracle Data Pump export and import operations（）A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported
考题
Which of the following statements are true regarding the Recycle Bin？（）A、 The Recycle Bin is a physical storage area for dropped objects.B、 The Recycle Bin is a logical container for dropped objects.C、 The Recycle Bin stores the results of a Flashback Drop operation.D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
Which two statements are true regarding the Oracle Data Pump export and import operations（）A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported.
考题
You have just performed a FLASHBACK TABLE operation using the following command： flashback table employees to scn 123456； The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（） A、 All the triggers are disabled.B、 All the triggers are enabled by default.C、 Enabled triggers remain enabled and disabled triggers remain disabled.D、 Triggers are deleted when a Flashback Table operation is performed.
考题
你正在SQL SERVER 2005 服务器上一个名为DB1的数据库上进行着工作。你发现由于对DB1中Table1表的扫描导致了查询执行缓慢。已知，Table是一个使用频繁而且非常巨大的表，同时你又确定了查询中包含如下的语句：SELECT col1，col2 FROM table1 WHERE col3 = 。在表保持对所有用户有效的情况下，为了最大化的提高查询性能，你应该怎么做？（）A、更新DB1数据库中表Table1的所有统计信息B、在DB1数据库中，使用CREATE STATISTICS 语句为表Table1的列col3创建缺少的统计信息C、设置优先值提升选项的值为1D、执行如下语句：USE DB1 GO CREATE INDEX index1 ON table1（col3） INCLUDE（col1， col2） WITH （ONLINE = ON） GOE、执行如下语句 USE DB1GOCREATE INDEX index1 ON table1（col3， col2，col1）
考题
You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 = You need to provide maximum query performance. Table1 must remain available to users. What should you do？（）A、Update all statistics on Table1 in DB1.B、Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.C、Set the priority boost server option to 1.D、Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO
考题
单选题对于表A（col1 int，col2 char（1）），表B（col1 int，col2char（1）），为确保表A的数据全部被保留，下面正确的联接方式是（）A
A inner join BB
A left join BC
A right join BD
Across join B
考题
单选题你正在SQL SERVER 2005 服务器上一个名为DB1的数据库上进行着工作。你发现由于对DB1中Table1表的扫描导致了查询执行缓慢。已知，Table是一个使用频繁而且非常巨大的表，同时你又确定了查询中包含如下的语句：SELECT col1，col2 FROM table1 WHERE col3 = 。在表保持对所有用户有效的情况下，为了最大化的提高查询性能，你应该怎么做？（）A
更新DB1数据库中表Table1的所有统计信息B
在DB1数据库中，使用CREATE STATISTICS 语句为表Table1的列col3创建缺少的统计信息C
设置优先值提升选项的值为1D
执行如下语句：USE DB1 GO CREATE INDEX index1 ON table1（col3） INCLUDE（col1， col2） WITH （ONLINE = ON） GOE
执行如下语句 USE DB1GOCREATE INDEX index1 ON table1（col3， col2，col1）
考题
多选题Which of the following statements are true regarding the Recycle Bin？（）AThe Recycle Bin is a physical storage area for dropped objects.BThe Recycle Bin is a logical container for dropped objects.CThe Recycle Bin stores the results of a Flashback Drop operation.DThe objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
单选题对于表A（col1 int，col2 char（1））更新col1=1的数据col2值为N，下面语句正确的是（）A
update table A setcol2=’N’ where col1=1B
modify table A setcol2=N where col1=1C
update A set col2=’N’ where col1=1D
modify A set col2=N where col1=1
考题
多选题Given two collection objects referenced by col1 and col2，which of these statements are true？（）AThe operation col1.retainAll（col2） will not modify the col1 object.BThe operation col1.removeAll（col2） will not modify the col2 object.CThe operation col1.addAll（col2） will return a new collection object， containing elements from both col1 and col2.DThe operation col1.containsAll（Col2） will not modify the col1 object.
考题
多选题You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）ASYSDATE should not be used with TIMESTAMP.BThe database must have multiplexed redo log files.CThe database must be in the MOUNT state to execute the command.DThe database must be opened with the RESETLOGS option after the flashback operation.EThe entire database needs to be restored from the most recent backup before the flashback operation.
热门标签
最新试卷