You executed the following command to create a tablespace called SALES_DATA： > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）A、The database automatically d

题目

You executed the following command to create a tablespace called SALES_DATA： > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）

A、The database automatically determines the extent-sizing policy for the tablespace.
B、The segments are automatically shrunk when the contents are removed from them.
C、The allocation of extents within the tablespace is managed through the dictionary tables.
D、The space utilization description of the data blocks in segments is recorded inbitmapblocks.
E、The space utilization description of the data blocks in segments is managed through free lists.MANUAL

更多“You executed the&ensp”相关问题

第1题

In which scenario will you create a hash cluster？（）A、 when you want the data to be returned automatically in chronological orderB、 if the application uses queries joining tables only occasionallyC、 if the queries against the clustered table use the equality operator （=） to retrieve the desired rowD、 if the full table scan is executed often on only one of the clustered tables

点击查看答案
第2题

You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database

点击查看答案
第3题

Which statement about using RMAN stored scripts is true?（）A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

点击查看答案
第4题

单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the result of issuing the above statement？（）AThe statement will be executed successfully， and a new time zone will be set for the database.BThe statement will be executed successfully， but a new time zone will not be set for the database.CThe statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.DThe statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

点击查看答案
第5题

单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）A renaming the control filesB dropping a user in your databaseC enabling or disabling redo log archivingD dropping a tablespace in your databaseE re-creating the control files， after you lost all the control files in your database

点击查看答案
第6题

单选题You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You plan to use a PresentationTraceSources object when the application is executed by users. When the application is executed in a test environment, all debug information is successfully captured. You need to be able to capture debug information when the application is deployed. What should you do?（）AEnable WPF tracing in the registry.Restart the application.BEnable tracing by modifying local Group Policy.Restart the application.COpen the XML configuration file for your application on the user's computer.Set tracing to a verbose level.Restart the application.DOpen the XML configuration file for your application on the user's computer.Add a trace listener.Restart the application.

点击查看答案
第7题

单选题You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）Aback up the control file to traceBbring database to the MOUNT stateCopen a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseDset the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

点击查看答案

You executed the&ensp

题目

更多“You executed the&ensp”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容