单项选择题
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine()
You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20))ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction ()
Identify the memory component from which memory may be allocated for: () 1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operations
You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification. Which schema object enables the user to access the information from the remote database()
Given below is a list of scenarios: 1) A user terminates his session abnormally. 2) The connection between the server and the client application terminates because of a network failure. 3) A schema is accidentally dropped. 4) The tablespace is accidentally dropped from the database. 5) The hard disk gets corrupted and the data files in the disk are lost. 6) The database instance abnormally shuts down because of power failure. Which scenarios require DBAintervention to perform recovery()
赞题库-搜题找答案
(已有500万+用户使用)
无需下载 立即使用
版权所有©考试资料网(ppkao.com)All Rights Reserved