Oracle - I/O and PL/SQL MCQ

Oracle – I/O and PL/SQL

1 / 25

1. How can you enable DBMS_OUTPUT for displaying information in PL/SQL?

Execute SET SERVEROUTPUT ON;

Execute DBMS_DEBUG.

Use the DBMS_PRINT package.

Execute DBMS_DISPLAY_OUTPUT;

2 / 25

2. What is the primary purpose of the UTL_FILE_DIR parameter in Oracle?

To enable DBMS_OUTPUT

To specify the directory for UTL_FILE operations

To configure network security

To retrieve file attributes

3 / 25

3. To work with files in PL/SQL, what must you do before using UTL_FILE functions?

Install the UTL_FILE package

Enable DBMS_OUTPUT

Create a directory object in Oracle

Configure network security

4 / 25

4. Which operation is used to check if a file is already open in PL/SQL using UTL_FILE?

NOFILE_CHECK

OPEN_FILE

FILE_EXISTS

IS_FILE_OPEN

5 / 25

5. What is the primary function of the UTL_FILE.FOPEN procedure in PL/SQL?

To write data to a file

To check if a file exists

To read data from a file

To open a file for I/O operations

6 / 25

6. Which procedure is used to close an open file in PL/SQL when working with UTL_FILE?

UTL_FILE.CLOSE

CLOSE_FILE

FILE_CLOSE

OPEN_CLOSE

7 / 25

7. What does the UTL_FILE.FCLOSE procedure do in PL/SQL?

Closes an open file

Reads data from a file

Deletes a file

Writes data to a file

8 / 25

8. How can you read data from a file in PL/SQL using UTL_FILE?

Use the FREAD procedure

Use the FDELETE procedure

Use the FCLOSE procedure

Use the FWRITE procedure

9 / 25

9. What operation does the UTL_FILE.FWRITE procedure perform in PL/SQL?

Closes an open file

Reads data from a file

Deletes a file

Writes data to a file

10 / 25

10. What is the primary purpose of the UTL_FILE.FCOPY procedure in PL/SQL?

To delete a file

To read data from a file

To copy a file

To close a file

11 / 25

11. What operation does the UTL_FILE.FREMOVE procedure perform in PL/SQL?

Reads data from a file

Deletes a file

Closes an open file

Writes data to a file

12 / 25

12. What is the primary function of the UTL_FILE.FRENAME procedure in PL/SQL?

To close a file

To rename a file

To write data to a file

To read data from a file

13 / 25

13. How can you retrieve file attributes in PL/SQL using UTL_FILE?

Use the FCLOSE procedure

Use the FINFO procedure

Use the FOPEN procedure

Use the FATTR procedure

14 / 25

14. Which package in PL/SQL is used for sending email?

UTL_MAIL

DBMS_MAIL

DBMS_EMAIL

DBMS_OUTBOUND

15 / 25

15. What is a prerequisite for sending email in Oracle?

Enabling DBMS_OUTPUT

Creating a directory object

Configuring network security

Installing the DBMS_EMAIL package

16 / 25

16. What is one method to send a plain-text message of arbitrary length in PL/SQL email?

Use the UTL_SMTP package

Use UTL_MAIL with attachments

Use the DBMS_MAIL package

Use the DBMS_OUTPUT.PUT_LINE procedure

17 / 25

17. How can you send a message with a short (32,767 bytes or less) attachment via PL/SQL email?

Use UTL_SMTP

Use DBMS_MAIL

Use UTL_MAIL

Use DBMS_OUTBOUND

18 / 25

18. What is the primary purpose of the UTL_HTTP package in PL/SQL?

To send email

To retrieve web-based data

To manage network security

To work with files

19 / 25

19. How can you retrieve a web page into a LOB in PL/SQL using UTL_HTTP?

Use the UTL_FILE package

Use the DBMS_OUTPUT.PUT_LINE procedure

Use the UTL_HTTP.REQUEST procedure

Use the UTL_SMTP package

20 / 25

20. What does the UTL_HTTP.AUTHENTICATE procedure in PL/SQL allow you to do?

Send emails

Work with LOBs

Authenticate using HTTP username/password

Retrieve web pages

21 / 25

21. What protocol is used for retrieving an SSL-encrypted web page (via HTTPS) in PL/SQL using UTL_HTTP?

SMTP

HTTP

FTP

HTTPS

22 / 25

22. What is the primary purpose of the UTL_HTTP.SET_WALLET procedure in PL/SQL?

To retrieve web pages

To send emails

To authenticate using HTTP username/password

To configure network security

23 / 25

23. How can you retrieve data from an FTP server in PL/SQL using UTL_TCP?

Use the UTL_SMTP package

Use the UTL_TCP package

Use the UTL_HTTP package

Use the UTL_FILE package

24 / 25

24. Which operation does the UTL_TCP.SET_PROXY procedure perform in PL/SQL?

Sends emails

Configures network security

Retrieves web pages

Uses a proxy server

25 / 25

25. What types of I/O are available in PL/SQL beyond file operations and email?

TCP sockets

Database triggers

Database procedures

Database pipes, queues, and alerts

Your score is

0%

Oracle – I/O and PL/SQL MCQ