Angular MCQ Questions and Answers

USER()

LOGIN_NAME()

SESSION_USER()

Counts the total number of rows in a table

Retrieves the last row in a result set

Assigns a unique identifier to each row in a table

PATTERN BY

MATCHING

PATTERN MATCH

Flushes the contents of a table

Deletes all privileges from a user

Flushes the query cache

Returns the average value of the arguments

Concatenates the arguments into a single string

Adds up all the arguments

SORT DESC

DESCENDING

REVERSE ORDER

Specifies the range of rows to include in the window function from the current
row to the end

Excludes the current row from the window function

Specifies the range of rows to include in the window function from the start to
the end

Shows all warnings in the database

Lists all columns with warning messages

Clears all warning messages

SQR()

ROOT()

POWER()

Sets the isolation level of the current transaction

Retrieves the current users login name

Changes the collation of the current session

INSERT COLUMN

CREATE COLUMN

ALTER COLUMN

Deletes data from a table

Loads data into a temporary table

Inserts a new record into a table

Converts a string to uppercase

Adds two binary numbers

Converts a string to lowercase