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:<br /> ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS;<br /> 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:<br /> ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS;<br /> What is the outcome of this command?（）”相关的问题

第1题

[单选题] You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）

A、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING B、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ath> C、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ath> D、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKINGath>ath>

点击查看答案

第2题

[单选题] You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

A、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; B、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>; C、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>; D、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

点击查看答案

第3题

[] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（） You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、A. You must have change tracking enabled in your database B、B. Your database must be running in NOARCHIVELOG mode C、C. To back up a tablespace, it must be in backup mode D、D. To back up a tablespace, it must first be taken offline

点击查看答案

第4题

[单选题] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、You must have change tracking enabled in your database B、Your database must be running in NOARCHIVELOG mode C、To back up a tablespace, it must be in backup mode D、To back up a tablespace, it must first be taken offline

点击查看答案

第5题

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

A、A. When you want all unauthenticated traffic to be redirected B、B. When you want all clear text traffic to be redirected. C、C. When you want all authenticated traffic to be redirected. D、D. When you want all encrypted traffic to be redirected.

点击查看答案

第6题

[单选题] You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature？（）

A、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING B、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ath> C、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ath> D、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKINGath>ath>

点击查看答案

第7题

[单选题] You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）

A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING； B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ath>； D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ath>；ath>ath>

点击查看答案

第8题

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