question What is the purpose of the SQL Server AVG function

Which SQL command is used to update data in a table?

A. UPDATE
B. MODIFY
C. CHANGE
D. SET

What is the purpose of the Oracle DBMS_SCHEDULER package?

A. Perform data manipulation tasks
B. Schedule and manage jobs, including PL/SQL blocks and stored procedures
C. Calculate the average value
D. Create database links

In SQL Server, what is the purpose of the CROSS JOIN clause?

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. Generates the Cartesian product of two tables

What is the purpose of the SQL Server AVG() function?

A. Find the average value
B. Find the total number of rows
C. Find the highest value
D. Find the lowest value

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;

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

In SQL Server, what is the purpose of the HAVING clause?

A. Filter rows
B. Sort the result set
C. Filter groups
D. Combine rows into groups

Which SQL Server statement is used to grant all privileges to a user?

A. GRANT ALL PRIVILEGES
B. GRANT FULL ACCESS
C. GRANT SUPERUSER
D. GRANT ALL RIGHTS

In SQL Server, what does the term "ACID" stand for in the context of transactions?

A. Atomicity, Consistency, Isolation, Durability
B. Association, Consistency, Isolation, Dependency
C. Atomicity, Consistency, Integration, Durability
D. Association, Commitment, Isolation, Dependency

In Oracle, what is the purpose of the BITAND() function?

A. Concatenate multiple values
B. Perform bitwise AND operation on two numbers
C. Calculate the average value
D. Round numeric values

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise