How can you find a PL/SQL block, if the cursor is open?

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

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

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