Database - Oracle Database
MCQS
A. Structured Question Language
B. Standard Query Language
C. Sequential Query Language
D. Structured Query Language
SQL stands for Structured Query Language in the context of Oracle Database.
A. VARCHAR2
B. CHAR
C. CLOB
D. VARCHAR
'CHAR' is used to store fixed-length character strings in Oracle.
A. Concatenate multiple columns
B. Replace NULL values with a specified value
C. Calculate the average value
D. Concatenate multiple rows
'NVL()' is used to replace NULL values with a specified value in Oracle.
A. ADD INDEX
B. CREATE INDEX
C. INDEX TABLE
D. ALTER INDEX
'CREATE INDEX' is used to add an index to an existing table in Oracle.
A. Convert a date to a string
B. Convert a string to a date
C. Concatenate multiple dates
D. Round a date value
'TO_DATE()' is used to convert a string to a date in Oracle.
A. Store binary data
B. Store XML data
C. Provide a one-row, one-column table for selecting expressions
D. Store numeric values
The 'DUAL' table is a one-row, one-column table in Oracle used for selecting expressions.
A. STRLEN()
B. LEN()
C. LENGTH()
D. STRINGLENGTH()
'LENGTH()' is used to find the length of a string in Oracle.
A. Save changes to the database
B. Undo changes made during the current transaction
C. Commit changes to the database
D. Delete records from the database
'ROLLBACK' is used to undo changes made during the current transaction in Oracle.
A. CREATE TABLE
B. NEW TABLE
C. ADD TABLE
D. INSERT TABLE
'CREATE TABLE' is used to create a new table in a database in Oracle.
A. Combine rows from two or more tables
B. Retrieve all rows from the left table
C. Retrieve rows that have no matching rows in the right table
D. Exclude specified rows
'JOIN' is used to combine rows from two or more tables based on a related column in Oracle.
A. GRANT ALL PRIVILEGES
B. GRANT FULL ACCESS
C. GRANT SUPERUSER
D. GRANT ALL RIGHTS
'GRANT ALL PRIVILEGES' is used to grant all privileges to a user in Oracle.
A. Combine rows from two or more tables
B. Rotate rows into columns based on values in a specified column
C. Sort the result set
D. Join multiple tables
'UNION' is used to combine the results of two or more SELECT statements in Oracle.
A. Filter rows
B. Sort the result set
C. Filter groups
D. Combine rows into groups
The 'HAVING' clause is used to filter groups based on a condition in Oracle.
A. DELETE TABLE
B. REMOVE TABLE
C. DROP TABLE
D. DELETE FROM TABLE
'DROP TABLE' is used to remove a table from a database in Oracle.
A. Filter rows
B. Sort the result set
C. Combine rows into groups
D. Join multiple tables
The 'GROUP BY' clause is used to combine rows into groups in Oracle.
A. Remove specific records
B. Remove all records and reset auto-increment
C. Remove duplicate records
D. Remove NULL values
'TRUNCATE TABLE' removes all records and resets the auto-increment in Oracle.
A. VARCHAR
B. TEXT
C. CLOB
D. CHAR
'CLOB' is used to store large text values in Oracle.
A. Combine rows from two or more tables
B. Update, insert, or delete data based on a condition
C. Sort the result set
D. Join multiple tables
The 'MERGE' statement is used to update, insert, or delete data based on a condition in Oracle.
A. CREATE SEQUENCE
B. NEW SEQUENCE
C. ADD SEQUENCE
D. INSERT SEQUENCE
'CREATE SEQUENCE' is used to create a sequence in Oracle.
A. Stores XML data
B. Stores binary data
C. Stores integer values
D. Stores a list of values
The 'XMLType' data type in Oracle is used to store XML data.
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
'SYS_CONTEXT' is used to retrieve the value of a parameter in the database context in Oracle.
A. ALLOW PRIVILEGES
B. GRANT PRIVILEGES
C. GRANT
D. ALLOW ACCESS
'GRANT' is used to grant specific privileges to a user in Oracle.
A. Filter rows based on a range of values
B. Sort the result set
C. Combine rows into groups
D. Search for a specified pattern in a column
'BETWEEN' is used to filter rows based on a range of values in Oracle.
A. Calculate the average value
B. Assign a rank to each row within a result set
C. Concatenate multiple rows
D. Find the length of a string
'RANK()' is used to assign a rank to each row within a result set in Oracle.
A. Combine rows from two or more tables
B. Rotate rows into columns based on values in a specified column
C. Find the common rows between two SELECT statements
D. Join multiple tables
The 'INTERSECT' operator is used to find the common rows between two SELECT statements in Oracle.
A. REMOVE PRIVILEGES
B. DELETE PRIVILEGES
C. DROP PRIVILEGES
D. REVOKE
'REVOKE' is used to remove a user's privileges in Oracle.
A. Generate a random globally unique identifier
B. Concatenate multiple columns
C. Calculate the average value
D. Round numeric values
'SYS_GUID()' is used to generate a random globally unique identifier in Oracle.
A. Concatenate multiple strings
B. Output a line of text to the console
C. Calculate the average value
D. Round numeric values
'DBMS_OUTPUT.PUT_LINE()' is used to output a line of text to the console in Oracle.
A. GETUSER()
B. CURRENT_USER()
C. USER()
D. SESSION_USER()
'USER()' is used to find the current user in Oracle.
A. Perform data manipulation tasks
B. Schedule and manage jobs, including PL/SQL blocks and stored procedures
C. Calculate the average value
D. Create database links
The 'DBMS_SCHEDULER' package is used to schedule and manage jobs in Oracle.
A. Concatenate multiple columns
B. Find the length of a string
C. Find the position of a substring in a string
D. Concatenate multiple rows
'INSTR()' is used to find the position of a substring in a string in Oracle.
A. GRANT EXECUTE
B. GRANT EXECUTION
C. ALLOW EXECUTE
D. ALLOW EXECUTION
'GRANT EXECUTE' is used to grant execute permissions on a stored procedure in Oracle.
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
The 'WITH' clause is used to create a temporary result set for use in a SELECT statement in Oracle.
A. Perform data manipulation tasks
B. Read and write files on the server's file system
C. Calculate the average value
D. Create triggers
The 'UTL_FILE' package is used to read and write files on the server's file system in Oracle.
A. Concatenate multiple values
B. Perform bitwise AND operation on two numbers
C. Calculate the average value
D. Round numeric values
'BITAND()' is used to perform a bitwise AND operation on two numbers in Oracle.