You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
Exam 1z0-082 All QuestionsBrowse all questions from this exam
Question 1
Correct Answer: A, C
The BIG_TBS tablespace, being a BIGFILE tablespace, allows the AUTOEXTEND option for the datafile, meaning the datafile can automatically grow as needed without manual intervention. Additionally, a BIGFILE tablespace can only contain a single, large datafile and does not allow adding additional datafiles. Therefore, options stating that AUTOEXTEND is possible and additional data files may not be added are correct.
Discussion
danitoOptions: AC
A C i think the correct answers, becuase B has not sense and i did not references about that
nautil2Options: AC
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“
FelipeCOptions: AC
A= Correct - Tested B= False - Tested C= Correct - Tested (ORA-32771: cannot add file to bigfile tablespace) D= False - Tested (Getting DDL) E= False -Tested
alexbraga93Options: AC
I've tested in my lab and: B - is not correct 'cause having a 30GB smallfile tablespace, I can create a 10GB bigfile tablespace
AlbertopologyOptions: AC
100% A and C
LeandroHPNOptions: AC
A and C
JorgeB_DBA
Please help me with this concern, if the correct answers are a and b and in the exam i selecte a and c, what happens to the score? Will it be zero points for the question or will it be a partial score?
HassanShamiOptions: AC
B is not correct. The size of file doesn't related to other normal tablespaces
auwiaOptions: AC
A and C are corrects.
MethioOptions: AC
A c is answer
0z0n3Options: AC
AC is correct
AberTrothOptions: AC
A and C
RaNik69Options: AC
A= Correct - Tested C= Correct - Tested
amayorcasOptions: AC
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.
Blob44Options: AC
A = Because autoextend allowed in TBS BIGFILE. C = Because the tablespace of type BIGFILE can only have one datafile.
amayorcasOptions: AC
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.
algerianphoenixOptions: AC
AC, Correct Answer!