[多选]

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders
(SER_NO NUMBER UNIQUE,
ORDER_ID NUMBER,
ORDER_DATE DATE NOT NULL
STATUS VARCHARD2(10)
CHECK (status IN ('CREDIT','CASH')),
PROD_ID_NUMBER
REFERENCES PRODUCTS(PRODUCT_ID),
ORD_TOTAL NUMBER,
PRIMARY KEY (order id, order date));
For which columns would an index be automatically created when you execute the aboveSQL statement? （）

如何在幼儿园的日常事务管理中运用“五常法”让幼儿学会自我管理。 A mechanical contractor is deploying a custom application written to take advantage of multithreading features and run in a Windows environment. The customer has read about iDataPlex, BladeCenter, and System x servers. The customer wants to know which processor family will run the application most efficiently. Which of the following questions will provide the required information?（） Can the application use Hot Swap Processor, Memory, and PCI-X technology? 。 Will the application benefit from larger disk cache and swap space? 。 Will the application run faster with Microsoft OLTP technology? 。 What is the application's maximum processor scaling capability?。 植物浇水的质量要求 You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（） Assign the DEFAULT profile to the users。 Set the RESOURCE_LIMIT parameter to TRUE in the parameter file。 Create a new profile with CPU restrictions and assign it to the users。 Specify the users as members of the DEFAULT_CONSUMER_GROUP。 Revoke the DBA role and grant CONNECT and RESOURCE role to the user。 商标权的特点是（）。 独占性。 按照申请时间先后注册。 地域性。 可转让性。

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders
(SER_NO NUMBER UNIQUE,
ORDER_ID NUMBER,
ORDER_DATE DATE NOT NULL
STATUS VARCHARD2(10)
CHECK (status IN ('CREDIT','CASH')),
PROD_ID_NUMBER
REFERENCES PRODUCTS(PRODUCT_ID),
ORD_TOTAL NUMBER,
PRIMARY KEY (order id, order date));
For which columns would an index be automatically created when you execute the aboveSQL statement? （）