Which operator can be used with a multiple-row subquery? ()
A、=
B、LIKE
C、BETWEEN
D、NOT IN
E、IS
F、<>
相关问题推荐
-
Which two are true about aggregate functions? ()
AYou can use aggregate functions in any clause of a SELECT statement.
BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
CYou can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
DYou can pass column names, expressions, constants, or functions as parameters to an aggregate function.
EYou can use aggregate functions on a table, only by grouping the whole table as one single group.
FYou cannot group the rows of a table by more than one column while using aggregate functions.
-
在PowerPoint2010中,幻灯片的放映类型有()。
A、演讲者放映
B、观众自行浏览
C、在展台浏览
D、循环放映
-
Evaluate the following statements: CREATE TABLE purchase_orders (po_id NUMBER(4), po_date TIMESTAMP, supplier_id NUMBER(6), po_total NUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITION BY RANGE(po_date) (PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?), PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?), PARTITION Q3 VALUES LESS THAN(TO_DATE(?1-oct - 2007?d-mon-yyyy?), PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?)); CREATE TABLE purchase_order_items (po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT NULL, unit_price NUMBER(8,2), quantity NUMBER(8), CONSTRAINT po_items_fk FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk); What are the two consequences of the above statements?()
APartitions of PURCHASE_ORDER_ITEMS have system-generated names.
BBoth PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
CPartitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
DThe PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
EPartition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
-
患儿,男性,6岁,突然发热、腹痛、腹泻2天,每天排便15次以上,粪便为黏液脓血便。入院查体:体温39.9℃,BP110/70mmHg,神清,双侧瞳孔等大等圆,左下腹压痛。入院诊断为"细菌性痢疾"。确诊前,为该病人采集便标本时,下列注意事项不需要的是()
A、采集脓血部分
B、可连续多次取样
C、标本应立即送检
D、注意标本保温
E、不要被尿液污染
-
患儿,男,13岁,因"高热2天"于当年7月20日收治入院,入院后第3天确诊为流行性乙型脑炎,下列对病人的做法正确的是()
A、严密隔离
B、呼吸道隔离
C、消化道隔离
D、接触隔离
E、虫媒隔离