MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 139 Mcqs, each offering curated multiple-choice questions to sharpen your Technical Programming knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
Which key accepts multiple NULL values? |
| A. | Foreign Key |
| B. | Unique Key |
| C. | Primary Key |
| D. | None of the Mentioned |
| Answer» B. Unique Key | |
| 52. |
A Key which is a set of one or more columns that can identify a record uniquely is called? |
| A. | Natural key |
| B. | Candidate key |
| C. | Not Null key |
| D. | Alternate key |
| Answer» C. Not Null key | |
| 53. |
By default, which key creates Clustered index? |
| A. | Foreign Key |
| B. | Unique Key |
| C. | Primary Key |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 54. |
What is true about Unique and primary key? |
| A. | Unique can have multiple NULL values but Primary can’t have. |
| B. | Unique can have single NULL value but Primary can’t have even single. |
| C. | Both can have duplicate values |
| D. | None of the Mentioned |
| Answer» C. Both can have duplicate values | |
| 55. |
Which of the following is not a Key in SQL Server? |
| A. | Primary |
| B. | Foreign |
| C. | Alternate |
| D. | Secondary |
| Answer» E. | |
| 56. |
A _______________ key is a minimal super key |
| A. | Primary |
| B. | Foreign |
| C. | Candidate |
| D. | Non-Prime |
| Answer» D. Non-Prime | |
| 57. |
How can a SQL developer add a key on a table? |
| A. | While creating a table |
| B. | With Alter table command |
| C. | With SQL server Properties window |
| D. | All of the Mentioned |
| Answer» E. | |
| 58. |
Which of the following is not a restriction for a table to be a relation? |
| A. | The cells of the table must contain a single value |
| B. | All of the entries in any column must be of the same kind |
| C. | The columns must be ordered |
| D. | No two rows in a table may be identical |
| Answer» D. No two rows in a table may be identical | |
| 59. |
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n): |
| A. | Transitive Dependency |
| B. | Insertion Anomaly |
| C. | Referential Integrity Constraint |
| D. | Normal Form |
| Answer» D. Normal Form | |
| 60. |
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that: |
| A. | A -> B |
| B. | A -> C |
| C. | A -> (B,C) |
| D. | (B,C) -> A |
| Answer» B. A -> C | |
| 61. |
Anomalies are avoided by splitting the offending relation into multiple relations, is also known as |
| A. | Accupressure |
| B. | Decomposition |
| C. | Precomposition |
| D. | Both Decomposition and Precomposition |
| Answer» C. Precomposition | |
| 62. |
In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key. |
| A. | Candidate |
| B. | Join |
| C. | Functional |
| D. | None of the Mentioned |
| Answer» B. Join | |
| 63. |
A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z. |
| A. | Multivalued Dependencies |
| B. | Join Dependency |
| C. | Trivial Functional Dependency |
| D. | Transitive Dependencies |
| Answer» E. | |
| 64. |
Every constraint on the table is a logical consequence of the table’s |
| A. | Fourth normal form |
| B. | Fifth normal form |
| C. | Domain/key normal form |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 65. |
A table is in 3NF if it is in 2NF and if it has no ____________ |
| A. | Functional Dependencies |
| B. | Transitive Dependencies |
| C. | Trivial Functional Dependency |
| D. | Multivalued Dependencies |
| Answer» C. Trivial Functional Dependency | |
| 66. |
The ___________ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos. |
| A. | Third |
| B. | Fourth |
| C. | Fifth |
| D. | Sixth |
| Answer» E. | |
| 67. |
A table is in BCNF if it is in 3NF and if every determinant is a ___________ key. |
| A. | Dependent |
| B. | Normal |
| C. | Candidate |
| D. | Both Normal and Candidate |
| Answer» D. Both Normal and Candidate | |
| 68. |
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. | |
| 69. |
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 Mentioned |
| Answer» B. Increased dependence on a single vendor | |
| 70. |
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. | |
| 71. |
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 Mentioned |
| Answer» D. None of the Mentioned | |
| 72. |
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 | |
| 73. |
A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes? |
| A. | Push |
| B. | Pull |
| C. | RFM |
| D. | OLAP |
| Answer» C. RFM | |
| 74. |
The “curse of dimensionality” relates to which problem of using operational data for BI reporting? |
| A. | Dirty data |
| B. | Inconsistent data |
| C. | Too much data |
| D. | Non-integrated data |
| Answer» D. Non-integrated data | |
| 75. |
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 | |
| 76. |
Which of the following is not one of the three ways to classify an action assertion? |
| A. | Condition |
| B. | Integrity Control |
| C. | Authorization |
| D. | Enabler |
| Answer» E. | |
| 77. |
Use of a supertype/subtype relationship is necessary when which of the following exists? |
| A. | An instance of a subtype participates in a relationship that is unique to that subtype |
| B. | An instance of a subtype participates in a relationship that is the same as the other subtypes |
| C. | Attributes apply to all of the instances of an entity type |
| D. | No attributes apply to any of the instances of an entity type |
| Answer» B. An instance of a subtype participates in a relationship that is the same as the other subtypes | |
| 78. |
A supertype/subtype hierarchy is which of the following? |
| A. | Each subtype has only one attribute |
| B. | Each supertype has only one attribute |
| C. | Each subtype has only one supertype |
| D. | Each supertype has only one subtype |
| Answer» D. Each supertype has only one subtype | |
| 79. |
When an entity instance must be a member of only one sub-type, it is which of the following? |
| A. | Disjoint with total specialization |
| B. | Disjoint with partial specialization |
| C. | Overlap with total specialization |
| D. | Overlap with partial specialization |
| Answer» B. Disjoint with partial specialization | |
| 80. |
If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called |
| A. | Consistent state |
| B. | Inconsistent state |
| C. | Durable state |
| D. | Atomic state |
| Answer» C. Durable state | |
| 81. |
The relationship between DEPARTMENT and EMPLOYEE is a |
| A. | One-to-one relationship |
| B. | One-to-many relationship |
| C. | Many-to-many relationship |
| D. | Many-to-one relationship |
| Answer» C. Many-to-many relationship | |
| 82. |
Which of the following is the process of selecting the data storage and data access characteristics of the database? |
| A. | Logical database design |
| B. | Physical database design |
| C. | Testing and performance tuning |
| D. | Evaluation and selecting |
| Answer» C. Testing and performance tuning | |
| 83. |
Which of the following is the oldest database model? |
| A. | Relational |
| B. | Deductive |
| C. | Physical |
| D. | Network |
| Answer» E. | |
| 84. |
A collection of data designed to be used by different people is called a/an |
| A. | Organization |
| B. | Database |
| C. | Relationship |
| D. | Schema |
| Answer» C. Relationship | |
| 85. |
In order to use a record management system |
| A. | you need to understand the low level details of how information is stored |
| B. | you need to understand the model the record management system uses |
| C. | you need to understand both information storage and the model of record management system |
| D. | None of the Mentioned |
| Answer» C. you need to understand both information storage and the model of record management system | |
| 86. |
Which of the following statements concerning business rules is true? |
| A. | It should be complex. |
| B. | It should not be convertible to computer code. |
| C. | It may include restrictions. |
| D. | All of the Mentioned |
| Answer» D. All of the Mentioned | |
| 87. |
Which of the following situation requires the use of ID-dependent entities ? |
| A. | Association relationships only |
| B. | Multivalued attributes only |
| C. | Instance relationships only |
| D. | All of the Mentioned |
| Answer» E. | |
| 88. |
Choose the RDBMS which supports full fledged client server application development |
| A. | dBase V |
| B. | Oracle 7.1 |
| C. | FoxPro 2.1 |
| D. | Ingress |
| Answer» C. FoxPro 2.1 | |
| 89. |
Which of the following is not true of the traditional approach to information processing |
| A. | There is common sharing of data among the various applications |
| B. | It is file oriented |
| C. | Programs are dependent on the file |
| D. | All of the Mentioned |
| Answer» B. It is file oriented | |
| 90. |
The management information system (MIS) structure with one main computer system is called a |
| A. | Hierarchical MIS structure |
| B. | Distributed MIS structure |
| C. | Centralized MIS structure |
| D. | Decentralized MIS structure |
| Answer» D. Decentralized MIS structure | |
| 91. |
Report generators are used to |
| A. | Store data input by a user |
| B. | Retrieve information from files |
| C. | Answer queries |
| D. | Retrieve information from files and Answer queries |
| Answer» E. | |
| 92. |
The language used application programs to request data from the DBMS is referred to as the |
| A. | DML |
| B. | DDL |
| C. | Query language |
| D. | All of the Mentioned |
| Answer» B. DDL | |
| 93. |
One approach to standardization storing of data ? |
| A. | MIS |
| B. | Structured programming |
| C. | CODASYL specification |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 94. |
Database management systems are intended to _____________ |
| A. | Eliminate data redundancy |
| B. | Establish relationship among records in different files |
| C. | Manage file access |
| D. | All of the Mentioned |
| Answer» E. | |
| 95. |
You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this. |
| A. | Set the TRACE_ENABLED parameter to TRUE |
| B. | Set the threshold for the Current Logons Count metric |
| C. | Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE |
| D. | Set the SESSIONS_PER_USER limit in the profiles used by users |
| Answer» C. Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE | |
| 96. |
A user receives the following error while executing a query: ORA-01555: snapshot too old Predict one way to avoid such errors in near future. |
| A. | Increase the size of redo log files |
| B. | Increase the size of the undo tablespace |
| C. | Increase the size of the Database Buffer Cache |
| D. | Increase the size of the default temporary tablespace |
| Answer» C. Increase the size of the Database Buffer Cache | |
| 97. |
Which operations can be performed using the Data Recovery Ad-visor? |
| A. | Diagnosing data failure |
| B. | It is a percentage of rows in which the statistics are collected incrementally for partitions |
| C. | Presenting appropriate repair options |
| D. | Generating reports for possible causes of failure |
| Answer» B. It is a percentage of rows in which the statistics are collected incrementally for partitions | |
| 98. |
Which statement is correct regarding undo management? |
| A. | The database can have more than one undo tablespaces |
| B. | The undo data must be purged manually when the transaction is over |
| C. | The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF |
| D. | Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL |
| Answer» B. The undo data must be purged manually when the transaction is over | |
| 99. |
You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem? |
| A. | Increase the size of the redo log files |
| B. | Decrease the number of redo log members |
| C. | Set LOG_CHECKPOINT_TO_ALERT to TRUE |
| D. | Decrease the value for the FAST_START_MTTR_TARGET initialization parameter |
| Answer» E. | |
| 100. |
What SYSTEM VARIABLE is used to refer DATABASE TIME ? |
| A. | $$dbtime$$ |
| B. | $$time$$ |
| C. | $$datetime$$ |
| D. | None of the Mentioned |
| Answer» B. $$time$$ | |