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

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

#91. You need to remove all the data from the employee table while leaving the table definition intact. You want to be able to undo this operation. How would you accomplish this task?

#92. You need to change the job title ‘Clerk’ to ‘Administrative Clerk’ for all clerks, Which statement does this?

#93. Which operator is NOT appropriate in the join condition of a non-equi join SELECT statement?

#94. 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?

#95. 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?

#96. 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 of 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 TM table. Which SELECT statement produces the required results?

#97. Which statement would you use to add a primary key constraint to the patient table using the id_number column, immediately enabling the constraint?

#98. Examine the structure of the STUDENT table:

 Name          Null           Type 
 STUD ID       NOT NULL       NUMBER(3) 
 NAME                         VARCHAR2(25) 
 ADDRESS                      VARCHAR2(5O) 
 GRADUATION                   DATE

Currently, the table is empty. You have decided that NULL values should not be allowed for NAME column. Which statement restricts NULL values from being entered into the column?

#99. The structure of the DEPT table is as follows:

 Name         Null            Type 
 DEPTNO       NOT NULL        NUMBER(2) 
 DNAME                        VARCHAR2(14) 
 LOC                          VARCHAR2(13)

Examine the declaration section:

 DECLARE 
 TYPE dept_record_type IS RECORD 
 (dno NUMBER. 
 name VARCHAR2(20)); 
 dept_rec dept_record_type;

How do you retrieve an entire row of the DEPT table using the DEPT_REC variable?

#100. Examine the code:

 DECLARE 
 CURSOR emp_cursor IS 
 SELECT ename, deptno 
 FROM emp; 
 emp_rec emp_cursor%ROWTYPE; 
 BEGIN 
 OPEN emp_cursor; 
 LOOP 
 FETCH emp_cursor 
 INTO emp_rec; 
 EXIT WHEN emp_cursor%NOTFOUND; 
 INSERT INTO temp_emp(name, dno) VALUES (emp_recename, emp_rec.deptno); 
 END LOOP; 
 CLOSE emp_cursor; 
 END;

Using a cursor FOP loop, which PLJSQL block is equivalent to the above code?

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

gen. 0.272

Server date 10:10 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps