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

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

#51. For which three tasks would you use the WHERE clause? (Choose three.)

#52. As a DBA, you have just created a user account for employee Smith by using the CREATE USER command Smith should be able to create tables and packages in his schema. Which command will the DBA need to execute next so that Smith can perform his tasks successfully?

#53. Which privilege concerns system level security?

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

#55. You want to retrieve the employee details from the EMP table and process them in PL/SQL block, Which type of variable do you create in the PL/SQL block to retrieve all the rows and columns using a single SELECT statement from the EMP table?

#56. The EMPLOYEE table contains these columns:

 LAST_NAME      VARCHAR2(25) 
 FIRST_NAME     VARCHAR2(25) 
 SALARY         NUMBER(7,2)

You need to display the names of employees that earn more than the average salary of all employees.
Evaluate this SQL statement

 SELECT last_name, first_name 
 FROMemployee 
 WHEREsalary > AVG(salary);

Which change should you make to achieve the desired results?

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

 SELECT name, salary 
 FROM employee 
 WHERE salary = 
 (SELECT salary 
 FROM employee 
 WHERE last_name = ‘Wagner’ OR dept_no = 233);

Why could this statement cause an error?

#58. In which section of a PL/SQL block is a user-defined exception raised?

#59. Which script would you use to query the data dictionary to view only the name of the primary key constraints by using a substitution parameter for the table name?

#60. You are a user of the PROD database which contains over 1000 tables, and you need to determine the number of tables you can access. Which data dictionary view could you query to display this information?

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

gen. 0.225

Server date 10:50 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps