33、Where Is backup metadata stored for use by Recovery Manager (RMAN)?
A) In the control file
B) In the SYSAUX tablespace
C) in the SPFILE
D) in the SYSTEM tablespace
E) In the diagnostic destin...
23、Which two are true about data dictionary and dynamic performance views (v$ views)?
A) All database users have access to ALL_* views.
B) Data dictionary view output is subject to read consistency...
36.choose the best answer
View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS tables.
You issue the following query:
SQL>SELECT p.prod_id,prod_name,prod_list_price,...
33.choose the best answer
View the Exhibit and examine the structure of the ORDER_ITEMS table.
Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHER...
34.choose two
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.
You have a requirement from the supplies department to give a list containing PRODUCT_ID...
choose three
Which three statements are true about Oracle Data Pump?
A) Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
B) IMPDP can be used ...
choose two
Examine this command executed on a client that is remote from the database server.
SQL> CONNECT hr/hr@orcl
Which two are required for this command to connect the SQLPLUS client to a data...
67、(25-8)choose the best answer:
View the Exhibit and examine the structure of CUSTOMERS table.
Evaluate the following query:
SQL>SELECT cust_id, cust_city
FROM customers
WHERE cust_first_name...
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 ...
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 ...
77、Which two statements are true about sequences created in a single instance database? (Choose two.)
A. When the MAXVALUElimit for the sequence is reached, you can increase the MAXVALUElimit by usi...
