Oracle
MySQL
Sybase
Microsoft Access
第1题:
A Database Management System(DBMS) consists of a collection of interrelated data and a collection of () to access to that data
A.programs
B.memory
C.space
D.password
第2题:
第3题:
第4题:
第5题:
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. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? ()
第6题:
Which three benefits does WX Central Management System (WX CMS) software offer WX administrators?()(Choose three.)
第7题:
You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database()
第8题:
ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database. Which is the most effectivemethod to access this data in your database()
第9题:
You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure. You need to recommend an approach for ensuring that database connectivity does not degrade. Which two actions should you recommend?()
第10题:
Enable Flashback Data Archive for the tables.
Specify undo retention guarantee for the database.
Enable supplemental logging for the database.
Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
Create Flashback Data Archive on the tablespace on which the tables are stored.
第11题:
Implement transactions for database queries.
Close database connections in the application.
Use Microsoft ADO.NET in the data access layer.
Implement a retry policy in the data access layer.
第12题:
You should use the Database Engine Tuning Advisor tool
You should use the Windows System Monitor tool
You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio
You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
第13题:
第14题:
第15题:
第16题:
Which three ports does a WX device use for control traffic purposes?() (Choose three.)
第17题:
Which two conditions will cause switch-to-wire to occur? ()(Choose two.)
第18题:
Which database does WX Central Management System (WX CMS) software use to store historical data?()
第19题:
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?()
第20题:
You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding, the Session objects are not lost. What should you do?()
第21题:
Oracle
MySQL
Sybase
Microsoft Access
第22题:
Server session
Cookie
ViewState
Hidden Field
第23题:
Use the InProc Session Management mode to store session data in the ASP.NET worker process.
Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database.
Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm.
Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm.
第24题:
You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances.
You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances.
You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances.
You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.