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

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

#11. The CUSTOMERS table has these columns:

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

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

#13. Evaluate the set of SQL statements:

 CREATE TABLE dept 
 (deptno NUMBER(2), 
 dname VARCNAR2(14), 
 loc VARCNAR2(13)); 
 ROLLBACK; 
 DESCRIBE DEPT

What is true about the set?

#14. Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)

Evaluate this SQL statement:

 SELECT e.employee_id "Emp_id", e.emp_name "Employee", 
 e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" 
 FROM employees e, employees m 
 WHERE e.mgr_id = m.employee_id 
 AND e.salary > 4000;

What is its output?

#15. Which /SQL*Plus feature can be used to replace values in the WHERE clause?

#16. You are formulating queries in a SQL*Plus. Which of the following statement correctly describes how to specify a column alias?

#17. You want to use a function in you column clause of a SQL statement. The NVL function accomplishes which of the following tasks?

#18. You want to use SQL*Plus to connect to the oracle database. Which of the following choices does not indicate a component you must specify when logging into the oracle?

#19. The EMPLOYEE_HISTORY table contains these columns:

 EMPLOYEE_ID         NUMBER 
 LAST_NAME           VARCHAR2(25) 
 FIRST_NAME          VARCHAR2(25) 
 DEPARTMENT_ID       NUMBER 
 POSITION            VARCHAR2(30) 
 SALARY              NUMBER(6,2) 
 HIRE_DATE           DATE 
 DEPART_DATE         DATE

The EMPLOYEE_HISTORY table contains only former employees.
You need to create a report to display all former employees that were hired on or
after January 1, 1996. The data should display in this format:

 Former    Employee    Term of Employment 
 14837     SMITH       10-MAY-92 / 01-JUN-01

Which SELECT statement could you use?

#20. The EMPloyee table contains these columns:

 Empno       Number(4) 
 Ename       Varchar2(10) 
 job         varchar2(10) 
 sal         Varchar2(10)

You need to display the employees information by using this query. How many columns are presented after executing this query:

 SELECT Empno||','||Ename||','||Job "Employee Information" FROM employee;

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

gen. 0.141

Server date 10:47 22-11-2008

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps