|
Home > Archive > Oracle certifications > October 2001 > Classic 1z0-001 questions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Classic 1z0-001 questions
|
|
|
| Classic 1z0-001 questions
*14. Evaluate this procedure:
PROCEDURE price_increase
(v_quota IN BOOLEAN;
v_stock IN BOOLEAN;
v-approval INOUT BOOLEAN)
IS
BEGIN
v_approval :=v_quota AND v_stock;
END;
If v_quota=FALSE and v_stock=NULL, which value is assigned to v_approval?
A. NULL
B. TRUE
C. FALSE
D. None
*21. What causes a PL/SQL WHILE loop to terminate?
A. A Boolean variable or expression evaluates to TRUE.
B. A Boolean variable or expression evaluates to FALSE.
C. A Boolean variable or expression evaluates to NULL.
D. Control is passed to the EXIT statement.
E. The specified number of iterations has been performed.
#22. Which type of variable has a column ( : ) prefix in a PL/SQL statement?
A. declared PL/SQL variable
B. PL/SQL procedure variable
C. SQL *Plus global variable
D. PL/SQL function variable
24. Evaluate this command:
SELECT id_number, description
FROM inventory
WHERE id_number =
(SELECT id_number
FROM inventory
WHERE quantity > 500 OR price > 5.00);
Which clause will cause an error?
A. SELECT id_number, description
B. WHERE id_number =
C. SELECT id_number
D. WHERE quantity > 500 OR price > 5.00
E. none
60. What is the syntax for removing a primary key constraint and all its dependent
constraints?
A. ALTER TABLE table
DISABLE CONSTRAINT PRIMARY KEY CASCADE;
B. ALTER TABLE table
REMOVE CONSTRAINT PRIMARY KEY CASCADE;
C. ALTER TABLE table
DROP CONSTRAINT PRIMARY KEY CASCADE;
D. A primary key constraint cannot be removed. | |
| laloca 2001-10-23, 1:06 pm |
| is it a test sql21 ? ;-)
14. A
21. both FALSE or NULL - discussion!
22. hmm .. a colon prefix have only :bindvariables ??
24. B
60. C | |
| Bhamoo 2001-10-23, 5:16 pm |
| #21 is definitely FALSE.
I just had this question on a class exam last night!  | |
| laloca 2001-10-24, 2:06 am |
| Oracle technet says:
"Before each iteration of the loop, the condition is evaluated. If the condition is true, the sequence of statements is executed, then control resumes at the top of the loop. If the condition is false or null, the loop is bypassed and control passes to the next statement.
This is exactly the problem in the exams! In some questions you have to guess what they want. I agree with you, during exam I would also answer with false ... |
|
|
|
|