单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
– Pardon me. Could you please tell me where the department store is? –() (A)All right. Thank you anyway.(B) It’s a pleasure.(C) Sorry, I’m not sure about it. Let’s go and ask the policeman.(D) Don’t bother!
Because you don’t want to stay _____ all night packing and wear yourself out before you even leave for the trip.
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.
Shop-assistant: May I help you, sir?Mr. Blair: Er…I want to buy my wife a gift for Christmas, but I don’t know what she would like.Shop-assistant: _______________________ These are all from Paris.Mr. Blair: No. She has very good taste in clothes. I don’t want to take the risk.A: Do you want to buy a pair of shoes?B: What about a gold necklace?C: How about an evening gown?D: Don’t you think a gold watch would be very nice?
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.
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 reducedB. All historical data older than 3 years is purged from the flashback archive FLA1C. All historical data is retained but the subsequent flashback data archives are maintained for only 3 yearsD. All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
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 redirectedB. 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.
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.
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.You want to minimize changes to your security model and to your database applications. How should you modify the database?A．Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.B．Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.C．Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.D．Create a view of the lookup tables. Use the view to allow users access to the lookup tables.
When you're teenager(青少年) it seems that every time you say "l want to．．． "，your par-ents answer，" No，you can' t． "Young people further complain that their parents do not (11) them． When something goes(12) ，most parents just don't believe in their children．(13) asking why，they think their kids are wrong． And not many parents allow their kids to choose for themselves．Yes，(14) is true that your parents sometimes treat you as a little could． But remember that not long ago you were really a child． Your parents still remember the childish (15) you used to make． They want to protect you (16) you don-t want them to do so．So，if you want to get(17 freedom(自由)，please try to understand you don-t lie to them．Try a more friendly way．lf you want them to (18) you to stay out late，don't just say "All (19) kids can stay out late． Tell them as much as you can about what you want to do and where you’ll be and (20) it，s important for you to stay out late． Then they just might say "yes ．( )11．A． enjoyB． preferC． understandD． decide
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
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
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 triggersB、by using external tablesC、by using anonymous PL/SQL blocksD、by auditing all DML operations on the table
You need to design a method to log changes that are made to servers and domain controllers. You also need to track when administrators modify local security account manager objects on servers. What should you do？（）A、Enable failure audit for privilege user and object access on all servers and domain controllersB、Enable success audit for policy change and account management on all servers and domain controllersC、Enable success audit for process tracking and logon events on all servers and domain controllersD、Enable failure audit for system events and directory service access on all servers and domain controllers
单选题A: I can’t seem to find a color TV of the new model. B: _______AWhy don’t you try the new store on King’s Road?BThere’s also something wrong with my TV set.CDon’t you know the new model you want is not on the market yet?DThe new model is far more expensive than those old ones.
单选题You are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect-traffic all command?（）AWhen you want all unauthenticated traffic to be redirectedBWhen you want all clear text traffic to be redirected.CWhen you want all authenticated traffic to be redirected.DWhen you want all encrypted traffic to be redirected.
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A You must use automatic undo management in the database.B You must configure OMF in your database.C You must configure ASM for storing the datafiles.D You must multiplex the online redo log file.
单选题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？（）AfunctionsBpackagesCproceduresDdatabase triggersEanonymous PL/SQL block
单选题I recommend that you all are diligent if you want to pass the exam.ArecommendBareCifDthe exam
单选题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？（）Aby using triggersBby using external tablesCby using anonymous PL/SQL blocksDby auditing all DML operations on the table
单选题You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do？（）AImplement a stored procedure that writes data about schema changes to a log table.BImplement DDL AFTER triggers that write user and schema information to a log table.CImplement a DML INSTEAD OF trigger that writes data about schema changes to a log table.DImplement a DML AFTER trigger that writes data about schema changes to a log table.
单选题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?（）AThe command produces an error because the retention period cannot be reducedBAll historical data older than 3 years is purged from the flashback archive FLA1CAll historical data is retained but the subsequent flashback data archives are maintained for only 3 yearsDAll historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time