Oracle PL/SQL Fundamentals
Test your knowledge of Oracle database and PL/SQL programming concepts including data types, control structures, exception handling, and basic PL/SQL syntax.
Questions
A ____________ is the collection of all objects that a user has created.
- package
- database
- schema
- none of these
Which of the following is a set of predefined resource parameters that can be used to monitor and control various database resources?
- Profile
- Password
- Username
- None of these
Which of the following is a block-structured language?
- SQL
- C++
- C
- PL/SQL
________ is an explicit numeric, character, string or Boolean value not represented by identifier.
- Reserved word
- Delimiter
- Literal
- Single line comment
___________ is a simple or compound symbol that has a special meaning to PL/SQL.
- Delimiter
- Literal
- Identifier
- Comment
Which of the following languages allows you to directly interact with the database and manipulate objects & data?
- PL/SQL
- JAVA
- SQL
- C++
Which of the following are used to name PL/SQL program, objects and units? <o:p>
- Delimiters
- Identifiers
- Comments
- None of these
- Delimiter
- Comment
- Literal
- String literal
Which of the following data types is used to store fixed or floating point numbers of virtually any size?
- CHAR
- NUMBER
- VARCHAR2
- FLOAT
_______________ have special syntactic meaning to PL/SQL and, thus, cannot be redefined.
- Reserved words
- String literals
- Boolean literals
- Literals
_________ is a sequence of zero or more characters enclosed by single quotes.<o:p>
- String literal
- Boolean literal
- Literal
- Identifier
__________ begin(s) with a slash-asterisk, end(s) with an asterisk-slash and can span multiple lines.
- Single line comment
- Comments
- Multiline comments
- None of these
_____________ data type is used to store variable length character data.
- NUMBER
- CHAR
- VARCHAR2
- STRING
In PL/SQL iterative control statements, a ___________ repeats sequence of statements.
- Loop statement
- WHILE loop statement
- FOR loop statement
- DO-WHILE loop statement
Which of the error handling expections are executed when an error occurs while executing a PL/SQL block of code?
- Predetermined internal exceptions
- User defined expections
- Internally defined expections
- None of these
Which of the following statements enables you to specify the condition required to exit the execution of loop?
- EXIT
- EXIT WHEN
- GOTO
- None of these
Which Loop statement allows to execute a block of code repeatedly until some condition occurs?
- WHILE Loop statement
- DO-WHILE Loop statement
- FOR Loop statement
- None of these
___________ statement allows you to change the flow of control within a PL/SQL block.
- GOTO
- EXIT
- FOR
- CONTINUE
Which of the following are used to assign values to the variables that are given in the selected statement?
- Cursor names
- Parameters
- Data types
- None of these
Which Oracle authentication mechanism is used to manage password for an account?
- Database authentication
- Operating system authentication
- Password authentication
- None of these
__________ predefined exception is raised when a select statement returns zero rows.
- VALUE_ERROR
- TOO_MANY_ROWS
- ZERO_DIVIDE
- NO_DATA_FOUND
Which of the following predetermined exceptions is raised if PL/SQL runs out of memory or if memory is corrupted?
- PROGRAM_ERROR
- STORAGE_ERROR
- VALUE_ERROR
- None of these
_________ exception is raised when the conversion of a number to a character string fails.
- VALUE_ERROR
- NO_DATA_FOUND
- INVALID_NUMBER
- PROGRAM_ERROR
Which exception is raised when login to ORACLE has failed because of invalid username or password?
- INVALID_CURSOR
- CURSOR_ALREADY_OPEN
- LOGIN_DENIED
- OTHERS
Which exception is raised when all other exceptions fail to catch errors?
- LOGIN_DENIED
- OTHERS
- VALUE_ERROR
- ERROR