1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", page: 5

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

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-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

#41. The ORDERS table has these columns:

ORDER_ID            NUMBER(4)    NOT NULL 
 CUSTOMER_ID       NUMBER(12)    NOT NULL 
 ORDER_TOTAL       NUMBER(10,2)

The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? (Choose two.)

#42. Examine the data in the EMPLOYEES and EMP_HIST tables:

The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.
Which statement accomplishes this task?

#43. Which two statements about subqueries are true? (Choose two.)

#44. Examine the data of the EMPLOYEES table.
EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)

Evaluate this SQL statement:

 SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, 
 m.employee_id "Mgr_id", m.emp_name "Manager" 
 FROM employees e, employees m 
 WHERE e.mgr_id = m.employee_id 
 AND e.salary > 4000;

What is its output?

#45. 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?

#46. In which case would you use a FULL OUTER JOIN?

#47. Which two statements accurately describe a role? (Choose two.)

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

#49. The EMP table has these columns:

 ENAME       VARCHAR2(35) 
 SALARY      NUMBER(8,2) 
 HIRE_DATE   DATE

Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?

#50. 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?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [85]

gen. 0.159

Server date 07:55 22-11-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump