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 »
In your data center, Oracle Managed Files (OMF) is used for all databases.All tablespaces are smallfile tablespaces.SALES_Q1 is a permanent user-defined tablespace in the SALES database.Examine this command which is about to be issued by a DBA logged in to the SALES database:ALTER TABLESPACE sales_q1 ADD DATAFILE;Which are two actions, either one of which you could take to… 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 »
In your data center, Oracle Managed Files (OMF) is used for all databases.All tablespaces are smallfile tablespaces.SALES_Q1 is a permanent user-defined tablespace in the SALES database.Examine this command which is about to be issued by a DBA logged in to the SALES database:ALTER TABLESPACE sales_q1 ADD DATAFILE;Which are two actions, either one of which you could take to… 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 »
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 »
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 »