Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files): CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3(user_temp)/user_files/user_tbsp’ SIZE 200M; What would be the result of this command?()
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct?()
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?()
Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?()
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?()
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()
Which two statements are true regarding the MRKT tablespace()
When running the tablespace point-in-time command recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/08/2008 16:00:30 RMAN-20202: Tablespace not found in the recovery catalog RMAN-06019: could not translate tablespace name "USERS" What is the likely cause of the error?()
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?()
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?()