1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", page: 17

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

#161. The PRODUCTS table has these columns:

 PRODUCT_ID     NUMBER(4) 
 PRODUCT_NAME   VARCHAR2(45) 
 PRICE          NUMBER(8,2)

Evaluate this SQL statement:

 SELECT * FROM PRODUCTS ORDER BY price, product_name;

What is true about the SQL statement?

#162. In which two cases would you use an outer join? (Choose two.)

#163. Which constraint can be defined only at the column level?

#164. Examine the structure of the EMPLOYEES table:

 EMPLOYEE_ID NUMBER NOT NULL 
 EMP_NAME VARCHAR2(30) 
 JOB_ID VARCHAR2(20) 
 SAL NUMBER 
 MGR_ID NUMBER 
 DEPARTMENT_ID NUMBER

You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below:
EMPLOYEE_ID: Next value from the sequence
EMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables
SAL: 2000
MGR_ID: No value
DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50.
Which INSERT statement meets the above requirements?

#165. The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

#166. Which view should a user query to display the columns associated with the constraints on a table owned by the user?

#167. Examine these statements:

 CREATE ROLE registrar;  
 GRANT UPDATE ON student_grades TO registrar;  
 GRANT registrar TO user1, user2, user3;

What does this set of SQL statements do?

#168. Which two statements about subqueries are true? (Choose two.)

#169. You need to design a student registration database that contains several tables storing academic information.
The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.
You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?

#170. Evaluate the SQL statement:

 TRUNCATE TABLE DEPT;

Which three are true about the SQL statement? (Choose three.)

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

gen. 0.081

Server date 05:10 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump