76、View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables.
The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the following...
50、(11-15)choose two
Examine the structure of the MARKS table:
Which two statements would execute successfully?
A) SELECT SUM(subjectl+subject2+subject3)
FROM marks
WHERE student_name IS NULL;...
40、(8-7) choose two
Which two statements are true regarding views? (Choose two.)
A) A simple view in which column aliases have been used cannot be updated.
B) The OR REPLACE option is used to chan...
74、View the exhibit and examine the structure of ORDERS and CUSTOMERS tables.
ORDERS
Name Null? Type
ORDER_ID NOT NULL NUMBER(4)
ORDER_DATE NOT NULL DATE
ORDER_MODE VARCHA...
71、(32-18) choose three
Which three statements indicate the end of a transaction? (Choose three.)
A) after a CREATE statement is issued
B) after a SELECT statement is issued
C) after a ROLLBACK i...
38.choose the best answer
View the Exhibit and examine the data in the PROMOTIONS table.
PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provid...
19.choose the best answer
View the Exhibit and examine the structure of the PROMOTIONS table.
Evaluate the following SQL statement:
SQL>SELECT promo_name,CASE
WHEN promo_cost>=(SELECT AVG(promo_...
78、View the exhibit and examine the structure of the CUSTOMERStable.
Which two tasks would require subqueries or joins to be executed in a single statement?
A. finding the number of customers, in...
44、(9-12)choose all that apply
View the Exhibit and examine the details of the ORDER_ITEMS table.
Evaluate the following SQL statements:
Statement 1:
SELECT MAX(unit_price*quantity) "Maximum Or...
48、(10-12)choose the best answer
View the Exhibit and examine the description for the PRODUCTS and SALES table.
PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table w...
66、(22-19)choose two
Examine the structure proposed for the TRANSACTIONS table:
Which two statements are true regarding the creation and storage of data in the above table structure?
A) The TRAN...
64、(22-7) choose the best answer:
View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables.
Evaluate the following SQL statement:
SELECT oi.order_id, product_id, order_date
...
45、(9-16)choose the best answer:
View the Exhibit and examine the data in the EMPLOYEES table.
You want to generate a report showing the total compensation paid to each employee to date(迄今为止...
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...
-------------------------------------------------------
51、(12-10)choose the best answer:
Evaluate the following SQL statement:
SQL> SELECT cust_id, cust_last_name
FROM customers
WHERE cust_cred...
8. Which are two ways for a database service to be recognized by a listener in Oracle Database 12c?
A) Static registration in the listener.ora file using the service_name parameter
B) Dynamic Regist...
68、(29-13)choose two:
Which two statements are true? (Choose two.)
A) DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.
B) The user SYSTEM own...
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...
41、(8-14) choose two
View the Exhibit and examine the structure of the ORDERS table.
The columns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0 respectively.
Which two INSERT ...
63、(22-4) choose the best answer:
View the Exhibit and examine the data in the PRODUCTS table.
Which statement would add a column called PRICE, which cannot contain NULL?
A) ALTER TABLE products
...
