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

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-007: Introduction to Oracle9i: SQL

#71. Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?

#72. You need to calculate the total of all salaries in the accounting department. Which group function should you use?

#73. Which SELECT statement will the result ‘elloworld’ from the string ‘HelloWorld’?

#74. Evaluate this SQL statement:

 SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) 
 + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE 
 FROM employees e, sales s 
 WHERE e.employee_id = s.emp_id;

What will happen if you remove all the parentheses from the calculation?

#75. Which script displays '01-JAN-02' when the ENROLL_DATE value is '01-JUL-01'?

#76. Which three functions can be used to manipulate character, number, or date column values? (Choose three.)

#77. A new standard has been adopted in your department that all codes that contain only 3 characters must have a dash (-) and two character values appended to them. Which function can be used in your query to restrict the data displayed to only those codes containing 3 characters?

#78. Which statement concerning SQL functions is true?

#79. The STUDENT_GRADES table has these columns:

 STUDENT_ID       NUMBER(12) 
 SEMESTER_END     DATE 
 GPA              NUMBER(4,3)

The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?

#80. Evaluate the SQL statement:

 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 
 2 FROM employees a, 
 3 (SELECT dept_id, MAX(sal) maxsal 
 4. FROM employees 
 5 GROUP BY dept_id) b 
 6 WHERE a.dept_id = b.dept_id 
 7 AND a.sal < b.maxsal;

What is the result of the statement?

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

gen. 0.323

Server date 09:48 22-11-2008

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps