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

#111. Which two statements about creating constraints are true? (Choose two)

#112. Which two statements are true about WHERE and HAVING clauses? (Choose two)

#113. EMPLOYEES and DEPARTMENTS data:

On the EMPLOYEES table, EMPLOYEE_ID is the primary key.
MGR_ID is the ID managers and refers to the EMPLOYEE_ID.
On the DEPARTMENTS table DEPARTMENT_ID is the primary key.
Evaluate this UPDATE statement.

 UPDATE employees 
 SET mgr_id = 
 (SELECT mgr_id 
 FROM employees 
 WHERE dept_id= 
 (SELECT department_id 
 FROM departments 
 WHERE department_name = 'Administration')), 
 Salary = (SELECT salary 
 FROM employees 
 WHERE emp_name = 'Smith') 
 WHERE job_id = 'IT_ADMIN';

What happens when the statement is executed?

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

#115. Evaluate the SQL statement:

 SELECT ROUND(45.953, -1), TRUNC(45.936, 2) 
 FROM dual;

Which values are displayed?

#116. The CUSTOMERS table has these columns:

 CUSTOMER_ID         NUMBER (4)         NOT NULL 
 CUSTOMER_NAME       VARCHAR2 (100)      NOT NULL 
 STREET_ADDRESS      VARCHAR2 (150) 
 CITY_ADDRESS        VARHCAR2 (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. You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?

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

#118. Examine the structure of the EMP_DEPT_VU view:

 Column Name       Type Remarks 
 EMPLOYEE_ID       NUMBER 
 EMP_NAME          VARCHAR2(30) 
 JOB_ID            VARCHAR2(20)  
 SALARY            NUMBER 
 DEPARTMENT_ID     NUMBER  
 DEPT_NAME         VARCHAR2(30)

Which SQL statement produces an error?

#119. You own a table called EMPLOYEES with this table structure:

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

What happens when you execute this DELETE statement?

 DELETE employees;

#120. 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 MERGE statement is valid?

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

gen. 0.082

Server date 05:21 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump