单选题You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task?()A Enable Flashback Data Archive for the tables.B Specify undo retention guarantee for the database.C Enable supplemental logging for the database.D Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E Create Flashback Data Archive on the tablespace on which the tables are stored.

单选题
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task?()
A

 Enable Flashback Data Archive for the tables.

B

 Specify undo retention guarantee for the database.

C

 Enable supplemental logging for the database.

D

 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.

E

 Create Flashback Data Archive on the tablespace on which the tables are stored.


参考解析

解析: 暂无解析

相关考题:

Only in this way ____ to make improvements in the operating system. A.you can hopeB.you did hopeC.can you hope

_____ decision he made I would try my best to support it. A.AnythingB.WhoeverC.WhatD.Whatever

It was clever ______ you to make such a decisive decision at the moment.A、aboutB、ofC、 onD、with

Why are you working in a field other than the one in which you have a degree?

A Catalyst switch has just been installed and configured, and is not working as expected. You have decided to capture multiple show command outputs to study.Which one command could you use that includes the output of many other show commands, such as show version and show running-config?()A. show configurationB. show memoryC. show stacksD. show tech-support

If you know that the vessel you are about to call on the VHF radio maintains a radio watch on both the working and the calling frequencies, which frequency should you call on ?______.A.Calling frequencyB.Distress frequencyC.Urgency frequencyD.Working frequency

决策支持系统的英文表示为()。A、Decision Support SystemsB、Management Information SystemsC、TransactionD、Management

You are running Linux 2.0.36 and you need to add a USB mouse to your system. Which of the following statements is true?()A、 You need to rebuild the kernel.B、 You need to upgrade the kernelC、 You need to load the USB modules for your existing modular kernel.D、 USB support is not available in Linux.

Your database instance is currently configured to support 1,500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA,  which configuration would you set to support more than 1,500 connections at a time()A、You would configure more listeners for the database.B、You would configure the database in shared server mode to use the connection pooling feature.C、You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.D、You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT

Which view will you use to view information regarding the jobs that are currently running in a database?()A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG

You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true?()A、The database crashes.B、The DBA needs to re-create the file.C、The file gets re-created automatically.D、The file gets restored automatically from the last backup.E、The DBA needs to perform a complete database recovery.F、The DBA needs to perform an incomplete database recovery.

In which two cases would you perform only consistent backup?()A、You are working on a database where downtime is not tolerated.B、You are working on a database where downtime can be tolerated.C、You are working on a database that operates in ARCHIVELOG mode.D、You are working on a database that operates in NOARCHIVELOG mode.E、You are working on a database where all the tablespaces are locally managed.F、You are working on a database where control files and redo log files are multiplexed.G、You are working on a database where control files and redo log files are not multiplexed.

You executed the following procedure to collect statistics regarding an index:       SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE;   Which view will you use to determine whether you need to rebuild the index or not?() A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task?()A、 Enable Flashback Data Archive for the tables.B、 Specify undo retention guarantee for the database.C、 Enable supplemental logging for the database.D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job?()A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG

You want to compress your folder named test on a FAT32 file system. When you try to compress the folder, you found no advance tab in the folder’s property window. What may be its reason.()A、You are not an administratorB、A local system policy is implemented to hide the advance tabC、FAT32 does not support compressionD、Delete and recreate the testing folder

You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services. Configuring name resolution and network access and so on.Your company is desigiing its network. The network will use an IPv6 prefix of 2001:DB8: BBCC:0000::/53. You have to identify an IPv6 addressing scheme that will support 2000 subnets. Which network mask should you use?()A、You should use /63.B、You should use /64.C、You should use /61.D、You should use /62.

单选题You are running Linux 2.0.36 and you need to add a USB mouse to your system. Which of the following statements is true?()A You need to rebuild the kernel.B You need to upgrade the kernelC You need to load the USB modules for your existing modular kernel.D USB support is not available in Linux.

单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()A V$FLASHBACK_DATABASE_LOGB V$FLASHBACK_DATABASE_STATC V$DATABASED V$UNDOSTAT

单选题You want to compress your folder named test on a FAT32 file system. When you try to compress the folder, you found no advance tab in the folder’s property window. What may be its reason.()AYou are not an administratorBA local system policy is implemented to hide the advance tabCFAT32 does not support compressionDDelete and recreate the testing folder

单选题You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true?()AThe database crashes.BThe DBA needs to re-create the file.CThe file gets re-created automatically.DThe file gets restored automatically from the last backup.EThe DBA needs to perform a complete database recovery.FThe DBA needs to perform an incomplete database recovery.

单选题You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task?()A Enable Flashback Data Archive for the tables.B Specify undo retention guarantee for the database.C Enable supplemental logging for the database.D Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E Create Flashback Data Archive on the tablespace on which the tables are stored.

单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job?()A DBA_SCHEDULER_JOB_RUN_DETAILSB DBA_SCHEDULER_RUNNING_JOBSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG

单选题You executed the following procedure to collect statistics regarding an index:       SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE;   Which view will you use to determine whether you need to rebuild the index or not?()A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE

多选题Your company has a Microsoft Hyper-V Server 2008 R2 environment. You manage the virtual environment by using Microsoft System Center Virtual Machine Manager (VMM) 2008 R2. Virtual machines (VMs) will use Microsoft iSCSI Software Initiator to connect to the shared storage volumes within the guest operating system. You need to configure the VMM host server to optimize the network environment for iSCSI traffic. Which two actions should you perform?()ASet the network adapters to 1454 MTU.BSet the network adapters and the supporting infrastructure to support jumbo frames.CEnable RX and TX TCP checksum offload support on the network adapters.DDisable RX and TX TCP checksum offload support on the network adapters.

单选题A Catalyst switch has just been installed and configured, and is not working as expected. You have decided to capture multiple show command outputs to study. Which one command could you use that includes the output of many other show commands, such as show version and show running-config?()Ashow configurationBshow memoryCshow stacksDshow tech-support

问答题Directions: some people prefer work or activities that mainly involve working with people. Others choose work or activities that mainly involve working with objects or machines. Compare these types of activities. Which of them do you prefer? Give reasons to support your answer. Your composition should be no less than about 160 words.