Tag Archives: temporary

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

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 »

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed

A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored? A. in the undo tablespace B. in the PGA C. in the SYSAUX tablespace D. in the SGA E. in the temporary tablespace Correct Answer: A

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

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 »

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed

A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored? A. in the undo tablespace B. in the SYSAUX tablespace C. in the SGA D. in the PGA E. in the temporary tablespace Correct Answer: E http://www.dba-oracle.com/t_temp_undo_enabled.htm

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

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 »

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.) A. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted. B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table. C. A DELETE command on a GLOBAL TEMPORARY TABLE cannot… Read More »

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

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.

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 »

A company is using OSPF between its HQ location and a branch office. HQ is assigned area 0 and the branch office is assigned area 1. The company purchases a second branch office, but due to circuit delays to HQ, it decides to connect the new branch office to the existing branch office as a temporary measure. The new branch office is assigned to area 2. Which OSPF configuration enables all three locations to exchange routes?

A. The existing branch office must be configured as a stub area B. A virtual link must be configured between the new branch office and HQ C. A sham link must be configured between the new branch office and HQ D. The new branch office must be configured as a stub area Answer: Option B. Explanation:  No answer… Read More »