which one of the following database elements is not updated when the design task is run?（）A、formsB、viewsC、rolesD、agents

第1题：

第2题：

Which one is the most important based on the following common elements of a network design？（）

• A、Business needs
• B、Risk analysis
• C、Security policy
• D、Best practices

第3题：

A retail customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations. Which questions will provide the information necessary to design the best performing storage solution of the following？（）

• A、How many web servers will be connected to the database？
• B、How many concurrent applications will run against the database？
• C、How many concurrent users will be accessing the database？
• D、What are the types of transactions run against the database？

第4题：

Which of the following database objects can be used to raise an error if a table is updated?（）

• A、Package
• B、Trigger
• C、Stored Procedure
• D、Informational Constraint

第5题：

Marry wants to create a new application on his laptop that does not have any design elements in it. Which one of the following should he do to begin his process?（）

• A、 select file->Database->new and give it a filename of “blank.nsf” 
• B、 select file->Database->new,choose local as the server,and chose the blank template 
• C、 select file->Database->new,choose local as the server,and chose the default.ntf template 
• D、 select file->Database->new,give it a filename of “blank.nsf”,and chose the blank template 

第6题：

management has asked bob to post an introductory welcome page when notes users first open the video application in which one of the following places should bob put the welcome message?（）

• A、 in a document named welcome 
• B、 in the  database about doc 
• C、 in the  database using doc 
• D、 in the first page in the database design

第7题：

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

• A、 run { open script backup_database； run script backup_database }
• B、 run { engage script backup_database； }
• C、 run { run script backup_database； }
• D、 Run { execute script backup_database； }
• E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

第8题：

Which of the following commands cannot be executed when the database open？（）

• A、RECOVER DATABASE
• B、RECOVER TABLESPACE
• C、RECOVER DATAFILE
• D、ALTER DATABASE RECOVER DATAFILE

第9题：

You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

• A、When the instance is started 
• B、When the database is mounted 
• C、When the database is opened 
• D、When the database is closed

第10题：

第11题：

第12题：

第13题：

第14题：

Which of the following should be updated when new computers are purchased?（）

• A、Asset management
• B、Change management
• C、Cable management
• D、Baselines

第15题：

When updated, which of the following will allow network access to new users?（）

• A、Route lists
• B、ACLs
• C、Firmware
• D、Definitions

第16题：

shirin plans to change the form and views of a production database. she will make the changes locally and then update the application’s design template with the changes. which one of the following server tasks does the administrator run in order for the changes to take effect?（）

• A、 design 
• B、 updall 
• C、 replica 
• D、 fixup

第17题：

Selling the total solution includes adding services and financing options which ensures your customer will remain satisfied with their purchase. Which of the following best describes the benefits of Selling options， storage， services， and financing to your clients？（）

• A、More face time with the executives
• B、Enhanced credibility， higher profits， less competitive pressure
• C、One source for elements， cleaner design， simpler support
• D、Locks competitors out of account

第18题：

A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations.  Which of the following questions will provide the information necessary to design the best performing storage solution？（）

• A、How many web servers will be connected to the database？
• B、Will the database be run on a Windows solution？
• C、How many concurrent users will be accessing the database？
• D、What are the types of transactions run against the database？

第19题：

You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）

• A、Restart the database instance and run the job
• B、Truncate the Certkiller STAFF table and run the job
• C、Delete all rows from the Certkiller STAFF table and run the job
• D、Increase the size of the USERStablespacethe and run the job
• E、Increase the size of the database default permanenttablespaceand run the job

第20题：

You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）

• A、 Window
• B、 Program
• C、 Job class
• D、 Window group

第21题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed， a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions， this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless， the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However， the application that executes the query should not be changed. In addition， the effect on end users should be cut to the least.  Which action should be performed to finish the task？（）

• A、To finish the task， the index should be built by utilizing a FILLFACTOR of 10 percent.
• B、To finish the task， the index should be recreated to have all of the columns in the table included.
• C、To finish the task， an indexed view of the Orders table should be viewed.
• D、To finish the task， the statistics should be updated on the index.

第22题：

第23题：