databases Online Quiz - 131
Description: databases Online Quiz - 131 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
If the below block, when you execute then what will be the output? Begin Null; Exception When others then Dbms_output.put_line(‘ I am in Others Exception’); When no_data_found then Dbms_output.put_line(‘ I am in no data found Exception’); End;
What are the different methods for passing parameters to Procedure?
How can you find within a PL/SQL block, if a cursor is open?
What is the use of %ROWTYPE in PL/SQL?
What is the maximum number of columns in table or view in Oracle?
Raw types are used to store _________ data.
SQL has facility for programmed handling of errors that arise during the manipulation of data.
In a PL/SQL block structure, which parts are optional?
Which of the following are not operators you can use in a math formula within a SQL statement?
What is the proper syntax for assigning a column alias?
Which of the following are reasonable series of transaction-control commands?
Which of the following shows the wildcards for a single character and multiple characters, respectively?
Which statement below is true?
A trigger is a special type of stored procedure that is executed by the SQL Server when an Insert, Modify or Delete operation is performed Against a given table.
Stored procedures are the way to create routines and procedures that are run on the server.