question In SQL Server what does the term ACID stand for in the context of transactions

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

In SQL Server, what is the purpose of the CONTAINSTABLE function?

A. Perform full-text search
B. Concatenate multiple columns
C. Validate XML structure
D. Generate a sequence of numbers

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

A. Combine rows from two or more tables
B. Create a temporary result set for use in a SELECT statement
C. Sort the result set
D. Join multiple tables

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;

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

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

In SQL Server, what is the purpose of the PI constant?

A. Mathematical constant representing the ratio of a circle's circumference to its diameter
B. Numeric constant representing the speed of light
C. Constant representing the number of days in a year
D. Constant representing the number of seconds in a minute

In SQL Server, what is the purpose of the LIKE operator?

A. Filter rows based on a condition
B. Sort the result set
C. Combine rows into groups
D. Search for a specified pattern in a column

What is the purpose of the Oracle UTL_FILE package?

A. Perform data manipulation tasks
B. Read and write files on the server's file system
C. Calculate the average value
D. Create triggers

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 SQL Server, what is the purpose of the IDENTITY property?

A. Establish a link between two tables
B. Automatically increments the value of a column
C. Enforce a unique constraint
D. Limit the number of rows returned

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise