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

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

#91. Which clause should you use to exclude group results?

#92. A subquery can be used to _________.

#93. The EMPLOYEES table contains these columns:

 LAST_NAME         VARCHAR2 (25) 
 SALARY            NUMBER (6,2) 
 COMMISSION_PCT    NUMBER (6)

You need to write a query that will produce these results:
1. Display the salary multiplied by the commission_pct.
2. Exclude employees with a zero commission_pct.
3. Display a zero for employees with a null commission value. Evaluate the SQL statement:

 SELECT LAST_NAME, SALARY*COMMISSION_PCT 
 FROM EMPLOYEES 
 WHERE COMMISSION_PCT IS NOT NULL;

What does the statement provide?

#94. Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

#95. Which is an /SQL*Plus command?

#96. What does the TRUNCATE statement do?

#97. You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows.
Which statement is valid?

#98. Which statement creates a new user?

#99. Which three are true regarding the use of outer joins? (Choose three.)

#100. In which scenario would TOP N analysis be the best solution?

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

gen. 0.122

Server date 07:46 22-11-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump