-
You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）
A . Event Viewer gives more details on the failure.
B . The alert log file gives detailed information about the failure.
C . PMON rolls back the transaction and releases the locks.
D . SMON rolls back the transaction and releases the locks.
E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
-
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.
-
In WebLogic 10.3.6 and 12c, transaction logs can optionally write to a JDBC store instead of a file store on the file system. Identify the three benefits as a result of this capability.（）
A . simplified disaster recovery architecture and efforts
B . better performance than writing logs to a file store
C . common storage of transaction logs with application data
D . common replication of transaction logs with application data
E . higher transaction throughput
-
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 transactio
-
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
A . uses undo data for roll forward
B . uses Flashback Log for recovery
C . uses online redo logs to roll back
D . uses undo data to roll back the transaction
E . uses Recovery Manager （RMAN） to roll back
F . uses the System Monitor （SMON） background process to perform instance recovery
-
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)
A . ALTER DATABASE FLASHBACK ON;
B . GRANT SELECT any transaction TO scott;
C . GRANT EXECUTE ON dbms_flashback TO scott;
D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E . ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
-
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this 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.
-
After completing a commercial transaction, （） will execute the transfer of goods from the seller to the buyer in the most-effective manner.
A . Logistics
B . Supply chain
C . Virtual warehouse
D . Transportation
-
If the place named for the loading is simply a port or dock，notice of readiness may be given as soon as the ship arrives（）although she is not in the particular spot where the loading is to take place.
A . in the loading place
B . in the port or dock
C . in the loading spot
D . in the discharging spot
-
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
A . guarantee undo retention
B . add one more redo log group
C . size the redo log files appropriately
D . size the UNDO tablespace appropriately
E . size the SYSTEM tablespace appropriately
F . configure an appropriate undo retention interval
G . change automatic undo management to manual
-
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）
A . ALTER DATABASE FLASHBACK ON;
B . GRANT SELECT any transaction TO scott;
C . GRANT EXECUTE ON dbms_flashback TO scott;
D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E . ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
-
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）
A . ALTER DATABASE FLASHBACK ON
B . GRANT SELECT any transaction TO scott
C . GRANT EXECUTE ON dbms_flashback TO scott
D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
E . ALTER TABLESPACE undots1 RETENTION GUARANTEE
F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS
-
A ________ transaction in the foreign exchange market requires delivery of foreign exchange at some future date.
-
A __________ transaction in the foreign exchange market requires an almost immediate delivery of foreign exchange.
-
Customers must have access to the Internet and a valid method of payment in order to complete a transaction.
-
听力原文：Each month the cardholder receives a statement from the bank, which lists the details of all the transactions in the month, together with the total amount outstanding.
(4)
A．Each month the cardholder receives a statement and the amount of all the transactions.
B．Each month the bank gives the cardholder a statement showing the total amount outstanding.
C．Each month the bank gives the cardholder a statement showing the compound interest.
D．Each month the bank gives the cardholder a statement showing any minimum amount that needs to be paid.
-
听力原文：Typical foreign exchange transactions involve trades of one currency for another in the spot or cash market, or forward transactions.
(3)
A．Forward transactions is not of typical foreign exchange transactions.
B．Typical foreign exchange transactions occur in the spot or cash market.
C．Forward transactions don't occur in the spot or cash market.
D．Typical foreign exchange transactions occur only in the spot market.
-
The greater use of cash in a transaction can lay the foundation for keeping financialsystem more stable and rational.
查看材料
-
In the first paragraph, the word spot means______.
A．find
B．help
C．teach
D．treat
-
Journalizing is the process to record transactions in a __________.
-
When market participants expect the spot price of a commodity to be higher in the future, the commodity market is most likely said to be in:
A、contango.
B、Full carry
C、backwardation
-
In a Mergers and Acquisition transaction, the buyer prefers.在并购交易中，买方更喜欢：（)。
A．Assetdeal资产交易
B．Stockdeal股票交易
C．Merger合并
-
Which of the following events is not a transaction that would be recorded in a company
A．A.The purchase of equipment .
B．B.The investment of additional cash in the business by the owner.
C．C.The death of a key manager.
D．D.The sale of equipment .
-
The foreign exchange option transaction in which the buyer of the contract has the right to sell a specific amount of currency to the seller at the agreed exchange rate on or before the expiration dat
A．Call option
B．American option
C．Put option
D．European option
此题为多项选择题。
