PL SQL MCQ Questions 8
Which statement is package specification or body of a stored subprogram?
- Package Specification only requires recompilation
- Package body only requires recompilation
- Both package & body requires recompilation
- Both package & body does not require recompilation.
Ans : 1
The packaged procedure that makes data in form permanent in the Database is
- Post
- Post form
- Commit form
- None of the above
Ans : 3
Which of the following do not execute multiple PL/SQL programs simultaneously?
- Oracle Advanced Queuing
- DBMS_JOB
- DBMS_SQL
- Pipelined Functions
Ans : 3
Which package can you use to output values and messages stored procedures?
- DBMS_DISPLAY
- DBMS_OUTPUT
- DBMS_LIST
- DBMS_DESCRIBE
Ans : 2
Which of the package statement is true?
- Packages can be nested.
- You can pass parameters to packages.
- A package is loaded into memory each time it is invoked.
- The contents of packages can be shared by many applications.
Ans : 4
Attend Free Demo and Learn SQL SERVER ONLINE TRAINING by Real-Time Expert
Which state of a package variable after executing the package is declared?
- It persists across transactions within a session.
- It persists from session to session for the same user.
- It does not persist across transaction within a session.
- It persists from user to user when the package is invoked.
Ans : 1
What can you do with the DBMS_LOB package?
- WRITE procedure to write data to a BFILE.
- BFILENAME function to locate an external BFILE.
- FILEEXISTS function to find the location of a BFILE.
- FILECLOSE procedure to close the file being accessed.
Ans : 4
Which Package use database triggers to application when specific db values change?
- DBMS_OUTPUT
- DBMS_ALERT
- DBMS_PIPE
- All mentioned above
Ans : 2
What function you are using to load the data in UTL_FILE package?
- Fopen()
- file_open()
- isopen()
- fileopen()
Ans : 1
Which is not in UTL_FILE function?
- FOPEN()
- File_CLOSE()
- FCOPY()
- FFLUH()
Ans : 2
Attend Free Demo and Learn SQL SERVER ONLINE TRAINING by Real-Time Expert
Can we load the data from table to table through utl_file package?
- Yes
- No
- Depends upon
- Invalid option
Ans : 1
What is the disadvantage of Packages?
- Memory wastage
- Performance
- data Hiding
- modularity
Ans : 1
Pl/sql packages supports polymorphism?
- True
- False
- Depends upon
- Invalid option
Ans : 1
PL/SQL package consists of?
- Datatypes
- columns
- tables
- synonyms
Ans : 3
How can you generate debugging output from PL/SQL?
- DBMS_SQL
- DBMS_OUTPUT
- DBMS_PIPE
- DBMS_LOB
Ans : 2
Attend Free Demo and Learn SQL SERVER ONLINE TRAINING by Real-Time Expert
Which is oracle supplied package?
- DBMS_SQL
- DB_ORACLE
- DB_SQl
- DBMS_OBJ
Ans : 1
Which of the following procedures of DBMS_SQL supports bulk DML operations?
- BIND_VARIABLE_CHAR
- BIND_VARIABLE_RAW
- BIND_ARRAY
- BIND_VARIABLE
Ans : 3
How STANDARD Package Defines the PL/SQL Environment?
- The package specification declares public types, variables, subprograms
- The package specification declares private
- A & B
- None of the above
Ans : 1
A __________ is a special kind of a store procedure that executes in response to certain actions.
- Procedures
- Triggers
- Functions
- None of the mentioned
Ans : 2
Under which circumstance do you design database triggers?
- To duplicate the functionality of other triggers.
- To replicate built-in constraints in the Oracle server such as primary key and foreign key.
- When a specific operation is performed, related actions are performed.
- None of the above
Ans : C
Attend Free Demo and Learn SQL SERVER ONLINE TRAINING by Real-Time Expert
What is a condition predicate in a DML trigger?
- Specify a WHEN-LOGGING-ON condition in the trigger body.
- Use the NEW and OLD qualifiers in the trigger body as a condition.
- Combine several DBM triggering events into one in the trigger body.
- Specify a SHUTDOWN or STARTUP condition in the trigger body.
Ans : 3
Which of the following is true concerning triggers?
- You do not create them with SQL.
- They execute against only some applications that access a database.
- They have an event, condition, and action.
- They cannot cascade (cause another trigger to fire).
Ans : 3
What is the maximum number of triggers that can apply to a single table?
- 14
- 10
- 12
- 16
Ans : 3
Attend Free Demo and Learn SQL SERVER ONLINE TRAINING by Real-Time Expert
Read More PL/SQL Objective Questions and Answers