Database and SQL

This statement is used to add methods but not attributes to an object type stored in the database.

The align attribute was commonly used with multiple HTML elements including paragraphs (p), horizontal rules (hr), and tables (table) to control horizontal positioning of content.

Delimiter is a simple or compound symbol that has a special meaning to PL/SQL.

Identifier is used to name PL/SQL program, objects and units

A loop repeats a sequence of statements.

GOTO statement allows you to change the flow of control within a PL/SQL block.

NO_DATA_FOUND is raised when a select statement returns zero rows.

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.