You work as a database administrator for Certkiller .com. Yo

题目
单选题
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database?()
A

Start the instance and open the database, instance recovery automatically recovers control files 

B

Create a file based on the contents of the trace file and save it to the control file locations and start the database 

C

Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 

D

Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 

E

Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You work as a database administrator for Certkiller .com. 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 Advisors
  • B、Segment Advisors
  • C、SQL Tuning and Access Advisors
  • D、Automated Workload Repository (AWR)
  • E、Automatic Database Diagnostic Monitor (ADDM)

正确答案:C

第2题:

You work as a database administrator for Certkiller .com. 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?()

  • A、All control files are opened
  • B、All redo files are opened
  • C、The password file is opened
  • D、The parameter file is opened
  • E、All online data files are opened

正确答案:B,E

第3题:

You work as a database administrator for Certkiller .com. 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 failover
  • B、Configure shared server
  • C、Enable database failover
  • D、Enable connect-time failover
  • E、Enable Transparent Application Failover (TAF)

正确答案:D

第4题:

You work as a database administrator for Certkiller .com. 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 Control
  • B、Management Server
  • C、Management Repository
  • D、Application Server Control
  • E、Oracle Management Agent

正确答案:E

第5题:

You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. 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.ora
  • B、names.ora
  • C、spfile.ora
  • D、sqlnet.ora
  • E、listener.ora
  • F、tnsnames.ora

正确答案:D,F

第6题:

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this? ()

  • A、The DBMS_JOB package
  • B、The BACKUP_JOB package
  • C、The DBMS_BACKUP_RESTORE package
  • D、The calendar tool in the Operating System (OS)
  • E、The backup scheduler in Enterprise Manager (EM)
  • F、The DBMS_BACKUP_SCHEDULER packager inline mode

正确答案:E

第7题:

You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA).  You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()

  • A、Control file
  • B、Password file
  • C、Parameter file
  • D、Online redo log file
  • E、Listener controller file
  • F、Server parameter file

正确答案:B

第8题:

You work as a database administrator for Certkiller .com. 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 backup
  • B、Online backup
  • C、consistent backup
  • D、incremental backup
  • E、inconsistent backup

正确答案:C

第9题:

You work as a database administrator for Certkiller .com. 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 file
  • B、The fixed views
  • C、The data dictionary views
  • D、The operating system log fields
  • E、The dynamic performance views.

正确答案:E

第10题:

单选题
You work as a database administrator for Certkiller .com. 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_DEST

B

CORE_DUMP_DEST

C

ALERT_LOG_DEST

D

ALERT_DUMP_DEST

E

TRACE_DUMP_DEST

F

BACKGROUND_DUMP_DEST


正确答案: D
解析: 暂无解析

更多相关问题