1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", 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-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

#61. The CUSTOMERS table has these columns:

 CUSTOMER_ID         NUMBER(4)     NOT NULL 
 CUSTOMER_NAME       VARCHAR2(100) NOT NULL 
 STREET_ADDRESS      VARCHAR2(150) 
 CITY_ADDRESS        VARCHAR2(50) 
 STATE_ADDRESS       VARCHAR2(50) 
 PROVINCE_ADDRESS    VARCHAR2(50) 
 COUNTRY_ADDRESS     VARCHAR2(50) 
 POSTAL_CODE         VARCHAR2(12) 
 CUSTOMER_PHONE      VARCHAR2(20)

The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? (Choose two.)

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

#62. Which two tasks can your perform by using the TO_CHAR function? (Choose two)

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

#63. Which two statements are true regarding the ORDER BY clause? (Choose two)

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

#64. 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

#65. Which are DML statements? (Choose all that apply)

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

#66. Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?

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

#67. Examine the structure of the EMPLOYEES table:

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

You issue these statements:

 CREATE TABLE new_emp ( employee_id NUMBER, name VARCHAR2(30)); 
 INSERT INTO new_emp SELECT employee_id , last_name FROM employees; 
 SAVEPOINT s1; 
 UPDATE new_emp SET name = UPPER(name); 
 SAVEPOINT s2; 
 DELETE FROM new_emp; 
 ROLLBACK TO s2; 
 DELETE FROM new_emp WHERE employee_id =180; 
 UPDATE new_emp SET name = 'James'; 
 ROLLBACK TO s2; 
 UPDATE new_emp SET name = 'James' WHERE employee_id =180; 
 ROLLBACK;