You issued the following command:
SQL> DROP TABLE employees;
Which three statements are true?
A.
All uncommitted transactions are committed.
B.
All indexes and constraints defined on the table being dropped are also dropped.
C.
Sequences used in the employees table become invalid.
D.
The space used by the employees table is reclaimed immediately.
E.
The employees table can be recovered using the rollback command.
F.
The employees table is moved to the recycle bin.
Explanation:
http://www.sqlcourse.com/drop.html
A: IS WRONG ( ALL uncommited transactions are ROLLBACK )
B: IS CORRECT!
C: IS CORRECT!
D: IS WRONG ( The space isn’t reclaimed immediately, JUST if used PURGE option )
E: IS WRONG ( The table just can recovered with clause FLASHBACK TABLE, sure if the PURGE option it was not used)
F: IS CORRECT!
sorry,
correcting..
sequences used in table are not affected, and all transaction uncommited will be commited
I think that the correct answer is
– A
– B
– F
A sequence created directly on the table with the clause IDENTITY will be dropped as well. Still the statement C remains false; the sequence won’t become invalid, it will be dropped without problem.
Yes,
A, B and F are the correct answers.
A, B and F are correct.
A: If a user issues a DDL (CREATE, ALTER, or DROP) or DCL (GRANT or REVOKE) command, the transaction in progress (if any) will be committed.
A-B-F
Here is an excellent Weblog You may Obtain Exciting that we encourage you to visit.
one of our guests a short while ago encouraged the following website
Wonderful story, reckoned we could combine a handful of unrelated data, nevertheless definitely really worth taking a search, whoa did a single master about Mid East has got more problerms as well
that will be the end of this post. Here youll locate some sites that we consider you will value, just click the links over
we came across a cool site that you simply may well love. Take a look for those who want
Here is a good Blog You might Uncover Fascinating that we encourage you to visit.
the time to study or take a look at the content material or web-sites we have linked to below the
please go to the websites we adhere to, like this one, as it represents our picks from the web
Here is a great Blog You may Obtain Fascinating that we Encourage You
Wonderful story, reckoned we could combine a handful of unrelated information, nevertheless actually really worth taking a search, whoa did 1 discover about Mid East has got more problerms as well
always a major fan of linking to bloggers that I appreciate but really don’t get a lot of link enjoy from
Here are several of the web sites we suggest for our visitors
Here are several of the web sites we recommend for our visitors
below you will obtain the link to some web sites that we think you ought to visit
Sites of interest we have a link to
one of our visitors not too long ago suggested the following website
although websites we backlink to below are considerably not associated to ours, we really feel they’re in fact really worth a go via, so have a look
Wonderful story, reckoned we could combine several unrelated information, nevertheless definitely really worth taking a search, whoa did one study about Mid East has got much more problerms as well
that is the finish of this write-up. Right here you will locate some websites that we think you will appreciate, just click the hyperlinks over
please stop by the websites we follow, including this one particular, because it represents our picks through the web
usually posts some incredibly intriguing stuff like this. If youre new to this site
usually posts some very fascinating stuff like this. If youre new to this site
always a huge fan of linking to bloggers that I like but do not get quite a bit of link adore from
You must take part in a contest for one of the best blogs on the web. I’ll suggest this site!