QUESTION 2Identify the memory component from which memory may be allocated for:Session memory for the shared server, Buffers for I/O slaves Oracle Database Recovery Manager (RMAN) backup and...
QUESTION 1You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)A. Disable automatic checkpoint tuningB. Check ...
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...
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 ...
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_...
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 ...
46、(10-4) choose two:
Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
----------------------
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to ex...
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...
42、(9-1)choose the best answer:
Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?
A) DELETE but not TRUNCATE statement can be used to remove data from selective columns ...
