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 th

题目

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)
相似考题

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

2.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)

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

4.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 ”相关问题

  • 第1题：

    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.

    正确答案:C

  • 第2题：

    Given the address 192.168.20.19/28, which of the following are valid host addresses on this subnet?（）

    • A、192.168.20.29
    • B、192.168.20.16
    • C、192.168.20.17
    • D、192.168.20.31
    • E、192.168.20.0

    正确答案:A,C

  • 第3题：

    Which of the following is the FIRST thing to consider when designing an email retention policy？（）

    • A、 Local laws and industry regulations
    • B、 Company policies and guidelines
    • C、 Project guidelines given by stakeholders
    • D、 Mail server and backup capacity

    正确答案:A

  • 第4题：

    Given four drives， which of the following RAID levels will allow for the GREATEST performance？（）

    • A、RAID 0
    • B、RAID 5
    • C、RAID 6
    • D、RAID 10

    正确答案:A

  • 第5题：

    Which of the following commands should be used to show the percentage of time that any given disk was busy？（）

    • A、 ps
    • B、 tprof
    • C、 iostat
    • D、 vmstat

    正确答案:C

  • 第6题：

    单选题
    Which of the following terms would best describe the temperature at which a liquid boils at a given pressure?（）
    A

    Degree of saturation

    B

    Saturation temperature

    C

    Superheated temperature

    D

    Degree of superheat


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    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

     sar

    B

     pstat

    C

     iostat

    D

     filemon


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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 myapp

    B

     continue myapp

    C

     exec myapp

    D

     fg myapp

    E

     myapp &


    正确答案： B
    解析： 暂无解析

  • 第10题：

    DDL


    正确答案: 数据定义语言，用于定义数据库的三级结构，包括外模式、概念模式、内模式及其相互之间的映象，定义数据的完整性、安全控制等约束。

  • 第11题：

    Which of the following RAID levels would be appropriate given two drives and a need for fault tolerance？（）

    • A、RAID 0
    • B、RAID 1
    • C、RAID 5
    • D、RAID 10

    正确答案:B

  • 第12题：

    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 myapp
    • B、 continue myapp
    • C、 exec myapp
    • D、 fg myapp
    • E、 myapp &

    正确答案:A

  • 第13题：

    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、 sar
    • B、 pstat
    • C、 iostat
    • D、 filemon

    正确答案:A

  • 第14题：

    单选题
    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.5

    B

    40.40.0.254

    C

    66.40.90.121

    D

    72.40.91.1


    正确答案： C
    解析： 暂无解析

  • 第15题：

    单选题
    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？（）
    A

    Use the given value as an IPv6 address.

    B

    Use the given value as a DNS suffix search item.

    C

    Use the given value as a WEP key for a wireless network.

    D

    Use the given value as a manually assigned MAC address.


    正确答案： B
    解析： 暂无解析

  • 第16题：

    问答题
    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.

    正确答案：
    Producing Situations
    Mr. Liu,
    I would like to give you, the production manager, a brief report on producing situations in our production department. Generally, the producing runs well with 500,000 ton as its daily output. And the coal that is desperately needed in producing lines has already been delivered and arrived this morning. What’s more, the HAD company requires to renew the contact for a year in a letter and the renewal has already gone through the formalities and come into effect.
    Best Wishes!
    Yours,
    Li Chengyuan
    解析： 暂无解析

  • 第17题：

    单选题
    Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）
    A

    None of the data definition language (DDL) statements are logged in the trace file.

    B

    Only DDL commands that resulted in errors are logged in the alert log file.

    C

    A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.

    D

    Only DDL commands that resulted in the creation of new database files are logged.


    正确答案： D
    解析： 暂无解析

  • 第18题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

相关内容