Database and SQL

This part of the trigger is the procedure that contains the SQL statements and code to be run when a trigger statement is issued.

Sets of dictionary tables are created once the database is created.

The executeUpdate(String s) method in JDBC returns an integer value representing the number of rows affected by the SQL operation (INSERT, UPDATE, DELETE). For CREATE TABLE or similar DDL statements, it typically returns 0.

Multi-query optimisation is a methodology of optimising a group of SQL queries with the help of common sub-expressions to save cost and time.

SQL's SELECT statement implements the three fundamental relational operations: selection (choosing rows based on conditions via WHERE), projection (choosing columns via SELECT), and join (combining data from multiple tables via JOIN). Difference and intersection are other set operations, not the primary SELECT operations described.

rowUpdated() method is present in the ResultSet interface and it retrieves whether the current row in the table has been updated or not. So, this is the correct choice.

rowInserted() method is present in the ResultSet interface and it retrieves whether the current row has had an insertion or not. So, this answer is correct.

This is the correct answer because getMaxColumnsInTable() method is defined in the DatabaseMetaData interface and it retrieves the maximum number of columns this database allows in a table.

This is the correct choice because getMaxColumnNameLength() method is defined in the DatabaseMetaData interface and it retrieves the maximum number of characters this database allows for a column name.

This is the correct answer because refreshRow() method is defined in the ResultSet interface and it refreshes the current row with its most recent value in the database.

Salary may be same for more than two employees. Hence, it cannot be a primary key

This is a methodology of optimising a group of SQL queries.

This type of anomaly occurs in DBMS when inconsistencies arise due to the removal of record from a relation.

This is the correct answer.

This technique enables you to embed large piece of text in your script which may include lots of double quotes and single quotes without having to constantly escape them.