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

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

#61. Which data dictionary view contains the definition of a view?

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

You create a view with this command:

 CREATE VIEW dept_salary_vu 
 AS SELECT dept_no, salary, last_name 
 FROM employee 
 WHERE salary> 45000 
 WITH CHECK OPTION;

For which employee can you update the dept_no column?

#63. Click on the EXHIBIT button and examine the table instance chart for the patient table.

You created the patient_vu view based on id_number and last_name from the patient table.
What is the best way to modify the view to contain only those patients born in 1997?

#64. In the declarative section of a PL/SQL block, you created but did not initialize a number variable. When the block executes, what will be the initial value of the variable?

#65. Which SELECT statement displays all the employees who do not have any subordinates?

#66. Which statement about using a subquery in the FROM clause is true?

#67. Which SELECT statement displays the order id, product id, and quantity of items in the ITEM table that match both the product id and quantity of an item in order 605? (Do not display the details for order 605.)

#68. You attempt to query the database with this command:

 SELECT dept_no, AVG(MONTHS_BETWEEN(SYSDATE, hire_date)) 
 FROM employee 
 WHERE AVG(MONTHS_BETWEEN(SYSDATE, hire_date)) > 60 
 GROUP BY dept_no 
 ORDER BY AVG(MONTHS_BETWEEN(SYSDATE, hire_date));

Why does this statement cause an error?

#69. In which order does the Oracle Server evaluate clauses?

#70. Which statement describes the use of a group function?

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

gen. 0.155

Server date 07:02 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps