网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）
A
LOGICAL_READS_PER_SESSION
B
CONNECT_TIME
C
COMPOSITE_LIMIT
D
CPU_PER_SESSION
E
PRIVATE_SGA
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）A LOGICAL_READS_PER_SESSION B CONNECT_TIME C COMPOSITE_LIMIT D CPU_PER_SESSION E PRIVATE_SGA” 相关考题
考题
You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()
A. PhaseB. StatusC. Source TypeD. Rule FunctionE. Customization Level
考题
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?()
A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session History (ASH) reportD. Taking a new snapshot and comparing it with a preserved snapshot
考题
You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（） A、 MMANB、 PMONC、 MMOND、 MMNL
考题
You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
考题
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）A、BFILE B、REF column C、Object table D、Column object E、INSTEAD-OF trigger
考题
While planning to manage more than one database in your system， you perform the following activities： 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you？（）A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architecture
考题
You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?（）A、PhaseB、StatusC、Source TypeD、Rule FunctionE、Customization Level
考题
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
考题
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）A、LOGICAL_READS_PER_SESSION B、CONNECT_TIME C、COMPOSITE_LIMIT D、CPU_PER_SESSION E、PRIVATE_SGA
考题
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？（）A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace
考题
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A、 Oracle Net ManagerB、 Listener Control utilityC、 Database Configuration AssistantD、 Oracle Net Configuration Assistant
考题
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
考题
单选题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?（）A
SYSTEM B
OUTLN C
INTERNAL D
SYS
考题
单选题You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?（）A
PhaseB
StatusC
Source TypeD
Rule FunctionE
Customization Level
考题
单选题You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）A
Compare Period ADDM reportB
AWR Compare Period reportC
Active Session History (ASH) reportD
Taking a new snapshot and comparing it with a preserved snapshot
考题
单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）A
renaming the control filesB
dropping a user in your databaseC
enabling or disabling redo log archivingD
dropping a tablespace in your databaseE
re-creating the control files， after you lost all the control files in your database
考题
多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.
考题
单选题You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A
Shared pool B
Control file C
SGA D
PGA
考题
单选题You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）A
Use the external table population.B
Use the Oracle Data Pump export and import utility.C
Use the conventional path data load of the SQL*Loader utility.D
Use the INSERT INTO...SELECT command to load the data.
考题
单选题You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）A
LOGICAL_READS_PER_SESSION B
CONNECT_TIME C
COMPOSITE_LIMIT D
CPU_PER_SESSION E
PRIVATE_SGA
考题
单选题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？（）A
online redo log filesB
alert log filesC
control fileD
datafiles associated with the SYSTEM tablespace
考题
多选题You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）ABFILEBREF columnCObject tableDColumn objectEINSTEAD-OF trigger
考题
单选题You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）A
Use the database link.B
Use the SQL*Loader utility.C
Use the Oracle Data Pump utility.D
Create an external table and leave the data in the flat file
考题
单选题You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）A
Clone B
Copy C
Template D
Terminal
考题
单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）A
Writes buffers to disk B
Writes current redo log number to datafile headers C
Writes redo log information to disk D
Reads information into memory for users
考题
单选题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?（）A
a table name which has 100s of recordsB
a table name which has 10s of recordsC
a table name which has empty recordsD
a table name which has 1000s of recordsE
never use a table name
考题
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）A
When the instance is started B
When the database is mounted C
When the database is opened D
When the database is closed
考题
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）A
V$DATABASE B
DBA_TABLES C
SYSAUD$ D
EMP
热门标签
最新试卷
