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

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

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

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

#83. Evaluate the SQL statement:

 SELECT ROUND(45.953, -1), TRUNC(45.936, 2) 
 FROM dual;

Which values are displayed?

#84. The CUSTOMERS table has these columns:

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

The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?

#85. You want to use single row function in your SQL statements which three of the following are number functions? (Choose three).

#86. You are using single row function in a SELECT statement which function can best be catergorized as similar in function to an IF-THEN-ELSE statement?

#87. Which of the following functions are available in SQL? (Choose four)

#88. Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

Evaluate this SQL statement:

 SELECT employee_id, e.department_id, department_name, 
 salary 
 FROM employees e, departments d 
 WHERE e.department_id = d.department_id;

Which SQL statement is equivalent to the above SQL statement?

#89. Examine the data in the EMPLOYEES and DEPARTMENTS tables.

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?

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

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

gen. 0.301

Server date 06:50 22-11-2008

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps