What are PL/SQL cursor exceptions?

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: SELECT *FROM Employees WHERE EmpName like ?M%?

Correct Answer: Trigger allows us to execute a batch of SQL code when an insert, update or delete command is executed against a specific table Triggers are special types of stored procedures that are defined to execute automatically in place of or after data modifications They can be executed automatically on the insert, delete and update operation

Correct Answer: By use of %ISOPEN status variable

Correct Answer: Use the DBMS_OUTPUT package Another possible method is to use the SHOW ERROR command

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