当前位置:1Z0-007题库

问题:

[单选]

You need to create a table named ORDERS that contain four columns:
1. an ORDER_ID column of number data type
2. aCUSTOMER_ID column of number data type
3. an ORDER_STATUS column that contains a character data type
4. aDATE_ORDERED column to contain the date the order was placed.
When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead.
Which statement accomplishes this? ()

A . CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
B . CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
C . CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
D . CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
E . CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
F . CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE)

Which storage subsystem can scale in a single image to multiple petabytes of physical disk?() XIV system 。 SONAS 。 DS5300 。 DS8700。 青年教师刘某通过高等教育心理学的学习,认识到学会学习是大学生走向社会的基本需要。于是,他在自己任教的班级进行了一场轰轰烈烈的改革,既开设专题讲座,又组织专门考试,全力倡导和普及“学法比知识本身更重要”的学习理念。一个学期下来,学生对各种学习方法,倒背如流,但是学业成绩并没有明显的提高。你认为,就工作而言,()是青年教师刘某的当务之急。 重温并深入理解学习策略的理论。 切实贯彻生成性原则。 废除改革。 贯彻主体性原则。 A healthcare and life sciences client wants to maintain electronic patient records, including medical images, for a period of seven years. How would the IT storage industry describe this business goal?() an archive solution that requires event-based retention。 a backup solution that provides version-based expiration。 a PACS environment that provides two year litigation hold。 a business continuity solution that provides two years Recovery Time Objective (RTO)。 A manufacturing customer has a requirement to add 12 additional dual-attached servers to theirexisting two Brocade 16 port SAN switches that have no more ports available. Which of thefollowing should be recommended to accommodate the current capacity requirements, allow forfuture growth and provide 8 and 4 Gb support?() two SAN16B 。 two SAN80B-4 。 two SAN24B-4 。 two SAN04B-R。 直接报酬

You need to create a table named ORDERS that contain four columns:
1. an ORDER_ID column of number data type
2. aCUSTOMER_ID column of number data type
3. an ORDER_STATUS column that contains a character data type
4. aDATE_ORDERED column to contain the date the order was placed.
When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead.
Which statement accomplishes this? ()

参考答案:

  参考解析

本题暂无解析

在线 客服