当前位置:1Z0-053题库

问题:

[多选]

The EMP table exists in your schema. You want to execute the following query:  
SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ’6’ MINUTE)  
WHERE ename = ’ALLEN’;  
What are the minimum requirements for the statement to execute successfully?()

A .  ARCHIVELOG mode must be enabled
B .  Row Movement must be enabled for the table
C .  FLASHBACK must be set to ON for the database
D .  The UNDO_MANAGEMENT parameter must be set to AUTO
E .  The UNDO_RETENTION parameter must be set appropriately

Which two statements are true about the Oracle Enterprise Manager (OEM) ?()  OEM can do management and monitoring across multiple WLS Domains。  OE is a unified solution for management and monitoring across entire architecture - Web Tier, App Tier & DB Tier。  OEM is focused solely on Oracle solutions, cannot manage 3rd party products。  OEM includes tools to configure the operating system。 What advantage would you get if you increase the length of time during which the undo information would be stored in the database?() roll back of large transactions。 roll forward to redo a transaction。 data concurrency for large updates。 read consistency for long-running transactio。 You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?() by granting a secure application role to the users。 by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to false。 By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4。 By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.。 By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.。 “一切有所作为都是那么卑鄙/一切无所作为都是那么优雅”出自诗歌()。 《履历》。 《第三代诗人》。 《一切》。 《我和我》。 社会保险基金的会计核算基础是权责发生制。

The EMP table exists in your schema. You want to execute the following query:  
SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ’6’ MINUTE)  
WHERE ename = ’ALLEN’;  
What are the minimum requirements for the statement to execute successfully?()

参考答案:

  参考解析

本题暂无解析

在线 客服