更多"USER_DATA is a nonencrypted tablesp"的相关试题:
[多项选择]Which two are true concerning a multitenant container database with three pluggable database?（）
A. All administration tasks must be done to a specific pluggable database.
B. The pluggable databases increase patching time.
C. The pluggable databases reduce administration effort.
D. The pluggable databases are patched together.
E. Pluggable databases are only used for database consolidation.
[单项选择]( )system concerns itself with shipment of containers overland as a part of a sealand or asea-land-sea route.
A. Sea/air
B. Land bridge
C. Rail/road
D. Piggyback
[单项选择]You have created a Host Checker policy that contains multiple rules. You want to inform end users which rule specifically has failed.In the admin GUI, which configuration setting would you enable?（）
A. Enable Custom Instructions
B. Pre-auth notification
C. Remediation message
D. Send reason strings
[单项选择]“It is declared that this shipment does not contain any wood packing materials．”与这句话意思接近的是( )。
[单项选择] 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?（）
A. It will create the tablespace TEMP1 in group G1.
B. It will create the tablespace TEMP1 in group G3.
C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group.
[单项选择] You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?（）
A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
B. It generates an error when creating the table because the wallet is closed.
C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
[单项选择]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?（）
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
[单项选择]You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。
A. identify the segments that you should shrink
B. modify the storage parameters for the tablespace
C. automatically shrink the segments with unused space
D. check the alerts generated for the tablespace that is running low on space
[单项选择]An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）
A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.
[单项选择] Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）
A. You cannot perform the TSPITR with the constraints enabled.
B. You must perform the TSPITR recovery of both tablespaces for it to be successful.
C. You can perform TSPITR only on the USERS tablespace.
D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
E. The TSPITR will only be successful if the constraint is enabled.
[单项选择] 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?（）
A. The database is in ARCHIVELOG mode.
B. There is not a current backup of the database available.
C. The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.
D. The USERS tablespace is not eligible for TSPITR because it has invalid objects.
E. The recover tablespace command is incorrect and generates the error.
[单项选择]During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）
A. incomplete names
B. incomplete names with templates
C. alias with template names
D. numeric names
[单项选择] An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace： 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen？（）
A. Recovery Manager
B. Recovery Window
C. Recovery Wizard
D. Enterprise Manager Home Page
[多项选择] You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace. What methods can you use to re/x7fcreate the indexes？（）
A. Data Pump
B. SQL scripts
C. SQL*Loader
D. Flashback database
E. Recovery Manager （RMAN） script
[单项选择]tablespace point-in-time recovery is possible only with RMAN.（）
A. True
B. False
[单项选择] You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）
A. System monitor （SMON）
B. Process monitor （PMON）
C. Memory manager process （MMAN）
D. Manageability Monitor process （MMON）
[单项选择] An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）
A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace （BFT）.
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.
[单项选择]在Oracle中创建用户时，若未提及DEFAULT TABLESPACE关键字，则Oracle就将（）表空间分配给用户作为默认表空间。
A. USER
B. SYSTEM
C. SYS
D. DEFAULT
