1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", page: 9

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-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

#81. Examine the data from the ORDERS and CUSTOMERS tables.

Evaluate the SQL statement:

 SELECT * 
 FROM orders 
 WHERE cust_id = (SELECT cust_id 
 FROM customers 
 WHERE cust_name = 'Smith');

What is the result when the query is executed?

#82. You need to display the last names of those employees who have the letter “A” as the second character in their names.
Which SQL statement displays the required results?

#83. You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.
You want to look at the definition of the view (the SELECT statement on which the view was create.)
How do you obtain the definition of the view?

#84. Evaluate this SQL statement:

 SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME 
 FROM EMP e, DEPARTMENT d 
 WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;

In the statement, which capabilities of a SELECT statement are performed?

#85. Which two are character manipulation functions? (Choose two.)

#86. Which three statements correctly describe the functions and use of constraints? (Choose three.)

#87. You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".
What happens when the main query is executed?

#88. You need to calculate the total of all salaries in the accounting department. Which group function should you use?

#89. What is true about joining tables through an equijoin?

#90. Scott issues the SQL statements:

 CREATE TABLE dept 
 (deptno NUMBER(2), 
 dname VARCHAR2(14), 
 loc VARCHAR2(13)}; 
 GRANT SELECT 
 ON DEPT 
 TO SUE;

If Sue needs to select from Scott's DEPT table, which command should she use?

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

gen. 0.203

Server date 07:49 22-11-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump