- Oracle 11g OCP认证052考试题库（54）-CUUG内部学员版USER1 grants SELECT and UPDATE privileges on USER1.EMP to USER2。 SYS executes this command： SQL REVOKE SELECT ON user1.emp FROM user1; What will be the outcome? A)It will succeed and USER2 ...[详细]
- Oracle 11g OCP认证052考试题库（53）-CUUG内部学员版USER1 grants SELECT, INSERT, and UPDATE privileges on USER1.EMP to USER2. Sys executes this command: SQL REVOKE UPDATE ON user1.emp FROM user1; What will be the outcome? A)It will fail becaus...[详细]
- Oracle 11g OCP认证052考试题库（52）-CUUG内部学员版Your DB_RECOVERY_FILE_DEST_SIZE IS 8G,Currently,5G of the space is used of which 4G consists of obsolete backups, You execute this command; SQL ALTER SYSTEM SET db_recovery_file_dest_size=2G; W...[详细]
- Oracle 11g OCP认证052考试题库（51）-CUUG内部学员版Your database is open in ARCHIVELOG mode. LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and It is 100% full when a log switch takes place. No alternative or optional archive destinations ...[详细]
- Oracle 11g OCP认证052考试题库（50）-CUUG内部学员版052考试题-50（OCP考试题库讨论群：101-5267-481 验证：ocp） Which two are true about the Fast Recovery Area (FRA)? A)It should be larger than the database. B)Only consistent backups can be store...[详细]
- Oracle 11g OCP认证052考试题库（49）-CUUG内部学员版Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE. B)It includes diagnostic data for critical error...[详细]
- Oracle 11g OCP认证052考试题库（48）-CUUG内部学员版Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured. B) It only contains the alert log and trace files for...[详细]
- Oracle 11g OCP认证052考试题库（47）-CUUG内部学员版Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance by automatically implementing Oracle ‘s best practices. B)It can assist the DBA ...[详细]
- Oracle 11g OCP认证052考试题库（46）-CUUG内部学员版Examine this command: SQL CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which three statements are true about rows in...[详细]
- Oracle 11g OCP认证052考试题库（45）-CUUG内部学员版You want to access employee details contained in flat files created by an application. Which two methods will achieve this? A)Use a BFILE column in a table to access the flat file. B)Use an Or...[详细]
- Oracle 11g OCP认证052考试题库（44）-CUUG内部学员版Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL. C)They support the ORACLE_DATAPUMP access driver. D...[详细]
