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- 1z0-061





Question ID 2295

Examine the structure of the sales table:
 
Evaluate the following create table statement:
 
Which two statements are true about the creation of the SALES1 table?

Option A

A.    The SALES1 table is created with no rows but only a structure.
 

Option B

B.    The SALES1 table would have primary key and unique constraints on the specified columns.
 

Option C

C.    The SALES1 table would not be created because of the invalid where clause.
 

Option D

D.    The SALES1 table would have not null and unique constraints on the specified columns.
 

Option E

E.    The SALES1 table would not be created because column-specified names in the select and create table clauses do not match,
 

Correct Answer A
Explanation


Question ID 2296

Which two statements are true regarding subqueries?

Option A

A.    A subquery can retrieve zero or more rows.
 

Option B

B.    Only two subqueries can be placed at one level.
 

Option C

C.    A subquery can be used only in SQL query statements.
 

Option D

D.    A subquery can appear on either side of a comparison operator.

 

Option E

E.    There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.

Correct Answer A,D
Explanation

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