which action should you take?

Your database operates in
ARCHIVELO Gmode. User-managed consistent backups are performed every Sunday night.
On Tuesday, client A drops a table at 8:00
A.m. as follows:
SQL> DROP TABLE cust_ord PURGE;
Table dropped.
Client B executes a query at 9:00 A.m. on the same table as follows:
SQL> SELECT * FROM cust_ord;
SELECT * FROM cust_ord
*
ERROR at line 1:
ORA-00942: table or view does not exist
Client B needs the dropped table and reports the problem to you.
With reference to this scenario, which action should you take?

Your database operates in
ARCHIVELO Gmode. User-managed consistent backups are performed every Sunday night.
On Tuesday, client A drops a table at 8:00
A.m. as follows:
SQL> DROP TABLE cust_ord PURGE;
Table dropped.
Client B executes a query at 9:00 A.m. on the same table as follows:
SQL> SELECT * FROM cust_ord;
SELECT * FROM cust_ord
*
ERROR at line 1:
ORA-00942: table or view does not exist
Client B needs the dropped table and reports the problem to you.
With reference to this scenario, which action should you take?

A.
retrieve the table by using the flashback feature

B.
restore all the data files from last Sunday’s backup and then perform a time-based
recovery

C.
restore all the data files from last Sunday’s backup and then perform a log sequence
recovery

D.
restore all the data files from last Sunday’s backup and then perform a cancel-based
recovery

E.
restore from last Sunday’s backup only data files that belong to the table space in which
the table was stored and then perform a complete recovery



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Google

Google

Please stop by the websites we stick to, like this 1, because it represents our picks in the web.

SEO services in Lahore

SEO services in Lahore

Here are a number of the internet sites we suggest for our visitors

app maker

app maker

The data talked about inside the write-up are several of the top offered

how to make your own app

how to make your own app

we came across a cool internet site which you could appreciate. Take a search in case you want

satta matka

satta matka

usually posts some quite exciting stuff like this. If you are new to this site

satta matka

satta matka

one of our visitors just lately advised the following website

app maker

app maker

we like to honor many other online sites around the net, even when they arent linked to us, by linking to them. Underneath are some webpages worth checking out