MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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.
| 601. |
Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing. |
| A. | True |
| B. | False |
| Answer» C. | |
| 602. |
Most operational databases can be used for many BI applications. |
| A. | True |
| B. | False |
| Answer» C. | |
| 603. |
A data warehouse is a database system that is optimized for operational transaction processing. |
| A. | True |
| B. | False |
| Answer» C. | |
| 604. |
Which of the following types of databases are the most common? |
| A. | Personal |
| B. | Workgroup |
| C. | Department |
| D. | Enterprise |
| Answer» D. Enterprise | |
| 605. |
Both ASP and ColdFusion allow for the coding of custom tags within an HTML document. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 606. |
The term Incomplete for a UML has the same meaning as which of the following for an EER diagram? |
| A. | Overlapping rule |
| B. | Disjoint rule |
| C. | Total specialization rule |
| D. | Partial specialization rule |
| Answer» E. | |
| 607. |
An atomic literal is which of the following? |
| A. | Strings |
| B. | Boolean |
| C. | Long |
| D. | All of the above. |
| Answer» E. | |
| 608. |
A cursor type in which the application can only move forward through the recordset is called: |
| A. | forward only. |
| B. | static. |
| C. | keyset. |
| D. | dynamic. |
| Answer» B. static. | |
| 609. |
In ODBC, a data source that is local to a single computer is called a: |
| A. | system data source. |
| B. | file data source. |
| C. | user data source. |
| D. | SQL text file. |
| Answer» B. file data source. | |
| 610. |
How does Tomcat execute a JSP? |
| A. | As a CGI script |
| B. | As an independent process |
| C. | By one of Tomcat's threads |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 611. |
The data warehouse DBMS needs to be the same DBMS used for the operational database. |
| A. | True |
| B. | False |
| Answer» C. | |
| 612. |
Which of the following conditions should exist if you want to convert a relationship to an associative entity? |
| A. | Some of the relationships for the participating entities are "many". |
| B. | The resulting associative entity has an independent meaning. |
| C. | The resulting associative entity has no attributes. |
| D. | All of the above |
| Answer» C. The resulting associative entity has no attributes. | |
| 613. |
A rectangle represents which of the following in an EER? |
| A. | Attribute |
| B. | Entity |
| C. | Optional One |
| D. | Relationship |
| Answer» C. Optional One | |
| 614. |
A subtype discriminator is which of the following? |
| A. | An attribute of the supertype whose values determine the subtype |
| B. | An attribute of the subtype whose values determine the supertype |
| C. | An attribute of the supertype whose values determine the supertype |
| D. | An attribute of the subtype whose values determine the subtype |
| Answer» B. An attribute of the subtype whose values determine the supertype | |
| 615. |
Hypertext Transfer Protocol (HTTP) is secure. |
| A. | True |
| B. | False |
| Answer» C. | |
| 616. |
Performance analysis and tuning is which of the following? |
| A. | Undertaken one time at the time of a DBMS installation |
| B. | Undertaken one time at the time of the implementation of a new application |
| C. | Undertaken as an ongoing part of the backup of a database |
| D. | Undertaken as an ongoing part of managing a database |
| Answer» E. | |
| 617. |
The command to eliminate a table from a database is: |
| A. | REMOVE TABLE CUSTOMER; |
| B. | DROP TABLE CUSTOMER; |
| C. | DELETE TABLE CUSTOMER; |
| D. | UPDATE TABLE CUSTOMER; |
| Answer» C. DELETE TABLE CUSTOMER; | |
| 618. |
Because it contains a description of its own structure, a database is considered to be ________ . |
| A. | described |
| B. | metadata compatible |
| C. | self-describing |
| D. | an application program |
| Answer» D. an application program | |
| 619. |
When the parent entity is required, a new child row can always be inserted. |
| A. | True |
| B. | False |
| Answer» C. | |
| 620. |
What is an SQL virtual table that is constructed from other tables? |
| A. | Just another table |
| B. | A view |
| C. | A relation |
| D. | Query results |
| Answer» C. A relation | |
| 621. |
What servlet processor was developed by Apache Foundation and Sun? |
| A. | Apache Tomcat |
| B. | Apache Web server |
| C. | Sun servlet processor |
| D. | None of the above is correct. |
| Answer» B. Apache Web server | |
| 622. |
What is bytecode? |
| A. | Machine-specific code |
| B. | Java code |
| C. | Machine-independent code |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 623. |
Which JDBC driver Types are for use over communications networks? |
| A. | Type 3 only |
| B. | Type 4 only |
| C. | Both Type 3 and Type 4 |
| D. | Neither Type 3 nor Type 4 |
| Answer» D. Neither Type 3 nor Type 4 | |
| 624. |
In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 625. |
Which of the following is true concerning triggers? |
| A. | You do not create them with SQL. |
| B. | They execute against only some applications that access a database. |
| C. | They have an event, condition, and action. |
| D. | They cannot cascade (cause another trigger to fire). |
| Answer» D. They cannot cascade (cause another trigger to fire). | |
| 626. |
A distributed database is which of the following? |
| A. | A single logical database that is spread to multiple locations and is interconnected by a network |
| B. | A loose collection of file that is spread to multiple locations and is interconnected by a network |
| C. | A single logical database that is limited to one location. |
| D. | A loose collection of file that is limited to one location. |
| Answer» B. A loose collection of file that is spread to multiple locations and is interconnected by a network | |
| 627. |
Which of the following statement is true concerning objects and/or classes? |
| A. | An object is an instance of a class. |
| B. | A class is an instance of an object. |
| C. | An object includes encapsulates only data. |
| D. | A class includes encapsulates only data. |
| Answer» B. A class is an instance of an object. | |
| 628. |
JDBC stands for: |
| A. | Java Database Connectivity |
| B. | Java Database Components |
| C. | Java Database Control |
| D. | None of the above is correct. |
| Answer» B. Java Database Components | |
| 629. |
Business Intelligence (BI) systems do not obtain their data by which of the following means? |
| A. | Read and process data from an operational database |
| B. | Process transactions |
| C. | Process extracts from operational databases |
| D. | Process data purchased from data vendors |
| Answer» C. Process extracts from operational databases | |
| 630. |
How many tables may be included with a join? |
| A. | One |
| B. | Two |
| C. | Three |
| D. | All of the above. |
| Answer» E. | |
| 631. |
Which of the following is true about ColdFusion Markup Language (CFML)? |
| A. | It is stored in .asp files. |
| B. | It is executed on the client. |
| C. | It does not use tags. |
| D. | It allows for coding of custom tags in an HTML file. |
| Answer» E. | |
| 632. |
Client-side extensions: |
| A. | add functionality to the server. |
| B. | add functionality to the browser. |
| C. | add functionality to the firewall. |
| D. | add functionality to the network. |
| Answer» C. add functionality to the firewall. | |
| 633. |
Reconciled data is which of the following? |
| A. | Data stored in the various operational systems throughout the organization. |
| B. | Current data intended to be the single source for all decision support systems. |
| C. | Data stored in one operational system in the organization. |
| D. | Data that has been selected and formatted for end-user support applications. |
| Answer» C. Data stored in one operational system in the organization. | |
| 634. |
Concurrency control is important for which of the following reasons? |
| A. | To ensure data integrity when updates occur to the database in a multiuser environment |
| B. | To ensure data integrity when updates occur to the database in a single-user environment |
| C. | To ensure data integrity while reading data occurs to the database in a multiuser environment |
| D. | To ensure data integrity while reading data occurs to the database in a single-user environment |
| Answer» B. To ensure data integrity when updates occur to the database in a single-user environment | |
| 635. |
With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted. |
| A. | True |
| B. | False |
| Answer» C. | |
| 636. |
SQL Server indexes are special data structures used to improve performance. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 637. |
SERIALIZABLE is the strictest isolation level. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 638. |
FOR XML EXPLICIT tells SQL Server to place the values of the columns as attributes in the resulting XML document. |
| A. | True |
| B. | False |
| Answer» C. | |
| 639. |
In a database, data is stored in spreadsheets which have rows and columns. |
| A. | True |
| B. | False |
| Answer» C. | |
| 640. |
Which prefixes are available to Oracle triggers? |
| A. | :new only |
| B. | :old only |
| C. | Both :new and :old |
| D. | Neither :new nor :old |
| Answer» D. Neither :new nor :old | |
| 641. |
With an asynchronous system, the requesting system waits for a response in real time. |
| A. | True |
| B. | False |
| Answer» C. | |
| 642. |
Query-by-Example (QBE) is the most widely available direct-manipulation database query language. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 643. |
A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage. |
| A. | True |
| B. | False |
| Answer» C. | |
| 644. |
Client/server environments use a local area network (LAN) to support a network of personal computers, each with its own storage, that are also able to share common devices and software attached to the LAN. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 645. |
The database server is responsible for database storage, access, and processing. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 646. |
In a relation, the order of the rows matters. |
| A. | True |
| B. | False |
| Answer» C. | |
| 647. |
A functional dependency is always an equation. |
| A. | True |
| B. | False |
| Answer» C. | |
| 648. |
A relation has cells that hold multi-value entries. |
| A. | True |
| B. | False |
| Answer» C. | |
| 649. |
In a relation, the rows are sometimes called "fields." |
| A. | True |
| B. | False |
| Answer» C. | |
| 650. |
A candidate key is a determinant that determines all the other columns is a relation. |
| A. | True |
| B. | False |
| Answer» B. False | |