网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Your database is not configured for session failover. Your tnsnames.ora file contains the following details： test.us.oracle.com= （DESCRIPTION= （ADDRESS_LIST= （LOAD_BALANCE=off） （FAILOVER=ON） （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521）） （ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521））） （CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com））） Which feature is enabled in this case？（）
A
Load balancing
B
Instance failover
C
Database failover
D
Connect-time failover
E
Transparent Application Failover （TAF）
参考答案
参考解析
解析：
暂无解析
更多 “单选题Your database is not configured for session failover. Your tnsnames.ora file contains the following details： test.us.oracle.com= （DESCRIPTION= （ADDRESS_LIST= （LOAD_BALANCE=off） （FAILOVER=ON） （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521）） （ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521））） （CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com））） Which feature is enabled in this case？（）A Load balancingB Instance failoverC Database failoverD Connect-time failoverE Transparent Application Failover （TAF）” 相关考题
考题
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（） A、 The block change tracking feature must be enabled.B、 OMF must be configured on your database.C、 The database must be in ARCHIVELOG mode.D、 A USERID must be supplied.
考题
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（） A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
考题
Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this（）A、to limit the User Global Area （UGA） memory allocated to a session from the SGAB、to limit the amount of memory to be used for the dispatcher queue of a session in SGAC、to limit the amount of memory to be used for the request pool in System Global Area （SGA）D、to control the amount of memory allocated in SGA for the local variables for each shared server process
考题
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）A、LOGICAL_READS_PER_SESSION B、CONNECT_TIME C、COMPOSITE_LIMIT D、CPU_PER_SESSION E、PRIVATE_SGA
考题
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）A、renaming the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files， after you lost all the control files in your database
考题
You issued the following statement in your SQL*Plus session： SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）A、 creating a table in your schema and you exceed your allocated space quota on the tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
考题
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A、 the system change numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
考题
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
考题
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
考题
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
考题
Your database is not configured for session failover. Your tnsnames.ora file contains the following details： test.us.oracle.com= （DESCRIPTION= （ADDRESS_LIST= （LOAD_BALANCE=off） （FAILOVER=ON） （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521）） （ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521））） （CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com））） Which feature is enabled in this case？（）A、Load balancingB、Instance failoverC、Database failoverD、Connect-time failoverE、Transparent Application Failover （TAF）
考题
单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）A
renaming the control filesB
dropping a user in your databaseC
enabling or disabling redo log archivingD
dropping a tablespace in your databaseE
re-creating the control files， after you lost all the control files in your database
考题
多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.
考题
多选题You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)AEven with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.BA resumable statement is suspended only if an out of space error occurs.CWhen a resumable statement is suspended, the transaction that contains the statement is also suspended.DA resumable statement can only be suspended and resumed once during the execution of the statement.EYou can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session
考题
单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A
backup database allB
backup compressed databaseC
backup as compressed backupset databaseD
backup as compressed backup database plus archivelog allE
backup as compressed backupset database plus compress archivelog all
考题
单选题Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this（）A
To limit the User Global Area （UGA） memory allocated to a session from the SGAB
To limit the amount of memory to be used for the dispatcher queue of a session in SGAC
To limit the amount of memory to be used for the request pool in System Global Area （SGA）D
To control the amount of memory allocated in SGA for the local variables for each shared server process
考题
单选题You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）A
LOGICAL_READS_PER_SESSION B
CONNECT_TIME C
COMPOSITE_LIMIT D
CPU_PER_SESSION E
PRIVATE_SGA
考题
单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A
The time when the last flashback operation in your database was performed.B
The time when the first flashback operation in your database was performed.C
A list of flashback operations performed in your database using SCN and time.D
The approximate time and the lowest system change number （SCN） to which you can flash back your database.
考题
单选题Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA， which configuration would you set to support more than 1，500 connections at a time（）A
You would configure more listeners for the database.B
You would configure the database in shared server mode to use the connection pooling feature.C
You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.D
You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
考题
单选题Your database is not configured for session failover. Your tnsnames.ora file contains the following details： test.us.oracle.com= （DESCRIPTION= （ADDRESS_LIST= （LOAD_BALANCE=off） （FAILOVER=ON） （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521）） （ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521））） （CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com））） Which feature is enabled in this case？（）A
Load balancingB
Instance failoverC
Database failoverD
Connect-time failoverE
Transparent Application Failover （TAF）
考题
单选题You issued the following statement in your SQL*Plus session： SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）A
creating a table in your schema and you exceed your allocated space quota on the tablespaceB
executing a long query that involves a sort operation and the statement runs out of temporary spaceC
loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD
creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
考题
单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）A
by using the RMAN utilityB
by using the export/import utilityC
by using the ALTER DATABASE commandD
by enabling the change tracking feature
考题
多选题Which are the prerequisites for performing flashback transactions on your database？（）AUndo retention guarantee for the database must be configured.BSupplemental log must be enabled for the primary key.CSupplemental log must be enabled.DExecute permission on the DBMS_FLASHBACK package must be granted to the user.
考题
单选题You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A
the system change numberB
the locations of the redo log filesC
the locations of the datafilesD
the physical location of all the database changes
考题
单选题A customer needs to ensure that the number of threads servicing an application does not exceed the number of database connections available to the application. What step must you take to address this situation?（）A
Configure a Max Threads Constraint and add your application to the list of applications for the Constraint.B
Configure a Work Manager with a Maximum Threads Constraint tied to the Connection Pool and configuration your application to use the Work Manager.C
Configure a Work Manager with a Minimum Threads Constraint tied to the Connection Pool and configure your application to use the Work Manager.D
Configure a global MaxThreads constraint and target it to the server or clusters where your application is deployed.E
Configure the startup parameter -Dwls-maxThreads to be the same as the number of database connections configured.
考题
多选题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
考题
单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A
the time when the last flashback operation in your database was performedB
the time when the first flashback operation in your database was performedC
a list of flashback operations performed in your database using SCN and timeD
the approximate time and the lowest system change number （SCN） to which you can flash back your database
考题
单选题The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）A
The block change tracking feature must be enabled.B
OMF must be configured on your database.C
The database must be in ARCHIVELOG mode.D
A USERID must be supplied.
热门标签
最新试卷
