How can you generate debugging output from PL/SQL?

Correct Answer: By use of %ISOPEN status variable

Correct Answer: Cursor_Already_Open, Invalid_Cursor

Correct Answer: Too_many_rows No_Data_Found Zero_Error

Correct Answer: PL/SQL tables are scalar arrays that can be referenced by a binary digit They can be used to store values for later queries and calculations

Correct Answer: An SQL statement is a string of characters that conforms to the syntax and format specified in the international standard A query is a statement that returns a record-set

Correct Answer: Similarity: Both WHERE and HAVING Clause filters out records based on one or more conditions Difference: WHERE Clause can only be applied to a static non-aggregated column whereas HAVING is needed for aggregated columns

Correct Answer: A default is a value which will be used by a column, if no value is supplied to that column while inserting data Yes, IDENTITY and TIMESTAMP columns are free from the bounds of default

Correct Answer: Constraints enable the RDBMS to enforce the integrity of the database automatically, without the need to create triggers, rule or defaults Types of Constraints: NOT NULL, CHEQUE, UNIQUE, PRIMARY KEY, FOREIGN KEY

Correct Answer: By default, primary key creates a clustered index on the column, whereas a unique key creates a non clustered index by default

Correct Answer: - A clustered index is a special type of index that reorders the way records in the table are physically stored Therefore table can have only one clustered index The leaf nodes of a clustered index contain the data pages - A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk The leaf node of a non clustered index does not consist of the data pages Instead, the leaf nodes contain index rows