MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
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 | |
| 2. |
PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
Which of the following executes the query and identifies the result set, consisting of all rows that meet the query search criteria. |
| A. | Fetching with a Cursor |
| B. | Opening a cursor |
| C. | Fetching bulk data with a cursor |
| D. | None of the above |
| Answer» C. Fetching bulk data with a cursor | |
| 4. |
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 | |
| 5. |
WRAP command is used to encrypt a PL/SQL application. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
Oracle-supplied package called DBMS_LOB is used to manipulate the LOB objects. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
Which structure executes a sequence of statements repeatedly as long as a condition holds true? |
| A. | Selection structure |
| B. | Iteration structure |
| C. | Sequence structure |
| D. | None of the above |
| Answer» C. Sequence structure | |
| 8. |
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. | |
| 9. |
PL/SQL packages are schema objects that group logically related PL/SQL types, variables and subprograms. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
Can BOOLEAN datatype be used in functions that are called from SQL statements? |
| A. | Yes |
| B. | No |
| Answer» C. | |
| 11. |
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 | |
| 12. |
What is the maximum number of ELSE clauses that can be included in an IF clause that is not nested? |
| A. | 1 |
| B. | 0 |
| C. | 15 |
| D. | Any number |
| Answer» B. 0 | |
| 13. |
A RECORD is a collection of data items, which differ from each other in data type, but are logically related. |
| A. | True |
| B. | False |
| Answer» B. False | |