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 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)
相关考题：
Examine the following command;ALTER SYSTEM SET enable_ddl_logging = TRUE;Which statement is true?() A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B. All DDL commands are logged in the alert log file.C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D. Only DDL commands that resulted in the creation of new segments are logged.E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）A.0B.1C.2D.3
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 a subnet mask of 255.255.255.224, which of the following addresses can be assigned to network hosts?（）A、15.234.118.63B、92.11.178.93C、134.178.18.56D、192.168.16.87E、201.45.116.159F、217.63.12.192
Which of the following statements is true regarding the VERSIONS BETWEEN clause？（） A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
Given the address 192.168.20.19/28, which of the following are valid host addresses on this subnet?（）A、192.168.20.29B、192.168.20.16C、192.168.20.17D、192.168.20.31E、192.168.20.0
Which of the following RAID levels would be appropriate given two drives and a need for fault tolerance？（）A、RAID 0B、RAID 1C、RAID 5D、RAID 10
Which of the following is the FIRST thing to consider when designing an email retention policy？（）A、 Local laws and industry regulationsB、 Company policies and guidelinesC、 Project guidelines given by stakeholdersD、 Mail server and backup capacity
Given the following output： prompt myapp [1]+ Stopped myapp prompt Which of the following commands will resume executing the stopped process while allowing the user to continue to type commands at the command prompt？（）A、 bg myappB、 continue myappC、 exec myappD、 fg myappE、 myapp
Given four drives， which of the following RAID levels will allow for the GREATEST performance？（）A、RAID 0B、RAID 5C、RAID 6D、RAID 10
Which of the following commands should be used to monitor the number of threads on the scheduler’s run queue for any given interval？（）A、 sarB、 pstatC、 iostatD、 filemon
Which of the following commands should be used to show the percentage of time that any given disk was busy？（）A、 psB、 tprofC、 iostatD、 vmstat
单选题Given the following routing table entries， which of the following will the next-hop address be for a packet destined for the address 192.168.1.203？（）A 77.0.5.5B 40.40.0.254C 66.40.90.121D 72.40.91.1
单选题Which of the following terms would best describe the temperature at which a liquid boils at a given pressure?（）ADegree of saturationBSaturation temperatureCSuperheated temperatureDDegree of superheat
单选题You report to the IT department in your company that your computer has a connectivity problem. The department requests that you configure your system with the following value： 2001：：f85c：494e：7：4bd4 You need to configure your computer accordingly. What should you do？（）AUse the given value as an IPv6 address.BUse the given value as a DNS suffix search item.CUse the given value as a WEP key for a wireless network.DUse the given value as a manually assigned MAC address.
单选题Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）AOnly the data definition language (DDL) commands that resulted in errors are logged in the alert log file.BAll DDL commands are logged in the alert log file.CAll DDL commands are logged in a different log file that contains DDL statements and their execution dates.DOnly DDL commands that resulted in the creation of new segments are logged.EAll DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
问答题You are required to write an email of no fewer than 80 words to your manager, according to the following information given in Chinese. You should include all the points listed in the following table. Now write the message on the Answer Sheet.
单选题Which of the following commands should be used to monitor the number of threads on the scheduler’s run queue for any given interval？（）A sarB pstatC iostatD filemon
单选题Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）ANone of the data definition language (DDL) statements are logged in the trace file.BOnly DDL commands that resulted in errors are logged in the alert log file.CA new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.DOnly DDL commands that resulted in the creation of new database files are logged.
单选题Given the following output： prompt myapp [1]+ Stopped myapp prompt Which of the following commands will resume executing the stopped process while allowing the user to continue to type commands at the command prompt？（）A bg myappB continue myappC exec myappD fg myappE myapp
单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）A The VERSIONS BETWEEN clause may be used in DML statements.B The VERSIONS BETWEEN clause may be used in DDL statements.C The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.