You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary pr

第1题：

What is necessary for your query on an existing view to execute successfully? （）

• A、The underlying tables must have data.
• B、You need SELECT privileges on the view.
• C、The underlying tables must be in the same schema.
• D、You need SELECT privileges only on the underlying tables.

第2题：

Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

• A、adding a new user to the database
• B、dropping a user from the database
• C、dropping a table from the database
• D、dropping a data file from a tablespace
• E、adding a new tablespace to the database

第3题：

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

• A、Upgrade the hardware/memory to accommodate the data.
• B、Load the data into your database by using the PARALLEL clause.
• C、Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.
• D、Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

第4题：

There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

• A、Only bring the tablespace back online.
• B、Only recover the tablespace and then bring the tablespace back online.
• C、Shut down the database， recover the data file and then start up the database.
• D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
• E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

第5题：

In which two cases would you use an outer join? （）

• A、The tables being joined have NOT NULL columns.
• B、The tables being joined have only matched data.
• C、The columns being joined have NULL values.
• D、The tables being joined have only unmatched data.
• E、The tables being joined have both matched and unmatched data.
• F、Only when the tables have a primary key/foreign key relationship.

第6题：

You have an Exchange Server 2010 organization.You create a distribution group for all users in your company.You need to ensure that new users can add their mailboxes to the distribution group.What should you do？（）

• A、Modify the group scope of the distribution group.
• B、Modify the approval mode of the distribution group.
• C、Modify the security settings of the distribution group.
• D、Modify the authentication settings of the ECP virtual directory.

第7题：

You have an Exchange Server 2010 organization.  You plan to delegate Exchange administrative rights to some users in the organization.  You need to recommend a solution that tracks all changes made to the Exchange organization.  What should you include in the solution？（）

• A、administrator audit logging
• B、circular logging
• C、diagnostic logging
• D、Windows Security Auditing

第8题：

You have an Exchange organization.All servers in the organization have Exchange Server 2010 Service Pack 1 （SP1） installed. The organization contains two Mailbox servers named Server1 and Server2.Each Mailbox server has one mailbox database and one public folder database. You discover that all users create public folders on Server1 only. You need to ensure that all users create public folders on Server2 only. What should you do？（）

• A、Move all mailboxes to Server2.
• B、Modify the properties of both mailbox databases.
• C、Remove all public folder replicas from Server1.
• D、Modify the properties of both public folder databases.

第9题：

You are a systems administrator responsible for managing a Windows Server 2008 Web server. Recently，your organization set up a new IIS Web site that will be accessed by users outside of your organizations.Consultants should be able to connect to this Web site， using IIS Manager. Your organization’s securitypolicy prevents you from creating domain accounts or local user accounts for these users. You attempt touse the IIS Manager Permissions feature for the Web site. However， when you click Allow User， you areable to select only Windows users.  How can you resolve this problem？（）

• A、Verify that Management Service has been started.
• B、Reconfigure the file system permissions for the root folder of the Web site.
• C、Reconfigure Management Service to enable Windows And IIS Manager Credentials.
• D、Verify the Authentication settings for the Web site.

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and performtablespacerecovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第14题：

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、 Flash back all the tables in the data file， one by one.
• B、 Restore the data file to a new location and perform a media recovery.
• C、 Flash back the database， there is no need to restore the data file.
• D、 Restore the data file from the most recent backup and flash the database.

第15题：

While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

• A、the CREATE TABLE .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第16题：

You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）

• A、by using the STATUS command of the Listener control utility
• B、by using the STATUS L1 command of the Listener control utility
• C、by using the SHOW RULES command of the Listener control utility
• D、by using the SET PASSWORD command of the Listener control utility
• E、by searching for the PASSWORD_LISTENER entry in the listener.ora file

第17题：

Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

• A、 V$DATABASE
• B、 V$UNDOSTAT
• C、 V$FLASHBACK_DATABASE_LOG
• D、 V$FLASHBACK_DATABASE_STAT

第18题：

You have an Exchange Server 2010 organization.  You have a global security group named Legal that contains all the members of your companys legaldepartment.  The companys security policy states that the Legal group must be able to search all mailboxes for e-mailmessages that contain specific keywords.  You need to recommend a solution for the organization that complies with the security policy.  What should you include in the solution？（）

• A、a Discovery Management role group
• B、a legal hold
• C、administrator audit logging
• D、Mailbox journaling

第19题：

You are an IIS Web server administrator implementing authentication settings for a new Web site.According to the requirements for the Human Resources Web site， users should be prompted forauthentication information when they attempt to access the site. The site will be accessed only by userswho have accounts in your organization’s Active Directory domain. You have already configured the filesystem permissions for the content based on the appropriate settings. You also want to maximize securityof the site. Which two actions should you take to meet these requirements？（）

• A、Enable Windows authentication.
• B、Enable basic authentication.
• C、Disable anonymous authentication.
• D、Enable anonymous authentication.

第20题：

You have an Exchange Server 2010 organization.  You need to recommend a mailbox storage management solution for your organization to meet thefollowing requirements： .Apply quota limits for users by department.Automatically apply quota limits for new users What should you recommend？（）

• A、A storage group for each department.
• B、A mailbox database for each department.
• C、An organizational unit for each department.
• D、A managed folder mailbox policy for each department.

第21题：

You are employed as the exchange administrator at TestKing.com. The TestKing.com network containsan Exchange Server 2010 Organization. TestKing.com has its headquarters in Chicago and a branchoffice in Dallas. TestKing.com has a global security group named TestFinance. TestFinance contains all the users in theFinance department. A new TestKing.com policy state that TestFinance have the nesessary permissons tosearch the mailboxes for e-mail messages containing certain words. The CIO wants you to recommend asolution that will comply with the new policy. What should you do？（）

• A、Your solution should include a finance hold.
• B、Your solution should include mailbox journaling.
• C、Your solution should include a Discovery Management role group.
• D、Your solution should include administrator audit logging.

第22题：

第23题：