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

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

#171. The PRODUCT table contains these columns:

 PRODUCT_ID         NUMBER           NOT NULL 
 PRODUCT_NAME       VARCHAR2(25) 
 SUPPLIER_ID        NUMBER 
 LIST_PRICE         NUMBER(7,2) 
 COST               NUMBER(7,2)

You need to increase the list price and cost of all products supplied by Global Imports, Inc. by 5.5 percent. The SUPPLIER_ID for Global Imports, Inc. is 105. Which statement should you use?

#172. Which two statements would cause an implicit COMMIT to occur? (Choose two.)

#173. Examine the structures of the EVENT and NEW_EVENT tables.

You execute this MERGE statement:

 MERGE INTO EVENT e 
 USING (SELECT * 
 FROM new_event 
 WHERE event_type_id = 4) n 
 ON (e.event_id = n.event_id) 
 WHEN MATCHED THEN 
 UPDATE SET 
 e.event_type_id = n.event_type_id, 
 e.start_dt = n.start_dt 
 WHEN NOT MATCHED THEN 
 INSERT (event_id, event_name, event_type_id) 
 VALUES(n.event_id, n.event_name, n.event_type_id);

This MERGE statement generates an error. Which statement describes the cause of the error?

#174. Which statement regarding DML statement functionality is true?

#175. The STUDENT table contains these columns:

 STU_ID          NUMBER(9)          NOT NULL 
 LAST_NAME       VARCHAR2(30)       NOT NULL 
 FIRST_NAME      VARCHAR2(25)       NOT NULL 
 DOB             DATE 
 STU_TYPE_ID     VARCHAR2(1)        NOT NULL 
 ENROLL_DATE     DATE

You create another table, named PT_STUDENT, with an identical structure. You want to insert all part-time students, who have a STU_TYPE_ID value of "P", into the new table. You execute this INSERT statement:

 INSERT INTO pt_student 
 (SELECT stu_id, last_name, first_name, dob, SYSDATE 
 FROM student 
 WHERE UPPER(stu_type_id) = 'P');

What is the result of executing this INSERT statement?

#176. Examine the structures of the AR_TRX and AR_TRX_HY tables.

You are loading historical accounts receivable data from the AR_TRX table into the AR_TRX_HY table. During the load, you want to transform the data so that the GRAND_TOTAL column of the AR_TRX_HY table is equal to the sum of the EXT_AMT and TAX_AMT columns in the AR_TRX table. You want to set LOAD_DATE to the current date. If the record already exists in the target table, all values, except TRX_ID and TRX_TYPE, should be refreshed with the most recent data. Which MERGE statement should you execute?

#177. EMPLOYEES and DEPARTMENTS data:

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID.
On the DEPARTMENTS table DEPARTMENT_ID is the primary key.
Evaluate this UPDATE statement.

 UPDATE employees 
 SET mgr_id = 
 (SELECT mgr_id 
 FROM employees 
 WHERE dept_id= 
 (SELECT department_id 
 FROM departments 
 WHERE department_name = 'Administration')), 
 Salary = (SELECT salary 
 FROM employees 
 WHERE emp_name = 'Smith') 
 WHERE job_id = 'IT_ADMIN';

What happens when the statement is executed?

#178. The transaction control which prevent more than one user from updating data in a table is which of the following?

#179. What is necessary for your query on an existing view to execute successfully?

#180. Examine the structure if the EMPLOYEES table:

You need to create a view called EMP_VU that allows the user to insert rows through the view.
Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [31]

gen. 0.115

Server date 03:33 08-01-2009

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps