网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）
A
TRIG_A
B
TRIG_B
C
TRIG_C
D
TRIG_D
参考答案
参考解析
解析：
暂无解析
更多 “单选题The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）A TRIG_AB TRIG_BC TRIG_CD TRIG_D” 相关考题
考题
View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
考题
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
考题
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?()
A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
考题
Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;（）A.3B.2C.1D.0
考题
你定义了一个对象类型myOBJ,要基于该类型来创建表tab1,语句为()。
A.CREATE TABLE tab1 OF myOBJB.CREATE TABLE myOBJ OF tab1C.CREATE TABLE tab1 AS myOBJD.CREATE TABLE tab1 TYPE OF myOBJ
考题
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.
考题
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
考题
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? （）A、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2)B、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2) C、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1)D、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1）
考题
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）A、REVOKE ADD, DELETE FROM USER tom ON TABLE tab1B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
考题
Given the following statements: CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3); What is the result of the following query? SELECT count(*) FROM tab2;（）A、3B、2C、1D、0
考题
Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）A、SELECT * FROM tab1 INNER JOIN tab2 ON c1=cxB、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cxC、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cxD、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
考题
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（） A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C、 Referential integrity constraints must be manually enabled after the online table redefinition process.D、 The materialized log should be dropped before the online table redefinition process.
考题
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.
考题
单选题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.
考题
单选题You need to ensure that when the button is clicked， both update panels update the tim without generating a postback. What should you do？（）A
Add the following marktip to UpdatePanel1. Triggers asp:PostBackTrigger ControlID=btnSave / /Triggers B
Set the UpdateMode property for the UpdatePanel2 to AlwaysC
Add the following markup to UpdatePanel2 Triggers asp:AsyncPostBackTrigger ControlID=btnSave EventName=Click / /Triggers D
Set the UpdateMode property for UpdatePanel2 to Conditional
考题
多选题In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；Awhen the schema of the user， SCOTT， was deleted by mistake 15 minutes agoBwhen the table EMP of the SCOTT schema was dropped by mistake 15 minutes agoCwhen some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes agoDwhen some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutesEnever， because FLASHBACK TABLE is not a valid command in Oracle 10g.
考题
单选题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.
考题
单选题You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）A
The dependent materialized view should have a complete refresh performed after the online table redefinition process.B
Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C
Referential integrity constraints must be manually enabled after the online table redefinition process.D
The materialized log should be dropped before the online table redefinition process.
考题
单选题Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）A
CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) B
CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) C
CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) D
CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
考题
单选题下列哪个语句将赋予用户John向表tab1中插入数据的权限？（）A
GRANT ADD ON TABLE tab1 TO JohnB
GRANT INSERT ON tab1 TO JohnC
GRANT ADD ON TABLE tab1 TO USER JohnD
GRANT INSERT ON TABLE tab1 TO USER John
考题
单选题Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）A
GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB
GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C
GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD
GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
考题
单选题你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。A
CREATE TABLE tab1 OF myOBJB
CREATE TABLE myOBJ OF tab1C
CREATE TABLE tab1 AS myOBJD
CREATE TABLE tab1 TYPE OF myOBJ
考题
单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）A
The shrink operation touches every block in the BOOKING tableB
The high-water mark (HWM) for the BOOKING table is shifted from its original positionC
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
考题
多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it
考题
单选题Examine the following command： SQL ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）A
The shrink operation touches every block in the BOOKING tableB
The high-water mark （HWM） for the BOOKING table is shifted from its original positionC
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD
The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
考题
单选题Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）A
INSERT INTO tab1 SELECT cx, cy FROM tab2B
INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)C
INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)D
INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
考题
单选题The radar component that produces the synchronizing signal and triggers the indicator sweep is which of the following?（）.A
transmitterB
antenna systemC
indicatorD
modulator
热门标签
最新试卷