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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

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

#111. A DBA has updated Smith’s account by adding the privileges CREATE ANY TABLE and CREATE PROCEDURE. Which tasks can Smith successfully perform?

#112. Which three SQL arithmetic expressions return a date? (Choose three.)

#113. Click on the EXHIBIT button and examine the table instance chart for the employee table.

You need to display the hire_date values in this format 10 of October 1999. Which SELECT statement can you use?

#114. You need to analyze how long your orders take to be shipped from the date that the order is placed. To do this, you must create a report that displays the customer number. date ordered, date shipped, and the number of months in whole numbers from the time the order is placed to the time the order is shipped.
Which statement produces the required results?

#115. Which SELECT statement displays employee names, salaries. department numbers, and average salaries for all employees who earn more than the average salary in their department?

#116. Mr. King is the president of a company. Five managers report to him. All other employees report to these managers. Examine the code:

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

The above statement returns
no rows selected.
as the result. Why?

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

#118. Examine the code:

 SET SERVEROUTPUT ON 
 DECLARE 
 v_char_val VARCHAR2(100); 
 BEGIN 
 v_char_val := ‘Hello World’; 
 DBMS_OUTPUT .PUT_LINE(v_char_vaI); 
 END; 
 SET SERVEROUTPUT OFF

This code is stored in a script tile named myproc.sql. Which statement executes the code in the script file?

#119. Which statement is true about nesting blocks?

#120. Which statement is valid within the executable section of a PL/SQL block?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18]

gen. 0.075

Server date 11:08 08-01-2009

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps