网友您好，请在下方输入框内输入要搜索的题目：

搜题

题目

[主观题]

You are a database administrator in the Los Angeles branch office of a specialty foods sup

plier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.

The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.

You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.

You want to enable the server in Sydney to connect to the mainframe. database. What should you do？

A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.

B．Modify the workflow in the DTS package so that the server in Sydney is included.

C．On the server in Sydney, install an OLE DB provider for the mainframe. database.

D．On the server in Sydney, delete and then re-create the DTS package.

查看参考答案

更多“You are a database administrator in the Los Angeles branch office of a specialty foods sup”相关的问题

第1题

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of t

he DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:ALTER TABLESPACE data1 BEGIN BACKUP;While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

D. If you restart the database, the database will not be opened.

点击查看答案

第2题

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager （RMAN) backup, which is the best option you would consider for the new database？（）

A. Opening the database in RESTRICTED mode

B. Opening the database with the RESETLOGS option

C. Setting a new DBID for the newly restored database

D. Restoring the server parameter file (SPFILE) to the new host

点击查看答案

第3题

You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set

the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true？（）

A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE

B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

C. The database instance starts, but Automatic Memory Management is disabled

D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

点击查看答案

第4题

The database is running in the ARCHIVELOG mode. It has three redo log groups with one memb

er each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command？（）

A. You should perform a log switch

B. You should make a backup of the database

C. You should switch the database to the NONARCHIVELOG mode

D. You should shut down the database instance and perform a complete database recovery

点击查看答案

第5题

You are the administrator of two Microsoft Windows 2000 advanced server computers. On thes

e servers, you are configuring a database that will store accounting information for your company.

The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.

How should you configure the database？

A．Configure the database on the two servers as a SQL Server 2000 cluster.

B．Configure the database on one server, and then configure a standby database on the second server.

C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.

D．Configure the database as a federated database, and then partition half the data on each server.

点击查看答案

第6题

You realize that the control file is damaged in your production database.After restoring t

he control file from autobackup, what is the next step that you must do to proceed with the database recovery？（）

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

点击查看答案

第7题

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the

same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command？（）

You are managing the APPPROD database as a DBA. Yo

A. The source database should be open

B. The target database should be in ARCHIVELOG mode if it is open

C. RMAN should be connected to both the instances as SYSDBA

D. The target database backups should be copied to the source database backup directories

E. The password file must exist for the source database and have the same SYS user password as the target

点击查看答案

第8题

You are managing an Oracle Database 11g database with the ASM storage. The database is hav

ing big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.What configuration would you effect to achieve your objective？（）

A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

点击查看答案

第9题

You are the administrator of a SQL Server 2000 database named Articles. A large city newsp

aper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.

A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.

You want to ensure that the journalists can query the database. What should you do？

A．Create a new full-text catalog for the Articles database

B．Rebuild the full-text catalog for the Articles database

C．Create a new full-text index on the table that holds the text for the articles

D．Repopulate the full-text index on the table that holds the text for the articles

点击查看答案

第10题

our 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 Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant

点击查看答案

第11题

Which command do you use to display the status of an antivirus database update？（）

A. show security utm anti-virus status

B. show security anti-virus database status

C. show security utm anti-virus database

D. show security utm anti-virus update

点击查看答案