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 4874

View the Exhibit and examine the structure of the SALES table.The following query is written to retrieve all those product IDs from the SALES table that have more than
55000 sold and have been ordered more than 10 times. SQL> SELECT prod_id
FROM sales
 
WHERE quantity_sold > 55000 AND COUNT(*)>10 GROUP BY prod_id HAVING COUNT(*)>10;
Which statement is true regarding this SQL statement?

Option A

A.    It executes successfully and generates the required result.
 

Option B

B.    It produces an error because COUNT(*) should be specified in the SELECT clause also.
 

Option C

C.    It produces an error because COUNT(*) should be only in the HAVING clause and not in the
WHERE clause.
 

Option D

D.    It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*).
 

Correct Answer C
Explanation


Question ID 4875

You need to create a table with the following column specifications:
1.    Employee ID (numeric data type) for each employee
2.    Employee Name (character data type) that stores the employee name
3.    Hire date, which stores the date of joining the organization for each employee
4.    Status (character data type), that contains the value 'ACTIVE' if no data is entered
5.    Resume (character large object [CLOB] data type), which contains the resume submitted by the employee
Which is the correct syntax to create this table? A. CREATE TABLE EMP_1
 
 

Option A

(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
e_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB(200));
 

Option B

B.    CREATE TABLE 1_EMP
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB);
 

Option C

C.    CREATE TABLE EMP_1
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT "ACTIVE",
resume CLOB);
 

Option D

D.    CREATE TABLE EMP_1
(emp_id NUMBER,
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB);
 

Correct Answer D
Explanation

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