Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use?（）A.ALTERDATABASESalesMODIFYFILE(NAME=Sales dat3,SIZE=10GB)B.ALTERINDEXALLONSales.Sales HistoryREBUILDWITH(FILLFACTOR=60)C.EXECsys.sp_configure‘fillfactor(%)‘,‘60‘D.UPDATESTATISTICSSales.Sales History(Products)WITHFULLSCAN,NORECOMPUTE
Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use?（）
A.ALTERDATABASESalesMODIFYFILE(NAME=Sales dat3,SIZE=10GB)
B.ALTERINDEXALLONSales.Sales HistoryREBUILDWITH(FILLFACTOR=60)
C.EXECsys.sp_configure‘fillfactor(%)‘,‘60‘
D.UPDATESTATISTICSSales.Sales History(Products)WITHFULLSCAN,NORECOMPUTE
相关考题：
You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?A．Increase the maximum file size of Sales_Data to 1,500MB.B．Use the DBCC SHRINKDATABASE statement.C．Set automatic file growth to 10 percent.D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.
In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？ A、 database buffer cacheB、 shared poolC、 PGAD、 large pool
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（） A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（） A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）A、The command must be issued in MOUNT state.B、The command succeeds only if the data file is offline.C、The command must be issued when the database is in the archivelog mode.D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
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
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
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
You work as the exchange administrator at company.com.the company.com network contains an exchange server 2010 organization.you are responsible for managing the exchange network for company.com.the company.com network contains two mailbox servers named -ex01 and -ex02 as well as a mailbox database named -ex03.-ex01 and -ex02 are members of a database availability group named tkdag and contain a copy of -ex03.during the course of the week you receive an instruction from the cio to remove the -ex03 mailbox database from -ex01.what should you do？（）A、your best option would be to use the exchange management console （emc） and then select the remove option on a right-click of the -ex03 database copy on -ex01.B、your best option would be to run clean-mail box database -identity -ex03 on the exchange management shell.C、your best option would be to use the exchange management console （emc） and then select the manage database availability group membership on a right-click on tkdag then you can remove -ex01 from the list.D、your best option would be to run remove-mail box database -identity -ex03/-ex01 from the exchange management shell.
Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?（）A、ALTER DATABASE Sales MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)B、ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)C、EXEC sys.sp_configure 'fill factor (%)', '60'D、UPDATE STATISTICS Sales.Sales History(Products) WITH FULLSCAN, NORECOMPUTE
单选题For which database operation would you need the database to be in the MOUNT state（）Arenaming the control filesBre-creating the control filesCdropping a user in your databaseDdropping a tablespace in your databaseEconfiguring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）AOne tablespace has only one datafileBMany tablespaces can share one datafileCOne tablespace can have many datafilesDOne datafile can contain many tablespaces
单选题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？（）Arenaming the control filesBdropping a user in your databaseCenabling or disabling redo log archivingDdropping a tablespace in your databaseEre-creating the control files， after you lost all the control files in your database
单选题You are responsible for importing data into SQL Server 2005 databases.Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons.You need to import the files into the sales database. What should you do？（）ACreate a custom format file， specifying a semicolon as the row terminator.BUse the bcp command， specifying a semicolon as the field terminator.CUse the bcp command with the default arguments.DUse the BULK INSERT statement with the default arguments.
单选题You are responsible for managing a SQL Server 2005 database that stores sales information. Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces. Your solution must be available for reuse in Transact-SQL statements and views. What should you do？（）ACreate DML triggers that query the inserted and deleted tables.BCreate a stored procedure that calls the LTRIM and RTRIM built-in functions.CCreate a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.DCall the TRIM built-in function.
单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A backup database allB backup compressed databaseC backup as compressed backupset databaseD backup as compressed backup database plus archivelog allE backup as compressed backupset database plus compress archivelog all
单选题Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query： SQL SELECT * FROM sales； Which process would retrieve the result from the database and return it to the client program？（）A User processB Server processC System Monitor （SMON）D Process Monitor （PMON）E Checkpoint process （CKPT）
单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A The time when the last flashback operation in your database was performed.B The time when the first flashback operation in your database was performed.C A list of flashback operations performed in your database using SCN and time.D The approximate time and the lowest system change number （SCN） to which you can flash back your database.
单选题In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information. Whataction would you take to achieve this task（）AApply fine-grained auditing.BImplement value-based auditing.CImpose standard database auditing to audit object privileges.DImpose standard database auditing to audit SQL statements.
单选题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）A The database will not start.B The database will start but will not retain the undo data in the undo segment.C The database will start， and the undo segment will contain the undo data for at least one hour.D The database will start， and the undo segment will retain the undo data for at least 15 minutes.
单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）AUser processBServer processCSystem Monitor (SMON)DProcess Monitor (PMON)ECheckpoint process (CKPT)
单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）A by using the RMAN utilityB by using the export/import utilityC by using the ALTER DATABASE commandD by enabling the change tracking feature
单选题Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）A The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
单选题In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？A database buffer cacheB shared poolC PGAD large pool
单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number （SCN） to which you can flash back your database
单选题You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）AThe command must be issued in MOUNT state.BThe command succeeds only if the data file is offline.CThe command must be issued when the database is in the archivelog mode.DThe command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
单选题You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）AUpdate the view to use an outer join between the Customers and Sales tables.BCreate a clustered index on the v CustomerSales view.CCreate two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.DCreate a stored procedure for the business analysts that uses the v CustomerSales view.