1033 + Mcqs in Database Page 10 McqOptions

451.	SQL Server automatically creates an index on:
A.	primary keys only.
B.	foreign key only.
C.	both primary and foreign keys.
D.	SQL Server never automatically creates an index.
Answer» D. SQL Server never automatically creates an index.

Discussion

452.	In OLE DB, actions that an object can perform are called:
A.	properties.
B.	collections.
C.	methods.
D.	abstractions.
Answer» D. abstractions.

Discussion

453.	An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
A.	True
B.	False
Answer» B. False

Discussion

454.	To see the contents of the SQL*Plus buffer, type:
A.	CONTENTS.
B.	BUFFER.
C.	CURRENT.
D.	LIST.
Answer» E.

Discussion

455.	All primary keys are required.
A.	True
B.	False
Answer» B. False

Discussion

456.	Business Intelligence (BI) reporting analyses can be performed using ________ .
A.	standard SQL only
B.	extensions to SQL only
C.	OLAP only
D.	both standard SQL and extensions to SQL
Answer» B. extensions to SQL only

Discussion

457.	Which of the following statements is true concerning JDBC?
A.	It is language independent.
B.	It is similar in concept to ODBC.
C.	It is useful for all object-oriented languages.
D.	It consists of three main layers.
Answer» C. It is useful for all object-oriented languages.

Discussion

458.	Data replication is favored where most process requests are read-only and where the data are relatively static.
A.	True
B.	False
Answer» B. False

Discussion

459.	READ COMMITTED is the default isolation level.
A.	True
B.	False
Answer» B. False

Discussion

460.	Which of the following is true concerning the following statement: class Manager extends Employee
A.	Manager is a concrete class and a superclass.
B.	Manager is a concrete class and a subclass.
C.	Manager is an abstract class and a superclass.
D.	Manager is an abstract class and a subclass.
Answer» C. Manager is an abstract class and a superclass.

Discussion

461.	The default extension for an Oracle SQL*Plus file is:
A.	.txt.
B.	.pls.
C.	.ora.
D.	.sql.
Answer» E.

Discussion

462.	An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
A.	COBOL.
B.	VB.NET.
C.	TRANSACT SQL.
D.	Visual Basic.
Answer» D. Visual Basic.

Discussion

463.	How many JDBC driver types does Sun define?
A.	One
B.	Two
C.	Three
D.	Four
Answer» E.

Discussion

464.	OLE DB tabular data providers present data in the form of rowsets.
A.	True
B.	False
Answer» B. False

Discussion

465.	The "F" in RFM analysis stands for ________ .
A.	frequently
B.	freshness
C.	fast food
D.	fantasy
Answer» B. freshness

Discussion

466.	The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
A.	Equi-join
B.	Natural join
C.	Outer join
D.	Cartesian join
Answer» B. Natural join

Discussion

467.	A benefit of the three-tier architecture is which of the following?
A.	New modules can be built to support specific business needs
B.	Performance improves for compiled SQL statements
C.	Results in a thinner client and database server
D.	All of the above.
Answer» B. Performance improves for compiled SQL statements

Discussion

468.	A semijoin is which of the following?
A.	Only the joining attributes are sent from one site to another and then all of the rows are returned.
B.	All of the attributes are sent from one site to another and then only the required rows are returned.
C.	Only the joining attributes are sent from one site to another and then only the required rows are returned.
D.	All of the attributes are sent from one site to another and then only the required rows are returned.
Answer» D. All of the attributes are sent from one site to another and then only the required rows are returned.

Discussion

469.	Which of the following is part of an administrative policy to secure a database?
A.	Authentication policies
B.	Limiting particular areas within a building to only authorized people
C.	Ensure appropriate responses rates are in external maintenance agreements
D.	All of the above.
Answer» E.

Discussion

470.	A foreign key is used to implement relationships between tables.
A.	True
B.	False
Answer» B. False

Discussion

471.	Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
A.	Nonrepeatable read
B.	Phantom read
C.	Dirty read
D.	Consistent read
Answer» C. Dirty read

Discussion

472.	Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
A.	Lock level
B.	Transaction isolation level
C.	Cursor concurrency setting
D.	Locking hints
Answer» B. Transaction isolation level

Discussion

473.	ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
A.	True
B.	False
Answer» B. False

Discussion

474.	HTML is an application of a more robust document markup language called:
A.	XHTML.
B.	XML.
C.	SGML.
D.	None of the above is correct.
Answer» D. None of the above is correct.

Discussion

475.	OLAP uses measures, dimensions and associations.
A.	True
B.	False
Answer» C.

Discussion

476.	A proxy server controls the passage of messages or files through to the organization's network.
A.	True
B.	False
Answer» B. False

Discussion

477.	VBScript is similar to JavaScript.
A.	True
B.	False
Answer» B. False

Discussion

478.	A load-balancing approach where requests to one IP address are distributed among the multiple servers hosting the Website at the TCP/IP routing level is DNS (domain name server) balancing.
A.	True
B.	False
Answer» C.

Discussion

479.	C++ is an object-oriented language and is simpler than Java.
A.	True
B.	False
Answer» C.

Discussion

480.	Servlets are stored on the server rather than with an application on a client.
A.	True
B.	False
Answer» B. False

Discussion

481.	Most browsers support e-mail, instant messaging, bookmarking of Websites, and Website addressing and searching.
A.	True
B.	False
Answer» B. False

Discussion

482.	Virus detection is a problem with encrypted messages, because the virus may not be detectable until the message is unencrypted.
A.	True
B.	False
Answer» B. False

Discussion

483.	Routers are used to transmit message packets and forward them to the correct destination over the most efficient pathway available.
A.	True
B.	False
Answer» B. False

Discussion

484.	Documents that have no DTD are by definition not-type-valid.
A.	True
B.	False
Answer» B. False

Discussion

485.	XML uses the same terms with the same meanings as terms in the database world.
A.	True
B.	False
Answer» C.

Discussion

486.	Datasets which reside on the user's hard drive are created by ADO.NET to facilitate the transformation of XML documents to and from relational database constructs.
A.	True
B.	False
Answer» C.

Discussion

487.	It took the popularity of the Internet to realize that database processing and document processing need each other.
A.	True
B.	False
Answer» B. False

Discussion

488.	With XML, document structure, content and format are all defined within one document.
A.	True
B.	False
Answer» C.

Discussion

489.	XML Schemas are XML documents.
A.	True
B.	False
Answer» B. False

Discussion

490.	You can validate an XML Schema document against its schema, just as you would any other XML document.
A.	True
B.	False
Answer» B. False

Discussion

491.	Stylesheets are used by XSLT to indicate how to transform the elements of the XML document into another format.
A.	True
B.	False
Answer» B. False

Discussion

492.	SOAP is now just a name, not an acronym.
A.	True
B.	False
Answer» B. False

Discussion

493.	XML technology is a hybrid of document processing and database processing.
A.	True
B.	False
Answer» B. False

Discussion

494.	With XSLT, you specify a procedure for materializing document elements.
A.	True
B.	False
Answer» C.

Discussion

495.	XML Schema is used to define the content, structure and format of documents.
A.	True
B.	False
Answer» C.

Discussion

496.	The most popular way to materialize XML documents is to use XSLT.
A.	True
B.	False
Answer» B. False

Discussion

497.	Schemas consist of properties and methods
A.	True
B.	False
Answer» C.

Discussion

498.	With failure transparency, all of the actions of a transaction are committed or none of them are committed.
A.	True
B.	False
Answer» B. False

Discussion

499.	Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system.
A.	True
B.	False
Answer» B. False

Discussion

500.	Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.
A.	True
B.	False
Answer» B. False

Discussion

Explore topic-wise MCQs in Engineering.

SQL Server automatically creates an index on:

In OLE DB, actions that an object can perform are called:

An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

To see the contents of the SQL*Plus buffer, type:

All primary keys are required.

Business Intelligence (BI) reporting analyses can be performed using ________ .

Which of the following statements is true concerning JDBC?

Data replication is favored where most process requests are read-only and where the data are relatively static.

READ COMMITTED is the default isolation level.

Which of the following is true concerning the following statement: class Manager extends Employee

The default extension for an Oracle SQL*Plus file is:

An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:

How many JDBC driver types does Sun define?

OLE DB tabular data providers present data in the form of rowsets.

The "F" in RFM analysis stands for ________ .

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

A benefit of the three-tier architecture is which of the following?

A semijoin is which of the following?

Which of the following is part of an administrative policy to secure a database?

A foreign key is used to implement relationships between tables.

Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.

HTML is an application of a more robust document markup language called:

OLAP uses measures, dimensions and associations.

A proxy server controls the passage of messages or files through to the organization's network.

VBScript is similar to JavaScript.

A load-balancing approach where requests to one IP address are distributed among the multiple servers hosting the Website at the TCP/IP routing level is DNS (domain name server) balancing.

C++ is an object-oriented language and is simpler than Java.

Servlets are stored on the server rather than with an application on a client.

Most browsers support e-mail, instant messaging, bookmarking of Websites, and Website addressing and searching.

Virus detection is a problem with encrypted messages, because the virus may not be detectable until the message is unencrypted.

Routers are used to transmit message packets and forward them to the correct destination over the most efficient pathway available.

Documents that have no DTD are by definition not-type-valid.

XML uses the same terms with the same meanings as terms in the database world.

Datasets which reside on the user's hard drive are created by ADO.NET to facilitate the transformation of XML documents to and from relational database constructs.

It took the popularity of the Internet to realize that database processing and document processing need each other.

With XML, document structure, content and format are all defined within one document.

XML Schemas are XML documents.

You can validate an XML Schema document against its schema, just as you would any other XML document.

Stylesheets are used by XSLT to indicate how to transform the elements of the XML document into another format.

SOAP is now just a name, not an acronym.

XML technology is a hybrid of document processing and database processing.

With XSLT, you specify a procedure for materializing document elements.

XML Schema is used to define the content, structure and format of documents.

The most popular way to materialize XML documents is to use XSLT.

Schemas consist of properties and methods

With failure transparency, all of the actions of a transaction are committed or none of them are committed.

Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system.

Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.