Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use

题目

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

相似考题

1.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.

2.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.

3. 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

4. In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ 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

更多“Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyins ”相关问题

  • 第1题：

    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.

    正确答案:D

  • 第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 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

    正确答案:D

  • 第3题：

    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.

    正确答案:A

  • 第4题：

    单选题
    For which database operation would you need the database to be in the MOUNT state（）
    A

    renaming the control files

    B

    re-creating the control files

    C

    dropping a user in your database

    D

    dropping a tablespace in your database

    E

    configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes


    正确答案： E
    解析： 暂无解析

  • 第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 files

    B

    dropping a user in your database

    C

    enabling or disabling redo log archiving

    D

    dropping a tablespace in your database

    E

    re-creating the control files， after you lost all the control files in your database


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    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？（）
    A

    Create DML triggers that query the inserted and deleted tables.

    B

    Create a stored procedure that calls the LTRIM and RTRIM built-in functions.

    C

    Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.

    D

    Call the TRIM built-in function.


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    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 process

    B

     Server process

    C

     System Monitor （SMON）

    D

     Process Monitor （PMON）

    E

     Checkpoint process （CKPT）


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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（）
    A

    Apply fine-grained auditing.

    B

    Implement value-based auditing.

    C

    Impose standard database auditing to audit object privileges.

    D

    Impose standard database auditing to audit SQL statements.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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 process

    B

    Server process

    C

    System Monitor (SMON)

    D

    Process Monitor (PMON)

    E

    Checkpoint process (CKPT)


    正确答案： E
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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 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


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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？（）
    A

    Update the view to use an outer join between the Customers and Sales tables.

    B

    Create a clustered index on the v CustomerSales view.

    C

    Create 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.

    D

    Create a stored procedure for the business analysts that uses the v CustomerSales view.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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 files
    • B、dropping a user in your database
    • C、enabling or disabling redo log archiving
    • D、dropping a tablespace in your database
    • E、re-creating the control files， after you lost all the control files in your database

    正确答案:C

  • 第14题：

    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 all
    • B、 backup compressed database
    • C、 backup as compressed backupset database
    • D、 backup as compressed backup database plus archivelog all
    • E、 backup as compressed backupset database plus compress archivelog all

    正确答案:C

  • 第15题：

    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

    正确答案:B

  • 第16题：

    单选题
    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
    A

    One tablespace has only one datafile

    B

    Many tablespaces can share one datafile

    C

    One tablespace can have many datafiles

    D

    One datafile can contain many tablespaces


    正确答案： C
    解析： 暂无解析

  • 第17题：

    单选题
    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？（）
    A

    Create a custom format file， specifying a semicolon as the row terminator.

    B

    Use the bcp command， specifying a semicolon as the field terminator.

    C

    Use the bcp command with the default arguments.

    D

    Use the BULK INSERT statement with the default arguments.


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    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 all

    B

     backup compressed database

    C

     backup as compressed backupset database

    D

     backup as compressed backup database plus archivelog all

    E

     backup as compressed backupset database plus compress archivelog all


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    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 utility

    B

     by using the export/import utility

    C

     by using the ALTER DATABASE command

    D

     by enabling the change tracking feature


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ 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 cache

    B

     shared pool

    C

     PGA

    D

     large pool


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

相关内容