question Which statement is used to delete records from a table in SQL Server

Database

Which statement is used to delete records from a table in SQL Server?

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

'DELETE FROM table;' is used to delete records from a table in SQL Server.

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

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

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

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 remove a user's privileges?

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

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

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

In SQL Server, what is the purpose of the SEQUENCE object?

A. Generate a sequence of numbers
B. Execute a set of statements in a loop
C. Define a cursor for record processing
D. Create a temporary table

In Oracle, what is the purpose of the DBMS_OUTPUT.PUT_LINE() procedure?

A. Concatenate multiple strings
B. Output a line of text to the console
C. Calculate the average value
D. Round numeric values

Which Oracle function is used to find the current user?

A. GETUSER()
B. CURRENT_USER()
C. USER()
D. SESSION_USER()

Which SQL function is used to find the length of a string?

A. STRLEN()
B. LEN()
C. LENGTH()
D. STRINGLENGTH()

Which MySQL 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