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

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

#51. Evaluate these two SQL statements:

 SELECT last_name, salary , hire_date 
 FROM EMPLOYEES 
 ORDER BY salary DESC; 
 SELECT last_name, salary, hire_date 
 FROM EMPLOYEES 
 ORDER BY 2 DESC;

What is true about them?

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

#53. The CUSTOMERS table has these columns:

 CUSTOMER_ID        NUMBER(4)        NOT NULL 
 CUSTOMER_NAME      VARCHAR2(100)    NOT NULL 
 STREET_ADDRESS     VARCHAR2(150) 
 CITY_ADDRESS       VARCHAR2(50) 
 STATE_ADDRESS      VARCHAR2(50) 
 PROVINCE_ADDRESS   VARCHAR2(50) 
 COUNTRY_ADDRESS    VARCHAR2(50) 
 POSTAL_CODE        VARCHAR2(12) 
 CUSTOMER_PHONE     VARCHAR2(20)

Which statement finds the rows in the CUSTOMERS table that do not have a postal code?

#54. Which SELECT statement will the result ‘ello world’ from the string ‘Hello World’?

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

#56. From SQL*Plus, you issue this SELECT statement:

 SELECT* 
 FROM orders;

You use this statement to retrieve data from a data table for __________. (Choose all that apply)

#57. You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?

#58. Examine the structure of the STUDENTS table:

 STUDENT_ID      NUMBER NOT NULL, Primary Key 
 STUDENT_NAME    VARCHAR2(30) 
 COURSE_ID       VARCHAR2(10) NOT NULL 
 MARKS           NUMBER 
 START_DATE      DATE 
 FINISH_DATE     DATE

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task?

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

#60. Examine the data from the EMP table:

The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three)

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

gen. 0.25

Server date 08:09 22-11-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump