违法和不良信息举报 联系客服
免费注册 登录

You are in the middle of a transaction updating a very impor

题目
单选题
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
A

The online redo log files and archived redo log files are required to accomplish the recovery.

B

The uncommitted transaction will be committed at the next startup of the database instance.

C

The uncommitted transaction is rolled back automatically at the next opening of the database.

D

The DBA has to perform the recovery on the database to recover the uncommitted transaction

参考答案和解析
正确答案： C
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You don’t say whether you wish the transaction to be ()cash on credit.

A、at

B、by

C、on

D、in


参考答案：D

第2题：

View the following SQL statements:You want to back out transaction T2. Which option would you use?()

A. It is possible, but transaction T3 also backs out.

B. It is possible with the NOCASCADE_FORCE option.

C. It is possible with the NONCONFLICT_ONLY option.

D. It is not possible because it has conflicts with transaction T3.


参考答案：B

第3题：

—Shall we see a movie tonight?

--- ____.

A.Thank you very much

B.Good you very much

C.See you later


参考答案：B

第4题：

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

  • A、 You must use automatic undo management in the database.
  • B、 You must configure OMF in your database.
  • C、 You must configure ASM for storing the datafiles.
  • D、 You must multiplex the online redo log file.

正确答案:A

第5题：

You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）

  • A、 Only the Flashback Table
  • B、 Both the Flashback Transaction Query and the Flashback Version Query
  • C、 Only the Flashback Drop
  • D、 Only the Flashback Version

正确答案:B

第6题：

A:Hello, Linda, how are you? B:( ).

A. Very good. Are you good?

B. Very well, thank you. And you?

C. Hello, Rose, how do you do?


答案：B

第7题：

You think you are one of the high and mighty;remember pride goes before a fall.

A:very fast
B:very long
C:very great
D:very strong

答案：D
解析：
本句话的意思是：“你自以为是了不起的人物，别忘了骄兵必败。”mighty: 强大的、巨大的。fast：快的，例如：The lightening travels faster that the thunder storm．闪电比雷雨的速度快。long：长的。great：重大的、闻名的，例如：the great cultural achievements of the past 昔日辉煌的文化成就。strong：强大的、强壮的，例如：The local economy is strong and the population is growing．当地经济蓬勃发展，人口也在增长。

第8题：

—Would you like a coffee? — ()

A、Yes, please

B、I like coffee very much.

C、I like coffee very much.

D、Thank you very much.


参考答案：A

第9题：

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

  • A、On startup， SMON coordinates instance recovery.
  • B、On startup， CKPT coordinates instance recovery.
  • C、On startup， use RMAN to perform instance recovery.
  • D、Uncommitted changes will be rolled back after the database is opened.
  • E、On startup， perform media recovery and then instance recovery.
  • F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

正确答案:A,D

第10题：

You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）

  • A、The online redo log files and archived redo log files are required to accomplish the recovery.
  • B、The uncommitted transaction will be committed at the next startup of the database instance.
  • C、The uncommitted transaction is rolled back automatically at the next opening of the database.
  • D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

正确答案:C

更多相关问题
相关内容