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