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-001





Question ID 8158

Which script would you use to query the data dictionary to view only the names of the primary key constraints using a substitution parameter for the table name?

Option A

ACCEPT TABLE PROMPT('table to view primary key constraint:') SELECT constraint_name FROM user_constraints WHERE table_name=upper('&table') AND constraint_type= 'P';

Option B

ACCEPT TABLE PROMPT('table to view primary key constraint:') SELECT constraint_name FROM user_constraints WHERE table_name=upper('&table') AND constraint_type= 'PRIMARY';

Option C

ACCEPT TABLE PROMPT('table to view primary key constraint:') SELECT constraint_name,constraint_type FROM user_constraints WHERE table_name=upper('&table');

Option D

ACCEPT TABLE PROMPT('table to view primary key constraint:') SELECT constraint_name FROM user_cons_columns WHERE table_name=upper('&table') AND constraint_type= 'P';

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because this syntax is correct to display only the names of the primary key constraints, usage of condition constraint_type = 'P' in the WHERE clause is correct. Information can be found in the USER_CONSTRAINT table. Incorrect Answers: B: Usage of condition constraint_type = 'PRIMARY' is wrong. C: There is no any condition regarding CONSTRAINT_TYPE, so ALL constraints will be displayed, not only primary keys. D: There is wrong view USER_CONS_NAME for this kind of query. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 143-144 Chapter 4: Creating Other Database Objects in Oracle


Question ID 8159

Exhibit button and examine the employee table. ID NO LAST_NAME FIRST_NAME SALARY DEPT_NO 7 Brown Terry 30000 255 6 Wargner Julie 233 4 southall david 25000 102 3 chiazza mike 50000 2 limber john 32000 145 5 goldberg Kelvin 233 1 lomberg susan 55000 8 oliver tracey 145 You attempt to query the database with this command: SELECT dept_no,last_name,SUM(salary) FROM employee WHERE salary<50000 GROUP BY dept_no ORDER BY last_name; Which clause causes an error?

Option A

FROM employee.

Option B

WHERE salary<50000.

Option C

GROUP BY dept_no.

Option D

ORDER BY last_name; 

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because GROUP BY works only with dept_no column, but SELECT clause displays dept_no and last_name for each dept_no. Correction GROUP BY dept_no, last_name will fix this error. Incorrect Answers: A: The FROM clause is correct, problem related only with a GROUP BY clause. B: The WHERE clause is correct. D: The ORDER BY clause will not cause an error. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 60-63 Chapter 2: Advanced Data Selection in Oracle

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