A C i think the correct answers, becuase B has not sense and i did not references about that

AC is correct answer all thanks to validitexams.com

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?

B is not correct. The size of file doesn't related to other normal tablespaces

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“

A and C are corrects.

A c is answer

AC is correct

A and C

A= Correct - Tested C= Correct - Tested

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

I've tested in my lab and: B - is not correct 'cause having a 30GB smallfile tablespace, I can create a 10GB bigfile tablespace

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 = Because autoextend allowed in TBS BIGFILE. C = Because the tablespace of type BIGFILE can only have one datafile.

100% A and C

A and C

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.