What is the outcome on execution?

The STRING_TAB table has the following structure: View the Exhibit and examine the code. What is the outcome on execution? A. It displays Output buffer not long enough. This is my test string.-. B. It displays only Output buffer not long enough, and exits the anonymous block. C. It displays only This is my test […]

Read More

Why does the code give an error on execution?

View the Exhibit and examine the code. Why does the code give an error on execution? A. because the WORD_LIST variable is not visible in procedure wording B. because the lexicon variable is not visible in procedure ADD_ENTRY C. because the lexicon variable is not initialized in procedure wording D. because the WORD_LIST parameter in […]

Read More

Which two statements are true about the instead of triggers?

Which two statements are true about the instead of triggers? (Choose two.) A. Delete operations cannot be performed using the instead of triggers. B. The instead or triggers must be created to add or modify data through any view. C. The instead of triggers can be written only for views, and the before and after […]

Read More

What is the outcome when the above code is executed?

View the Exhibit and examine the structure of the employees table. Examine the following block of code: What is the outcome when the above code is executed? A. It executes successfully. B. It gives an error because decode cannot be used in a PL/SQL block. C. It gives an error because the AVG function cannot […]

Read More

Which two statements are true about the above function?

Examine the following code: Which two statements are true about the above function? (Choose two.) A. It can be used only in a parallelized query. B. It can be used in both a parallelized query and a parallelized DML statement. C. It can be used only in a parallelized data manipulation language (DML) statement. D. […]

Read More

What is the outcome?

/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder. Examine the following commands that are executed by the DBA: SQL>CREATE DIRECTION my_dir AS `/temp/my_files’: SQL>GRANT READ ON DIRECTORY my_dir To public: View the Exhibit and examine the procedure created by user SCOTT to read the list of […]

Read More