1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: SQL", 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-007: Introduction to Oracle9i: SQL

#41. Management has asked you to calculate the value 12*salary* comossion_pct for all the employees in the EMP table. The EMP table contains these columns:

Which statement ensures that a value is displayed in the calculated columns for all employees?

#42. Examine the description of the STUDENTS table:

Which two aggregate functions are valid on the START_DATE column? (Choose two)

#43. The EMPLOYEE tables has these columns:

You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?

#44. You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?

#45. Evaluate the SQL statement:

 SELECT ROUND(TRUNC(MOD(1600,10),-1),2) 
 FROM dual;

What will be displayed?

#46. Examine the description of the MARKS table:

SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table:

 SELECT subj1+subj2 total_marks, std_id 
 FROM marks 
 WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) 
 ORDER BY total marks;

What is the result of the SELECT statement?

#47. Which three SELECT statements display 2000 in the format “$2,000.00”? (Choose three)

#48. Examine the description of the EMPLOYEES table:

Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?

#49. Which two are true about aggregate functions? (Choose two.)

#50. Which four statements correctly describe functions that are available in SQL? (Choose four)

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

gen. 0.183

Server date 07:22 22-11-2008

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps