MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 1033 Mcqs, each offering curated multiple-choice questions to sharpen your Engineering knowledge and support exam preparation. Choose a topic below to get started.
| 501. |
Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 502. |
Most plug-ins download slowly because they are rather large files. |
| A. | True |
| B. | False |
| Answer» C. | |
| 503. |
The World Wide Web Consortium (W3C) is the chief standards body for HTTP and HTML. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 504. |
XML is a rapidly developing scripting language that may, in conjunction with XHTML, replace HTML. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 505. |
XSL is a language used to develop style sheets from XML documents. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 506. |
SQL Server automatically creates an index on all primary and foreign keys. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 507. |
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 508. |
With SQL Server, parameters and variables in T-SQL start with the "%" sign. |
| A. | True |
| B. | False |
| Answer» C. | |
| 509. |
Nonclustered indexes are faster than clustered indexes for retrieval. |
| A. | True |
| B. | False |
| Answer» C. | |
| 510. |
SOAP uses HTTP as its only transport mechanism. |
| A. | True |
| B. | False |
| Answer» C. | |
| 511. |
There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements. |
| A. | True |
| B. | False |
| Answer» C. | |
| 512. |
The DTD defines the structure of XML documents. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 513. |
If a document does not conform to the DTD, it is a bad XML document. |
| A. | True |
| B. | False |
| Answer» C. | |
| 514. |
The relational database model was created by E.F. Codd. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 515. |
XSLT processors are context-oriented; each statement is evaluated in the context of the match that has been made. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 516. |
Web page display is the most important application of XML. |
| A. | True |
| B. | False |
| Answer» C. | |
| 517. |
A database is called "self-describing" because it contains a description of itself. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 518. |
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset. |
| A. | True |
| B. | False |
| Answer» C. | |
| 519. |
ODBC identifies two types of drivers: single tier and multiple-tier. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 520. |
A data source is an ODBC data structure that identifies a database and the DBMS that processes it. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 521. |
Users of OLE DB functionality are referred to as data providers. |
| A. | True |
| B. | False |
| Answer» C. | |
| 522. |
Better security occurs if Windows-only authentication is selected. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 523. |
SQL Server AFTER Triggers may be assigned views. |
| A. | True |
| B. | False |
| Answer» C. | |
| 524. |
'dbo' stands for database object. |
| A. | True |
| B. | False |
| Answer» C. | |
| 525. |
An OLE DB interface is specified by a set of objects and the properties and methods that they expose. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 526. |
With SQL Server optimistic locking, an update lock is placed on the row when the row is read. |
| A. | True |
| B. | False |
| Answer» C. | |
| 527. |
By default, SQL Server will create one data file and one log file for each newly created database. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 528. |
A OLE DB collection is an object that contains a group of other objects. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 529. |
OLE DB has two types of data providers: tabular data providers and service providers. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 530. |
The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source. |
| A. | True |
| B. | False |
| Answer» C. | |
| 531. |
The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 532. |
ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages. |
| A. | True |
| B. | False |
| Answer» C. | |
| 533. |
A user data source is one that can be shared among database users. |
| A. | True |
| B. | False |
| Answer» C. | |
| 534. |
ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 535. |
The ADO connection object is created after the ADO errors object is created. |
| A. | True |
| B. | False |
| Answer» C. | |
| 536. |
A differential backup makes a copy of the entire database. |
| A. | True |
| B. | False |
| Answer» C. | |
| 537. |
SQL Server supports three recovery modes: simple, full and Bulk. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 538. |
With SQL Server pessimistic locking, no lock is obtained until the user updates the data. |
| A. | True |
| B. | False |
| Answer» C. | |
| 539. |
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers. |
| A. | True |
| B. | False |
| Answer» C. | |
| 540. |
SQL Server supports two kinds of indexes: clustered and nonclustered. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 541. |
SQL Server supports a language called Transact-SQL (also called T-SQL). |
| A. | True |
| B. | False |
| Answer» B. False | |
| 542. |
The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000. |
| A. | True |
| B. | False |
| Answer» C. | |
| 543. |
ODBC is a foundation of data access in the specifically Microsoft world. |
| A. | True |
| B. | False |
| Answer» C. | |
| 544. |
An abstraction is a generalization of something. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 545. |
The semijoin approach saves network traffic. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 546. |
In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 547. |
An OLE DB rowset is equivalent to a cursor. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 548. |
A file data source is one that is local to a single computer. |
| A. | True |
| B. | False |
| Answer» C. | |
| 549. |
The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 550. |
The purpose of timestamping is to avoid the use of locks. |
| A. | True |
| B. | False |
| Answer» B. False | |