Explore topic-wise MCQs in Engineering.

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.

1.

CASE tools do not include which of the following features?

A. Help to draw data models
B. Help to generate code
C. Help to manage people
D. Create an information repository
Answer» D. Create an information repository
2.

If the XML data instance conforms to the DTD, the document is said to be:

A. type-invalid.
B. type-valid.
C. not-type-valid.
D. an HTML document.
Answer» C. not-type-valid.
3.

An XML component that defines the structure of a document is known as a(n):

A. DOCTYPE.
B. DTD.
C. #PCDATA.
D. HTML Stylesheet.
Answer» C. #PCDATA.
4.

XSLT processors evaluate each statement in the context of the match that has been made. That is, XSLT processors are:

A. context oriented.
B. procedural oriented.
C. object oriented.
D. relational oriented.
Answer» B. procedural oriented.
5.

The DTD begins with the word:

A. #PCDATA.
B. XML.
C. DOCTYPE.
D. HTTPS.
Answer» D. HTTPS.
6.

To eliminate definition duplication, XML Schemas define:

A. an intersection table.
B. global elements.
C. a normalized definition table.
D. None of the above is correct.
Answer» C. a normalized definition table.
7.

ADO.NET provides the ability to create and process in-memory databases called:

A. views.
B. relations.
C. tables.
D. datasets.
Answer» E.
8.

What is not true about SOAP?

A. SOAP originally meant Simple Object Access Protocol.
B. SOAP was defined as an XML-based standard for providing remote procedure calls over the Internet.
C. SOAP now is just a name, not an acronym
D. SOAP was an early form of XML.
Answer» E.
9.

XML Schemas consist of:

A. properties and methods.
B. elements and attributes.
C. structure and data.
D. tables and relationships.
Answer» C. structure and data.
10.

XML is:

A. a subset of SGML only.
B. a hybrid of document processing and database processing only.
C. a standardized yet customizable way to describe the content of documents only.
D. XML is all of the above.
Answer» E.
11.

The document that is used by XSLT to indicate how to transform the elements of the XML document to another format is a(n):

A. HTML page.
B. DOCTYPE procedure.
C. stylesheet.
D. stored procedure.
Answer» D. stored procedure.
12.

If an XML document does not have a DTD, then by definition it is:

A. not-type-valid.
B. type-valid.
C. an HTML document.
D. None of the above is correct.
Answer» B. type-valid.
13.

What is not true about XML?

A. Web page display is the most important application of XML.
B. With XML, there is a clear separation between document structure, content and materialization.
C. XML is more powerful than HTML.
D. XML documents have two sections.
Answer» B. With XML, there is a clear separation between document structure, content and materialization.
14.

The expression FOR XML RAW tells SQL Server to:

A. place the values of the columns as attributes in the resulting XML document.
B. place the values of the columns into elements rather than attributes.
C. place some columns into elements and others into attributes.
D. None of the above is correct.
Answer» B. place the values of the columns into elements rather than attributes.
15.

In enterprise data modeling, which is incorrect?

A. You review current systems.
B. You implement the new database.
C. You describe the data needed at a very high level of abstraction.
D. You plan one or more database development projects.
Answer» C. You describe the data needed at a very high level of abstraction.
16.

Which of the following database activities require a specific knowledge of a DBMS?

A. Enterprise modeling
B. Conceptual data modeling
C. Logical database design
D. Physical database design and definition
Answer» E.
17.

Whose role is it to determine the requirements and design for a database?

A. Database analysts
B. Database administrators
C. Both A and B.
D. Neither A or B.
Answer» B. Database administrators
18.

Which of the following database activities determines the entities, attributes, and relationships of data?

A. Conceptual data modeling
B. Logical database design
C. Physical database design and definition
D. Database implementation
Answer» B. Logical database design
19.

The use of packaged data models can offer which of the following benefits?

A. Reduce implementation time and costs
B. Higher quality models
C. Both A and B.
D. Neither A nor B.
Answer» D. Neither A nor B.
20.

The Enterprise tier of the three-tiered database architecture includes:

A. managing the data.
B. managing the User-system interface.
C. processing HTTP protocol.
D. processing scripting tasks.
Answer» B. managing the User-system interface.
21.

An entity type is which of the following?

A. A major category of data about people, place, and things
B. The various departments of an organization
C. The application software
D. The business processes the support the mission of an organization
Answer» B. The various departments of an organization
22.

Strategic Planning factors do not include which of the following?

A. Organizational goals
B. Critical success factors
C. Information engineering
D. Problem areas
Answer» D. Problem areas
23.

The XSLT processor copies the elements of the stylesheet until it finds a command in the format:

A. SELECT ... FROM ... WHERE.
B. {item, action}.
C. {for-each select}.
D. <HTML>...< HTML>.
Answer» C. {for-each select}.
24.

Which of the following statements is not true about XML Schemas:

A. They are used to define the content and structure of data.
B. They define a set of symbols and the relationships of those symbols.
C. They are themselves XML documents.
D. They have their own syntax.
Answer» E.
25.

The most popular way to materialize XML documents is to use:

A. DTD.
B. XSLT.
C. HTML.
D. SOAP.
Answer» C. HTML.
26.

Locks placed by command are called ________ .

A. implicit locks
B. explicit locks
C. exclusive locks
D. shared locks
Answer» C. exclusive locks
27.

Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

A. Weak entity
B. Strong entity
C. ID-dependent entity
D. ID- independent entity
Answer» B. Strong entity
28.

With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?

A. Differential recovery
B. Full recovery
C. Simple recovery
D. Bulk-logged recovery
Answer» E.
29.

Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?

A. #
B. %
C. &
D. @
Answer» E.
30.

What mode of authentication does SQL Server NOT provide?

A. Windows-only security
B. Both SQL Server and Windows-only security
C. Mixed security
D. SQL Server only security
Answer» E.
31.

A relation is in this form if it is in BCNF and has no multivalued dependencies:

A. second normal form.
B. third normal form.
C. fourth normal form.
D. domain/key normal form.
Answer» D. domain/key normal form.
32.

Row is synonymous with the term:

A. record.
B. relation.
C. column.
D. field.
Answer» B. relation.
33.

Which of the following indicates the maximum number of entities that can be involved in a relationship?

A. Minimum cardinality
B. Maximum cardinality
C. ERD
D. Greater Entity Count (GEC)
Answer» C. ERD
34.

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

A. parent
B. child
C. instance
D. subtype
Answer» B. child
35.

Which type of entity represents an actual occurrence of an associated generalized entity?

A. Supertype entity
B. Subtype entity
C. Archetype entity
D. Instance entity
Answer» E.
36.

A recursive relationship is a relationship between an entity and ________ .

A. itself
B. a subtype entity
C. an archetype entity
D. an instance entity
Answer» B. a subtype entity
37.

With XML:

A. views are not limited to one multi-valued path only.
B. documents can automatically be generated from database data only.
C. database data can automatically be extracted from XML documents only.
D. With XML, all of the above are true.
Answer» E.
38.

The first step in database development is which of the following?

A. Enterprise data modeling
B. Logical database design
C. Physical database design and definition
D. Database Implementation
Answer» B. Logical database design
39.

Which of the following is NOT a basic element of all versions of the E-R model?

A. Entities
B. Attributes
C. Relationships
D. Primary keys
Answer» E.
40.

The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

A. Dirty data
B. Inconsistent data
C. Too much data
D. Non-integrated data
Answer» D. Non-integrated data
41.

A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

A. Push
B. Pull
C. RFM
D. OLAP
Answer» C. RFM
42.

Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

A. Supertype entity
B. Subtype entity
C. Archetype entity
D. Instance entity
Answer» D. Instance entity
43.

In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

A. parent
B. child
C. instance
D. subtype
Answer» C. instance
44.

Entities of a given type are grouped into a(n):

A. database.
B. entity class.
C. attribute.
D. ERD.
Answer» C. attribute.
45.

What is an advantage of placing computations in SQL views?

A. To save users from having to write an expression.
B. To ensure that the results are consistent.
C. To accomplish both of the above.
D. None of the above is correct - computations cannot be placed in a view.
Answer» D. None of the above is correct - computations cannot be placed in a view.
46.

Which of the following locks the item from access of any type?

A. Implicit lock
B. Explicit lock
C. Exclusive lock
D. Shared lock
Answer» D. Shared lock
47.

Which of the following indicates the minimum number of entities that must be involved in a relationship?

A. Minimum cardinality
B. Maximum cardinality
C. ERD
D. Greater Entity Count (GEC)
Answer» B. Maximum cardinality
48.

Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?

A. Entity
B. Attribute
C. Identifier
D. Relationship
Answer» B. Attribute
49.

In which of the following is a single-entity instance of one type related to many entity instances of another type?

A. One-to-One Relationship
B. One-to-Many Relationship
C. Many-to-Many Relationship
D. Composite Relationship
Answer» C. Many-to-Many Relationship
50.

Which is NOT one of the most common types of SQL CHECK constraints?

A. System date
B. Range checks
C. Lists of values
D. Comparing one column value to another within the same table
Answer» B. Range checks