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 4848

Which is the valid CREATE [TABLE statement?
 
 

Option A

A.    CREATE TABLE emp9S# (emp_no NUMBER(4)):
 

Option B

B.    CREATE TABLE 9emp$# (emp_no NUMBER(4));
 

Option C

C.    CREATE TABLE emp*123 (emp_no NUMBER(4)):
 

Option D

D.    CREATE TABLE emp9$# (emp_no NUMBER(4). date DATE);
 

Correct Answer A
Explanation


Question ID 4849

View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.)
 

Option A

A.    CREATE MEW v3
AS SELECT * FROM SALES "WHERE cust_id = 2034 WITH CHECK OPTION:

Option B

B.    CREATE MEW vl
AS SELECT * FROM SALES WHERE time
_    id <= SYSDATE - 2*365 WITH CHECK OPTION:

 

Option C

C.    CREATE MEW v2
AS SELECT prod_id. cust_icL time_id FROM SALES WHERE time_id <= SYSDATE - 2*365 WITH CHECK OPTION:
 

Option D

D.    CREATE MEWv4
AS SELECT prod_id. cust_icL SUM(quantity_sold) FROM SALES WHERE time_id <= SYSDATE - 2*365 GROUP BYprod_id. cust_id WITH CHECK OPTION:

Correct Answer A,B
Explanation

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