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? （） SER_NO。 ORDER_ID。 STATUS。 PROD_ID。 ORD_TOTAL。 Composite index on ORDER_ID and ORDER_DATE。
由S、P、Q组成的三角形称为（）
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。
The server host1 has been set up as a backup system with the following /etc/exports： /backups -rw How can a second server regularly use this disk space？（） /usr/sbin/mkfs -s 8G -o nbpi=2048，frag=512 /dev/lv00 -b -l host1。 /usr/sbin/crnfsmnt -d /backups -l /backups host1 -R -X -v -S -b bg。 /usr/sbin/mknfsmnt -f /backups -d /backups -h host1 -a -S -t rw -w bg -g。 /usr/sbin/crfs -v nfs -g vg1 -A yes -p rw -m /backups -a logname=/dev/lv00。
计量计价控制实施过程中以（）为基础，对承包商完成工程量报表进行实时计量 合同工程量。 计划工程量。 预算工程量。 实际工程量。
You have created a locally managed tablespace by issuing the following command：
CREATE TABLESPACE data1
DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE
UNLIMITED；
For the DATA1 tablespace， you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated？（）
