READ Free Dumps For Oracle- 1z0-007

Question ID 8025	Which four are types of functions available in SQL? (Choose 4)
Option A	string
Option B	character
Option C	integer
Option D	G. date
Option E	numeric
Option F	H.  conversion
Correct Answer	BEGH

Explanation Explanation/Reference: Explanation : SQL have character, numeric, date, conversion function. Incorrect answer : A SQL have character, numeric, date, conversion function. C SQL have character, numeric, date, conversion function. D SQL have character, numeric, date, conversion function. F SQL have character, numeric, date, conversion function. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 3-3

Question ID 8026	Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)
Option A	You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
Option B	The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
Option C	The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
Option D	Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
Option E	The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
Option F	The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
Correct Answer	CD

Explanation Explanation/Reference: Explanation : the EMP_ID_SEQ sequence is not affected by modification to the EMPLOYEES table. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence. Incorrect answer : A EMP_ID_SEQ sequence can be use to populate JOB_ID B EMP_ID_SEQ sequence will not be invalidate when column in EMPLOYEE_ID is modify. E EMP_ID_SEQ sequence will be dropped automatically when you drop the EMPLOYEES table. F EMP_ID_SEQ sequence will be dropped automatically when you drop the EMPLOYEE_ID column. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 12-4

Previous-Page 1 2. . . 140 141 142 143 144 145 146. . . 160 161 Next-Page

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