單項(xiàng)選擇題

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?（）

A. Complete Recovery with online redo log
B. Complete Recovery with archived redo log
C. Tablespace Point-in-Time Recovery (TSPITR)
D. Incomplete Recovery with system change number (SCN)

你可能感興趣的試題

多項(xiàng)選擇題

Which two statements about the SQL Management Base （SMB） are true？（）

A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log，the plan history，plan baselines，and SQL profiles.

多項(xiàng)選擇題

Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)

A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

你可能感興趣的試題

Which two statements about the SQL Management Base （SMB） are true？（）

Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)

Which two statements about the SQL Management Base （SMB） are true？（）