ITPub博客

（489）For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A. viewsB. fixed tablesC. heap tablesD. external tablesE. temporary tablesF. index-organized tables(IOT)答案：（C、F）

（488）You are managing an Oracle Database 11g database with the ASM storage.The database is having big file tablespaces.You want files to open faster and less memory to be used in the shared pool to manage the extent maps.What configuration would you effect to achieve your objective?(Choose ...

（487）When executing a SQL workload,you choose to generate execution plans only,without collecting execution statistics.Which two statements describe the implications of this?(Choose two.)A. It produces less accurate results of the comparison analysis.B. It automatically calls the SQL Tu...

（486）You execute the following Recovery Manager(RMAN) commands in the following order:BACKUP VALIDATE DATABAERECOVER CORRUPTION LIST;Which two tasks are performed by these commands?(Choose two.)A. Repair the corrupted blocks.If any, In the backup created.B. Populate VSCOPV_CORRU...

（485）You want to back up your 100-GB database on a remote tape device.You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device.The current consumption of your CPU is approximately 40 percent.Which type of backup should you p...

（484）Which steps are mandatory to enable Direct NFS?1. Mount all required file systems using the kernel NFS driver.2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.3. Replace the ODM library libodm11.so_stub with libodm11.so.A...

（483）Evaluate the following block of code:BEGIN  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( acl => 'mycompany-com-permissions.xml',                  &nbs...

（482）USER_DATA is a nonencrypted tablespace that contains a set of tables with data.You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methods would you use to achieve this?(Choose all that apply.)A. Use Data Pump to transf...

（481）Which statement is true about a running session that belongs to the online transaction processing(OLTP) group?A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.B. It performs the first 10000 I/O requests or ...

检查Oracle Cluserware配置文件的完整性

（480）View the Exhibit exhibit1 to examine the series of SQL commands.View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline.The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query i...

（479）Which two statements about workload capture and replay operations are true?(Choose two.)A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for...

（478）Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.(Choose two.)A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository(AWR) snapshots答案：（A、C）解析：《performance tuning guide》 15D...

（477）Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangement答案：（A）解析：再议

（476）What is the name of the file that identifies the set of available locale definitions?A. locale.defB. lxdef.oraC. lx1boot.nlbD. lx1boot.oraE. lang.def答案：（C）解析：《globalization support guide》 13.8After you have defined a new language,territory,cha...

（475）Case-insensitive sorts are always accent insensitive by default.A. TrueB. False答案：（B）解析：反了，应该是accent不敏感的（AI），默认为大小写不敏感的（CI）。

（474）Which NLS parameter directly governs linguistic searches?A. NLS_SEARCH_LB. NLS_SORTC. NLS_SEARCHD. NLS_SORT_LE. None of the above答案：（B）解析：其它参数都没有

（473）How many different calendars does Oracle 11g support?A. 22B. 7C. 6D. 15E. 2答案：（B）解析：《Globalization Support Guide》 1.2.5

（472）Which is not a valid locale definition file type?A. LanguageB. Linguistic sortC. CalendarD. TerritoryE. Character set答案：（C）

（471）Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?A. All objects in the databaseB. Tables owned by SYS and SYSTEMC. Data dictionary tablesD. NCHAR columnsE. CHAR columns答案：（E）解析：指定长度的语义是字符语义，还是字节语义...