×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Evaluate the following ALTER TABLE statement:
ALTER TABLE orders
SET UNUSED order_date;
Which statement is true?
2.
You need to create a table with the following column specifications:
1. Employee ID (numeric data type) for each employee
2. Employee Name, (character data type) which stores the employee name
3. Hire date, to store the date when the employee joined the organization
4. Status (character data type). It should contain the value "ACTIVE" if no data is entered.
5. Resume (character large object [CLOB] data type), which would contain the resume submitted by the
employee
Which is the correct syntax to create this table?
3.
The details of the order ID, order date, order total, and customer ID are obtained from the ORDERS table. If the
order value is more than 30000, the details have to be added to the LARGE_ORDERS table. The order ID,
order date, and order total should be added to the ORDER_HISTORY table, and order ID and customer ID
should be added to the CUST_HISTORY table. Which multitable INSERT statement would you use?
4.
The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to
the user HR. Which statement would create a synonym ORD so that HR can execute the following query
successfully?
SELECT * FROM ord;
5.
Evaluate the following DELETE statement:
DELETE FROM orders;
There are no other uncommitted transactions on the ORDERS table.
Which statement is true about the DELETE statement?
6.
Which statement is true regarding synonyms?
7.
Evaluate the following command: CREATE TABLE employees
CREATE TABLE employees
(employee_id NUMBER(2) PRIMARY KEY,
last_name VARCHAR2(25) NOT NULL,
department_id NUMBER(2),
job_id VARCHAR2(8),
salary NUMBER(10,2));
You issue the following command to create a view that displays the IDs and last names of the sales staff in the
organization:
CREATE OR REPLACE VIEW sales_staff_vu AS
SELECT employee_id, last_name,job_id
FROM employees
WHERE job_id LIKE 'SA_%' WITH CHECK OPTION;
Which statements are true regarding the above view? (Choose all that apply.)
8.
The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT
command:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What correction needs to be done to the above statement?
9.
Given below is a list of functions and the tasks performed by using these functions, in random order. Function
Usage
1) LPAD a) Used to truncate a column, expression, or value to n decimal places
2) TRUNC b) Used to remove heading or trailing or both characters from the character string
3) DECODE c) Pads the character value right-justified to a total width of n character positions
4) TRIM d) Used to return the numeric value for position of a named character from the character string
5) INSTR e) Used to translate an expression after comparing it with each search value
Which option correctly matches the function names with their usage?
10.
Which statement is true regarding the CUBE operator in the GROUP BY clause of a SQL statement?