What part of a databse trigger determine the number of times the trigger body excutes?

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?

I have just now created sequence abc and If you immediately run the below select statement , what is the output? CREATE SEQUENCE abc MINVALUE 1 MAXVALUE 10 START WITH 1 INCREMENT BY 1 CACHE 20 Select abc.currval from dual;

What is the maximum number of columns in table or view in Oracle?

What are the Sql Cursor Attributes in Pl/sql?

Raw types are used to store _________ data.

SQL has facility for programmed handling of errors that arise during the manipulation of data.

_________ data type stores unstructured binary data upto 4GB length.

In a PL/SQL block structure, which parts are optional?

Under which two circumstances do you design database triggers? (Choose two)

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.