SQL3 with the OnlineReadOnly and HR databases
SQL4 with the TravelOnline and Storefront databases
SQL2 with the Storefront and TravelOnline databases
SQL2 with the Storefront and HR databases
第1题:
此题为判断题(对,错)。
第2题:
You want to install Windows 2000 Professional on 20 new PXE compliant computers, which do not have operating systems installed. You create a RIS image and load the image onto the RIS server and then start the new computers. You find that the new computers cannot connect to the RIS server. You verify that existing client computers on the network can connect to network servers.
What should you do? (SELECT AND PLACE)
第3题:
A、if you may
B、if you do
C、if not
D、if so
第4题:
Do you want some______(蔬菜)soup?
第5题:
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.
However, the existing SQL server computers in your office are configured to use the
SQL_Latin1_General_CP1_CI_AS collation.
You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.
What should you do?
A.Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.
B.Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.
C.Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.
D.Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
第6题:
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? ()
A. MERGE
B. INSERT
C. UPDATE
D. ADD
E. ENTER
F. You cannot enter the phone numbers for the existing employee records.
第7题:
You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.
You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
How should you configure SQL1?
A.Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
B.Add SQL2 as remote server.
C.Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
D.Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.
第8题:
You will find as you read this book that you just can't keep some of these stories to ___. You will want to share them with a friend.
A、itself
B、yourself
C、himself
D、themselves
第9题:
You want to use the Web to let Eternal users or your customers look at corporate information. But you want to keep installation at the user end(66)and you don't want just anyone to get(67)your databases.
That may be where an application server enters the picture. For more user machine independent, these t software packages, typically written in the(68)programming language.
for use on Windows NT-based systems, act as go-betweens linking browser-equipped end users to the databases that(69)the information they need to(70)。
A.simple
B.simply
C.single
D.singly
第10题:
What can I do for you, sir?()
ACan you lend me some money?
BNothing.
CI want a pair of shoes.
DWhatever