

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] | |