When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?（）

相似题目

• Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

  A .  log writer B .  archival C .  process monitor D .  system monitor E .  change tracking writer F .  database writer

  查看最佳答案

• You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

  A . Information about each Oracle Net connection. B . Information about each entry in theLinstener.orafile C . Information about the changed done in the database D . Information about the different listeners in your system E . Information about all thenondatabasefiles required to operate the database

  查看最佳答案

• When youre performing active database duplication，a backup of what kind is required？（）  

  A .  A current RMAN backup-set backup is required. B .  No backup is required. C .  An RMAN image backup is required. D .  A manual backup is required. E .  A "duplicate" preparatory backup is required.

  查看最佳答案

• What does the minimize load database parameter mean when backing up a database?（）

  A . RMAN will attempt to make the backup run as fast as possible without any IO limitations.  B . RMAN will automatically restrict the number of channels in use to one.  C . RMAN will spread the backup IO over the total duration stated in the backup command. D . RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up.  E . Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first.&e

  查看最佳答案

• In a high-availability deployment, when the Cisco CRS Administrator adds a JTAPI Call Control Group with 100 CTI ports, how many device records will be added to the Cisco Unified CallManager database?（）

  A . CTI Ports are not added by the creation of a Call Control Group.   B . CTI ports are no longer required to be added to the Cisco Unified CallManager database.   C . 100 devices will be added to the Cisco Unified CallManager database.   D . 200 devices will be added to the Cisco Unified CallManager database.   E . It depends upon how many port groups these ports will be split into.   F . It depends upon the number of server nodes within the Cisco Unified CallManager cluster.

  查看最佳答案

• What two things happen when the CRS Publisher Database on an HRDB expansion server fails?（）

  A . All call processing immediately begins using the CRS Subscriber Database.  B . Calls in queue are dropped.  C . Agent calls are dropped.  D . Agents are automatically logged out.  E . CRS configuration changes are blocked until the CRS Publisher Database is restored and synchronized with the CRS Subscriber Database.  F . Configuration changes are buffered until the CRS Publisher Database is restored.

  查看最佳答案

• When designing a single tier AIX database solution for a customer， what other technical specialist would be most instrumental in putting together a total solution and why？（）

  A . xSeries specialist，as the customer may have some Intel-based systems. B . Hardware customer engineer，as they will be installing the entire solution. C . Services specialist，as they can provide education recommendations for the entire solution.  D . Storage specialist，as the customer may need disk to store the data and tape to backup the data.

  查看最佳答案

• When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）

  A . Size of typical transactions  B . Concurrent transactions  C . Size of rows in table most frequently changed  D . Number of anticipated disk sort

  查看最佳答案

• 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.

  查看最佳答案

• Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

  A . archival B . log writer C . database writer D . system monitor E . process monitor F . change tracking writer

  查看最佳答案

• 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.

  查看最佳答案

• When performing recover of a database in NOARCHIVELOG mode with RMAN， the target database must be in the （） state to restore the control file.

  A . OPEN B . IDLE C . MOUNT D . NOMOUNT

  查看最佳答案

• When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）

  A . create B . import C . load D . sqlimport E . update

  查看最佳答案

• When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）  

  A .  log_file_name_convert B .  convert_log_file_name C .  file_name_convert_log D .  redo_log_file_name_convert E .  logfile_convert_directory

  查看最佳答案

• Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）  

  A .  Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database. B .  Oracle will automatically take the datafile out of hot backup mode and then open the database. C .  Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database. D .  The database will open with the file in hot backup mode. You can restart the backup at any time. E .  The datafile in hot backup mode will be corrupted and you will have to recover it.

  查看最佳答案

• When WebSphere Commerce， WebSphere Application Server， the web server and the database server are all located on a single machine， which of the following statements are TRUE？ （）

  A . this is a multi-node installation B . this is a single node installation. C . each hardware and software component is a single point of failure. D . this is an example of load balancing.

  查看最佳答案

• you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

  A .  True B .  False

  查看最佳答案

• What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）

  A . The standby database is protected against write operations.  B . The primary database is protected against write operations.  C . The primary database is protected against data loss and data divergence.  D . The standby database is protected against data loss and data divergence.&e

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）

  A . Information about each Oracle Net connection. B . Information about each entry in theLinstener.orafile C . Information about the changed done in the database D . Information about the different listeners in your system E . Information about all thenondatabasefiles required to operate the database

  查看最佳答案

• When an ASM instance receives a SHUTDOWN NORMAL command，what command does it pass on to all database instances that rely on the ASM instances disk groups？（）

  A .  TRANSACTIONAL B .  IMMEDIATE C .  ABORT D .  NORMAL

  查看最佳答案

• Two database users， Jack and Bill， are accessing the Certkiller STAFF table of the Certkiller DB database. When Jack modifies a value in the table， the new value is invisible to Bill.  Which is the modified value invisible to Bill？（）

  A . The modified data are not available on disk. B . The modified data have been flushed out from memory. C . The modified rows of the Certkiller STAFF table have been locked. D . Jack has not committed the changes after modifying the value. E . Both users are accessing the database from two different machines.

  查看最佳答案

• Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）

  A . Maximum Undo per consumer group B . Maximum Idle time C . Parallel server limit D . CPU E . Exadata I/O F . Local file system I/O

  查看最佳答案

• A SQL Azure database generates an error when a row is inserted into any table in the database.  No error is generated when a row is deleted.  You need to recommend an approach for locating the source of the errors.  What should you recommend？（）  

  A .  Use a Dynamic Management View to check for locks. B .  Use a Dynamic Management View to check for blocked queries. C .  Use a Dynamic Management View to check for long-running queries. D .  Use a Dynamic Management View to check the size and maximum size of the database.

  查看最佳答案

• The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema.What happens when you execute this query？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' /> A. You obtain the results retrieved from the public synonym HR created by the database administrator. B. You obtain the results retrieved from the HR table that belongs to your schema. C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym. D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product. E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

  查看最佳答案