1z0-001 Oracle - Braindumps.com.ua: question list for "Ineroduction to oracle:sql and pl/sql", page: 3

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-001: Ineroduction to oracle:sql and pl/sql

#21. Click on the EXHIBIT button and examine the employee table.

You attempt to query the database with this command:

 SELECT dept_no, last_name, SUM(salary) 
 FROM employee 
 WHERE salary < 50000 
 GROUP BY dept_no 
 ORDER BY last_name;

Which clause causes an error?

#22. Click on the EXHIBIT button and examine the structure of the BOOK_TITLE, COPY, and CHECK_OUT tables.

You need to create the BOOKS_AVAILABLE view. These are the desired results:
1.Include the title of each book.
2.Include the availability of each book.
3.Order the results by the author.
Evaluate this SQL statement

 CREATE VIEW books_available 
 AS 
 SELECT b.title, c.availability 
 FROMbook_title b, copy c 
 WHEREB.id = c.title_id 
 ORDER BY b.author

What does the statement provide?

#23. The view EMP_VIEW is created based on the table EMP as follows:

 CREATE OR REPLACE VIEW emp_view 
 AS 
 SELECT deptno, SUM(sal) TOT_SAL, COUNT(*) NUM_EMP 
 FROM emp 
 GROUP BY deptno;

What happens when the following command is issued?

 UPDATE emp_view 
 SET tot_sal = 20000 
 WHERE deptno = 10;

#24. Which statement shows the view definition of the view EMP_VIEW that is created based on the table EMP?

#25. In which section of a PL/SQL block is a user-defined exception raised?

#26. Examine the table structures:
EMP Table

 Name       Null?          Type 
 EMPNO      NOT NULL       NUMBER(4) 
 NAME                      VARCHAR2(10) 
 JOB                       VARCHAR2(9) 
 MGR                       NUMBER(4) 
 HIREDATE                  DATE 
 SALARY                    NUMBER(7,2) 
 COMM                      NUMBER(7,2) 
 DEPTNO     NOT NULL       NUMBER(2)

TAX Table

 Name       Null?        Type 
 TAXGRADE                NUMBER 
 LOWSAL                  NUMBER 
 HIGHSAL                 NUMBER

You want to create a report that displays the employee details along with the tax category of each employee. The tax category is determined by comparing the salary of the employee from the EMP table to the lower and upper salary values in the TAX table. Which SELECT statement produces the required results?

#27. The PLAYER table contains these columns:

 ID            NUMBER(9) 
 NAME          VARCHAR(2) 
 MANAGER_ID    NUMBER(9)

In this instance, managers are players and you need to display a list of players. Evaluate these two SQL statements:

 SELECT p.name, m.name 
 FROMplayer p, player m 
 WHEREm.id = p.manager_id; 
 SELECT p.name, m.name 
 FROMplayer p, player m 
 WHEREm.manager_id = p.id;

How will the results differ?

#28. Which operator is NOT appropriate in the join condition of a non-equi join SELECT statement?

#29. In which situation should you use an outer join query?

#30. You need to store currency data and you know that the data will always have two digits to the right of the decimal point. However, the number of digits to the left of the decimal place will vary greatly. Which datatype would be most appropriate to store this data?

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

gen. 0.761

Server date 10:03 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps