单选题While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()A configure the database to run in

题目
单选题
While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()
A

configure the database to run in ARCHIVELOG mode

B

configure the Flash Recovery Area to enable automatic database backup

C

schedule the database backup using DBMS_JOB package after creating the database

D

schedule the database backup using Recovery Manager (RMAN)commands after creating the database

E

schedule the database backup using Database Configuration Assistant (DBCA)while creating the database

参考答案和解析
正确答案: D
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()

  • A、You must have change tracking enabled in your database
  • B、Your database must be running in NOARCHIVELOG mode
  • C、To back up a tablespace, it must be in backup mode
  • D、To back up a tablespace, it must first be taken offline

正确答案:C

第2题:

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()

  • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
  • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
  • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
  • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
  • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

正确答案:D

第3题:

While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective?()

  • A、configure the database to run in ARCHIVELOG mode
  • B、configure the Flash Recovery Area to enable automatic database backup
  • C、schedule the database backup using DBMS_JOB package after creating the database
  • D、schedule the database backup using Recovery Manager (RMAN) commands after creating the database
  • E、schedule the database backup using Database Configuration Assistant (DBCA) while creating the database

正确答案:E

第4题:

In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective?()

  • A、REBUILD
  • B、CASCADE
  • C、TRUNCATE
  • D、ROW MOVEMENT
  • E、SHRINK SPACE COMPACT
  • F、SHRINK SPACE CASCADE

正确答案:E

第5题:

Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()  

  • A、 Put the database in hot backup mode and perform an online backup,including backing up the  archived redo logs.
  • B、 Just back up the database datafiles without shutting down the database.
  • C、 You will have to wait until you can shut down the database to perform the backup.
  • D、 Mark each datafile as backup in progress, back them up individually,and then mark them as backup not in progress. No archived redo logs will need to be backed up.
  • E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing,you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

正确答案:C

第6题:

You work as a database administrator for Supportcenter.cn. 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 Control
  • B、Oracle Management Service
  • C、Oracle Enterprise Manager Repository
  • D、Oracle Enterprise Manager Database Control

正确答案:C,D

第7题:

While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()

  • A、configure the database to run in ARCHIVELOG mode
  • B、configure the Flash Recovery Area to enable automatic database backup
  • C、schedule the database backup using DBMS_JOB package after creating the database
  • D、schedule the database backup using Recovery Manager (RMAN)commands after creating the database
  • E、schedule the database backup using Database Configuration Assistant (DBCA)while creating the database

正确答案:E

第8题:

You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?()

  • A、 synch catalog
  • B、 resync catalog
  • C、 replicate catalog
  • D、 update catalog
  • E、 restore catalog

正确答案:B

第9题:

You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases, creating and managing tablespaces and database users, and taking regular backups, for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective?()

  • A、Oracle Management Agent
  • B、Enterprise Manager with Grid Control
  • C、Enterprise Manager with Database Control
  • D、Operating System Socket for incoming requests
  • E、Real Application Cluster (RAC) with three instances
  • F、Enterprise Manager with Generic Database Management

正确答案:A

第10题:

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into 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 SQL*Loader utility
  • D、use the direct path data load of Oracle export and import utility

正确答案:C

更多相关问题