The underlined word "subjects" in paragraph 5 means ______.A．branches of knowledge studied

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.3

B.2

C.1

D.0

Given the information in the following table, if the Home economy suffered a meltdown, and the Unit Labor Requirements doubled to 20 for cloth and 40 for widgets then home should ________________.

A、export cloth.

B、export widgets.

C、export both and import nothing.

D、export and import nothing.

Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object？（）

A.CREATE UNIQUE INDEX idx_partno ON parts(part_no)

B.CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)

C.CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)

D.CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)

Given the following function:CREATE FUNCTION emplist () RETURNS TABLE (id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement？

A.SELECT TABLE(EMPLIST()) FROM EMPLOYEE

B.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE

C.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE

D.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)Which of the following SQL statements will provide the table definition that meets the specified requirements？（）

A.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

B.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

C.CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

D.CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

he hr schema:$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hrTRANSFORM=DISABLE_ARCHIVE_LOGGING: YWhich statement is true？（）

A. All database operations performed by the impdp command are logged.

B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

The U.S. Treasury spot rates are provided in the following table:

Given a consistent corporate spread of 0.50%, what will be the most likely price of a 4% coupon corporate bond with 2 years to maturity？

A. $100.61

B. $102.96

C. $98.92

A．ALTER

B．CREATE

C．UPDATE

D．INSERT

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

Given the information in the following table, if it is ascertained that Foreign uses prison-slave labor to produce its exports, then home should __________.

A、export cloth.

B、export widgets.

C、export both and import nothing.

D、export and import nothing.