question Which SQL Server statement is used to change the structure of an existing table

Database

Which SQL Server statement is used to change the structure of an existing table?

A. MODIFY TABLE
B. CHANGE TABLE
C. ALTER TABLE
D. UPDATE TABLE

'ALTER TABLE' is used to change the structure of an existing table in SQL Server.

In SQL Server, what is the purpose of the XML data type?

A. Stores XML data
B. Stores binary data
C. Stores integer values
D. Stores a list of values

Which SQL statement is used to create a new table in a database?

A. CREATE TABLE
B. NEW TABLE
C. ADD TABLE
D. INSERT TABLE

What is the purpose of the Oracle SYS_GUID() function?

A. Generate a random globally unique identifier
B. Concatenate multiple columns
C. Calculate the average value
D. Round numeric values

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

Which Oracle statement is used to grant specific privileges to a user?

A. ALLOW PRIVILEGES
B. GRANT PRIVILEGES
C. GRANT
D. ALLOW ACCESS

What is the purpose of the SQL UNION operator?

A. Combine rows from two or more tables
B. Sort the result set
C. Combine rows into groups
D. Join multiple tables

In SQL Server, what is the purpose of the SQL Server FLOAT data type?

A. Stores binary data
B. Stores integer values
C. Stores floating-point numbers
D. Stores a list of values

Which SQL Server statement is used to remove a user's privileges?

A. REMOVE PRIVILEGES
B. DELETE PRIVILEGES
C. DROP PRIVILEGES
D. REVOKE

In MySQL, what is the purpose of the CASCADE keyword in a FOREIGN KEY constraint?

A. Automatically adds a new row
B. Automatically updates or deletes related rows
C. Allows NULL values
D. Sorts values in ascending order

Which MySQL statement is used to create a unique constraint on a column?

A. UNIQUE
B. ADD UNIQUE
C. CONSTRAINT UNIQUE
D. CREATE CONSTRAINT