question In MySQL which type of index allows only unique values and nulls are considered distinct

Which statement is used to remove all records from a table in MySQL?

A. DELETE FROM table;
B. REMOVE * FROM table;
C. TRUNCATE TABLE table;
D. DROP TABLE table;

In Oracle, what is the purpose of the BETWEEN operator?

A. Filter rows based on a range of values
B. Sort the result set
C. Combine rows into groups
D. Search for a specified pattern in a column

Which Oracle statement is used to grant execute permissions on a stored procedure?

A. GRANT EXECUTE
B. GRANT EXECUTION
C. ALLOW EXECUTE
D. ALLOW EXECUTION

What does SQL stand for?

A. Structured Language
B. Standard Query Language
C. Sequential Query Language
D. Simple Question Language

In Oracle, what is the purpose of the WITH clause?

A. Combine rows from two or more tables
B. Create a temporary result set for use in a SELECT statement
C. Sort the result set
D. Join multiple tables

Which MySQL data type is used to store a fixed-length string?

A. VARCHAR
B. CHAR
C. TEXT
D. BLOB

What does the SQL INNER JOIN clause do?

A. Combines rows from two or more tables
B. Retrieves all rows from a table
C. Retrieves rows that have no matching rows in the other table
D. Excludes specified rows

Which SQL Server statement is used to add a new row to a table?

A. INSERT INTO
B. ADD ROW
C. NEW ROW
D. CREATE ROW

In SQL Server, what is the purpose of the PI constant?

A. Mathematical constant representing the ratio of a circle's circumference to its diameter
B. Numeric constant representing the speed of light
C. Constant representing the number of days in a year
D. Constant representing the number of seconds in a minute

In SQL Server, what is the purpose of the PARSE() function?

A. Concatenate multiple columns
B. Parse a string into a specified data type
C. Calculate the average value
D. Generate a sequence of numbers

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise