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

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

#31. You have decided to permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?

#32. Which table name is valid?

#33. Examine the structure of the STUDENT table:

 Name          Null?       Type 
 STUD ID       NOT NULL    NUMBER(S) 
 NAME          NOT NULL    VARCHAR2(25) 
 PHONE         NOT NULL    VARCHAR2(9) 
 ADDRESS                   VARCHAR2(50) 
 GRADUATION                DATE

There are 100 records in the STUDENT table. You want to change the name of the GRADUATION column to GRAD_DATE.
Which statement is true?

#34. You need to update employee salaries. If the salary of an employee is less than 1000, the salary needs to be incremented by 10%. Use a SQL*PIus substitution variable to accept the employee number.
Which PL/SQL block successfully updates the salaries?

#35. Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL cursor attribute would you use to accomplish this task?

#36. Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)

#37. Evaluate this PL/SQL block:

 BEGIN 
 FOR i IN 1.10 LOOP 
 IF i = 4 OR i = 6 THEN 
 NULL; 
 ELSE 
 INSERT INTO test(results) 
 VALUES (I); 
 END IF; 
 COMMIT; 
 END LOOP; 
 ROLLBACK; 
 END;

How many values will be inserted into the TEST table?

#38. Which statement about multiple column sub queries is true?

#39. Examine the results from the report:

 Department       %Employees     %Salary 
 10               21.43          30.152 
  0               35.71          37.47 
 30               42.86          32.39

Which SELECT statement produces the report?

#40. Examine the code:

 SELECT employee.ename 
 FROM emp employee 
 WHERE employee.empno NOT IN 
 (SELECT manager.mgr 
 FROM emp manager);

What is the NOT IN operator equivalent to, in the above query?

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

gen. 0.123

Server date 07:00 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps