单选题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?（）ALOGICAL_READS_PER_SESSION BCONNECT_TIME CCOMPOSITE_LIMIT DCPU_PER_SESSION EPRIVATE_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?（）ASYSTEM BOUTLN CINTERNAL DSYS
单选题You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?（）APhaseBStatusCSource TypeDRule FunctionECustomization 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?（）ACompare Period ADDM reportBAWR Compare Period reportCActive Session History (ASH) reportDTaking 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？（）Arenaming the control filesBdropping a user in your databaseCenabling or disabling redo log archivingDdropping a tablespace in your databaseEre-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? （）AShared pool BControl file CSGA DPGA
单选题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（）AUse the external table population.BUse the Oracle Data Pump export and import utility.CUse the conventional path data load of the SQL*Loader utility.DUse 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?（）ALOGICAL_READS_PER_SESSION BCONNECT_TIME CCOMPOSITE_LIMIT DCPU_PER_SESSION EPRIVATE_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（）AUse the database link.BUse the SQL*Loader utility.CUse the Oracle Data Pump utility.DCreate 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? （）AClone BCopy CTemplate DTerminal
单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）AWrites buffers to disk BWrites current redo log number to datafile headers CWrites redo log information to disk DReads 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?（）Aa table name which has 100s of recordsBa table name which has 10s of recordsCa table name which has empty recordsDa table name which has 1000s of recordsEnever 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?（）AWhen the instance is started BWhen the database is mounted CWhen the database is opened DWhen the database is closed
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）AV$DATABASE BDBA_TABLES CSYSAUD$ DEMP