Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?

The correct answer is B. Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin. C. Shut down the database instance. D. Restart the database instance in UPGRADE mode. E. Restart the instance in normal mode. G. Set the MAX_STRING_SIZE parameter to EXTENDED. 1. Shut down the database. 2. Restart the database in UPGRADE mode. 3. Change the setting of MAX_STRING_SIZE to EXTENDED. 4. Run the rdbms/admin/utl32k.sql script. You must be connected AS SYSDBA to run the script. 5. Restart the database in NORMAL mode…

New Features for Storage

Question

Options

ARestart the database Instance in RESTRICTED mode.
BRun the ut132k.sql script in $ORACLE_HOME/rdbms/admin.
CShut down the database instance.
DRestart the database instance in UPGRADE mode.
ERestart the instance in normal mode.
FRun the Database Migration Assistant.
GSet the MAX_STRING_SIZE parameter to EXTENDED.

How the community answered

(28 responses)

A
4% (1)
B
82% (23)
F
14% (4)

Explanation

Shut down the database. 2. Restart the database in UPGRADE mode. 3. Change the setting of MAX_STRING_SIZE to EXTENDED. 4. Run the rdbms/admin/utl32k.sql script. You must be connected AS SYSDBA to run the script. 5. Restart the database in NORMAL mode. 9C0E6724693C.htm#REFRN10321

Topics

#extended data types#MAX_STRING_SIZE#UPGRADE mode#VARCHAR2 expansion

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice