单选题An instance member（）A is also called a static memberB is always a variableC is never a methodD belongs to a single instance， not to the class as a wholeE always represents an operation

第1题：

You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running？（）

• A、The instance would normally abort.
• B、The instance would not be affected.
• C、The instance would be invalid， so would have to be aborted.
• D、The instance would remain open， but the LGWR process would fail.
• E、The instance would remain open and would automatically create the missing file

第2题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 is available to a Windows group which is named WIIKIGO/Supervisors. A Windows user named User1 is a member of the WIIKIGO/Supervisors group. WIIKIGO/Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（）  

• A、 DROP LOGIN "WIIKIGO/User1"; 
• B、 EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO/User1';
• C、 EXEC dbo.sp_revokedbaccess 'WIIKIGO/User1';EXEC dbo.sp_revokelogin 'WIIKIGO/User1'; 
• D、 CREATE LOGIN "WIIKIGO/User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO/User1";

第3题：

An instance member（） 

• A、is also called a static member
• B、is always a variable
• C、is never a method
• D、belongs to a single instance， not to the class as a whole
• E、always represents an operation

第4题：

In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

• A、The database instance aborts.
• B、The database operation temporarily halts till the member becomes available.
• C、Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
• D、The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
• E、The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

第5题：

Windows Communication Foundation （WCF） application uses a data contract that has several data members. You need the application to throw a Serialization Exception if any of the data members are not present when a serialized instance of the data contract is deserialized. What should you do？（）

• A、 Add the Known Type attribute to the data contract.Set a default value in each of the data member declarations.
• B、 Add the Known Type attribute to the data contract.Set the Order property of each data member to unique integer value.
• C、 Set the Emit Default Value property of each data member to false.
• D、 Set the Is Required property of each data member to true.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which thefollowingstatements about static inner classes is true？（）

• A、 An anonymous class can be declared as static.
• B、 A static inner class cannot be a static member of the outer class.
• C、 A static inner class does not require an instance of the enclosing class.
• D、 Instance member of a static inner class can be referenced using the class name of the staticinner class.

第14题：

How do objects pass messages in Java？（）   

• A、They pass messages by modifying each other’s member variables
• B、They pass messages by modifying the static member variables of each other’s classes
• C、They pass messages by calling each other’s instance member methods
• D、They pass messages by calling static member methods of each other’s classes.

第15题：

Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）

• A、As ASM instance mounts an ASM control file
• B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
• C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
• D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

第16题：

What effect should the loss of an index tablespace have on an Oracle instance that is running？（）

• A、 instance hangs
• B、 instance gets aborted
• C、 instance continues running
• D、 instance gets restarted automatically

第17题：

Which of the following statements about variables and their scopes are true？ （）   

• A、 Instance variables are member variables of a class.
• B、 Instance variables are declared with the static keyword.
• C、 Local variables defined inside a method are created when the method is executed.
• D、 Local variables must be initialized before they are used.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：