MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What rows will this select statement return ? SELECT * FROM products WHERE ordernumber u003e = 1000? |
| A. | All rows in the products table whose order number is greater than 1000 |
| B. | The first 1000 rows of the product table |
| C. | All rows in the products table whose order number is less than or equal to 1000 |
| D. | All rows in the products table whose order number is greater than or equal to 1000 |
| Answer» E. | |
| 2. |
In b-tree the number of keys in each node is ____ than the number of its children. |
| A. | same |
| B. | half |
| C. | one less |
| D. | one more |
| Answer» D. one more | |
| 3. |
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect ? |
| A. | Operationally, if X is deleted, u0026 remains the same |
| B. | Operationally, if X is deleted, so is Y |
| C. | existence is dependent on Y |
| D. | Operationally, if Y is deleted, so is X |
| Answer» C. existence is dependent on Y | |
| 4. |
What are the desirable properties of a decomposition? |
| A. | Dependency preservation |
| B. | Security |
| C. | Partition constraint |
| D. | Redundancy |
| Answer» B. Security | |
| 5. |
The process by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is _________ |
| A. | Enforcing data integrity |
| B. | Enforcing referential integrity |
| C. | Indexing |
| D. | Normalization |
| Answer» E. | |
| 6. |
According to the levels of abstraction, the schema at the intermediate level is called _________ |
| A. | none of these |
| B. | Subschema |
| C. | Physical schema |
| D. | Logical schema |
| Answer» B. Subschema | |
| 7. |
The DBMS utility, _________ allows to reconstruct the correct state of database from the backup and history of transactions. |
| A. | Data loading |
| B. | Monitering |
| C. | Recovery |
| D. | Bakup |
| Answer» D. Bakup | |
| 8. |
The level of abstraction describes only part of the entire database called _________ |
| A. | Conceptual level |
| B. | View Level |
| C. | None of above |
| D. | Procedural Level |
| Answer» C. None of above | |
| 9. |
Which of the following statements is not true about two tier client server database architecture? |
| A. | SQL statements may be processed on some of the clients |
| B. | Business logic may be processed on the server |
| C. | SQL statements are processed on tier server |
| D. | Business logic is mostly processed on clients |
| Answer» E. | |
| 10. |
A report generator is used to ____________ |
| A. | print files on paper |
| B. | delete files |
| C. | update files |
| D. | data entry |
| Answer» B. delete files | |
| 11. |
Relational Algebra is ____________ |
| A. | None of the above |
| B. | Procedural query Language |
| C. | Meta Language |
| D. | Data Definition Language |
| Answer» C. Meta Language | |
| 12. |
In the _________ normal form, a composite attribute is converted to individual attributes. |
| A. | fourth |
| B. | third |
| C. | Second |
| D. | first |
| Answer» E. | |
| 13. |
The collection of information stored in a database at a particular moment is ? |
| A. | None of these |
| B. | Scheme |
| C. | Instance |
| D. | View |
| Answer» D. View | |
| 14. |
____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified |
| A. | none |
| B. | cursor |
| C. | Trigger |
| D. | Procedure |
| Answer» D. Procedure | |
| 15. |
As per equivalence rules for query transformation, selection operation distributes over |
| A. | Union |
| B. | Intersection |
| C. | All of the above |
| D. | Set difference |
| Answer» D. Set difference | |
| 16. |
Block-interleaved distributed parity is RAID level |
| A. | 3 |
| B. | 5 |
| C. | 2 |
| D. | 4 |
| Answer» C. 2 | |
| 17. |
A data dictionary is a special file that contains _________ |
| A. | All of the above. |
| B. | The data type of all fields in all files. |
| C. | The width of all fields in all files. |
| D. | The name of all fields in all files. |
| Answer» B. The data type of all fields in all files. | |
| 18. |
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R. |
| A. | It will immediately be rejected. |
| B. | It will be granted as soon as it is released by A . |
| C. | It will result in a deadlock situation. |
| D. | It will immediately be granted. |
| Answer» E. | |
| 19. |
What is data integrity? |
| A. | It is the data contained in database that is accurate and consistent |
| B. | It is the data contained in database that is shared |
| C. | It is the data contained in database that is non redundant |
| D. | It is the data contained in database that is secured |
| Answer» B. It is the data contained in database that is shared | |
| 20. |
Which of the following operations need the participating relations to be union compatible? |
| A. | All of the above |
| B. | DIFFERENCE |
| C. | INTERSECTION |
| D. | UNION |
| Answer» B. DIFFERENCE | |
| 21. |
The rule that a value of a foreign key must appear as a value of some specific table is called a ____________ |
| A. | Functional dependency |
| B. | Integrity constraint |
| C. | Index |
| D. | Referential constraint |
| Answer» E. | |
| 22. |
In the architecture of a database system external level is the ____________ |
| A. | view level |
| B. | conceptual level |
| C. | logical level |
| D. | physical level |
| Answer» B. conceptual level | |
| 23. |
A relational database developer refers to a record as ____________ |
| A. | an attribute |
| B. | a tuple |
| C. | a relation |
| D. | a criteria |
| Answer» C. a relation | |
| 24. |
In a relational schema, each tuple is divided into fields called ____________ |
| A. | ALL |
| B. | Query |
| C. | Domain |
| D. | Relation |
| Answer» D. Relation | |
| 25. |
A tool that can help designers understand the dependencies of database structures is a _________ |
| A. | data model. |
| B. | None of the above is correct. |
| C. | dependency graph. |
| D. | graphical display. |
| Answer» D. graphical display. | |
| 26. |
Manager salary details are hidden from the employee . This is |
| A. | External level data hiding. |
| B. | None of these. |
| C. | Conceptual level data hiding. |
| D. | Physical level data hiding. |
| Answer» D. Physical level data hiding. | |
| 27. |
The users who use easy-to-use menu are called ____________ |
| A. | Naïve users |
| B. | Casual end users |
| C. | Sophisticated end users |
| D. | Stand-alone users |
| Answer» B. Casual end users | |
| 28. |
A file manipulation command that extracts some of the records from a file is called ____________ |
| A. | PRODUCT |
| B. | JOIN |
| C. | PROJECT |
| D. | SELECT |
| Answer» E. | |
| 29. |
The drawback of shadow paging technique are |
| A. | All of these |
| B. | Garbage collection |
| C. | Data fragmentation |
| D. | Commit overhead |
| Answer» B. Garbage collection | |
| 30. |
The ability to modify the conceptual schema without causing any change to the application program is known as _________ |
| A. | Logical data independence |
| B. | Static data |
| C. | Physical data independence |
| D. | External data independence |
| Answer» B. Static data | |
| 31. |
Count function in SQL returns the number of ____________ |
| A. | distinct values. |
| B. | columns |
| C. | values |
| D. | groups |
| Answer» D. groups | |
| 32. |
The ________ states that a foreign key must either match a primary key value in another relation or it must be null. |
| A. | referential integrity constraint |
| B. | composite attribute |
| C. | entity integrity rule |
| D. | action assertion |
| Answer» D. action assertion | |
| 33. |
The number of attributes in relation is called as its ____________ |
| A. | Degree |
| B. | Row |
| C. | Cardinality |
| D. | Tuple |
| Answer» B. Row | |
| 34. |
The method in which records are physically stored in a specified order according to a key field in each record is _________ |
| A. | direct |
| B. | all of the above |
| C. | hash |
| D. | sequential |
| Answer» D. sequential | |
| 35. |
DROP is a ______________ statement in SQL |
| A. | DCL |
| B. | DDL |
| C. | Embedded SQL |
| D. | Query |
| Answer» C. Embedded SQL | |
| 36. |
The overall logical structure of data base can be expressed graphically by? |
| A. | Flow chart |
| B. | Entity relationship diagram |
| C. | Data flow chart |
| D. | Directed Graph |
| Answer» C. Data flow chart | |
| 37. |
____________ defines the structure of a relation which consists of a fixed set of attribute-domain pairs. |
| A. | none |
| B. | Instance |
| C. | Program |
| D. | Schema |
| Answer» E. | |
| 38. |
Related fields in a database are grouped to form ? |
| A. | Data Record |
| B. | Bank |
| C. | Data Field |
| D. | Menu |
| Answer» B. Bank | |
| 39. |
The fact that the same operation may apply to two or more classes is called _________ |
| A. | Multiple classification |
| B. | Encapsulation |
| C. | Polymorphism |
| D. | Inheritance |
| Answer» D. Inheritance | |
| 40. |
Which of the following is true for network structure? |
| A. | It will be the dominant database of the future. |
| B. | It is conceptually simple. |
| C. | It allows many to many relationship. |
| D. | It is a physical representation of the data. |
| Answer» E. | |
| 41. |
Checkpoints are a part of _________ |
| A. | Security measures |
| B. | Authorization measures |
| C. | Recovery measures |
| D. | Concurrency measures |
| Answer» D. Concurrency measures | |
| 42. |
DBMS is a collection of _________ that enables user to create and maintain a database. |
| A. | none |
| B. | Translator |
| C. | Program |
| D. | Key |
| Answer» D. Key | |
| 43. |
In RDBMS, Data is presented as a collection of _________ |
| A. | Table |
| B. | Entity |
| C. | Relation |
| D. | Attribute |
| Answer» D. Attribute | |
| 44. |
In the relational modes, cardinality is termed as _________ |
| A. | Number of attributes. |
| B. | Number of constraints. |
| C. | Number of tuples. |
| D. | Number of tables. |
| Answer» D. Number of tables. | |
| 45. |
The default level of consistency in SQL is _________ |
| A. | serializable |
| B. | read uncommitted |
| C. | read committed |
| D. | repeatable read |
| Answer» B. read uncommitted | |
| 46. |
Fifth Normal form is concerned with _________ |
| A. | Domain-key |
| B. | Join dependency |
| C. | Multivalued dependency |
| D. | Functional dependency |
| Answer» C. Multivalued dependency | |
| 47. |
_______ produces the relation that has attributes of R1 and R2 |
| A. | Product |
| B. | Intersection |
| C. | Difference |
| D. | Cartesian product |
| Answer» E. | |
| 48. |
In an object oriented model, one object can access data of another object by passing? |
| A. | Function |
| B. | Message |
| C. | Variable |
| D. | Instance variable |
| Answer» C. Variable | |
| 49. |
The tables generated on compilation of data definition language are stored in ____________ |
| A. | Meta data |
| B. | Data File |
| C. | Data dictionary |
| D. | Data abstraction |
| Answer» D. Data abstraction | |
| 50. |
_____________ was also known as 'Red Shirts' comprised non-violent revolutionaries who were also devoted social workers and played an active role in the nationalist movement. |
| A. | Simon commission |
| B. | Cripps Mission |
| C. | Socialists |
| D. | Khudai Khidmatgars |
| Answer» E. | |