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.

201.

A subquery in an SQL SELECT statement:
A. can only be used with two tables.
B. can always be duplicated by a join.
C. has a distinct form that cannot be duplicated by a join.
D. cannot have its results sorted using ORDER BY.
Answer» D. cannot have its results sorted using ORDER BY.
Discussion
202.

________ was adopted as a national standard by ANSI in 1992.
A. Oracle
B. SQL
C. Microsoft Access
D. DBase
Answer» C. Microsoft Access
Discussion
203.

A snowflake schema is which of the following types of tables?
A. Fact
B. Dimension
C. Helper
D. All of the above
Answer» E.
Discussion
204.

Fact tables are which of the following?
A. Completely denoralized
B. Partially denoralized
C. Completely normalized
D. Partially normalized
Answer» D. Partially normalized
Discussion
205.

Data transformation includes which of the following?
A. A process to change data from a detailed level to a summary level
B. A process to change data from a summary level to a detailed level
C. Joining data from one source into various sources of data
D. Separating data from one source into various sources of data
Answer» B. A process to change data from a summary level to a detailed level
Discussion
206.

Which of the following is a disadvantage of replication?
A. Reduced network traffic
B. If the database fails at one site, a copy can be located at another site.
C. Each site must have the same storage capacity.
D. Each transaction may proceed without coordination across the network.
Answer» D. Each transaction may proceed without coordination across the network.
Discussion
207.

A distributed database can use which of the following strategies?
A. Totally centralized at one location and accessed by many sites
B. Partially or totally replicated across sites
C. Partitioned into segments at different sites
D. All of the above
Answer» E.
Discussion
208.

Which of the following is not one of the stages in the evolution of distributed DBMS?
A. Unit of work
B. Remote unit of work
C. Distributed unit of Work
D. Distributed request
Answer» B. Remote unit of work
Discussion
209.

Some of the columns of a relation are at different sites is which of the following?
A. Data Replication
B. Horizontal Partitioning
C. Vertical Partitioning
D. Horizontal and Vertical Partitioning
Answer» D. Horizontal and Vertical Partitioning
Discussion
210.

Which of the following is true concerning a global transaction?
A. The required data are at one local site and the distributed DBMS routes requests as necessary.
B. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
C. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
D. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.
Answer» C. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
Discussion
211.

The Object Query Language is which of the following"?
A. Similar to SQL and uses a select-from-where structure
B. Similar to SQL and uses a select-where structure
C. Similar to SQL and uses a from-where structure
D. Not similar to SQL
Answer» B. Similar to SQL and uses a select-where structure
Discussion
212.

Storing a separate copy of the database at multiple locations is which of the following?
A. Data Replication
B. Horizontal Partitioning
C. Vertical Partitioning
D. Horizontal and Vertical Partitioning
Answer» B. Horizontal Partitioning
Discussion
213.

Which one of the following sorts rows in SQL?
A. SORT BY
B. ALIGN BY
C. ORDER BY
D. GROUP BY
Answer» D. GROUP BY
Discussion
214.

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
A. all columns of the table are to be returned.
B. all records meeting the full criteria are to be returned.
C. all records with even partial criteria met are to be returned.
D. None of the above is correct.
Answer» B. all records meeting the full criteria are to be returned.
Discussion
215.

The SQL -92 wildcards are ____ and ____ .
A. asterisk (*); percent sign (%)
B. percent sign (%); underscore (_)
C. underscore(_); question mark (?)
D. question mark (?); asterisk (*)
Answer» C. underscore(_); question mark (?)
Discussion
216.

Which of the following is the correct order of keywords for SQL SELECT statements?
A. SELECT, FROM, WHERE
B. FROM, WHERE, SELECT
C. WHERE, FROM,SELECT
D. SELECT,WHERE,FROM
Answer» B. FROM, WHERE, SELECT
Discussion
217.

Read-only databases are ________ updated.
A. always
B. commonly
C. seldom
D. never
Answer» E.
Discussion
218.

Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
A. advantage
B. disadvantage
C. either an advantage or disadvantage
D. neither an advantage nor disadvantage
Answer» E.
Discussion
219.

When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
A. first step.
B. second step.
C. third step.
D. fourth step.
Answer» C. third step.
Discussion
220.

Normalization ________ data duplication.
A. eliminates
B. reduces
C. increases
D. maximizes
Answer» B. reduces
Discussion
221.

Each answer below shows example data from a table. Which answer is an example of the missing values problem?
A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
C. Three rows have the values Brown, NULL, and Blue in the same column.
D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Answer» D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Discussion
222.

When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
A. first step.
B. second step.
C. third step.
D. fourth step.
Answer» B. second step.
Discussion
223.

Creating a read-only database is a task that is ________ assigned to beginning database professionals.
A. always
B. commonly
C. seldom
D. never
Answer» C. seldom
Discussion
224.

Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
C. Three rows have the values Brown, NULL, and Blue in the same column.
D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Answer» E.
Discussion
225.

When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
A. first step.
B. second step.
C. third step.
D. fourth step.
Answer» C. third step.
Discussion
226.

For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
A. read-only
B. updateable
C. either a read-only or an updateable
D. None of the above is correct.
Answer» B. updateable
Discussion
227.

Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
C. Three rows have the values Brown, NULL, and Blue in the same column.
D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Answer» B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Discussion
228.

The benefits of a standard relational language include which of the following?
A. Reduced training costs
B. Increased dependence on a single vendor
C. Applications are not needed.
D. All of the above.
Answer» B. Increased dependence on a single vendor
Discussion
229.

Which of the following are the five built-in functions provided by SQL?
A. COUNT, SUM, AVG, MAX, MIN
B. SUM, AVG, MIN, MAX, MULT
C. SUM, AVG, MULT, DIV, MIN
D. SUM, AVG, MIN, MAX, NAME
Answer» B. SUM, AVG, MIN, MAX, MULT
Discussion
230.

If a table has been normalized so that all determinants are candidate keys, then that table is in:
A. 1NF.
B. 2NF.
C. 3NF.
D. BCNF.
Answer» E.
Discussion
231.

Which of the following is true concerning the mainframe?
A. It is the same thing as client/server.
B. Requires someone to decide which code should be on the workstation or the server.
C. Mission-critical systems have tended to remain there.
D. All of the above.
Answer» D. All of the above.
Discussion
232.

A server cannot serve on which of the following levels?
A. Client Layer
B. Business Layer
C. Database Layer
D. All of the above.
Answer» B. Business Layer
Discussion
233.

The three different application logic components are which of the following?
A. Presentation, Client, and Storage
B. Presentation, Client, and Processing
C. Presentation, Processing, and Storage
D. Presentation, Processing, and Network
Answer» D. Presentation, Processing, and Network
Discussion
234.

Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
C. Three rows have the values Brown, NULL, and Blue in the same column.
D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Answer» C. Three rows have the values Brown, NULL, and Blue in the same column.
Discussion
235.

Three-tier architecture includes which of the following?
A. Three server layers
B. A client layer and two server layers
C. Two client layers and one server layer
D. Three client layers
Answer» C. Two client layers and one server layer
Discussion
236.

A database server is responsible for which of the following?
A. Database storage
B. Data processing logic
C. Data presentation logic
D. All of the above.
Answer» B. Data processing logic
Discussion
237.

Stored procedures have which of the following advantages?
A. It takes a longer time to write them as compared to writing Visual Basic.
B. Network traffic increases
C. Data integrity improves as multiple applications access the same stored procedure.
D. Result in thicker client and thinner database server.
Answer» D. Result in thicker client and thinner database server.
Discussion
238.

Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
A. Each vendor desiring to be ODBC-complaint provides an ODBC driver.
B. Requires certain criteria to be met in order to establish an ODBC connection.
C. Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
D. All of the above.
Answer» E.
Discussion
239.

Which of the following is true concerning QBE?
A. An official standard has been defined for QBE.
B. QBE cannot be used for client/server systems.
C. QBE does not give the programmer a visual programming environment.
D. Complete applications can be written using QBE.
Answer» E.
Discussion
240.

Client/server security includes which of the following?
A. Physical security
B. Change control security
C. Measures taken to secure all systems
D. All of the above.
Answer» E.
Discussion
241.

An application program interface (API) is which of the following?
A. The same thing as ODBC.
B. Middleware that does not provide access to a database.
C. Middleware that provides access to a database.
D. The same thing as JDBC.
Answer» D. The same thing as JDBC.
Discussion
242.

Most of the time, modification anomalies are serious enough that tables should be normalized into:
A. 1NF.
B. 2NF.
C. 3NF.
D. BCNF.
Answer» E.
Discussion
243.

The SQL statement that queries or reads data from a table is ________ .
A. SELECT
B. READ
C. QUERY
D. None of the above is correct.
Answer» B. READ
Discussion
244.

SQL can be used to:
A. create database structures only.
B. query database data only.
C. modify database data only.
D. All of the above can be done by SQL.
Answer» E.
Discussion
245.

Which of the following do you need to consider when you make a table in SQL?
A. Data types
B. Primary keys
C. Default values
D. All of the above.
Answer» E.
Discussion
246.

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
A. LIKE only.
B. IN only.
C. NOT IN only.
D. Both IN and NOT IN.
Answer» E.
Discussion
247.

The Microsoft Access wildcards are ____ and ____ .
A. asterisk (*); percent sign (%)
B. percent sign (%); underscore (_)
C. underscore(_); question mark (?)
D. question mark (?); asterisk (*)
Answer» E.
Discussion
248.

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
A. SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
B. SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
C. SELECT NAME IN CUSTOMER WHERE STATE = 'V';
D. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Answer» E.
Discussion
249.

To define what columns should be displayed in an SQL SELECT statement:
A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
B. use USING to name the source table(s) and list the columns to be shown after SELECT.
C. use SELECT to name the source table(s) and list the columns to be shown after USING.
D. use USING to name the source table(s) and list the columns to be shown after WHERE.
Answer» B. use USING to name the source table(s) and list the columns to be shown after SELECT.
Discussion
250.

A homogenous distributed database is which of the following?
A. The same DBMS is used at each location and data are not distributed across all nodes.
B. The same DBMS is used at each location and data are distributed across all nodes.
C. A different DBMS is used at each location and data are not distributed across all nodes.
D. A different DBMS is used at each location and data are distributed across all nodes.
Answer» C. A different DBMS is used at each location and data are not distributed across all nodes.
Discussion