question What is the purpose of the Oracle UTL FILE package

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

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

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

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

Which SQL Server statement is used to create a stored procedure?

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

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

What is the purpose of the Oracle TRUNCATE TABLE statement?

A. Remove specific records
B. Remove all records and reset auto-increment
C. Remove duplicate records
D. Remove NULL values

Which Oracle statement is used to remove a table from a database?

A. DELETE TABLE
B. REMOVE TABLE
C. DROP TABLE
D. DELETE FROM TABLE

In MySQL, what is the purpose of the BLOB data type?

A. Binary Large Object
B. Basic Long Object
C. Binary Linked Object
D. Basic Linked Object

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

A. Concatenate multiple strings
B. Quote an identifier to make it a valid SQL Server delimited identifier
C. Calculate the average value
D. Round numeric values

In MySQL, what is the purpose of the FOREIGN KEY constraint?

A. Ensures unique values in a column
B. Establishes a link between two tables
C. Limits the number of rows returned
D. Sets a default value for a column

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise