43、(9-2)choose three
Which three tasks can be performed by DDL statements?
A) preventing data retrieval from a table outside of office hours
B) modifying a table to prevent data that violate certa...
62、(13-17)choose the best answer:
You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE.
Examine the sample output:
Which query will provide the required output?...
72、View the exhibit for the structure of the STUDENTand FACULTYtables.
STUDENT
Name Null? Type
------------------ ------------------- -------------
STUDENT_ID NOT NULL NUMBER(2)
STUDENT_NAME V...
79、Which statement is true about transactions?
A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.
B. Each Data Defini...
47、(10-6)choose two
You need to calculate the number of days from 1st January 2007 till date.
Dates are stored in the default format of dd-mon-rr.
Which two SQL statements would give the required ...
69、(31-1)choose the best answer:
Evaluate the following query:
SELECT INTERVAL '300' MONTH,
INTERVAL '54-2' YEAR TO MONTH,
INTERVAL '11:12:10.1234567' HOUR TO SECOND
FROM dual;
What is the corr...
52、(12-11) choose the best answer:
Examine the structure and data in the PRICE_LIST table:
You plan to give a discount of 25% on the product price and need to display the discount amount
in the ...
39.choose the best answer
View the Exhibit and examine the description of the EMPLOYEES table.
You want to calculate the total remuneration for each employee. Total remuneration is the sum of the ...
