1、.Which two are true about the Archive (ARCn) processes?
A) They automatically delete obsolete archive logs to make space for new archive logs.
B) They are used during Instance recovery.
C) They arc...
6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).
You select the "Install and Configure Grid Infrastructure for a Standalone Server" option.
Which task ...
5、Which two affect the time taken for instance recovery?
A) size of redo logs
B) size of UNDO tablespace
C) FAST_START_MTTR_TARGET value
D) size of archivelogs
E) size of existing RMAN backupset...
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...
72、View the exhibit for the structure of the STUDENTand FACULTYtables.
STUDENT
Name Null? Type
------------------ ------------------- -------------
STUDENT_ID NOT NULL NUMBER(2)
STUDENT_NAME V...
65、(22-16) choose the best answer:
The CUSTOMERS table has the following structure:
You need to write a query that does the following tasks:
1. Display the first name and tax amount of the custo...
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...
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...
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...
70、(31-2)choose the best answer:
View the Exhibit and examine the structure of the Book table.
The BOOKS table contains details of 100 books.
Examine the commands executed and their outcome:
SQL...
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...
30、Which is true when a database instance is shut down?
A. Only transactional and normal modes wait for all uncommitted transactions to commit or rollback and then close the database.
B. Immediate,...
【OCP|052】OCP最新题库解析（052）--小麦苗解答版
OCP最新题库解析历史连接（052）：http://mp.weixin.qq.com/s/bUgn4-uciSndji_pUbLZfA⊙ 【OCP最新题库解析(052)--题20】Which command is used to display f...
【OCP|052】OCP最新题库解析（052）--小麦苗解答版
OCP最新题库解析历史连接（052）：http://mp.weixin.qq.com/s/bUgn4-uciSndji_pUbLZfA
⊙ 【OCP最新题库解析(052)--题20】Which command is used to display...
4、For which requirement should you configure shared servers?
A) accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited memory
B) ...
