MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 151 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
Which internal exception is raised when a program references a nested table or varray element using an index number larger than the number of elements in the collection. |
| A. | NO_DATA_FOUND |
| B. | COLLECTION_IS_NULL |
| C. | SUBSCRIPT_OUTSIDE_LIMIT |
| D. | SUBSCRIPT_BEYOND_COUNT |
| Answer» E. | |
| 52. |
Which Exception is also known as Oracle named exception handler? |
| A. | Predefined Exception |
| B. | Internal Exception |
| C. | User defined Exception |
| D. | None of the above |
| Answer» B. Internal Exception | |
| 53. |
Which error occurs while the program is running and cannot be detected by the PL/SQL compiler? |
| A. | Syntax error |
| B. | Runtime error |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 54. |
Which datatypes make it practical to write PL/SQL programs to do number-crunching, for scientific applications involving floating-point calculations. |
| A. | BINARY_FLOAT |
| B. | BINARY_DOUBLE |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 55. |
Which datatypes can be used with a RECORD Type? |
| A. | NUMBER,VRCHAR2 |
| B. | %TYPE,OR %ROWTYPE |
| C. | REF,CURSOR |
| D. | BOTH A & B |
| E. | BOTH B & C |
| Answer» E. BOTH B & C | |
| 56. |
Which datatype is used to store large blocks of character data in the database, in-line or out-of-line? Both fixed-width and variable-width character sets are supported. |
| A. | BLOB |
| B. | CLOB |
| C. | BFILE |
| D. | NCLOB |
| Answer» C. BFILE | |
| 57. |
Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic? |
| A. | PLS_INTEGER |
| B. | BINARY_INTEGER |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 58. |
Which data type supports only sequential access of objects? |
| A. | LONG |
| B. | LOB |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. LOB | |
| 59. |
Which collection exception is raised when a subscript exceeds the number of elements in a collection? |
| A. | VALUE_ERROR |
| B. | COLLECTION_IS_NULL |
| C. | SUBSCRIPT_BEYOND_COUNT |
| D. | SUBSCRIPT_OUTSIDE_LIMIT |
| Answer» D. SUBSCRIPT_OUTSIDE_LIMIT | |
| 60. |
Which collection method Returns the index number that precedes index n in a collection? |
| A. | PRIOR(n) |
| B. | LAST |
| C. | LIMIT |
| D. | COUNT |
| Answer» B. LAST | |
| 61. |
Which collection exception is raised when a subscript designates an element that was deleted, or a nonexistent element of an associative array? |
| A. | NO_DATA_FOUND |
| B. | COLLECTION_IS_NULL |
| C. | SUBSCRIPT_BEYOND_COUNT |
| D. | SUBSCRIPT_OUTSIDE_LIMIT |
| Answer» B. COLLECTION_IS_NULL | |
| 62. |
Which attribute returns NULL? |
| A. | %FOUND |
| B. | %ISOPEN |
| C. | %NOTFOUND |
| D. | %ROWCOUNT |
| Answer» B. %ISOPEN | |
| 63. |
When implementing methods using PL/SQL, you cannot call a base or supertype object method with the super keyword or an equivalent method in a derived object. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 64. |
When creating a function, in which section will you typically find a return key word? |
| A. | Header Only |
| B. | Declarative |
| C. | Executable and Header |
| D. | Executable and exception handling |
| Answer» D. Executable and exception handling | |
| 65. |
When building up a single SQL statement in a string, do not include any semicolon at the end. |
| A. | Yes |
| B. | No |
| Answer» B. No | |
| 66. |
What is the maximum number of triggers that can apply to a single table? |
| A. | 14 |
| B. | 10 |
| C. | 12 |
| D. | 16 |
| Answer» D. 16 | |
| 67. |
What is the advantage of using the %ROWTYPE datatype? |
| A. | It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separ |
| B. | It can be used even if data type of the table columns is not known. |
| C. | It ensures that data type of the variable changes dynamically if the underlying table is altered. |
| D. | All mentioned above |
| E. | Both A & B |
| Answer» E. Both A & B | |
| 68. |
What are the different datatypes that can be defined in a PL/SQL block? |
| A. | Scalar |
| B. | Composite |
| C. | Reference |
| D. | LOB |
| E. | All mentioned above |
| Answer» F. | |
| 69. |
Varrays are a good choice when - |
| A. | The number of elements is known in advance. |
| B. | The elements are usually all accessed in sequence. |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 70. |
Using DBMS_DB_VERSION Package Constants which represents the condition that the database version is less than or equal to 10; it is TRUE. |
| A. | VER_LE_10 |
| B. | VER_LE_10_2 |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. VER_LE_10_2 | |
| 71. |
Use the ROWID datatype only for backward compatibility with old applications. For new applications, use the UROWID datatype. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 72. |
To process most dynamic SQL statements, you use the EXECUTE IMMEDIATE statement. To process a multi-row query (SELECT statement), which of these statements would you use? |
| A. | OPEN-FOR |
| B. | FETCH |
| C. | CLOSE |
| D. | All mentioned above |
| Answer» E. | |
| 73. |
To handle raised exceptions, you write separate routines called exception handlers. |
| A. | Yes |
| B. | No |
| Answer» B. No | |
| 74. |
To call a subprogram directly, users must have the EXECUTE privilege on that subprogram. By granting the privilege, you allow a user to - |
| A. | Call the subprogram directly |
| B. | Compile functions and procedures that call the subprogram |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 75. |
The variables or expressions passed from the calling subprogram are - |
| A. | Actual Parameters |
| B. | Formal Parameters |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Formal Parameters | |
| 76. |
The values of any IN OUT parameters are copied before the subprogram is executed. |
| A. | Yes |
| B. | No |
| Answer» B. No | |
| 77. |
The subprogram is called through a database link or as an external procedure. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 78. |
The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored. |
| A. | Along with the row |
| B. | Outside the row |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Outside the row | |
| 79. |
The keyword All is a shorthand way to refer to all warning messages. |
| A. | Yes |
| B. | No |
| Answer» B. No | |
| 80. |
The DBMS_SQL package should be used in which of the following situations? |
| A. | 15. There is an unknown number of input or output variables, such as the number of column values returned by a query, that are used in a dynamic SQL s |
| B. | The dynamic code is too large to fit inside a 32K bytes VARCHAR2 variable. |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 81. |
The constructs of a procedure, function or a package are ________ . |
| A. | Variables and Constants |
| B. | Cursors |
| C. | Exceptions |
| D. | All mentioned above |
| Answer» E. | |
| 82. |
The comparison methods are used for comparing objects. How many ways are available for comparing objects? |
| A. | 4 |
| B. | 1 |
| C. | 2 |
| D. | 5 |
| Answer» D. 5 | |
| 83. |
The CLOSE statement enables a cursor variable and makes the associated result set undefined. |
| A. | True |
| B. | False |
| Answer» C. | |
| 84. |
The BINARY_INTEGER and PLS_INTEGER datatypes are not identical. |
| A. | True |
| B. | False |
| Answer» C. | |
| 85. |
The AUTONOMOUS_TRANSACTION pragma changes the way a subprogram works within a transaction. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 86. |
Pragmas are processed at ___________ . |
| A. | Run time |
| B. | Compile time |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 87. |
PL/SQL stands for - |
| A. | Programming Language/SQL |
| B. | Procedural Language/SQL |
| C. | Portable Language/SQL |
| D. | None of the above |
| Answer» C. Portable Language/SQL | |
| 88. |
PL/SQL stored procedures move application code from the server to the client. |
| A. | True |
| B. | False |
| Answer» C. | |
| 89. |
PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 90. |
PL/SQL provides many powerful functions to help you manipulate data. These built-in functions fall into which of these following categories? |
| A. | Error reporting,Character, Datatype conversion |
| B. | Number,Date,Object reference |
| C. | Miscellaneous |
| D. | All mentioned above |
| Answer» E. | |
| 91. |
PL/SQL provides a feature to handle the Exceptions which occur in a PL/SQL Block known as exception Handling. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 92. |
PL/SQL programs are written as lines of text using a specific set of characters. |
| A. | Upper- and lower-case letters A .. Z and a .. z |
| B. | Numerals 0 .. 9 |
| C. | Symbols ( ) + - * / < > = ! ~ ^ ; : . ' @ % , " # $ & _ | { } ? [ ] |
| D. | Tabs, spaces, and carriage returns |
| E. | All mentioned above |
| Answer» F. | |
| 93. |
PL/SQL packages are schema objects that group logically related PL/SQL types, variables and subprograms. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 94. |
PL/SQL keywords are not case-sensitive. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 95. |
PL/SQL is completely portable, high-performance transaction processing language that offers which of the following advantages - |
| A. | Tight Integration with SQL |
| B. | Better Performance |
| C. | Higher Productivity,Full Portability,Tight Security |
| D. | All mentioned above |
| Answer» E. | |
| 96. |
PL/SQL is a transaction processing procedural language that has which of the following advantages? |
| A. | Integration with database |
| B. | Better Performance |
| C. | Higher Productivity |
| D. | Portability |
| E. | All mentioned above |
| Answer» F. | |
| 97. |
PL/SQL is a completely portable, high-performance transaction processing language. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 98. |
PL/SQL has two types of subprograms, procedures and functions. Which subprogram is used to compute a value? |
| A. | Procedure |
| B. | Function |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 99. |
PL/SQL Expressions are constructed using. |
| A. | Operands |
| B. | Operators |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 100. |
PL/SQL Exception message consists of - |
| A. | Type of Exception |
| B. | An Error Code |
| C. | A message |
| D. | All mentioned above |
| Answer» E. | |