In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started?()A、The modified blocks would be written to the data files.B、The modified blocks would be written to the temp files.C、The modified blocks would be written to the control file.D、The modified blocks would be written to the redo log files.E、The modified blocks would be written to the archived redo log files.F、The modified blocks would be retained in the database buffer cache.

In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started?()

  • A、The modified blocks would be written to the data files.
  • B、The modified blocks would be written to the temp files.
  • C、The modified blocks would be written to the control file.
  • D、The modified blocks would be written to the redo log files.
  • E、The modified blocks would be written to the archived redo log files.
  • F、The modified blocks would be retained in the database buffer cache.

相关考题:

Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.) A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Which three items are configured in MST configuration submode? ()A、 Region nameB、 Configuration revision numberC、 VLAN instance mapD、 IST STP BPDU hello timerE、 CST instance mapF、 PVST+ instance map

You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you notice that the system identifier (SID) for the instance is set to ’+ASM’. What is the purpose of this instance?()A、 This instance is being used to manage the operating system files.B、 This instance is being used to manage the files of other databases.C、 This instance is being used to manage the instances of other databases.D、 This instance is being used to manage the background processes of other instances.

Choose the two correct statements regarding Oracle WebLogic Server()A、 a server instance can be associated with multiple machinesB、 a machine can be associated with multiple server instance C、 a server instance can be associated with only a single machine D、 a machine can be associated with only one server instance

以下关于MSTP中MST Instance和VLAN的映射关系的说法正确的是?()A、每个VLAN只能映射到一个MST Instance。B、每个MST Instance只能包含一个VLAN。C、每个MST Instance最多包含16个VLAN。D、每个VLAN可以映射到最多16个MST Instance。

While logged into a Company switch you issue the following command:   CompanySwitch(config-mst)# instance 10 vlan 11-12   What does this command accomplish?()A、 It enables a PVST+ instance of 10 for vlan 11 and vlan 12B、 It enables vlan 11 and vlan 12 to be part of the MST region 10C、 It maps vlan 11 and vlan 12 to the MST instance of 10.D、 It creates an Internal Spanning Tree (IST) instance of 10 for vlan 11 and vlan 12  E、 It create a Common Spanning Tree (CST) instance of 10 for vlan 11 and vlan 12F、 It starts two instances of MST, one instance for vlan 11 and another instance for vlan 12.

Spanning Tree Protocol IEEE 802.1s defines the ability to deploy which of these? ()A、one global STP instance for all VLANsB、one STP instance for each VLANC、one STP instance per set of VLANsD、one STP instance per set of bridges

Which of the following would be true if an administrator tried to create a commerce instance with Commerce Payments configuration values, without having Commerce Payments installed?()A、The commerce instance would be created successfully.B、Attempting to configure payments instance after the commerce instance is already created will not be possible.C、The commerce instance creation will fail on the step that would normally configure the payments instance.D、After installing Commerce Payments, the administrator can enter the needed payment configuration values through the Administration Console.

Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Which of the following options is true about shutting down an Automatic Storage Management (ASM) instance?()  A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance, the ASM instance immediately shuts down.B、 If the SHUTDOWN ABORT command is issued to the ASM instance, the ASM instance will shut down all the database instances and then shut down immediately.C、 If the SHUTDOWN NORMAL command is issued to the ASM instance, before shutting down, the ASM instance waits for the dependent database instances to shut down.D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance, the ASM instance passes the same SHUTDOWN command to the dependent database instances, but does not wait for any active transactions to complete before it shuts down.

What effect should the loss of an index tablespace have on an Oracle instance that is running?()A、 instance hangsB、 instance gets abortedC、 instance continues runningD、 instance gets restarted automatically

单选题You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL shutdown immediate; What is the result of executing this command?()AAll the instances, including the ASM instance, are shut down in the ABORT modeBThe ASM instance is shut down, but the other instances are still running CThe ASM instance is still functional, but the other instances are shut down DAll the instances, including the ASM instance, are shut down in the IMMEDIATE mode. EHRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode FHRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode

多选题Which three items are configured in MST configuration submode? ()ARegion nameBConfiguration revision numberCVLAN instance mapDIST STP BPDU hello timerE CST instance mapFPVST+ instance map

单选题Spanning Tree Protocol IEEE 802.1 s defines the ability to deploy which of these?()Aone global STP instance for all VLANsBone STP instance for each VLANCone STP instance per set of VLANsDone STP instance per set of bridges

单选题You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you notice that the system identifier (SID) for the instance is set to ’+ASM’. What is the purpose of this instance?()A This instance is being used to manage the operating system files.B This instance is being used to manage the files of other databases.C This instance is being used to manage the instances of other databases.D This instance is being used to manage the background processes of other instances.

单选题What effect should the loss of an index tablespace have on an Oracle instance that is running?()A instance hangsB instance gets abortedC instance continues runningD instance gets restarted automatically

单选题You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()Ato enable the ASM instance to identify the alert log fileBto enable the ASM instance to identify the server parameter fileCto enable the ASM instance to define the locations for Oracle Managed Files (OMF)Dto enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

单选题You create an application. The application processes hundreds of XML documents per minute. The XML documents are validated against inline schemas. You need to load XML documents from the file system and read them as quickly as possible. XML comments must be ignored while reading the XML documents.What should you do? ()ACreate an instance of the XmlReader class by using the XmlReader Create method with an instance of the XmlReaderSettings class.BCreate an instance of the XmlReader class with an instance of the XmlTextReader class.CCreate an instance of the XmlDocument class and specify a location for the application schema.DCreate an instance of the XmlReader class with an instance of the XmlNodeReader class.

单选题Spanning Tree Protocol IEEE 802.1s defines the ability to deploy which of these?()A one global STP instance for all VLANsB one STP instance for each VLANC one STP instance per set of VLANsD one STP instance per set of bridges

单选题Which of the following options is true about shutting down an Automatic Storage Management (ASM) instance?()A If the SHUTDOWN IMMEDIATE command is issued to the ASM instance, the ASM instance immediately shuts down.B If the SHUTDOWN ABORT command is issued to the ASM instance, the ASM instance will shut down all the database instances and then shut down immediately.C If the SHUTDOWN NORMAL command is issued to the ASM instance, before shutting down, the ASM instance waits for the dependent database instances to shut down.D If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance, the ASM instance passes the same SHUTDOWN command to the dependent database instances, but does not wait for any active transactions to complete before it shuts down.

多选题Which two statements are true regarding an Automatic Storage Management (ASM) instance?()AAs ASM instance mounts an ASM control fileBAn ASM instance uses the ASMB process for rebalancing of disks within a disk groupCAutomatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyDAn RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

多选题Which statements concerning the correlation between the inner and outer instances of non-static inner classes are true?()AMember variables of the outer instance are always accessible to inner instances, regardless of their accessibility modifiers.BMember variables of the outer instance can never be referred to using only the variable name within  the inner instance.CMore than one inner instance can be associated with the same outer instance.DAll variables from the outer instance that should be accessible in the inner instance must be declared  final.EA class that is declared final cannot have any inner classes.