单选题The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to 

题目
单选题
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator.  Which method would you suggest to the bank for achieving this task？（）
A

implementing value­based auditing by using triggers

B

implementing fine­grained auditing with audit condition and event handler

C

performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED

D

performing standard database auditing to audit SQL statements with granularity level set to ACCESS

相似考题

1.The EMPLOYEES table has these columns:Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:What is true about your ALTER statement?()A. Column definitions cannot be altered to add DEFAULT values.B. A change to the DEFAULT value affects only subsequent insertions to the table.C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

2.Which statement is true about a routing table?（）A、It contains routes learned dynamically only.B、It finds the best path to each destination by using a modified shortest-path-first calculation.C、It contains only active BGP routes.D、It contains all accepted routes to all destinations.

3. A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）A、Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.B、Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.C、Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.D、Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnE、Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.F、Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

4. You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.

更多“单选题The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to ”相关问题

  • 第1题：

    At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）

    • A、 Flashback Drop
    • B、 Flashback Database
    • C、 Flashback Table
    • D、 Flashback Version Query

    正确答案:C

  • 第2题：

    The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator.  Which method would you suggest to the bank for achieving this task？（）

    • A、implementing value­based auditing by using triggers
    • B、implementing fine­grained auditing with audit condition and event handler
    • C、performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
    • D、performing standard database auditing to audit SQL statements with granularity level set to ACCESS

    正确答案:B

  • 第3题：

    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）  

    • A、SQL Access Advisor
    • B、 Memory Advisor
    • C、SQL Tuning Advisor
    • D、 Segment Advisor

    正确答案:A

  • 第4题：

    Which two operations can be performed on an external table（）

    • A、Create a view on the table.
    • B、Create an index on the table.
    • C、Create a synonym on the table.
    • D、Add a virtual column to the table.
    • E、Update the table using the UPDATE statement.
    • F、Delete rows in the table using the DELETE command

    正确答案:A,C

  • 第5题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized.  Which action should be performed to finish the task？（）

    • A、A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
    • B、A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.
    • C、On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.
    • D、A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.

    正确答案:D

  • 第6题：

    单选题
    The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）
    A

    An update in a leaf row takes place.

    B

    The index becomes invalid after the update.

    C

    The leaf block containing the row to be updated is marked as invalid.

    D

    A row in the leaf block of the index for the key value is deleted and inserted.


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

  • 第7题：

    单选题
    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）
    A

    RMAN only

    B

    Flashback Table only

    C

    Flashback Versions Query only

    D

    Flashback Database and Flashback Transaction Query

    E

    Flashback Versions Query and Flashback Transaction Query


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

  • 第8题：

    多选题
    Which two operations can be performed on an external table（）
    A

    Create a view on the table.

    B

    Create an index on the table.

    C

    Create a synonym on the table.

    D

    Add a virtual column to the table.

    E

    Update the table using the UPDATE statement.

    F

    Delete rows in the table using the DELETE command


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

  • 第9题：

    单选题
    The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task？（）
    A

    implementing value-based auditing by using triggers

    B

    implementing fine-grained auditing with audit condition and event handler

    C

    performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED

    D

    performing standard database auditing to audit SQL statements with granularity level set to ACCESS


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

  • 第10题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized.  Which action should be performed to finish the task？（）
    A

    A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.

    B

    A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.

    C

    On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.

    D

    A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.


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

  • 第11题：

    单选题
    The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code， which is the primary key.  As part of the archival process， the company wants to transfer the rows in the TRANS_SUMMARY tableto the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products，the company deals with many new products during every quarter.  Which method is best suited for this quarterly data transfer（）
    A

    using the MERGE command

    B

    using the SQL*Loader utility

    C

    using the correlated UPDATE command

    D

    using the INSERT command to perform bulk operation


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

  • 第12题：

    单选题
    You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）
    A

    CLOB

    B

    BLOB

    C

    BFILE

    D

    LONG RAW


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

  • 第13题：

    The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）

    • A、B-tree
    • B、bitmap
    • C、reverse key
    • D、function based

    正确答案:B

  • 第14题：

    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）

    • A、ALTER TABLE commercials MODIFY (description CHAR2(2000));
    • B、ALTER TABLE commercials CHANGE (description CHAR2(2000));
    • C、ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));
    • D、ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));
    • E、You cannot increase the size of a column if the table has rows.

    正确答案:D

  • 第15题：

    You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）

    • A、CLOB
    • B、BLOB
    • C、BFILE
    • D、LONG RAW

    正确答案:C

  • 第16题：

    The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）

    • A、An update in a leaf row takes place.
    • B、The index becomes invalid after the update.
    • C、The leaf block containing the row to be updated is marked as invalid.
    • D、A row in the leaf block of the index for the key value is deleted and inserted.

    正确答案:D

  • 第17题：

    单选题
    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
    A

    SQL Access Advisor

    B

     Memory Advisor

    C

    SQL Tuning Advisor

    D

     Segment Advisor


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

  • 第18题：

    单选题
    The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator.  Which method would you suggest to the bank for achieving this task？（）
    A

    implementing value­based auditing by using triggers

    B

    implementing fine­grained auditing with audit condition and event handler

    C

    performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED

    D

    performing standard database auditing to audit SQL statements with granularity level set to ACCESS


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

  • 第19题：

    单选题
    The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column.  Which type of index would you suggest to improve the query performance？（）
    A

    B­tree

    B

    bitmap

    C

    reverse key

    D

    function based


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

  • 第20题：

    单选题
    You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）
    A

    Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.

    B

    Define the new column as NOT NULL with a default value of ’Undefined.’

    C

    Define the new column as NULL. Use application logic to enforce the data constraint.

    D

    Define the new column as NULL with a default value of ’Undefined.’


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

  • 第21题：

    单选题
    At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）
    A

     Flashback Drop

    B

     Flashback Database

    C

     Flashback Table

    D

     Flashback Version Query


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

  • 第22题：

    单选题
    Which statement is true about a routing table?（）
    A

    It contains routes learned dynamically only.

    B

    It finds the best path to each destination by using a modified shortest-path-first calculation.

    C

    It contains only active BGP routes.

    D

    It contains all accepted routes to all destinations.


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

  • 第23题：

    单选题
    You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）
    A

    Drop the foreign key. Import the data by using the script. Re-create the foreign key.

    B

    Create a CHECK constraint.

    C

    Create a DML INSTEAD OF trigger that writes the failed records to a file or table.

    D

    Create a DML AFTER trigger that writes the failed records to a file or table.


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

  • 第24题：

    单选题
    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）
    A

    ALTER TABLE commercials   MODIFY (description CHAR2(2000));

    B

    ALTER TABLE commercials   CHANGE (description CHAR2(2000));

    C

    ALTER TABLE commercials   CHANGE (description VARCHAR2(2000));

    D

    ALTER TABLE commercials   MODIFY (description VARCHAR2(2000));

    E

    You cannot increase the size of a column if the table has rows.


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

相关内容