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.
| 1. |
Which operations cannot be performed on cursor expressions? |
| A. | BIND |
| B. | EXECUTE |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 2. |
Which Operator Returns TRUE if a subquery returns at least one row? |
| A. | EXISTS |
| B. | IN |
| C. | IS NULL |
| D. | LIKE |
| Answer» B. IN | |
| 3. |
Which operator tests set membership? |
| A. | IN Operator |
| B. | BETWEEN Operator |
| C. | LIKE Operator |
| D. | IS NULL Operator |
| Answer» B. BETWEEN Operator | |
| 4. |
Which operators combine the results of two queries into one result? |
| A. | Set operator |
| B. | Row Operator |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Row Operator | |
| 5. |
Which Package lets you use database triggers to alert an application when specific database values change? |
| A. | DBMS_OUTPUT |
| B. | DBMS_ALERT |
| C. | DBMS_PIPE |
| D. | All mentioned above |
| Answer» C. DBMS_PIPE | |
| 6. |
Which package lets PL/SQL programs read and write operating system (OS) text files? |
| A. | UTL_HTTP |
| B. | UTL_FILE |
| C. | UTL_SMTP |
| D. | None of the above |
| Answer» C. UTL_SMTP | |
| 7. |
Which parameter acts like a constant inside the subprogram? |
| A. | IN |
| B. | OUT |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. OUT | |
| 8. |
Which PL/SQL warning categories gives Messages for conditions that do not have an effect on performance or correctness, but that you might want to change to make the code more maintainable, such as unreachable code that can never be executed? |
| A. | PERFORMANCE |
| B. | SEVERE |
| C. | INFORMATIONAL |
| D. | All mentioned above |
| Answer» D. All mentioned above | |
| 9. |
Which statement associates a cursor variable with a multi-row query, executes the query, and identifies the result set? |
| A. | OPEN-FOR |
| B. | FETCH |
| C. | CLOSE |
| D. | All mentioned above |
| Answer» B. FETCH | |
| 10. |
Which statement chooses from a sequence of conditions, and executes a corresponding statement? |
| A. | CASE Statement |
| B. | CLOSE Statement |
| C. | COMMIT Statement |
| D. | None of the above |
| Answer» B. CLOSE Statement | |
| 11. |
Which statement lets you create standalone functions that are stored in an Oracle database? |
| A. | SQL CREATE PROCEDURE |
| B. | SQL CREATE FUNCTION |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 12. |
Which statements are used to control a cursor variable? |
| A. | OPEN-FOR |
| B. | FETCH |
| C. | CLOSE |
| D. | All mentioned above |
| Answer» E. | |
| 13. |
Which statements execute a sequence of statements multiple times? |
| A. | LOOP statement |
| B. | NULL statement |
| C. | MERGE statement |
| D. | None of the above |
| Answer» B. NULL statement | |
| 14. |
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 | |
| 15. |
Which subtypes are used to declare fixed-point numbers with a maximum precision of 38 decimal digits? |
| A. | INTEGER,INT,SMALLINT |
| B. | DOUBLE PRECISION,FLOAT |
| C. | DEC,DECIMAL,NUMERIC |
| D. | None of the above |
| Answer» D. None of the above | |
| 16. |
Which type of cursor is automatically declared by Oracle every time an SQL statement is executed? |
| A. | An Implicit |
| B. | An Explicit |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. An Explicit | |
| 17. |
With PL/SQL, it is very simple to issue a query, retrieve each row of the result into a %ROWTYPE record, and process each row in a loop. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 18. |
WRAP command is used to encrypt a PL/SQL application. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 19. |
You can pass parameters to procedures or functions in a package. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 20. |
You can use the BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store values from each column of a query's result set in a separate collection. |
| A. | Yes |
| B. | No |
| Answer» B. No | |
| 21. |
You can use the BULK COLLECT INTO clause with the FETCH statement to store values from each column of a cursor in a separate collection. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 22. |
You can use the RETURNING BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store the results of which statements in a set of collections? |
| A. | INSERT |
| B. | UPDATE |
| C. | DELETE |
| D. | All mentioned above |
| Answer» E. | |
| 23. |
You use cursor variables to pass query result sets between PL/SQL stored subprograms and various clients. |
| A. | Yes |
| B. | No |
| Answer» B. No | |
| 24. |
Which of the following returns the current value in a specified sequence. |
| A. | CURRVAL |
| B. | NEXTVAL |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. NEXTVAL | |
| 25. |
Which of the following returns the current error message text? |
| A. | SQLERRM |
| B. | SQLCODE |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. SQLCODE | |
| 26. |
Which of the following returns all distinct rows selected by either query? |
| A. | INTERSECT |
| B. | MINUS |
| C. | UNION |
| D. | UNION ALL |
| Answer» D. UNION ALL | |
| 27. |
Which of the following results are true, when a ROLLBACK statement is issued to the database, the transaction has ended? |
| A. | All work done by the transaction is undone, as if it hadn't been issued. |
| B. | Any locks acquired by the transaction are released. |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 28. |
Which of the following provides a way for your program to select multiple rows of data from the database and then process each row individually. |
| A. | PL/SQL Cursors |
| B. | PL/SQL Trigger |
| C. | PL/SQL Select |
| D. | PL/SQL Process |
| Answer» B. PL/SQL Trigger | |
| 29. |
Which of the following is used to define code that is executed / fired when certain actions or event occur? |
| A. | Replace |
| B. | Keyword |
| C. | Trigger |
| D. | Cursor |
| Answer» D. Cursor | |
| 30. |
Which of the following is used to declare a record? |
| A. | %ROWTYPE |
| B. | %TYPE |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. %TYPE | |
| 31. |
Which of the following is used for reading and writing operating-system files? |
| A. | UTL_FILE |
| B. | UTL_HTTP |
| C. | UTL_SMTP |
| D. | None of the above |
| Answer» B. UTL_HTTP | |
| 32. |
Which of the following is not a schema object? |
| A. | Packages |
| B. | Indexes |
| C. | Public Synonyms |
| D. | Triggers |
| Answer» D. Triggers | |
| 33. |
Which of the following is handled with the help of exception-handling section in an PL/SQL block. For eg, SELECT INTO statement, which does not return any rows. |
| A. | A runtime error |
| B. | A syntax error |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. A syntax error | |
| 34. |
Which of the following is an explicit numeric, character, string, or BOOLEAN value not represented by an identifier? |
| A. | Delimiters |
| B. | Literals |
| C. | Comments |
| D. | None of the above |
| Answer» C. Comments | |
| 35. |
Which of the following is a group of related data items stored in fields, each with its own name and datatype? |
| A. | A Record |
| B. | A Collection |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. A Collection | |
| 36. |
Which of the following has internal components that can be manipulated individually, such as the elements of an array, record, or table? |
| A. | A Composite |
| B. | A LOB |
| C. | A Reference |
| D. | A Scalar |
| Answer» B. A LOB | |
| 37. |
Which of the following has a return type in its specification and must return a value specified in that type? |
| A. | Function |
| B. | Procedure |
| C. | Package |
| D. | None of the above |
| Answer» B. Procedure | |
| 38. |
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 | |
| 39. |
Which of the following declares an instance of an object type? |
| A. | record_declaration |
| B. | procedure_declaration |
| C. | object_declaration |
| D. | None of the above |
| Answer» D. None of the above | |
| 40. |
Which of the following combines the data manipulating power of SQL with the data processing power of Procedural languages? |
| A. | PQL |
| B. | Advanced SQL |
| C. | PL/SQL |
| D. | SQL |
| Answer» D. SQL | |
| 41. |
Which of the following cannot be used with associative arrays? |
| A. | EXTEND |
| B. | TRIM |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 42. |
Which of the following are used for displaying output on a web page? |
| A. | HTF |
| B. | HTP |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 43. |
Which of the following are the advantages of PL/SQL Packages? |
| A. | Modularity |
| B. | Easier Application Design |
| C. | Information Hiding |
| D. | Added Functionality,Better Performance |
| E. | All mentioned above |
| Answer» F. | |
| 44. |
Which methods implement some internal logic for comparing two objects? For example, a rectangle is bigger than another rectangle if both its sides are bigger. |
| A. | Order method |
| B. | Map method |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Map method | |
| 45. |
Which keyword is used instead of the assignment operator to initialize variables? |
| A. | NOT NULL |
| B. | DEFAULT |
| C. | %TYPE |
| D. | %ROWTYPE |
| Answer» C. %TYPE | |
| 46. |
Which keyword and parameter used for declaring an explicit cursor? |
| A. | constraint |
| B. | cursor_variable_declaration |
| C. | collection_declaration |
| D. | cursor_declaration |
| Answer» E. | |
| 47. |
Which is a simple or compound symbol that has a special meaning to PL/SQL? |
| A. | Delimiters |
| B. | Identifiers |
| C. | Literals |
| D. | Comments |
| Answer» B. Identifiers | |
| 48. |
Which is a schema object that groups logically related PL/SQL types, items, and subprograms? |
| A. | Package Declaration |
| B. | Object_type declaration |
| C. | Procedure declaration |
| D. | None of the above |
| Answer» B. Object_type declaration | |
| 49. |
Which is a procedural extension of Oracle- SQL that offers language constructs similar to those in imperative programming languages? |
| A. | PQL |
| B. | Advanced SQL |
| C. | PL/SQL |
| D. | SQL |
| Answer» D. SQL | |
| 50. |
Which is a database object that groups logically related PL/SQL types, objects and subprograms? |
| A. | Package |
| B. | Module |
| C. | Body |
| D. | Name |
| Answer» B. Module | |