● (73) is a query language for manipulating data in a relational database.(73)A. AssembleB．SQLC． C++D． Fortran
● (73) is a query language for manipulating data in a relational database.
(73)A. Assemble
B．SQL
C． C++
D． Fortran
相关考题：
● The program and the data are kept inside the computer in a place called (73) .A. bus B. cache C. CPU D. memory
● (73) provides a data path between the CPU and external devices.(73)A. KeyboardB. I/O portC. DiskD. Printer
● C++ fully supports (73) programming.(73)A. visualB. object-orientedC. logicD. natural language
● The program and the data are kept inside the computer in a place called(73) .(73)A. busB. cacheC. CPUD. memory
● (73) is a query language for manipulating data in a relational database.(73) A. AssembleB. SQLC. C++D. Fortran
The HTML is the language used to create(73)for use on the WWW.A．dataB．hypertext pagesC．pagesD．Active Server Pages
● Business intelligence (BI) is the integrated application of data warehouse, data mining and (73)．（73）A．OLAPB．OLTPC．MRPIID．CMS．
In C language, the usual expression statements are(73)or function calls.A．I/OsB．operationsC．assignmentsD．evaluations
The Assembly Language is often used to distinguish(73)machine-readable information from textual human-readable information.A．binaryB．hexC．octalD．decimal
Business intelligence （BI） is the integrated application of data warehouse, data mining and （73）．A.OLAPB.OLTPC.MRPIID.CMS
（73)is a query language for manipulating data in a relational database.A.AssembleB.SQLC.C++D.Fortran
The relational database model requires the data be(110)through programs that don't rely on the position of the data in the database. This is in direct(111)to the other database mode, where the program has to follow a series of pointers to the data it seeks. A program(112)a relational database simply asks for the data it seeks; the DBMS performs the necessary searches and(113)the information. The(114)on how the search is done are specific to the DBMS and vary from product to product.A．accessedB．movedC．readD．wrote
(73) is a query language for manipulating data in a relational database.A.Assemble SX （73） is a query language for manipulating data in a relational database.A.AssembleB.SQLC.C++D.Fortran
The relational database model requires the data be(71)through programs that don't rely on the position of the data in the database. This is in direct(72)to the other database mode, where the program has to follow a series of pointers to the data it seeks. A program(73)a relational database simply asks for the data it seeks; the DBMS performs the necessary searches and(74)the information. The(75)on how the search is done are specific to the DBMS and vary from product to product.A．accessedB．movedC．readD．wrote
●A (73) is a named memory block. By using its name, we can refer to the data stored in the memory block.(73)A.wordB.recordC.programD.variable
_____ is a query language for manipulating data in a relmional database.A.Assemble]B.SQLC.C++D.Fortran
______is a query language for manipulating data in a relmional database.A.AssembleB.SQLC.C++D.Fortran
The objective of (71) is to determine what parts of the application software will be assigned to what hardware. The major software components of the system being developed have to be identified and then allocated to the various hardware components on which the system will operate. All software systems can be divided into four basic functions. The first is (请作答此空). Most information systems require data to be stored and retrieved, whether a small file, such as a memo produced by a word processor, or a large database, such as one that stores an organization's accounting records. The second function is the (73), the processing required to access data, which often means database queries in Structured Query Language. The third function is the (74), which is the logic documented in the DFDs, use cases, and functional requirements. The fourth function is the presentation logic, the display of information to the user and the acceptance of the user's commands. The three primary hardware components of a system are (75). A. data access componentsB. database management systemC. data storageD. data entities
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.
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.
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. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）A、To achieve the goal， a Linked Server connection should be configured to the application database.B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.C、To achieve the goal， a Remote Server connection to the application database should be configured.D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
单选题You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear. You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do？（）AAdd an XML index to the table that contains the product data.BAdd the XSINIL argument to the ELEMENTS directive in the query.CAdd a HAVING clause to the query.DAdd the replace value of clause to the query.