Phase
Status
Source Type
Rule Function
Customization Level
第1题:
You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?()
第2题:
You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()
第3题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
第4题:
Your network contains an Active Directory domain named contoso.com. You have a management computer named Computer1 that runs Windows 7. You need to forward the logon events of all the domain controllers in contoso.com to Computer1. All new domain controllers must be dynamically added to the subscription. What should you do()
第5题:
From Computer1, configure source-initiated event subscriptions. From a Group Policy object (GPO) linked to the Do
From Computer1, configure collector-initiated event subscriptions. From a Group Policy object (GPO) linked to the D
From Computer1, configure source-initiated event subscriptions. Install a server authentication certificate on Compu
From Computer1, configure collector-initiated event subscriptions. Install a server authentication certificate on Com
第6题:
a table name which has 100s of records
a table name which has 10s of records
a table name which has empty records
a table name which has 1000s of records
never use a table name
第7题:
Use the external table population.
Use the Oracle Data Pump export and import utility.
Use the conventional path data load of the SQL*Loader utility.
Use the INSERT INTO...SELECT command to load the data.
第8题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第9题:
a table name which has 100s of records
a table name which has 10s of records
a table name which has empty records
a table name which has 1000s of records
never use a table name
第10题:
Oracle Enterprise Manager
The V$LOG view
The V$LOGFILE view
The V$FLASHBACK_DATABASE_LOGS view
第11题:
You should implement the Snapshot Replication topology along with a Push Subscription.
You should implement the Merge Replication topology along with a Pull Subscription.
You should implement the Snapshot Replication topology along with a Pull Subscription.
You should implement the Transactional Replication topology along with a Pull Subscription
第12题:
SYSTEM
OUTLN
INTERNAL
SYS
第13题:
The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?()
第14题:
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
第15题:
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()
第16题:
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?()
第17题:
V$DATABASE
DBA_TABLES
SYSAUD$
EMP
第18题:
Shared pool
Control file
SGA
PGA
第19题:
You should configure the database for Read Committed Snapshot isolation.
You should modify the stored procedure to use the Snapshot isolation level
You should configure the database for Auto Update Statistics asynchronously
You should modify the stored procedure to use the Repeatable Read isolation level
第20题:
SQL Tuning Advisor
Undo Advisor
ADDM
Memory Advisor
第21题:
REF cursor.
Instead Of trigger.
Stored procedure that returns object values.
The underlying view cannot be modified because DML on a view is not supported.
第22题:
Create a new report that has three embedded subreports. Create one standard subscription.
Create three new reports based on the same dataset. Create one data-driven subscription.
Create three data-driven subscriptions on a single shared schedule. Ensure that the e-mail recipient list is identical across all three subscriptions.
Create three standard subscriptions on a single shared schedule. Ensure that the mail recipient list and subject are identical across all three subscriptions.
第23题:
Clone
Copy
Template
Terminal