Are you able to pass this Oracle PL/SQL test? This free procedural language is designed to run alongside the SQL within the same server process, bringing optimal efficiency. The Oracle PL, although not portable and doesn't interface that well with the tons of libraries available for other environments, can process the statements of the system query language with ease. By taking this quiz, you will get to review how to use the languages back to back.
Foo_number varchar2(10);
Foo_text number(10);
Foo_char char(1) := 'Y';
Foo_time date;
Foo_text varchar2(10) := 'hello world';
CHAR
VARCHAR1
VARCHAR2
INTEGER
NUMBER
INITIALIZE, GET, CLOSE
CURSOR, GET, FETCH, CLOSE
OPEN, FETCH, CLOSE
CURSOR, FETCH, CLOSE
GET, SEEK, HIDE
Variables
IN OUT Parameters
Name
Signature
None of the above
Package specification is invalid. Too many procedures named foo.
Package specification is invalid. First procedure should be called called foo_1, second procedure should be called foo_2.
Package specification is valid. We can have an unlimited number of procedures name foo.
Package specification is valid. This is an example of overloading.
Package specification is invalid. We can only have one procedure named foo in the package.
%ID
%ROWTYPE
%COLUMNTYPE
%TYPE
None of the above.
%TABLE
%ROWTYPE
%COLUMNTYPE
%TYPE
None of the above
Explicit
Implicit
Select
PL/SQL
None of the above
Explicit
Implicit
Select
PL/SQL
None of the above
ELSE
ELSE IF
ELIF
ELSIF
None of the above
This SQL will list all employees in the Finance department earning more than 20000
This SQL will list all employees who are in the Finance or Sales department earning more than 20000
This SQL will list all employees who are Analysts in the Finance or Sales department earning more than 20000
This SQL will return a cartesian product
None of the above
In the PL/SQL working storage section
In the PL/SQL declaration section
In the PL/SQL body section
In the PL/SQL exception section
None of the above
The commit is fired 1000 times
The commit is fired 100 times
The commit is fired 10 times
The commit is fired 1 time
None of the above.
09/09/2009 09:09:09
09/09/2009 09:09:09AM
09/09/2009
09/09/2009 00:00:00
None of the above
Incantination
Integration
Continuation
Concatenation
None of the above
DECODE
TRUNCATE
TO_CHAR
NVL
Trick question, all of these are Oracle DML functions.
WHILE LOOP ... END LOOP;
FOR rec IN some_cursor LOOP ... END LOOP;
LOOP ... UNTIL ; END LOOP;
LOOP ... EXIT WHEN ; END LOOP;
None of the above. All are valid.
%NOTFOUND
%FOUND
%ROWCOUNT
%ISOPEN
None of the above. All of these are valid.
COUNT
SUM
DISTINCT
MIN
All of the above.
Wait!
Here's an interesting quiz for you.