1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: SQL", page: 19

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-007: Introduction to Oracle9i: SQL

#181. You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables:
EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME.
The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table.
You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables.
How can you accomplish this task?

#182. Which statements concerning the creation of a view are true? (Choose all that apply.)

#183. You are granted the CREATE VIEW privilege. What does this allow you to do?

#184. Examine the structure of the CURR_ORDER table as shown below:

You created the ORDER_V view selecting all rows and columns from the ORDER table where the amount of the order was over $250 and the date of the order was after January 1, 2000. The CREATE VIEW statement included the WITH CHECK OPTION clause.
Which statement will execute successfully?

#185. An inline view is a SELECT statement that is given an alias and is embedded in the ______ clause of another SELECT statement.

#186. You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.
Which SQL statement would you use to create the view EMP_VU?

#187. Which two statements about views are true? (Choose two.)

#188. The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table.
As a user of the database, you created a table called HR in your schema. What happens when you execute this query?

 SELECT * 
 FROM HR;

#189. Examine the structure of the EMPLOYEES table:

You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?

#190. In which scenario would index be most useful?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [31]

gen. 0.05

Server date 04:49 08-01-2009

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps