1033 + Mcqs in Database McqOptions

1.	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

Discussion

2.	Most plug-ins download slowly because they are rather large files.
A.	True
B.	False
Answer» C.

Discussion

3.	The World Wide Web Consortium (W3C) is the chief standards body for HTTP and HTML.
A.	True
B.	False
Answer» B. False

Discussion

4.	XML is a rapidly developing scripting language that may, in conjunction with XHTML, replace HTML.
A.	True
B.	False
Answer» B. False

Discussion

5.	XSL is a language used to develop style sheets from XML documents.
A.	True
B.	False
Answer» B. False

Discussion

6.	SQL Server automatically creates an index on all primary and foreign keys.
A.	True
B.	False
Answer» B. False

Discussion

7.	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

Discussion

8.	With SQL Server, parameters and variables in T-SQL start with the "%" sign.
A.	True
B.	False
Answer» C.

Discussion

9.	Nonclustered indexes are faster than clustered indexes for retrieval.
A.	True
B.	False
Answer» C.

Discussion

10.	SOAP uses HTTP as its only transport mechanism.
A.	True
B.	False
Answer» C.

Discussion

11.	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.

Discussion

12.	The DTD defines the structure of XML documents.
A.	True
B.	False
Answer» B. False

Discussion

13.	If a document does not conform to the DTD, it is a bad XML document.
A.	True
B.	False
Answer» C.

Discussion

14.	The relational database model was created by E.F. Codd.
A.	True
B.	False
Answer» B. False

Discussion

15.	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

Discussion

16.	Web page display is the most important application of XML.
A.	True
B.	False
Answer» C.

Discussion

17.	A database is called "self-describing" because it contains a description of itself.
A.	True
B.	False
Answer» B. False

Discussion

18.	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.

Discussion

19.	ODBC identifies two types of drivers: single tier and multiple-tier.
A.	True
B.	False
Answer» B. False

Discussion

20.	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

Discussion

21.	Users of OLE DB functionality are referred to as data providers.
A.	True
B.	False
Answer» C.

Discussion

22.	Better security occurs if Windows-only authentication is selected.
A.	True
B.	False
Answer» B. False

Discussion

23.	SQL Server AFTER Triggers may be assigned views.
A.	True
B.	False
Answer» C.

Discussion

24.	'dbo' stands for database object.
A.	True
B.	False
Answer» C.

Discussion

25.	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

Discussion

26.	With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
A.	True
B.	False
Answer» C.

Discussion

27.	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

Discussion

28.	A OLE DB collection is an object that contains a group of other objects.
A.	True
B.	False
Answer» B. False

Discussion

29.	OLE DB has two types of data providers: tabular data providers and service providers.
A.	True
B.	False
Answer» B. False

Discussion

30.	The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
A.	True
B.	False
Answer» C.

Discussion

31.	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

Discussion

32.	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.

Discussion

33.	A user data source is one that can be shared among database users.
A.	True
B.	False
Answer» C.

Discussion

34.	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

Discussion

35.	The ADO connection object is created after the ADO errors object is created.
A.	True
B.	False
Answer» C.

Discussion

36.	A differential backup makes a copy of the entire database.
A.	True
B.	False
Answer» C.

Discussion

37.	SQL Server supports three recovery modes: simple, full and Bulk.
A.	True
B.	False
Answer» B. False

Discussion

38.	With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
A.	True
B.	False
Answer» C.

Discussion

39.	SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.
A.	True
B.	False
Answer» C.

Discussion

40.	SQL Server supports two kinds of indexes: clustered and nonclustered.
A.	True
B.	False
Answer» B. False

Discussion

41.	SQL Server supports a language called Transact-SQL (also called T-SQL).
A.	True
B.	False
Answer» B. False

Discussion

42.	The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.
A.	True
B.	False
Answer» C.

Discussion

43.	ODBC is a foundation of data access in the specifically Microsoft world.
A.	True
B.	False
Answer» C.

Discussion

44.	An abstraction is a generalization of something.
A.	True
B.	False
Answer» B. False

Discussion

45.	The semijoin approach saves network traffic.
A.	True
B.	False
Answer» B. False

Discussion

46.	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

Discussion

47.	An OLE DB rowset is equivalent to a cursor.
A.	True
B.	False
Answer» B. False

Discussion

48.	A file data source is one that is local to a single computer.
A.	True
B.	False
Answer» C.

Discussion

49.	The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.
A.	True
B.	False
Answer» B. False

Discussion

50.	The purpose of timestamping is to avoid the use of locks.
A.	True
B.	False
Answer» B. False

Discussion

Explore topic-wise MCQs in Testing Subject.

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.

Most plug-ins download slowly because they are rather large files.

The World Wide Web Consortium (W3C) is the chief standards body for HTTP and HTML.

XML is a rapidly developing scripting language that may, in conjunction with XHTML, replace HTML.

XSL is a language used to develop style sheets from XML documents.

SQL Server automatically creates an index on all primary and foreign keys.

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.

With SQL Server, parameters and variables in T-SQL start with the "%" sign.

Nonclustered indexes are faster than clustered indexes for retrieval.

SOAP uses HTTP as its only transport mechanism.

There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements.

The DTD defines the structure of XML documents.

If a document does not conform to the DTD, it is a bad XML document.

The relational database model was created by E.F. Codd.

XSLT processors are context-oriented; each statement is evaluated in the context of the match that has been made.

Web page display is the most important application of XML.

A database is called "self-describing" because it contains a description of itself.

A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

ODBC identifies two types of drivers: single tier and multiple-tier.

A data source is an ODBC data structure that identifies a database and the DBMS that processes it.

Users of OLE DB functionality are referred to as data providers.

Better security occurs if Windows-only authentication is selected.

SQL Server AFTER Triggers may be assigned views.

'dbo' stands for database object.

An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

With SQL Server optimistic locking, an update lock is placed on the row when the row is read.

By default, SQL Server will create one data file and one log file for each newly created database.

A OLE DB collection is an object that contains a group of other objects.

OLE DB has two types of data providers: tabular data providers and service providers.

The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.

ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.

A user data source is one that can be shared among database users.

ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.

The ADO connection object is created after the ADO errors object is created.

A differential backup makes a copy of the entire database.

SQL Server supports three recovery modes: simple, full and Bulk.

With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.

SQL Server supports two kinds of indexes: clustered and nonclustered.

SQL Server supports a language called Transact-SQL (also called T-SQL).

The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.

ODBC is a foundation of data access in the specifically Microsoft world.

An abstraction is a generalization of something.

The semijoin approach saves network traffic.

In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.

An OLE DB rowset is equivalent to a cursor.

A file data source is one that is local to a single computer.

The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.

The purpose of timestamping is to avoid the use of locks.