You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change t

题目

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）

  • A、The command produces an error because the retention period cannot be reduced
  • B、All historical data older than 3 years is purged from the flashback archive FLA1
  • C、All historical data is retained but the subsequent flashback data archives are maintained for only 3 years
  • D、All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
相似考题

1.Where shall I go through the formalities if I want to store my luggage here?A.You can store your luggage in the reception desk over thereB.You can store your luggage in the information room.C.You can store your luggage in the safe box of the bank.D.Luggage can be stored in the railway station and airport.

2.Because you don’t want to stay _____ all night packing and wear yourself out before you even leave for the trip.

3.Why do you want to leave your previous job?().A. I'm hoping to have a better position.B. I don't want to work at all.C. You won't understand it.

4.You can find ( )kinds of shoes in this store.A.wholeB.allC.the wholeD.all the

更多“You want to track and store all”相关问题

  • 第1题：

    If you try all kinds of jobs, not only will you find out what you want to do, but you will also ___________ up a surprising amount of useful information as you go along.

    A、pick

    B、equipment

    C、drug

    D、director


    正确答案：A

  • 第2题：

    In which scenario would TOP N analysis be the best solution? ()

    A. You want to identify the most senior employee in the company.

    B. You want to find the manager supervising the largest number of employees.

    C. You want to identify the person who makes the highest salary for all employees.

    D. You want to rank the top three sales representatives who have sold the maximum number of products.


    参考答案：D

  • 第3题：

    You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command:ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS;What is the outcome of this command?（）

    A. The command produces an error because the retention period cannot be reduced

    B. All historical data older than 3 years is purged from the flashback archive FLA1

    C. All historical data is retained but the subsequent flashback data archives are maintained for only 3 years

    D. All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time


    参考答案：B

  • 第4题：

    You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.

    Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.

    You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two)

    A．Store the snapshot in the default folder on the Publisher/Distributor.

    B．Store the snapshot in an alternative folder on the Publisher/Distributor.

    C．Store the snapshot in a shared folder on a file server.

    D．Create pull subscriptions.

    E．Create push subscriptions.


    正确答案：CD
    解析：Explanation:
    C: In SQL Server 2000 it is possible to store snapshot files in a location other than or in addition to the default location. Alternate locations can be on another server, on a network share, or on removable media. Saving snapshot files in an alternate location can alleviate disk overhead on the Distributor.

    However, Subscribers running earlier versions of SQL Server cannot use the alternate snapshot location. When specifying the snapshot location on a network share, it is recommended that that share folder be dedicated for snapshot storage and files. Subscribers that need to access the snapshot files will need Read permission to the snapshot location and appropriate folders. If the snapshot folder is not shared for the appropriate Subscribers, the replication agents cannot access the folder and the replication will fail.

    D: With pull subscriptions the Subscriber requests data and updates that are made at the Publisher. Thus allows the user at the Subscriber to determine when the data changes are synchronized. With pull subscriptions the administration of the subscription takes place at the Subscriber.

    A feature of pull subscriptions is that the Distribution Agent for snapshot and transactional publications and the Merge Agent for merge publications all run at the Subscriber. This can result in a reduction of the amount of processing overhead on the Distributor. However, if needed, the Distribution Agent or Merge Agent can be run at the Distributor to offload agent processing from the Subscriber.

    Incorrect Answers:
    A: The default location for snapshot replication files are specified in the Specify Snapshot Folder dialog box that appears in the Configure Publishing and Distribution Wizard and in the Create Publication Wizard. The default location is usually on the Distributor.

    B: In SQL Server 2000 it is possible to store snapshot files in a location other than or in addition to the default location. Alternate locations can be on another server, on a network share, or on removable media. Saving snapshot files in an alternate location can alleviate disk overhead on the Distributor, particularly when it is located on another server, or a file server.

    E: Push subscriptions are created at the Publisher. This places higher processor overhead at a Publisher using a local Distributor as the Distribution Agent for the snapshot publication runs at the Distributor.

  • 第5题：

    Your performance in the test have reached the required standard, _____ ,you can get what you want.

    A. in other words
    B. in the end
    C. in all
    D. after all

    答案：A
    解析：
    本段话意为“你在考试中的表现达到了要求， ，你可以得到你想要的”。A项“换句话说.也就是说”；B 项“最后，最终”；Ｃ项“总共”；D 项“毕竟”。结合选项和语境可知A项最符合。

  • 第6题：

    You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis.  How would you achieve this？（）

    • A、by using triggers
    • B、by using external tables
    • C、by using anonymous PL/SQL blocks
    • D、by auditing all DML operations on the table

    正确答案:A

  • 第7题：

    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

    • A、 Enable Flashback Data Archive for the tables.
    • B、 Specify undo retention guarantee for the database.
    • C、 Enable supplemental logging for the database.
    • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
    • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

    正确答案:A

  • 第8题：

    单选题
    What do you want?（）
    A

    Thank you.

    B

    Yes, a hammer.

    C

    Two saws.

    D

    Not at all.


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

  • 第9题：

    单选题
    You are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect-traffic all command?（）
    A

    When you want all unauthenticated traffic to be redirected

    B

    When you want all clear text traffic to be redirected.

    C

    When you want all authenticated traffic to be redirected.

    D

    When you want all encrypted traffic to be redirected.


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

  • 第10题：

    单选题
    I recommend that you all are diligent if you want to pass the exam.
    A

    recommend

    B

    are

    C

    if

    D

    the exam


    正确答案： D
    解析：

  • 第11题：

    单选题
    You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis.  How would you achieve this？（）
    A

    by using triggers

    B

    by using external tables

    C

    by using anonymous PL/SQL blocks

    D

    by auditing all DML operations on the table


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

  • 第12题：

    单选题
    In which scenario will you use the Flashback Transaction Query feature？（）
    A

     when you want to restore an important table that is dropped from the Recycle Bin

    B

     when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction

    C

    when you want to restore a dropped user’s schema

    D

     when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period


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

  • 第13题：

    When you want to work for our country in the future, ______, you should have a strong body and rich knowledge.

    A、 at first

    B、 first of all

    C、 for the first time

    D、 after all


    参考答案：B

  • 第14题：

    In which case would you use a FULL OUTER JOIN? ()

    A. Both tables have NULL values.

    B. You want all unmatched data from one table.

    C. You want all matched data from both tables.

    D. You want all unmatched data from both tables.

    E. One of the tables has more data than the other.

    F. You want all matched and unmatched data from only one table.


    参考答案：D

  • 第15题：

    You are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect－traffic all command?()

    A. When you want all unauthenticated traffic to be redirected

    B. When you want all clear text traffic to be redirected.

    C. When you want all authenticated traffic to be redirected.

    D. When you want all encrypted traffic to be redirected.


    参考答案：B

  • 第16题：

    共用题干
    Canada Ikea:What a Great Place for You to Shop There are many different stores that people go to in order to buy various household goods. _______(46) The Canada Ikea（宜家）is not confined to one city alone in that country. Instead you will find there are many different branches spread out in many different localities. As with all of the Ikea stores the Canada Ikea deals mainly with selling top quality Swedish furniture. _________( 47 ) One facet（方面）of the Canada Ikea that its customers will like is that the store has tile ability of catering（迎合）to their English speaking customers as well as their French customers. To make shopping for furniture and other goods easy the Ikea stores in every country,are all set out in the same manners_______(48)As a result of this the Canada Ikea is one that its local and foreign customers enjoy visiting. To help make it easy for you to shop for the items that you want there are large blue and yellow bags or shopping carts available.______(49) As you wander through the store you will find many interesting items that you can use for your home or even office.With these products you will have a beautiful house that you can live comfortably in._______(50)The Canada Ikea is a great place for you to shop.

    _______(49)
    A:.The larger sized objects are displayed in the showrooms of the Canada Ikea stores.
    B:.This furniture is designed to provide the home owner with stylish（时髦的）furniture that is also affordable and perfect for everyday use.
    C:.With so many items to be found you are sure to want to buy everything that catches your fancy.
    D: These bags and carts are perfect for the many different lamp shades , cushions（垫子） bed linens（亚麻布）,toys and other medium to small sized objects that you want.
    E: This makes it very easy for visitors from other countries to buy the items they need with-out wandering around the store trying to find their goods.
    F: One such store that you can find in many different countries including that of Canada is that of the Ikea chain of stores.

    答案：D
    解析：
    第一段第一句：“There are many different stores that people go to in order to buy various household goods.”接下来是：“The Canada Ikea（宜家）is not confined to one city alone in that country.”才民据上下文，One such store that you can find in many different countries in-cluding that of Canada is that of the Ikea chain of stores是最合适的。承上，指出宜家是这样一家商场，启下，进一步介绍宜家。所以选F。


    空格前一句：“As with all of the Ikea stores the Canada Ikea deals mainly with selling top quality Swedish furniture.”而选项“B. This furniture is designed to provide the home owner with stylish（时髦的）furniture that is also affordable and perfect for everyday use.”是对家具作进一步的说明。其他选项都没有提到家具。


    第三段第一句：“To make shopping for furniture and other goods easy the Ikea stores in every country , are all set out in the same manner.”选项“E. This makes it very easy for visi-tors from other countries to buy the items they need without wandering around the store trying to find their goods. ”This指代空格前的这句话。这两句是因果关系。


    第四段第一句：“To help make it easy tor you to shop for the items that you want there are large blue and yellow bags or shopping carts available.”只有选项D提到了bags and carts。


    最后一段说在宜家：“you will find nany interesting items”只有“C. With so many items to be found you are sure to want to buy everything that catches your fancy.”符合逻辑。

  • 第17题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） 

    • A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 
    • B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 
    • C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 
    • D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 

    正确答案:B

  • 第18题：

    In which scenario will you use the Flashback Transaction Query feature？（）

    • A、 when you want to restore an important table that is dropped from the Recycle Bin
    • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
    • C、when you want to restore a dropped user’s schema
    • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

    正确答案:B

  • 第19题：

    In which scenario would TOP N analysis be the best solution?（）

    • A、You want to identify the most senior employee in the company.
    • B、You want to find the manager supervising the largest number of employees.
    • C、You want to identify the person who makes the highest salary for all employees.
    • D、You want to rank the top three sales representatives who have sold the maximum number of products.

    正确答案:D

  • 第20题：

    单选题
    You want to track and store all transactional changes to a table over its lifetime. To accomplish this task， you enabled Flashback Data Archive with the retention of 5 years. After some time， the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this， you issued the following command：   ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR；   What is the implication of this command？（）
    A

     The command produces an error because the retention time cannot be reduced.

    B

     All historical data is retained but the subsequent flashback data archives are maintained for only three years.

    C

     All historical data is purged and the new flashback data archives are maintained for three years.

    D

     All historical data older than three years is purged from the flashback archive FLA1.


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

  • 第21题：

    单选题
    You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）
    A

    functions

    B

    packages

    C

    procedures

    D

    database triggers

    E

    anonymous PL/SQL block


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

  • 第22题：

    单选题
    Your network contains a Network Policy Server (NPS) named Server1.NPS1 provides authentication for all of the VPN servers on the network.You need to track the usage information of all VPN connections.Which RADIUS attribute should you log？（）
    A

    Acct-Session-Id

    B

    Acct-Status-Type

    C

    Class

    D

    NAS-Identifier


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

  • 第23题：

    单选题
    In which case would you use a FULL OUTER JOIN? （）
    A

    Both tables have NULL values.

    B

    You want all unmatched data from one table.

    C

    You want all matched data from both tables.

    D

    You want all unmatched data from both tables.

    E

    One of the tables has more data than the other.

    F

    You want all matched and unmatched data from only one table.


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

  • 第24题：

    单选题
    You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）
    A

    The command produces an error because the retention period cannot be reduced

    B

    All historical data older than 3 years is purged from the flashback archive FLA1

    C

    All historical data is retained but the subsequent flashback data archives are maintained for only 3 years

    D

    All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time


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

相关内容