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

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

#61. Examine the structures of the EMPLOYEES and TAX tables.

TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?

Show comments for this question (1)
Add comments
Link to this question

#62. Examine the data in the WORKORDER table.

The WORKORDER table contains these columns:

 WO_ID          NUMBER     PK 
 CUST_ID        NUMBER 
 REQUIRED_DT    DATE 
 COMPL_DT       DATE 
 AMOUNT         NUMBER(7,2)

Which statement regarding the use of aggregate functions on the WORKORDER table is true?

Show comments for this question (1)
Add comments
Link to this question

#63. The INVENTORY table contains these columns:

 ID_NUMBER          NUMBER        PK 
 CATEGORY           VARCHAR2(10) 
 LOCATION           NUMBER 
 DESCRIPTION        VARCHAR2(30) 
 PRICE              NUMBER(7,2) 
 QUANTITY           NUMBER

You want to return the total of the extended amounts for each item category and location, including only those inventory items that have a price greater than $100.00. The extended amount of each item equals the quantity multiplied by the price. Which SQL statement will return the desired result?

Show comments for this question (1)
Add comments
Link to this question

#64. The EVENT table contains these columns:

 EVENT_ID        NUMBER 
 EVENT_NAME      VARCHAR2(30) 
 EVENT_DESC      VARCHAR2(100) 
 EVENT_TYPE      NUMBER 
 LOCATION_ID     NUMBER

You have been asked to provide a report of the number of different event types at each location. Which SELECT statement will produce the desired result?

Show comments for this question (1)
Add comments
Link to this question

#65. Which two statements about the evaluation of clauses in a SELECT statement are true? (Choose two.)

Show comments for this question (1)
Add comments
Link to this question

#66. Examine the structures of the EMPLOYEE and DEPARTMENT tables:
EMPLOYEE

 EMP_ID         NUMBER               NOT NULL       PK 
 NAME           VARCHAR(30)          NOT NULL 
 FNAME          VARCHAR(25)          NOT NULL 
 DEPT_NO        NUMBER 
 TITLE          VARCHAR2(25)

DEPARTMENT

 DEPT_ID         NUMBER          NOT NULL     PK 
 DEPT_NAME       VARCHAR2(25)

You need to produce a list of departments, including the department names, that have more than three administrative assistants. Which SELECT statement will produce the desired result?