Database and SQL

OTHERS exception is raised when all other expections fail to catch the errors.

This is the correct option as this function truncates the input number upto one decimal place.

Group by clause can be used along with aggregate functions like sum, count, avg, etc. to group the records from a table.

This would be the default output as the pattern specified with the function is not available on the left-side of the input.

This join eliminates one of the identical column from the two tables joined.

View is a virtual table that draws its data from the result of an SQL SELECT statement.

This is an outer join operator in SQL along with normal addition operator.

This command is used to grant object privileges to other users.

This function returns last day of the month from the current date or date specified by the user.

Database triggers are used to define code that is executed / fired when certain actions or events occur.

An outer join selects all the rows from one table whether they have corresponding matching rows in another table or not.

This block contains an executable code that are executed when the program is run.

This type of join in relation algebra is used to join a table to itself if the table were two tables and temporarily renaming at least one table in the SQL statement.

Collision occurs in internal hashing, when the hash field value of a record that is being inserted hashes to an address that already contains a different record.

This integrity constraint in database is also called attribute integrity that allows size values, right data type and null status, etc.