1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: SQL", page: 17

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1Z0-007: Introduction to Oracle9i: SQL

#161. Examine the data in the EMPLOYEES and DEPARTMENTS tables:

Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:

 CREATE TABLE departments 
 (department_id NUMBER PRIMARY KEY, 
 department_name VARCHAR2(30)); 
 CREATE TABLE employees 
 (EMPLOYEE_ID NUMBER PRIMARY KEY, 
 EMP_NAME VARCHAR2(20), 
 DEPT_ID NUMBER REFERENCES 
 departments(department_id), 
 MGR_ID NUMBER REFERENCES 
 employees(employee id), 
 MGR_ID NUMBER REFERENCES 
 employees(employee id), 
 JOB_ID VARCHAR2(15). 
 SALARY NUMBER); 
 ON the EMPLOYEES,

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.
Examine this DELETE statement:

 DELETE 
 FROM departments 
 WHERE department id = 40;

What happens when you execute the DELETE statement?

Show comments for this question (1)
Add comments
Link to this question

#162. You maintain two tables, CUSTOMER and PROSPECT, that have identical structures but different data. You want to synchronize these two tables by inserting records from the PROSPECT table into the CUSTOMER table, if they do not exist. If the customer already exists in the CUSTOMER table, you want to update customer data.
Which DML statement should you use to perform this task?

Show comments for this question (1)
Add comments
Link to this question

#163. Examine the structure of the EMPLOYEES table:

You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP.
COMM_PCT: Default value specified for this commission percentage column, if any.
If no default value is specified for the column, the value should be NULL.
DEPARTMENT_ID: Supplied by the user during run time through substitution variable.
Which UPDATE statement meets the requirements?

Show comments for this question (1)
Add comments
Link to this question

#164. You added a PHONE-NUMBER column of NUMBER data type to an existing EMPLOYEES table.
The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table.
Some of the employees may not have a phone number available.
Which data manipulation operation do you perform?

Show comments for this question (1)
Add comments
Link to this question

#165. Which two statements complete a transaction? (Choose two)

Show comments for this question (0)
Add comments
Link to this question

#166. Examine the data in the EMPLOYEES table.

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.
Evaluate this DELETE statement:

 DELETE employee_id, salary, job_id 
 FROM employees 
 WHERE dept_id = 90;

Why does the DELETE statement fail when you execute it?

Show comments for this question (1)
Add comments
Link to this question

#167. Examine the structure of the EMPLOYEES table:

Which three statements inserts a row into the table? (Choose three)

Show comments for this question (1)
Add comments
Link to this question

#168. Examine the structure of the EMPLOYEES table:

You issue these statements:

 CREATE TABLE new_emp ( employee_id NUMBER, name VARCHAR2(30)); 
 INSERT INTO new_emp SELECT employee_id , last_name FROM 
 employees; 
 SAVEPOINT s1; 
 UPDATE new_emp SET name = UPPER(name); 
 SAVEPOINT s2; 
 DELETE FROM new_emp; 
 ROLLBACK TO s2; 
 DELETE FROM new_emp WHERE employee_id =180; 
 UPDATE new_emp SET name = 'James'; 
 ROLLBACK TO s2; 
 UPDATE new_emp SET name = 'James' WHERE employee_id =180; 
 ROLLBACK;