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 4950

Which is a valid CREATE TABLE statement?
 

Option A

A.    CREATE TABLE EMP9$# AS (empid number(2));
 

Option B

B.    CREATE TABLE EMP*123 AS (empid number(2));
 

Option C

C.    CREATE TABLE PACKAGE AS (packid number(2));
 

Option D

D.    CREATE TABLE 1EMP_TEST AS (empid number(2));
 

Correct Answer A
Explanation


Question ID 4951

A SELECT statement can be used to perform these three functions:
- Choose rows from a table.
- Choose columns from a table
- Bring together data that is stored in different tables by creating a link between them.
Which set of keywords describes these capabilities?
 

Option A

A.    difference, projection, join
 

Option B

B.    selection, projection, join
 

Option C

C.    selection, intersection, join
 

Option D

D.    intersection, projection, join
 

Option E

E.    difference, projection, product
 

Correct Answer B
Explanation

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