You execute this command: Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two.)
A.
AUTOEXTEND is possible for the datafile
B.
It must be bigger than the largest SMALLFILE tablespace
C.
Additional data files may not be added
D.
It will be a dictionary-managed tablespace by default
A & C.
A - AUTOEXTEND is possible for any data file or temp file. It's not included in this sentence, but is possible to enable it in the future (OMF files enable AUTOEXTEND by default)
B - This restriction isn't mentioned anywhere
C - BIGFILE tablespaces only allows one datafile
D - BIGFILE tablespaces are supported only for locally managed tablespaces with automatic segment space management
E - BIGFILE tablespaces's datafile can have different block sizes
Quotations originate in official Oracle Database 19c documentation.
A – true; “With a bigfile tablespace, you can use the AUTOEXTEND clause outside of the ADD DATAFILE clause.”
B – false; there is no restriction for minimal size of a bigfile tablespace mentioned in Oracle documentation
C – true; “A bigfile tablespace is a tablespace with a single, but potentially very large (up to 4G blocks) data file. Traditional smallfile tablespaces, in contrast, can contain multiple data files, but the files cannot be as large.”
D – false; “Bigfile tablespaces are supported only for locally managed tablespaces with automatic segment space management, with three exceptions: locally managed undo tablespaces, temporary tablespaces, and the SYSTEM tablespace.”
E – false; “A.2 Physical Database Limits … Database Block Size … Maximum …
Operating system dependent; never more than 32 KB“
Correct answer is A and C
A = Because autoextend is a feature that is usually set by default in TBS BIGFILE.
C = Because the tablespace of type BIGFILE can only have one datafile.
B is not correct: Because it is possible to create a 10GB TBS BIGFILE, but in a year it will grow to 100GB while we have another 25GB NORMAL TBS.
Correct answer is A and C
A = Because autoextend is a feature that is usually set by default in TBS BIGFILE.
C = Because the tablespace of type BIGFILE can only have one datafile.
B is not correct: Because it is possible to create a 10GB TBS BIGFILE, but in a year it will grow to 100GB while we have another 25GB NORMAL TBS.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
danito
Highly Voted 4Â years, 8Â months agoelvegaa
Highly Voted 4Â years, 2Â months agoaihamza
Most Recent 6Â months agoHassanShami
1Â year, 1Â month agonautil2
1Â year, 4Â months agoauwia
1Â year, 7Â months agoMethio
1Â year, 8Â months ago0z0n3
1Â year, 8Â months agoAberTroth
1Â year, 8Â months agoRaNik69
1Â year, 9Â months agoFelipeC
2Â years agoalexbraga93
2Â years, 2Â months agoamayorcas
2Â years, 4Â months agoBlob44
2Â years, 4Â months agoAlbertopology
2Â years, 5Â months agoLeandroHPN
2Â years, 6Â months agoamayorcas
2Â years, 7Â months ago