AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4912

You need to create a table named ORDERS that contain four columns:
1.    an ORDER_ID column of number data type
2.    a CUSTOMER_ID column of number data type
3.    an ORDER_STATUS column that contains a character data type
4.    a DATE_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?
 

Option A

A.    CREATE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status VARCHAR2 (10),date_ordered DATE = SYSDATE);
 

Option B

B.    CREATE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status VARCHAR2 (10),date_ordered DATE DEFAULT SYSDATE);
 

Option C

C.    CREATE OR REPLACE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status VARCHAR2 (10),date_ordered DATE DEFAULT SYSDATE);
 

Option D

D.    CREATE OR REPLACE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status VARCHAR2 (10),date_ordered DATE = SYSDATE);
 

Option E

E.    CREATE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status NUMBER (10),date_ordered DATE = SYSDATE);
 

Correct Answer B
Explanation


Question ID 4913

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? (Choose three.)
 

Option A

A.    INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
 

Option B

B.    INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
 

Option C

C.    INSERT INTO employees VALUES ( 1000, 'John', NULL);
 

Option D

D.    INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
 

Option E

E.    INSERT INTO employees (employee_id) VALUES (1000);
 

Option F

F.    INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
 

Correct Answer C,E,F
Explanation

Send email to admin@getfreedumps for new dumps request!!!