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.

101.

The SQL command to create a table is:
A. MAKE TABLE.
B. ALTER TABLE.
C. DEFINE TABLE.
D. CREATE TABLE.
Answer» E.
Discussion
102.

The DROP TABLE statement:
A. deletes the table structure only.
B. deletes the table structure along with the table data.
C. works whether or not referential integrity constraints would be violated.
D. is not an SQL statement.
Answer» C. works whether or not referential integrity constraints would be violated.
Discussion
103.

SQL views can be used to hide:
A. columns and rows only.
B. complicated SQL syntax only.
C. both of the above can be hidden by an SQL view.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
104.

The SQL statement to create a view is:
A. CREATE VIEW.
B. MAKE VIEW.
C. SELECT VIEW.
D. INSERT VIEW.
Answer» B. MAKE VIEW.
Discussion
105.

A ________ is a stored program that is attached to a table or a view.
A. pseudofile
B. embedded SELECT statement
C. trigger
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
106.

The DBMS that is most difficult to use is ________ .
A. Microsoft's SQL Server
B. Microsoft's Access
C. IBM's DB2
D. Oracle Corporation's Oracle
Answer» E.
Discussion
107.

Which of the following products implemented the CODASYL DBTG model?
A. IDMS
B. DB2
C. dBase-II
D. R:base
Answer» B. DB2
Discussion
108.

Which of the following is not considered to be a basic element of an enterprise-class database system?
A. Users
B. Database applications
C. DBMS
D. COBOL programs
Answer» E.
Discussion
109.

An Enterprise Resource Planning application is an example of a(n) ________ .
A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer» C. e-commerce database application
Discussion
110.

A DBMS that combines a DBMS and an application generator is ________ .
A. Microsoft's SQL Server
B. Microsoft's Access
C. IBM's DB2
D. Oracle Corporation's Oracle
Answer» C. IBM's DB2
Discussion
111.

Which of the following products was the first to implement true relational algebra in a PC DBMS?
A. IDMS
B. Oracle
C. dBase-II
D. R:base
Answer» E.
Discussion
112.

SQL stands for ________ .
A. Structured Query Language
B. Sequential Query Language
C. Structured Question Language
D. Sequential Question Language
Answer» B. Sequential Query Language
Discussion
113.

The following are functions of a DBMS except ________ .
A. creating and processing forms
B. creating databases
C. processing data
D. administrating databases
Answer» B. creating databases
Discussion
114.

Helping people keep track of things is the purpose of a(n) ________ .
A. database
B. table
C. instance
D. relationship
Answer» B. table
Discussion
115.

The DBMS acts as an interface between what two components of an enterprise-class database system?
A. Database application and the database
B. Data and the database
C. The user and the database application
D. Database application and SQL
Answer» B. Data and the database
Discussion
116.

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
A. IDMS
B. DB2
C. dBase-II
D. R:base
Answer» C. dBase-II
Discussion
117.

The following are components of a database except ________ .
A. user data
B. metadata
C. reports
D. indexes
Answer» D. indexes
Discussion
118.

An application where only one user accesses the database at a given time is an example of a(n) ________ .
A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer» B. multiuser database application
Discussion
119.

An on-line commercial site such as Amazon.com is an example of a(n) ________ .
A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer» D. data mining database application
Discussion
120.

RFM analysis uses customers' purchasing patterns to ________ .
A. record transactions
B. analyze and rank customers
C. predict future sales using regression techniques
D. perform OLAP
Answer» C. predict future sales using regression techniques
Discussion
121.

We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .
A. the basic probability
B. support
C. lift
D. confidence
Answer» C. lift
Discussion
122.

Business Intelligence (BI) reporting systems cannot do which of the following operations?
A. Filter data
B. Group data
C. Modify data
D. Both filter and group data
Answer» D. Both filter and group data
Discussion
123.

Which of the following is not a component of a data warehouse?
A. Data extraction/cleaning/preparation programs
B. Data warehouse data
C. Data metadata
D. None of the above are data warehouse components.
Answer» D. None of the above are data warehouse components.
Discussion
124.

We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
A. the basic probability
B. support
C. lift
D. confidence
Answer» E.
Discussion
125.

We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
A. dirty data
B. inconsistent data
C. non-integrated data
D. a "wrong format" problem
Answer» D. a "wrong format" problem
Discussion
126.

The reports generated by a reporting system are usually not delivered in which of the following media?
A. Web portal
B. Commercial courier service
C. Digital dashboard
D. E-Mail
Answer» C. Digital dashboard
Discussion
127.

Data mining applications are used accomplish which of the following tasks?
A. Process transactions only
B. Do RFM analysis only
C. Do what-if analysis only
D. Do both RFM and what-if analysis
Answer» D. Do both RFM and what-if analysis
Discussion
128.

We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
A. Has ordered recently, orders frequently, and places a large order when she orders.
B. Hasn't ordered recently, orders infrequently, but places a large order when she orders.
C. Has ordered recently, orders frequently, but doesn't place a large order when she orders
D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.
Answer» D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.
Discussion
129.

In OLAP, we are interested in ________ .
A. levels only
B. dimensions only
C. measures only
D. measures and dimensions
Answer» E.
Discussion
130.

Which of the following is an unsupervised data mining technique?
A. Cluster analysis only
B. Regression Analysis only
C. RFM Analysis only
D. Both Regression Analysis and RFM Analysis
Answer» B. Regression Analysis only
Discussion
131.

Which of the following is not a reason that operational data are difficult to read?
A. Non-duplicated data
B. Dirty data
C. Missing values
D. Non-integrated data
Answer» B. Dirty data
Discussion
132.

Which is not a type of data management technology?
A. Relational
B. Rational
C. Object-oriented
D. Dimensional
Answer» C. Object-oriented
Discussion
133.

Which is not a relevant feature of CASE tools?
A. The ability to help draw data models using entity-relationship notations
B. The ability to generate code
C. An information repository
D. Access to a DB via the Internet
Answer» E.
Discussion
134.

A BI reporting system does not ________ .
A. create meaningful information
B. deliver information to users on a timely basis
C. use statistical procedures to predict future events
D. use disparate data sources
Answer» D. use disparate data sources
Discussion
135.

Which of the following database activities allow for the actual retrieval and use of a database?
A. Enterprise modeling
B. Logical database design
C. Physical database design and definition
D. Database implementation
Answer» E.
Discussion
136.

Which of the following are not done by Business Intelligence (BI) systems?
A. Analyze past and current activities only
B. Process and record transactions only
C. Both of the above are correct.
D. Neither of the above is correct.
Answer» C. Both of the above are correct.
Discussion
137.

Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
A. MUST COVER
B. MUST NOT
C. Both of the above.
D. None of the above is correct.
Answer» B. MUST NOT
Discussion
138.

If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
A. the primary key
B. any alternate key
C. a surrogate key
D. a foreign key
Answer» B. any alternate key
Discussion
139.

Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
A. Null status
B. Data type
C. Default value
D. Data constraints
Answer» E.
Discussion
140.

A foreign key is:
A. a column containing the primary key of another table.
B. used to define data types.
C. used to define null status.
D. all of the above are above correct.
Answer» B. used to define data types.
Discussion
141.

Which of the following columns is(are) are required in a table?
A. A foreign key
B. An alternate key
C. A primary key
D. A surrogate key.
Answer» D. A surrogate key.
Discussion
142.

In a 1:1 relationship, the foreign key is placed in:
A. either table without specifying parent and child tables.
B. the parent table.
C. the child table.
D. either the parent table or the child table.
Answer» B. the parent table.
Discussion
143.

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
A. ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
B. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
144.

Which is not true of a correlated subquery?
A. EXISTS/NOT EXISTS is a form of a correlated subquery.
B. The processing of the SELECT statements is nested.
C. They can be used to verify functional dependencies.
D. They are very similar to a regular subquery.
Answer» E.
Discussion
145.

How many copies of the database schema are typically used in the redesign process?
A. One
B. Two
C. Three
D. Four
Answer» D. Four
Discussion
146.

Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
A. optimistic
B. skeptical
C. ambivalent
D. None of the above is correct.
Answer» C. ambivalent
Discussion
147.

ON UPDATE CASCADE ensures which of the following?
A. Normalization
B. Data Integrity
C. Materialized Views
D. All of the above.
Answer» C. Materialized Views
Discussion
148.

The NOT EXISTS keyword will be true if:
A. any row in the subquery meets the condition.
B. all rows in the subquery fail the condition.
C. both of these two conditions are met.
D. neither of these two conditions is met.
Answer» C. both of these two conditions are met.
Discussion
149.

The reserved word enum is used for which of the following?
A. To define a range for an attribute.
B. To define a range for a class.
C. To define a range for a relationship.
D. All of the above.
Answer» B. To define a range for a class.
Discussion
150.

Which of the following is an unordered collection of elements that may contain duplicates?
A. Set
B. Bag
C. List
D. Dictionary
Answer» C. List
Discussion