网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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” 相关考题
考题
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.
考题
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.
考题
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、pickB、equipmentC、drugD、director
考题
When you want to work for our country in the future, ______, you should have a strong body and rich knowledge.
A、 at firstB、 first of allC、 for the first timeD、 after all
考题
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.
考题
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.
考题
共用题干
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.
考题
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 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.
考题
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
考题
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 BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 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
考题
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.
考题
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.
考题
单选题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 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 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
functionsB
packagesC
proceduresD
database triggersE
anonymous PL/SQL block
考题
单选题I recommend that you all are diligent if you want to pass the exam.A
recommendB
areC
ifD
the exam
考题
单选题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-IdB
Acct-Status-TypeC
ClassD
NAS-Identifier
考题
单选题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
考题
单选题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.
考题
单选题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 BinB
when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC
when you want to restore a dropped user’s schemaD
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
考题
单选题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
热门标签
最新试卷
