搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

A、db2advis -d proddb -i workload.sql -P  

B、db2advis -d proddb -i workload.sql -partitioning  

C、db2advis -d proddb -i workload.sql -m P  

D、db2advis -d proddb -i workload.sql -m ALL 

查看正确答案
更多“A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）”相关的问题
第1题
[] You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers， in its current configuration， can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used？（）

A、A.SQL3 with the OnlineReadOnly and HR databases  B、B.SQL4 with the TravelOnline and Storefront databases  C、C.SQL2 with the Storefront and TravelOnline databases  D、D.SQL2 with the Storefront and HR databases  

点击查看答案
第2题
[多选题] You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）

A、the CONVERT command of RMAN  B、Data Pump Export and Import into the same database  C、conventional export and import into the same database  D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN  E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN  

点击查看答案
第3题
[单选题] You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

A、 target database  B、 auxiliary database  C、 third-party database  D、 recovery catalog database  

点击查看答案
第4题
[多选题] 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 Control  B、Oracle Management Service  C、Oracle Enterprise Manager Repository  D、Oracle Enterprise Manager Database Control  

点击查看答案
第5题
[多选题] You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

A、 Flashback logs are not archived.  B、 Flashback logs are maintained in redo log files.  C、 Flashback logs are maintained in the Flash Recovery Area.  D、 Flashback logs are used to maintain Flashback Database related errors.  E、 Flashback logs need to be cleared manually after you disable Flashback Database.  

点击查看答案
第6题
[] You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

A、A.  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；  B、B.  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；  C、C.  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；  D、D.  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；  

点击查看答案
第7题
[单选题] Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）

A、 DBWn  B、 RVWR  C、 ARCH  D、 RECO  E、 TRWR  

点击查看答案
第8题
[单选题] You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So&

A、You should implement Differential backup   B、You should implement Database snapshots  C、You should implement Primary filegroup backup   D、You should implement Transaction log backup  

点击查看答案
第9题
[单选题] As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

A、 Shut down the database  B、 Clear the online redo log  C、 Back up the database  D、 Checkpoint the database  E、 Call Oracle support  

点击查看答案
第10题
[] Which of the following roles must be granted to a user to perform a full database import？（）

A、A.CONNECT  B、B.IMP_FULL_DATABASE  C、C.FULL_EXPORT_PRIVS  D、D.RESOURCE  E、E.FULL_IMPORT_PRIVS  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服