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

题目内容 (请给出正确答案)
单选题
You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go?()
A

3 hours

B

6 months

C

until last year

D

until last commit

E

until the point when the undotablespacewas refreshed

F

until the database is shut down and the memory erased


参考答案

参考解析
解析: 暂无解析
更多 “单选题You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go?()A 3 hoursB 6 monthsC until last yearD until last commitE until the point when the undotablespacewas refreshedF until the database is shut down and the memory erased” 相关考题
考题 You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?()A、Memory AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository (AWR)E、Automatic Database Diagnostic Monitor (ADDM)

考题 You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

考题 You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this?()A、Enable instance failoverB、Configure shared serverC、Enable database failoverD、Enable connect-time failoverE、Enable Transparent Application Failover (TAF)

考题 You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()A、Use a flashback query to retrieve the rows that were deletedB、Useconventialincremental export and then import the affected objectC、Shutdown the database inNORMALmode and restart the database instanceD、Use DBMS_META package to reconstruct the object using undo segmentsE、UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the dataF、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

考题 You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.

考题 You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

考题 You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?()A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup

考题 You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.

考题 You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error: ERROR:   ORA-12154:TNS:couldnot resolve service name   Which network configuration files would you look into to resolve this error?()A、snmp.oraB、names.oraC、spfile.oraD、sqlnet.oraE、listener.oraF、tnsnames.ora

考题 You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file?()A、USER_DUMP_DESTB、CORE_DUMP_DESTC、ALERT_LOG_DESTD、ALERT_DUMP_DESTE、TRACE_DUMP_DESTF、BACKGROUND_DUMP_DEST

考题 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 work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.

考题 多选题You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error: ERROR:   ORA-12154:TNS:couldnot resolve service name   Which network configuration files would you look into to resolve this error?()Asnmp.oraBnames.oraCspfile.oraDsqlnet.oraElistener.oraFtnsnames.ora

考题 单选题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 work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?()A Hot backupB Online backupC consistent backupD incremental backupE inconsistent backup

考题 单选题You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()A Database ControlB Management ServerC Management RepositoryD Application Server ControlE Oracle Management Agent

考题 单选题You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this?()A The DBMS_JOB packageB The BACKUP_JOB packageC The DBMS_BACKUP_RESTORE packageD The calendar tool in the Operating System (OS)E The backup scheduler in Enterprise Manager (EM)F The DBMS_BACKUP_SCHEDULER packager inline mode

考题 多选题You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()AUse a flashback query to retrieve the rows that were deletedBUseconventialincremental export and then import the affected objectCShutdown the database inNORMALmode and restart the database instanceDUse DBMS_META package to reconstruct the object using undo segmentsEUseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the dataFUse Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

考题 多选题You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()AExecute the ALTER DATABASE ARCHIVELOG statementBSelect ARCHIVELOG option in the database control and restart the database to apply the changes.CShut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.DShut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.

考题 单选题You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?()A Memory AdvisorsB Segment AdvisorsC SQL Tuning and Access AdvisorsD Automated Workload Repository (AWR)E Automatic Database Diagnostic Monitor (ADDM)

考题 单选题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.orafileC Information about the changed done in the databaseD Information about the different listeners in your systemE Information about all thenondatabasefiles required to operate the database

考题 单选题You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file?()A USER_DUMP_DESTB CORE_DUMP_DESTC ALERT_LOG_DESTD ALERT_DUMP_DESTE TRACE_DUMP_DESTF BACKGROUND_DUMP_DEST

考题 单选题You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table?()A Monitor thealert.logfileB Enable server-side SQL tracing for user sessionsC Enable fine-grained auditing for the customer tableD Enable Fine-Grained Access Control (FGAC) for the customer tableE Write a database trigger on the customer table on the SELECT event

考题 单选题You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this?()A Enable instance failoverB Configure shared serverC Enable database failoverD Enable connect-time failoverE Enable Transparent Application Failover (TAF)

考题 单选题You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A The trace fileB The fixed viewsC The data dictionary viewsD The operating system log fieldsE The dynamic performance views.

考题 多选题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 work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened