题目
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.
第1题
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题
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题
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题
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题
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题
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题
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题
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题
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题
A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant
第11题
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
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!