Which four are correct guidelines for naming database tables? （）A、Must begin with either a number or a letter.B、Must be 1-30 characters long.C、Should not be an Oracle Server reserved word.D、Must contain only A-Z, a-z, 0-+, _, *, and #.E、Must contain only

第1题：

Given two different character sets （A and B）， which of the following must be true for A to be considered a strict superset of B？（）

• A、 A must contain all of the characters defined in B
• B、 A must be Unicode
• C、 The encoded values in A must match the encoded values in B for all characters defined in B 
• D、 A must be a multibyte character set
• E、 The encoded values in A must match the encoded values in B for all numeric and alphabetic character

第2题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

• A、Each extra column in the copy with more columns must not have a default value
• B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
• C、The slave database cannot have more columns than the master. Only the master database can have more columns
• D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
• E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

第3题：

Which four are correct guidelines for naming database tables?（）

• A、Must begin with either a number or a letter.
• B、Must be 1-30 characters long.
• C、Should not be an Oracle Server reserved word.
• D、Must contain only A-Z, a-z, 0-+, _, *, and #.
• E、Must contain only A-Z, a-z, 0-9, _, $, and #.
• F、Must begin with a letter.

第4题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）

• A、 It must be executed from the Oracle Database 11g environment.
• B、 It must be executed only after the SYSAUX tablespace has been created.
• C、 It must be executed from the environment of the database that is being upgraded.
• D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

第5题：

Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）

• A、Both source and target database must be the same character set
• B、Both source and target database must have the same endian format
• C、The COMPATIBLE parameter must be the same in the source and target databases.
• D、The minimum compatibility level for both the source and target database must be 10.0.0.
• E、All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

第6题：

A client/server application has been configured to use local naming. The client and server run on separate machines. When the client tries to connect， it receives a TNS error. By carefully examining the environment， a tnsnames.ora is found only on the Oracle server machine， among other things. After copying this tnsnames.ora onto the client machine， the client is able to connect to the server.  Which statement is true？（）

• A、tnsnames.ora must be on the client machine for local naming. 
• B、tnsnames.ora must be removed from the server for the connection to work. 
• C、tnsnames.ora must be on both the client and server machines for local naming. 
• D、tnsnames.ora is not required for local naming; the problem was not fixed by copying the file to the client.

第7题：

You are developing a custom-collection class.You need to create a method in your class. You need to ensure that the method you create in your class returns a type that is compatible with the Foreach statement. Which criterion should the method meet？（）

• A、The method must return a type of either IEnumerator or IEnumerable.
• B、The method must return a type of IComparable.
• C、The method must explicitly contain a collection.
• D、The method must be the only iterator in the class.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which three statements are true regarding subqueries?（）

• A、Subqueries can contain GROUP BY and ORDER BY clauses 
• B、Main query and subquery can get data from different tables 
• C、Main query and subquery must get data from the same tables 
• D、Subqueries can contain ORDER BY but not the GROUP BY clause 
• E、Only one column or expression can be compared between the main query and subquery
• F、 Multiple columns or expressions can be compared between the main query and subquery

第14题：

Which pre-conditions must be met before an OSPF router can perform graceful restart？（）

• A、Router must be ABR
• B、Router must contain one sham link.
• C、The network topology must be stable.
• D、Router must be able to forward packets.
• E、Neighbors must support graceful restart.

第15题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

• A、It must be executed from the Oracle Database 11g environment.
• B、It must be executed only after the SYSAUX tablespace has been created.
• C、It must be executed from the environment of the database that is being upgraded.
• D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

第16题：

What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）

• A、It can contain parameters with distinct values for each distance.
• B、It can contain only parameters with identical values for each instance.
• C、It must contain an IFILE parameter for each instance’s individual parameter file.
• D、It must be located in the default location for the primary instance’s parameter file.

第17题：

Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）

• A、A must contain all of the characters defined in B
• B、A must be Unicode
• C、The encoded values in A must match the encoded values in B for all characters defined in B
• D、A must be a multibyte character set
• E、The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B

第18题：

Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion？（）

• A、 The database must be in read-write mode.
• B、 The database must have no external files.
• C、 The database must open in read-only mode.
• D、 The database must be mounted but not opened.

第19题：

You need to design a strategy for identifying the number of instances that any one SQL Server 2005 computer will support. What should you do？（）

• A、Specify that each server must have one instance for each customer.
• B、Specify that each server must each have only one instance.
• C、Specify that each server must have one instance for each database that is hosted on that server.
• D、Specify that each server must have one instance for each customer who has one or more databases that are hosted on that server.

第20题：

第21题：

第22题：

第23题：

第24题：