07 2018 档案
摘要：29、In one of your databases: * The database default tablespace is EXAMPLE. * Deferred_segment_creation is false. Examine these commands: SQL> create u
阅读全文
摘要：28、Which two are true about external tables? A. They support the ORACLE_DATAPUMP access driver. B. They have extents. C. They support all DML operatio
阅读全文
摘要：27、Examine these facts about a database: 1. USERS is the database default tablespace. 2. USER1, USER2, AND USER3 have the CREATE SESSION privilege. 3.
阅读全文
摘要：26、In which state can you back up a database in ARCHIVELOGMODE using RMAN? A. NOMOUNT, MOUNT, AND OPEN B. NOMOUNT AND MOUNT ONLY C. OPEN ONLY D. MOUNT
阅读全文
摘要：25、Which is true about logical and physical database structures? (Choose the best answer) A. An undo tablespace has a temp file instead of a data file
阅读全文
摘要：24、 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>
阅读全文
摘要：23、Which two are true about data dictionary and dynamic performance views (v$ views)? A) All database users have access to ALL_* views. B) Data dictio
阅读全文
摘要：22、You are planning a software installation for both Oracle Database 11g Release 1 and Release 2. You plan to have at lease one database for each rele
阅读全文
摘要：21、Which two are true about roles? A) A role can be password-protected. B) A role can be granted to another role. C) Only one default role can be gran
阅读全文
摘要：20、 Which is true about the SYSTEM and SYSAUX tablespaces? A) The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot. B) Both ta
阅读全文
摘要：19、Which is true about invalid PL/SQL objects? A) They are automatically recompiled against the new definition of a referenced object at the same time
阅读全文
摘要：18、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install. Your plan is to install both Oracle da
阅读全文
摘要：17、Which two statements are true about tablespaces? A) A database can contain multiple undo tablespaces. B) A database can contain only a single tempo
阅读全文
摘要：16、Your database Is configured In archivelog mode. The USERS01 tablespace Is currently online. You are required to take the tablespace offline. Which
阅读全文
摘要：15、Which two are true about space management in tablespaces? A) Locally managed tablespaces have either ASSM or manual segment space management (MSSM)
阅读全文
摘要：14、Which command is used to display files that no longer conform to the backup retention policy? A) REPORT OBSOLETE B) SHOW DATAFILE BACKUP COPIES C)
阅读全文
摘要：13、Which two are true about AWR snapshots? A) They are stored In the SYSAUX tablespace. B) They are not generated if STATISTICS_LEVEL Is set to TYPICA
阅读全文
摘要：11、Which three are true about UNDO data? A) It is used to roll back failed transactions. B) It is used to rewind a database by using FLASHBACK DATABAS
阅读全文
摘要：10、Which two are true about consistent database backups? A) They can only be taken when a RECOVERY CATALOG is used. B) They can only be taken if the d
阅读全文
摘要：9、Which is true about the Automatic Diagnostic Repository (ADR)? A) It includes diagnostic data for critical errors for each server and background pro
阅读全文
摘要：8、Which two are true about the Fast Recovery Area (FRA)? A) It should be larger than the database. B) Space management In the FRA Is Influenced by the
阅读全文
摘要：7、Which is true about external tables? A) The ORACLE_DATAPUMP access driver can be used to write data to external tables. B) Segments are allocated fo
阅读全文
摘要：6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI). You select the "Install and Configure Grid Infrastructu
阅读全文
摘要：5、Which two affect the time taken for instance recovery? A) size of redo logs B) size of UNDO tablespace C) FAST_START_MTTR_TARGET value D) size of ar
阅读全文
摘要：4、For which requirement should you configure shared servers? A) accommodating an increasing number of users who run short-duration, infrequent queries
阅读全文
摘要：3、Which structure can span multiple data files?❑ A) a permanent tablespace❑ B) a bigfile tablespace❑ C) a temporary tablespace❑ D) a segment❑ E) an ex
阅读全文
摘要：2、Which two are true about Optimizer Statistics? ❑ A) They do not persist across Instance restarts. ❑ B) They are automatically updated when DDL state
阅读全文
摘要：1、.Which two are true about the Archive (ARCn) processes?❑ A) They automatically delete obsolete archive logs to makespace for new archive logs.❑ B) T
阅读全文
