当前分类： Oracle认证考试
问题：Given the following directory st...
查看答案
问题：Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）A、An error is generated.B、You will have two identical tables in the HR schema with different names.C、You create a table called employees in the HR sc...
问题：Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER Yo...
问题：You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA f...
问题：You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February ...
问题：You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A、Information about each Oracle Net connection.B、Informati...
问题：In user-managed back...
问题：To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows: SQL ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = ...
问题：Which commands are used for RMAN database recovery？（）A、 restoreB、 repairC、 copyD、 recoverE、 replace...
问题：In WebLogic 10.3.6&#...
问题：Which statement describes the RO...
问题：You are creating&ensp...
问题：What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）A、It can contain parameters with distinct values for each distance.B、It can contain only parameters with identical values for each instance.C、It must co...
问题：For which two situations would y...
问题：Your database isQ...
问题：Which two activities...
问题：Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （ ） functions against a VARCHAR (10000) column quite often. An example of the start of ...
问题：User SCOTT executes&e...
问题：根据不同的需要，可对数据库服务器进行相应的启动方式，当以STAR...
问题：How would you ...
