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.
| 301. |
The relational model consists of: |
| A. | data in the form of tables. |
| B. | data redundancy. |
| C. | operations using non-SQL languages. |
| D. | unorganized data. |
| Answer» B. data redundancy. | |
| 302. |
When mapping a regular entity into a relation which of the following is true? |
| A. | One relation is created. |
| B. | Two relations are created. |
| C. | Three relations are created. |
| D. | Four relations are created. |
| Answer» B. Two relations are created. | |
| 303. |
When mapping a multivalued attribute into a relation which of the following is true? |
| A. | One relation is created. |
| B. | Two relations are created. |
| C. | Three relations are created. |
| D. | Four relations are created. |
| Answer» C. Three relations are created. | |
| 304. |
If no multivalued attributes exist in a relation, then the relation is in what normal form? |
| A. | First normal form |
| B. | Second normal form |
| C. | Third normal form |
| D. | Fourth normal form |
| Answer» B. Second normal form | |
| 305. |
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 ; |
| A. | Equi-join |
| B. | Natural join |
| C. | Outer join |
| D. | Cartesian join |
| Answer» E. | |
| 306. |
Which of the following statements is true concerning subqueries? |
| A. | Involves the use of an inner and outer query. |
| B. | Cannot return the same result as a query that is not a subquery. |
| C. | Does not start with the word SELECT. |
| D. | All of the above. |
| Answer» B. Cannot return the same result as a query that is not a subquery. | |
| 307. |
Which of the following is a correlated subquery? |
| A. | Uses the result of an inner query to determine the processing of an outer query. |
| B. | Uses the result of an outer query to determine the processing of an inner query. |
| C. | Uses the result of an inner query to determine the processing of an inner query. |
| D. | Uses the result of an outer query to determine the processing of an outer query. |
| Answer» C. Uses the result of an inner query to determine the processing of an inner query. | |
| 308. |
Embedded SQL is which of the following? |
| A. | Hard-coded SQL statements in a program language such as Java. |
| B. | The process of making an application capable of generating specific SQL code on the fly. |
| C. | Hard-coded SQL statements in a procedure. |
| D. | Hard-coded SQL statements in a trigger. |
| Answer» B. The process of making an application capable of generating specific SQL code on the fly. | |
| 309. |
A UNION query is which of the following? |
| A. | Combines the output from no more than two queries and must include the same number of columns. |
| B. | Combines the output from no more than two queries and does not include the same number of columns. |
| C. | Combines the output from multiple queries and must include the same number of columns. |
| D. | Combines the output from multiple queries and does not include the same number of columns. |
| Answer» D. Combines the output from multiple queries and does not include the same number of columns. | |
| 310. |
Which of the following is one of the basic approaches for joining tables? |
| A. | Subqueries |
| B. | Union Join |
| C. | Natural join |
| D. | All of the above |
| Answer» E. | |
| 311. |
Which of the following is true concerning systems information in an RDBMS? |
| A. | RDBMS store database definition information in system-created tables. |
| B. | This information can be accessed using SQL. |
| C. | This information often cannot be updated by a user. |
| D. | All of the above. |
| Answer» E. | |
| 312. |
When mapping a binary many-to-many relationship into a relation which of the following is true? |
| A. | One relation is created. |
| B. | Two relations are created. |
| C. | Three relations are created. |
| D. | Four relations are created. |
| Answer» D. Four relations are created. | |
| 313. |
A primary key is which of the following? |
| A. | Any attribute |
| B. | An attribute that uniquely identifies each row |
| C. | An attribute that uniquely identifies each column |
| D. | A derived attribute |
| Answer» C. An attribute that uniquely identifies each column | |
| 314. |
Aggregation is which of the following? |
| A. | Expresses a part-of relationship and is a stronger form of an association relationship. |
| B. | Expresses a part-of relationship and is a weaker form of an association relationship. |
| C. | Expresses an is-a relationship and is a stronger form of an association relationship. |
| D. | Expresses an is-a relationship and is a weaker form of an association relationship. |
| Answer» B. Expresses a part-of relationship and is a weaker form of an association relationship. | |
| 315. |
When the minimum and maximum number of instances of an entity is one, you know which of the following? |
| A. | Mandatory one |
| B. | Optional one |
| C. | Mandatory many |
| D. | Cannot tell |
| Answer» B. Optional one | |
| 316. |
An attribute name should be which of the following? |
| A. | Singular verb or verb phrase |
| B. | Follow a standard format |
| C. | Use a alias |
| D. | All of the above. |
| Answer» C. Use a alias | |
| 317. |
The benefits of object-oriented modeling are which of the following? |
| A. | The ability to tackle more challenging problems |
| B. | Reusability of analysis, design, and programming results |
| C. | Improved communication between users, analysts, etc. |
| D. | All of the above. |
| Answer» E. | |
| 318. |
When the minimum number of instances of an entity is one, you know which of the following? |
| A. | Mandatory one |
| B. | Optional one |
| C. | Mandatory many |
| D. | Cannot tell |
| Answer» E. | |
| 319. |
Which of the following is a technique for hiding the internal implementation details of an object? |
| A. | Encapsulation |
| B. | Polymorphism |
| C. | Inheritance |
| D. | All of the above. |
| Answer» B. Polymorphism | |
| 320. |
A good business rule is which of the following? |
| A. | Declarative |
| B. | Imprecise |
| C. | Redundant |
| D. | Compound |
| Answer» B. Imprecise | |
| 321. |
An entity name should be which of the following? |
| A. | A singular noun |
| B. | Specific to the organization |
| C. | Concise |
| D. | All of the above. |
| Answer» E. | |
| 322. |
An oval represents which of the following in an ERD? |
| A. | Attribute |
| B. | Entity |
| C. | Optional One |
| D. | Relationship |
| Answer» B. Entity | |
| 323. |
A binary relationship is which of the following? |
| A. | A relationship between two attributes |
| B. | A relationship between two entities |
| C. | An attribute with two different relationships |
| D. | An entity with two different relationships |
| Answer» C. An attribute with two different relationships | |
| 324. |
A data warehouse uses: |
| A. | partial operational data. |
| B. | historical operational data. |
| C. | future operational data. |
| D. | health care data. |
| Answer» C. future operational data. | |
| 325. |
A traditional data administrator performs which of the following roles? |
| A. | Tune database performance |
| B. | Establish backup and recovery procedures |
| C. | Resolve data ownership issues |
| D. | Protect the security of the database. |
| Answer» D. Protect the security of the database. | |
| 326. |
If both data and database administration exist in an organization, the database administrator is responsible for which of the following? |
| A. | Data modeling |
| B. | Database design |
| C. | Metadata |
| D. | All of the above. |
| Answer» C. Metadata | |
| 327. |
An intrusion detection system does not perform which of the following? |
| A. | Tries to identify attempts to hack into a computer system. |
| B. | May monitor packets passing over the network. |
| C. | May transmit message packets to the correct destination. |
| D. | Set up deception systems that attempt to trap hackers. |
| Answer» D. Set up deception systems that attempt to trap hackers. | |
| 328. |
If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist? |
| A. | Derived attribute |
| B. | Optional one cardinality |
| C. | Multi-valued attribute |
| D. | Weak entity |
| Answer» E. | |
| 329. |
Which of the following is true concerning a procedure? |
| A. | You do not create them with SQL. |
| B. | They do not need to have a unique name. |
| C. | They include procedural and SQL statements. |
| D. | They are the same thing as a function. |
| Answer» D. They are the same thing as a function. | |
| 330. |
A CASE SQL statement is which of the following? |
| A. | A way to establish an IF-THEN-ELSE in SQL. |
| B. | A way to establish a loop in SQL. |
| C. | A way to establish a data definition in SQL. |
| D. | All of the above. |
| Answer» B. A way to establish a loop in SQL. | |
| 331. |
Which of the following statements is true concerning routines and triggers? |
| A. | Both consist of procedural code. |
| B. | Both have to be called to operate. |
| C. | Both run automatically. |
| D. | Both are stored in the database. |
| Answer» B. Both have to be called to operate. | |
| 332. |
An abstract class is which of the following? |
| A. | A class that has direct instances, but whose descendants may have direct instances. |
| B. | A class that has no direct instances, but whose descendants may have direct instances. |
| C. | A class that has direct instances, but whose descendants may not have direct instances. |
| D. | A class that has no direct instances, but whose descendants may not have direct instances |
| Answer» C. A class that has direct instances, but whose descendants may not have direct instances. | |
| 333. |
A foreign key is which of the following? |
| A. | Any attribute |
| B. | The same thing as a primary key |
| C. | An attribute that serves as the primary key of another relation |
| D. | An attribute that serves no purpose |
| Answer» D. An attribute that serves no purpose | |
| 334. |
A transitive dependency is which of the following? |
| A. | A functional dependency between two or more key attributes. |
| B. | A functional dependency between two or more nonkey attributes. |
| C. | A relation that is in first normal form. |
| D. | A relation that is in second normal form. |
| Answer» C. A relation that is in first normal form. | |
| 335. |
Backward recovery is which of the following? |
| A. | Where the before-images are applied to the database |
| B. | Where the after-images are applied to the database |
| C. | Where the after-images and before-images are applied to the database |
| D. | Switching to an existing copy of the database |
| Answer» B. Where the after-images are applied to the database | |
| 336. |
ODBC minimum SQL grammar contains which of the following? |
| A. | INSERT, UPDATE, DELETE only |
| B. | Stored Procedures only |
| C. | Literals for date, time and timestamp only |
| D. | CREATE VIEW, DROP VIEW only |
| Answer» B. Stored Procedures only | |
| 337. |
A relationship is which of the following? |
| A. | A person, place, or thing |
| B. | Property or characteristic of an entity |
| C. | Link between entities |
| D. | Weak entity |
| Answer» D. Weak entity | |
| 338. |
A good identifier is which of the following? |
| A. | One that can change over time |
| B. | Can be null |
| C. | One that is unique |
| D. | Be intelligent |
| Answer» D. Be intelligent | |
| 339. |
Of the three ways to create an Oracle database, which one is the easiest and most recommended? |
| A. | Using the Oracle Database Configuration Assistant. |
| B. | Using the Oracle-supplied database creation procedures. |
| C. | Using the SQL CREATE DATABASE command. |
| D. | None of the above is correct. |
| Answer» B. Using the Oracle-supplied database creation procedures. | |
| 340. |
What Oracle backup and recover file contains user and system data? |
| A. | Control file |
| B. | Datafile |
| C. | OnLine ReDo file |
| D. | Offline ReDo file |
| Answer» C. OnLine ReDo file | |
| 341. |
When using SQL*Plus, Oracle commands, column names, table names and all other database elements: |
| A. | are case insensitive. |
| B. | are case sensitive. |
| C. | must always be in lower case. |
| D. | must always be in upper case. |
| Answer» B. are case sensitive. | |
| 342. |
Which of the following is not true of SQL views? |
| A. | Oracle views cannot use the ORDER BY clause in view definitions. |
| B. | Oracle views are created using the standard SQL-92 CREATE VIEW command. |
| C. | Oracle views can by queried. |
| D. | The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. |
| Answer» B. Oracle views are created using the standard SQL-92 CREATE VIEW command. | |
| 343. |
SQL*Plus will finish the statement and execute it when the user types in this: |
| A. | A left slash ( ) followed by [Enter]. |
| B. | A colon ( : ) followed by [Enter]. |
| C. | A semicolon ( ; ) followed by [Enter]. |
| D. | A period ( . ) followed by [Enter]. |
| Answer» D. A period ( . ) followed by [Enter]. | |
| 344. |
In OLE DB, a service provider: |
| A. | does not own data only. |
| B. | transforms data through OLE DB interfaces only. |
| C. | is both a consumer and a provider of data only. |
| D. | All of the above are true of an OLE DB service provider. |
| Answer» E. | |
| 345. |
Which of the following is NOT an Oracle-supported trigger? |
| A. | BEFORE |
| B. | DURING |
| C. | AFTER |
| D. | INSTEAD OF |
| Answer» C. AFTER | |
| 346. |
In OLE DB, a tabular data provider: |
| A. | does not own data. |
| B. | transforms data through ODE DB interfaces. |
| C. | is both a consumer and a provider of data. |
| D. | exposes data via rowsets. |
| Answer» E. | |
| 347. |
The ODBC Level 1 API contains which of the following functions? |
| A. | Browse possible connections and data sources only |
| B. | Connect to data sources with driver-specific information only |
| C. | Process a scrollable cursor only |
| D. | Both 1 and 3 above are in the OBDC Level 1 API. |
| Answer» C. Process a scrollable cursor only | |
| 348. |
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers? |
| A. | Data source |
| B. | Driver |
| C. | Driver manager |
| D. | OLE DB |
| Answer» D. OLE DB | |
| 349. |
An Oracle System Change Number (SCN): |
| A. | is a value that is incremented whenever a dirty read occurs. |
| B. | is incremented whenever a deadlock occurs. |
| C. | is a value that keeps track of explicit locks. |
| D. | is a value that is incremented whenever database changes are made. |
| Answer» E. | |
| 350. |
Which SQL phrase is not supported by Oracle? |
| A. | ON DELETE CASCADE |
| B. | ON UPDATE CASCADE |
| C. | CREATE SEQUENCE [SequenceName] |
| D. | DROP SEQUENCE [SequenceName] |
| Answer» C. CREATE SEQUENCE [SequenceName] | |