[单项选择] Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）
A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It will be successful only if the memory is available from the auto tuned components
C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

[多项选择]The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?（）
A. All the related indexes and views are automatically dropped
B. The flashback drop feature can recover only the table structure
C. Only the related indexes are dropped whereas views are invalidated
D. The flashback drop feature can recover both the table structure and its data

[多项选择] Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）
A. LOG_BUFFER
B. SORT_AREA_SIZE
C. JAVA_POOL_SIZE
D. STREAMS_POOL_SIZE
E. DB_16K_CACHE_SZIE
F. DB_KEEP_CACHE_SIZE

[单项选择]Which one of the following parameters will influence the GSL device utilization the most:（）
A. PILTIMER
B. ALPHA
C. CSPSPRIO

[单项选择]Which one of the following parameters is the very first thing that needs to be configured as part of the IGRP routing process?（）
A. The wild card mask
B. The IP address
C. The IP address mask
D. The metric weights
E. The Autonomous System number

[单项选择]Which of the following ping parameters will set the size of the outgoing packet?（）
A. –c
B. i
C. R
D. –s

[单项选择] You are consolidating your data center by using Windows Server 2008 R2 Hyper-V servers. You are performing virtual-to-virtual （V2V） conversions from Microsoft Virtual Server 2005 R2 and VMware ESX environments by using Microsoft System Center Virtual Machine Manage （VMM） 2008 R2. You need to place the virtual machines （VMs） to fully utilize the Windows Server 2008 R2 host servers. What should you do？（）
A. Set the placement goal to Load balancing.
B. Set the placement goal to Resource maximization.
C. Implement Windows System Resource Monitor （WSRM）.
D. Implement Performance and Resource Optimization （PRO）.

[单项选择] A full backup of your database named DB1 is created automatically at midnight every day.Differential backups of DB1 occur twice each day at 10：00 and at 16：00. A database snapshot is created every day at noon. A developer reports that he accidentally dropped the Pricelist table in DB1 at 12：30. The last update to Pricelist occurred one week ago. You need to recover the Pricelist table. You want to achieve this goal by using the minimum amount of administrative effort. You must also minimize the amount of data that is lost. What should you do？（）
A. Restore the most recent backup into a new database named DB1bak. Apply the most recent differential backup. Copy the Pricelist table from DB1bak to DB1.
B. Delete all database snapshots except the most recent one. Restore DB1 from the most recent database snapshot.
C. Recover DB1 from the most recent backup. Apply the most recent differential backup.
D. Copy the Pricelist table from the most recent database snapshot into DB1.

[单项选择]You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
A. Only the data files.
B. All of the data files and the control files.
C. Only the data files belonging to the SYSTEM tablespace.
D. Only the data files belonging to the SYSTEM tablespace and the control files.

[单项选择]已知： DAT1 LABEL BYTE DAT2 DW 0ABCDH 依次执行SHL DAT1，1和SHR DAT2，1指令后，DAT2字存储单元中的内容是______。
A. AF34H
B. 55CDH
C. 55E6H
D. ABCDH

[单项选择]

已知：DAT1 LABEL BYTE
DAT2 DW 0ABCDH
依次执行SHL DAT1，1和SHR DAT2，1指令后，DAT2字存储单元中的内容是：（）

A. AF34H
B. 55CDH
C. 55E6H
D. ABCDH

[单项选择]假设DAT为字节变量，下列三条指令中 Ⅰ．MOV AL，DAT[2] Ⅱ．MOV AL，DAT+2 Ⅲ．MOV AL，2[DAT] 其功能相同的是 ( )
A. 三条都相同
B. 仅Ⅰ和Ⅱ相同
C. 仅Ⅰ和Ⅲ相同
D. 仅Ⅱ和Ⅲ相同

[单项选择]执行下面的程序段后，DAT1单元的值是( )。 DAT1 DB 12H，34H DAT2 DB 56H，78H MOV AX， WORD PTR DAT1 CMP AX， WORD PTR DAT2 JA DONE MOV BX， WORD PTR DAT2 MOV OWRD PTR DAT2，AX MOV OWRD PTR DAT1， BX DONE:// HLT
A. 34H
B. 78H
C. 12H
D. 56H

[单项选择]若定义DAT DW 'A'，则DAT和DAT+1 两个相邻的内存单元中存放的数据是( )。
A. 0041H
B. 4100H
C. 0061H
D. 6100H

[单项选择]已知： 　　DAT1 LABEL BYTE 　　DAT2 DW OABCDH 　　依次执行SHL DAT1，1和SHR DAT2，1指令后，DAT2字存储单元中的内容是 ( )。
A. AF34H
B. 55CDH
C. 55E6H
D. ABCDH

[单项选择]已知：　　DAT1 LABEL BYTE 　　DAT2 DW OABCDH 　　依次执行SHL DAT1，1和SHR DAT2，1指令后，DAT2字存储单元中的内容是 ( )。
A. AF34H
B. 55CDH
C. 55E6H
D. ABCDH

[单项选择]已知： DAT1 LABEL BYTE DAT2 DW 0ABCDH 依次执行SHL DAT1,1和SHR DAT2,1指令后，DAT2字存储单元中的内容是( )。
A. AF34H
B. 55CDH
C. 55E6H
D. ABCDH

[单项选择]若定义DAT DW 'A'，则(DAT)和(DAT+1)两个相邻的地址单元中存放的数据是( )。
A. 0041H
B. 4100H
C. ××41H
D. 41××H