1z0-001 Oracle - Braindumps.com.ua: question list for "Ineroduction to oracle:sql and pl/sql", page: 14

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-001: Ineroduction to oracle:sql and pl/sql

#131. You create the sale table with this command:

 CREATE TABLE sale 
 (purchase_no NUMBER(9) 
 CONSTRAINT sale_purchase_no_pk PRIMARY KEY, customer_id NUMBER(9) 
 CONSTRAINT sale_customer_id_fk REFERENCES customer (id) CONSTRAINT 
 sale_customer_id_nn NOT NULL);

Which index or indexes are created for this table?

#132. How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in the DEPT table?

#133. Examine the structure of the STUDENT table:

 Name              Null            Type 
 STUD_ID           NOT NULL        NUMBER(3) 
 NAME                              VARCHAR2(25) 
 ADDRESS                           VARCHAR2(50) 
 GRADUATION                        DATE

Currently, the table is empty. You have decided that NULL values should not be allowed for NAME column.
Which statement restricts NULL values from being entered into the column?

#134. The view EMP_VIEW is created based on the table EMP as follows:

 CREATE OR REPLACE VIEW emp_view 
 AS 
 SELECT deptno, SUM(sal) TOT_SAL, COUNT(*) NUM_EMP 
 FROM emp 
 GROUP BY deptno;

What happens when the following command is issued?

 UPDATE emp_view 
 SET tot_sal = 20000 
 WHERE deptno = 10;

#135. You have a view called ANN_SAL that is based on the EMPLOYEE table. The structure of the ANN_SAL view is:

 Name            Null          Type 
 EMPNO           NOT NULL      NUMBER(4) 
 YEARLY_SAL                    NUMBER(92) 
 MONTHLY_SAL                   NUMBER(92)

Which statement retrieves data from the ANN_SAL view?

#136. Click on the EXHIBIT button and examine the table instance chart for the patient table.

You created the patient_vu view based on id_number and last_name from the patient table. What is the best way to modify the view to contain only those patients born in 1997?

#137. You have decided to permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?

#138. Examine the structure of the STUDENT table:

 Name           Null          Type 
 STUD_ID        NOT NULL      NUMBER(3) 
 NAME           NOT NULL      VARCHAR2(25) 
 PHONE          NOT NULL      VARCHAR2(9) 
 ADDRESS                      VARCHAR2(50) 
 GRADUATION                   DATE

There are 100 records in the STUDENT table. You need to modify the PHONE column to hold only numeric values.
Which statement will modify the datatype of the PHONE column?

#139. You need to store currency data and you know that the data will always have two digits to the right of the decimal point. However, the number of digits to the left of the decimal place will vary greatly. Which datatype would be most appropriate to store this data?

#140. You attempt to create the salary table with this command:

 1 CREATE TABLE salary 
 2 .(employee_idNUMBER(9) 
 3.CONSTRAINT salary_pk PRIMARY KEY, 
 4.1995_saIaryNUMBER(8,2), 
 5 .manager_nameVARCHAR2(25) 
 6.CONSTRAINT mgr_name_nn NOT NULL, 
 7.$salary_96NUMBER(8,2));

Which two lines of this statement will return errors? (Choose two.)

[1] ... [11] [12] [13] [14] [15] [16] [17] [18]

gen. 0.078

Server date 11:07 08-01-2009

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps