The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.Segment creation is not deferred.You execute this command:Which three statements must be true so that the SALES user can create tables in SALES_Q1?(Choose three.) A. The sales user must have been granted the CREATE SESSION privilege B. The sales user must have… Read More »
You execute this command:CREATE SMALLFILE TABLESPACE salesDATAFILE ‘/u01/app/oracle/sales01.dbfSIZE 5GSEGMENT SPACE MANAGEMENT AUTO;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. It must be smaller than the smallest BIGFILE tablespace B. Free space is managed using freelists C. Any data files added to the tablespace must have a size… Read More »
You execute this command:CREATE SMALLFILE TABLESPACE salesDATAFILE `/u01/app/oracle/sales01.dbfSIZE 5GSEGMENT SPACE MANAGEMENT AUTO;Which two statements are true about the SALES tablespace? (Choose two.) A. Any data files added to the tablespace must have a size of 5 gigabytes B. It uses the database default blocksize C. Free space is managed using freelists D. It must be smaller than the… Read More »
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.Segment creation is not deferred.You execute this command:Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.) A. The sales user must have their quota on the users tablespace removed B. The sales user… Read More »
Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE `undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Add the ONLINE clause B. Set UNDO_TABLESPACE to UNDOTBS01 C. Add the NOLOGGING clause D. Add the SEGMENT SPACE MANAGEMENT AUTO clause E. Make certain that the database operates in automatic… Read More »
Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Set UNDO_TABLESPACE to UNDOTBS01 B. Add the SEGMENT SPACE MANAGEMENT AUTO clause C. Add the ONLINE clause D. Add the NOLOGGING clause E. Make certain that the database operates in automatic… Read More »
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.Segment creation is not deferred.You execute this command:Which three statements must be true so that the SALES user can create tables in SALES_Q1?(Choose three.) A. The sales user must have been granted the CREATE TABLE privilege B. The sales user must have… Read More »
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:1. A size of 100 MB2. AUTOEXTEND is off3. UNDO_RETENTION is set to 15 minutes4. It has RETENTION GUARANTEEUNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.What will happen when the next update is attempted by any transaction? A. It succeeds and the generated… Read More »
Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Set UNDO_TABLESPACE to UNDOTBS01 B. Make certain that the database operates in automatic undo management mode C. Add the NOLOGGING clause D. Add the SEGMENT SPACE MANAGEMENT AUTO clause E. Add… Read More »
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.Segment creation is not deferred.You execute this command:Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.) A. The sales user must have been granted the CREATE TABLE privilege B. The sales user must… Read More »