question What is the purpose of the Oracle SYS GUID function

In MySQL, 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

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 create a unique constraint on a column?

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

What is the purpose of the SQL COALESCE() function?

A. Combine multiple columns
B. Replace NULL values with a specified value
C. Calculate the average value
D. Concatenate multiple rows

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

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 Oracle SYS_CONTEXT function?

A. Concatenate multiple values
B. Find the length of a string
C. Retrieve the value of a parameter in the database context
D. Validate XML structure

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

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

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

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

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise