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

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

#161. You want to create a report to show different jobs in each department. You do not want to display any duplicate rows in the report. Which SELECT statement do you use to create the report?

#162. You want to create a cursor that can be used several times in a block, selecting a different active set each time when it is opened. Which type of cursor do you create?

#163. The PLAYER table contains these columns:

 ID            NUMBER(9) 
 NAME          VARCHAR(2) 
 MANAGER_ID    NUMBER(9)

In this instance, managers are players and you need to display a list of players. Evaluate these two SQL statements:

 SELECT p.name, m.name 
 FROMplayer p, player m 
 WHEREm.id = p.manager_id; 
 SELECT p.name, m.name 
 FROMplayer p, player m 
 WHEREm manager_id = p.id;

How will the results differ?

#164. Click on the EXHIBIT button and examine the structure of the PRODUCT and PART tables.

You issue this SQL statement

 SELECT pr.name 
 FROMpart pt, product pr 
 WHEREpt.product_id(+) = pr.id;

What is the result?

#165. Examine the table structures:
EMP Table

  Name         Null           Type 
 EMPNO         NOT NULL       NUMBER(4) 
 NAME                         VARCHAR2(10) 
 JOB                          VARCHAR2(9) 
 MGR                          NUMBER(4) 
 HIREDATE                     DATE 
 SALARY                       NUMBER(7,2) 
 COMM                         NUMBER(7,2) 
 DEPTNO        NOT NULL       NUMBER(2)

TAX Table

 Name          Null      Type 
 TAXGRADE                NUMBER 
 LOWSAL                  NUMBER 
 HIGHSAL                 NUMBER

You want to create a report that displays the employee details along with the tax category or each employee. The tax category is determined by comparing the salary of the employee from the EMP table to the lower and upper salary values in the TAX table.
Which SELECT statement produces the required results?

#166. Which privilege concerns system level security?

#167. Evaluate this SQL script:

 CREATE ROLE manager; 
 CREATE ROLE clerk; 
 CREATE ROLE inventory; 
 CREATE USER scott IDENTIFIED BY tiger; 
 GRANT inventory TO clerk; 
 GRANT clerk TO manager; 
 GRANT inventory TO scott

How many roles will user SCOTT have access to?

#168. Scott forgot his password while on vacation. What command must be executed to set a password for Scott?

#169. You need to create a report to display the ship date and order totals of your ORDER table. If the order has not been shipped, your report must display ‘Not Shipped’. If the total is not available, your report must display ‘Not Available’.
In the ORDER table, the SHIPDATE column has a datatype of DATE. The TOTAL column has a datatype of NUMBER.
Which statement do you use to create this report?

#170. You want to display the details of all employees whose last name is Smith, but you are not sure in which case the last names are stored. Which statement will list all the employees whose last name is Smith?

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

gen. 0.111

Server date 11:05 08-01-2009

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps