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

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

#111. Examine the data from the EMP table:

The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three)

#112. Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

#113. Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?

#114. Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES:

 EMPLOYEE_ID        NUMBER          Primary Key 
 FIRST_NAME         VARCHAR2 (25) 
 LAST_NAME          VARCHAR2 (25) 
 HIRE_DATE          DATE

NEW EMPLOYEES:

 EMPLOYEE_ID     NUMBER         Primary Key 
 NAME            VARCHAR2 (60)

Which DELETE statement is valid?

#115. Evaluate this SQL*Plus command: COLUMN teacher_name HEADING 'Teacher' FORMAT A25
Which two tasks will this command accomplish? (Choose two.)

#116. The STUDENT table contains these columns:

 ID             NUMBER(9)        PK 
 LAST_NAME      VARCHAR2(25) 
 FIRST_NAME     VARCHAR2(25) 
 STU_TYPE       VARCHAR2(1) 
 ENROLL_DATE    DATE

Evaluate this iSQL*Plus script:

 SELECT id, last_name, first_name, enroll_date 
 FROM student 
 WHERE stu_type = '&stype' 
 AND enroll_date BETWEEN &&bdate AND &&edate

What happens when this script is run a second time in the same session?

#117. Evaluate this SELECT statement:

 SELECT order_num, &order_date 
 FROM &&ordertbl 
 WHERE order_date = '&order_date';

Which statement regarding the execution of this statement is true?

#118. The INVENTORY table contains these columns:

 ID_NUMBER        NUMBER             PK 
 DESCRIPTION      VARCHAR2(30) 
 SUPPLIER_ID      NUMBER

You want to create a query that for each session allows the user to input a value for DESCRIPTION each time the query runs. While the DESCRIPTION column is stored in upper case, you want the query to retrieve matching values regardless of the case used when inputting the substitution variable value. Which SELECT statement should you use?

#119. In which clauses of a SELECT statement can substitution variables be used?

#120. What is the default character for specifying substitution variable in select statement?

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

gen. 0.069

Server date 03:41 08-01-2009

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps