21. How to add foreign key constraint to dept_no in emp table referring to id_column in dept table?
22. How to create non-unique index on the foreign key column?
23. If you grant UPDATE privilege to last_name column, which data dictionary view you can check
a. Table_privileges
b. All_col_privs_recd
24. What is USER_COL_PRIVS-MADE data dictionary?
25. Create synonym emp
for ed.employee
26. Create public synonym emp
for ed.employee
27. Which SELECT statement could you use to display the ID__ NUMBER and MANUFACTURER __ID values based on the DESCRIPTION value entered at the prompt, regardless of case?
a.SELECT id __ number, manufacturer __id
FROM inventory
WHERE description - LOWER ('&description');
SELECT id__ number, manufacturer __id
b.FROM inventory
WHERE LOWER (description)="&description";
c.SELECT id__number, manufacturer __id
FROM inventory
WHERE UPPER(description)=UPPER("&description"
;
d.SELECT id __ number, manufacturer __id
FROM inventory
WHERE description = "&description".
28. How to create sequence?
29 How to create view?
30 To find primary key from employee table in User_Indexes and User_ind_columns
31 Which type of exception requires a RAISE statement?
32. Legal Table name
a. number
b. abc@5
c. catch_#5
d. catch-5
33.In executable section of PL/SQL block
Declare
Variable1 CONSTANT number(8,2)
a. An index identifie will be assigned a value
b. A record will be assigned a value
c. A constant will be assigned a value
d. A composite variable will be assigned a variable
34. You create a view based on table employee. How should you limit the view only can be accessible between 8:00am to 5:00pm?
a. Alter table view
b. Drop view and create view with where clause
c. No way to do this
35. Update patient table with variable input at runtime
è Update paient
set doctor_id = &doctor_id
where patient_id=&paient_id
36. You want to delete all records in the emp table, but leave table definition, also you can rollback the command.
a. Delete from
b. Update
c. Alter table
d. Truncate table
37. User Jane has same privilege as Scott on table Patient. Scott did extensive update on Patient table before issuing COMMIT. Scott asks Jane to log on database and check modification what he did .
a. Jane cannot access to table patient
b. Jane can view Scott’s changes
c. Jane cannot see the changes Scott made
d. Jane can access table and made change for Scott
38..How do you write Select statement in PL/SQL block?
a. Select last_name, first_name
From employee
b. Select last_name, first_name
Into v_last_name, v_first_name
From employee
39. Declare
low number := 4
hign number :=4
For I in low..high loop
End Loop;
What is the loop counter?
a. 0
b. 1
c. 4
d. 8
40. Declare
value number
new_value number
If value > 100 then
New_value = value *2
Elsif
If value > 200 then
New_value = value *3
Else
If value < 300 then
New_value = value *4
End if
If value =250 what is new_value?
a. 250
b. 500
c. 750
d. 1000 |
