网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?（）
- A、CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
- B、CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
- C、CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
- D、CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1
参考答案
更多 “A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?（）A、CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446B、CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446C、CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1D、CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1” 相关考题
考题
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 modeB. Opening the database with the RESETLOGS optionC. Setting a new DBID for the newly restored databaseD. Restoring the server parameter file (SPFILE) to the new host
考题
Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? ()
A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database
考题
Examine the following command that is used to duplicate a database on the same host:RMAN RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database
考题
Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database
考题
Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?()
A.LIST DB DIRECTORYB.LIST DCS DIRECTORYC.LIST NODE DIRECTORYD.LIST ACTIVE DATABASES
考题
You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP address and listener port number， change frequently due to development requirements， and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）A、Host namingB、Local namingC、Easy ConnectD、External namingE、directory naming
考题
You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）A、More than one database is to be registered with the listener.B、The users will connect the database by using the host naming method.C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.D、The database that is to be registered with the listener is configured in shared server mode.E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
考题
Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?（）A、LIST DB DIRECTORYB、LIST DCS DIRECTORYC、LIST NODE DIRECTORYD、LIST ACTIVE DATABASES
考题
Examine the following command that is used to duplicate a database on the same host: RMAN RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)A、The data files of the read-only tablespaces in the target database are not duplicatedB、The read-only tablespaces in the target database are still defined in new the databaseC、The read-only tablespaces in the target database are changed to online after duplicationD、The data files of the read-only tablespaces in the target database get duplicatedE、The read-only tablespaces in the target database are not defined in the new database
考题
You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
考题
Identify architecturally where in an application， Coherence stack will be used （）A、 coherence resides locally on the machines of all remote application usersB、 coherence resides between remote users and the Web tierC、 coherence resides between the Web tier and application tierD、 coherence resides between the application tier and data tier
考题
You work as a database administrator for Supportcenter.cn. You are using three database， SupportCenter DB01， SupportCenter DB02， and SupportCenter DB03， on different host machines in your development environment. The database server configuration， such as IP address and listener port number， change frequently due to development requirements， and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）A、Host namingB、Local namingC、Easy ConnectD、External namingE、directory naming
考题
多选题You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
考题
单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）A
One tablespace has only one datafileB
Many tablespaces can share one datafileC
One tablespace can have many datafilesD
One datafile can contain many tablespaces
考题
单选题A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?（）A
CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446B
CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446C
CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1D
CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1
考题
单选题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 modeB
Opening the database with the RESETLOGS optionC
Setting a new DBID for the newly restored databaseD
Restoring the server parameter file （SPFILE） to the new host
考题
单选题In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this？（）A
Modify the value for the UTL_FILE_DIR parameter in the parameter fileB
Grant read and write privilege on the operating system path to the database usersC
Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter fileD
Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter fileE
Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users
考题
多选题Examine the following command that is used to duplicate a database on the same host： RMAN RUN { ALLOCATE AUXILIARY CHANNEL， aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY； / } Which two statements describe the effect after the database is duplicated successfully？（）AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database
考题
单选题You work in a company which is named Wiikigo Corp. The company 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 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use? （）A
You should use database snapshots B
You should use database backup and restore C
You should use database backup and restore along with compression D
You should use schema-bound views in a read-only database. The database resides on the same instance.
考题
单选题The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）A
OracleSIDsonlyB
Oracle homes onlyC
Oracle install timestampD
Oracle inventory pointer filesE
Oracle database creation timestampF
OracleSIDsand Oracle homes onlyG
OracleSIDs， Oracle homes and flag for auto startup
考题
单选题In which situation would you use static database registration for a listener（）A
when multiple databases are to be registered with the listenerB
when DBAs need to connect remotely to start up the database instanceC
when users need to connect the database instance using the host naming methodD
when the database instance that is to be registered with the listener is configured in shared server mode
考题
多选题Which three statements are true about Flashback Database?（）AFlashback logs are written sequentially, and are archived.BFlashback Database uses a restored control file to recover a database.CThe Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.DFlashback Database can recover a database to the state that it was in before a reset logs operation.EFlashback Database can recover a data file that was dropped during the span of time of the flashback.FFlashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
考题
单选题You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）A
SQL*PlusB
iSQL*PlusC
Management ServerD
Management RepositoryE
Oracle Enterprise Manager 10g Database Control
考题
多选题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？（）AApplication Server ControlBOracle Management ServiceCOracle Enterprise Manager RepositoryDOracle Enterprise Manager Database Control
考题
单选题Identify architecturally where in an application， Coherence stack will be used （）A
coherence resides locally on the machines of all remote application usersB
coherence resides between remote users and the Web tierC
coherence resides between the Web tier and application tierD
coherence resides between the application tier and data tier
考题
单选题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 modeB
Opening the database with the RESETLOGS optionC
Setting a new DBID for the newly restored databaseD
Restoring the server parameter file (SPFILE) to the new host
热门标签
最新试卷