MCQOPTIONS
Saved Bookmarks
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. |
The Austroloids have features similar the aboriginals of__________ |
| A. | Australia |
| B. | Austria |
| C. | America |
| D. | Spain |
| Answer» B. Austria | |
| 2. |
The People's Charter, a document was written in 1838 by_________ |
| A. | Disraeli |
| B. | William Lovett |
| C. | Robert Peel |
| D. | Gladstone |
| Answer» C. Robert Peel | |
| 3. |
Who wrote 'The History of the Decline and fall of the Roman Empire'? |
| A. | Thomas Hobbes |
| B. | Francis Bacon |
| C. | Edward Gibbon |
| D. | Robert Owen |
| Answer» D. Robert Owen | |
| 4. |
Vico, the ________ philosopher historian and the author of the famous work,The New Sciencestried to establish history on a theoretical as well as on a critical basis. |
| A. | Italian |
| B. | French |
| C. | Russian |
| D. | German |
| Answer» B. French | |
| 5. |
Who called facts in social science as 'social facts?' |
| A. | Auguste Comte |
| B. | Emile Durkheim |
| C. | Max Weber |
| D. | Karl Marx |
| Answer» C. Max Weber | |
| 6. |
George Sorel was a ___________ philosopher and theorist of revolutionary Syndicalism. |
| A. | Dutch |
| B. | German |
| C. | Russian |
| D. | French |
| Answer» E. | |
| 7. |
Who was the author of 'the Farmer's Calendar'? |
| A. | Francis Bacon |
| B. | August Comte |
| C. | Arthur Young |
| D. | Descartes |
| Answer» D. Descartes | |
| 8. |
The enlightenment thinkers stressed the importance of ____________ and rationality as the ways of organising knowledge. |
| A. | Reason |
| B. | Deduction |
| C. | Idealism |
| D. | Romanticism |
| Answer» B. Deduction | |
| 9. |
Who was the English scholar whose writings were highly influenced the Glorious Revolution of 1688? |
| A. | Edmund Burke |
| B. | John Locke |
| C. | Thomas Hobbes |
| D. | David Hume |
| Answer» C. Thomas Hobbes | |
| 10. |
____________ attempted to revive Chartism in 1840 by founding the National Charter Association. |
| A. | Fergus O'Connor |
| B. | Machiavelli |
| C. | Thomas Hobbes |
| D. | Robert Owen |
| Answer» B. Machiavelli | |
| 11. |
Matrilineal societies are societies in which descent is traced through ________ rather than through fathers. |
| A. | Fathers |
| B. | Mothers |
| C. | Sons |
| D. | Sisters |
| Answer» C. Sons | |
| 12. |
George III belonged to the ________ dynasty. |
| A. | Stuart |
| B. | Bourbon |
| C. | Hapsburg |
| D. | Hanoverian |
| Answer» E. | |
| 13. |
In 1867, Marx produced _________, which linked economics to history. |
| A. | Utopia |
| B. | Das Capital |
| C. | the Annals of Agriculture |
| D. | Communist Manifesto |
| Answer» C. the Annals of Agriculture | |
| 14. |
The termsocial sciencefirst appeared in the 1824 book An Inquiry into the Principles of the Distribution of Wealth Most Conducive to Human Happiness; applied to the Newly Proposed System of Voluntary Equality of Wealth by ________ |
| A. | William Thompson |
| B. | Emile Durkheim |
| C. | E.H.Carr |
| D. | Carl Becker |
| Answer» B. Emile Durkheim | |
| 15. |
__________ Insisted that Women and young persons to work in factories only between the hours of 6 a.m. and 6 p.m. or 7 a.m. and 7 p.m. |
| A. | Factory Act of 1833 |
| B. | Factory Act of 1850 |
| C. | Factory Act of 1844 |
| D. | Factory Act of 1856 |
| Answer» C. Factory Act of 1844 | |
| 16. |
Who engaged in various experiments, and embodied the results of them in 'A Course of Experimental Agriculture' (1770)? |
| A. | John Locke |
| B. | August Comte |
| C. | Arthur Young |
| D. | Thomas Hobbes |
| Answer» D. Thomas Hobbes | |
| 17. |
Which are the two ways in which entities can participate in a relationship ? |
| A. | All of the above |
| B. | Simple and Complex |
| C. | Total and partial |
| D. | Passive and active |
| Answer» D. Passive and active | |
| 18. |
Who opined that the aim of history is 'to show what actually happened?' |
| A. | Comte |
| B. | Ranke |
| C. | Durkheim |
| D. | Niebuhr |
| Answer» C. Durkheim | |
| 19. |
James I came to power in England in ___________ |
| A. | 1503 |
| B. | 1601 |
| C. | 1603 |
| D. | 1703 |
| Answer» D. 1703 | |
| 20. |
The darkest hour is just before the dawn; a saying which truly signifies the Indian festival called ________ |
| A. | Holi |
| B. | Ganesh Chaturthi |
| C. | Navaratri |
| D. | Onam |
| Answer» B. Ganesh Chaturthi | |
| 21. |
The EXISTS keyword will be true if _________ |
| A. | neither of these two conditions is met. |
| B. | both of these two conditions are met. |
| C. | all rows in the subquery fail the condition only. |
| D. | any row in the subquery meets the condition only. |
| Answer» E. | |
| 22. |
Object based data models are used in describing the abstraction of the following levels? |
| A. | Only physical |
| B. | Only conceptual |
| C. | Conceptual and view |
| D. | Physical and conceptual |
| Answer» D. Physical and conceptual | |
| 23. |
Which of the following operation is used if we are interested in only certain columns of a table? |
| A. | SELECTION |
| B. | JOIN |
| C. | PROJECTION |
| D. | UNION |
| Answer» D. UNION | |
| 24. |
Which of the following is not a consequence of concurrent operations? |
| A. | Dirty read |
| B. | Unrepeatable read. |
| C. | Update anomaly. |
| D. | Lost update problem. |
| Answer» D. Lost update problem. | |
| 25. |
Which of the following statement on the view concept in SQL is invalid? |
| A. | The definition of a view should not have GROUP BY clause in it |
| B. | The views are instantiated at the time they are referenced and not when they are defined |
| C. | The views may be referenced in an SQL statement whenever tables are referenced |
| D. | All views are not updateable |
| Answer» B. The views are instantiated at the time they are referenced and not when they are defined | |
| 26. |
The concept of data independence is similar to the concept of ? |
| A. | Isolation |
| B. | Consolidation |
| C. | Abstract data type |
| D. | Data Type |
| Answer» D. Data Type | |
| 27. |
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in |
| A. | inner join |
| B. | full outer join |
| C. | right outer join |
| D. | left outer join |
| Answer» B. full outer join | |
| 28. |
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are ____________ |
| A. | distinct values |
| B. | cannot have NULL |
| C. | same as primary key |
| D. | both (A) u0026 (B) |
| Answer» E. | |
| 29. |
Immediate database modification technique uses _________ |
| A. | Both undo and redo |
| B. | Undo but no redo |
| C. | Neither undo nor redo |
| D. | Redo but no undo |
| Answer» B. Undo but no redo | |
| 30. |
A field or a combination of fields that has a unique value is called _________ |
| A. | Secondary key |
| B. | Alternate key |
| C. | Foreign key |
| D. | Primary key |
| Answer» E. | |
| 31. |
The result of the UNION operation between R1 and R2 is a relation that includes |
| A. | all the tuples of R1 and R2 which have common columns |
| B. | all the tuples of R1 and R2 |
| C. | all the tuples of R2 |
| D. | all the tuples of R1 |
| Answer» B. all the tuples of R1 and R2 | |
| 32. |
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree |
| A. | m + 1 |
| B. | m |
| C. | m -1 |
| D. | m * m |
| Answer» C. m -1 | |
| 33. |
Cartesian product in relational algebra is ____________ |
| A. | not defined |
| B. | a Ternary operator |
| C. | a Binary operator |
| D. | a Unary operator |
| Answer» D. a Unary operator | |
| 34. |
The level of data abstraction which describes how the data is actually stored is? |
| A. | Physical level |
| B. | Conceptual level |
| C. | File level |
| D. | Storage Level |
| Answer» B. Conceptual level | |
| 35. |
The way a particular application views the data from the database that the application uses is a _________ |
| A. | sub schema |
| B. | schema |
| C. | relational model |
| D. | module |
| Answer» B. schema | |
| 36. |
A relation is in ____________ if an attribute of a composite key is dependent on anattribute of other composite key. |
| A. | 1NF |
| B. | BCNF |
| C. | 3NF |
| D. | 2NF |
| Answer» D. 2NF | |
| 37. |
Precedence graphs help to find a |
| A. | Recoverable schedule |
| B. | Cascadeless schedule |
| C. | Serializable schedule |
| D. | Deadlock free schedule |
| Answer» D. Deadlock free schedule | |
| 38. |
If a transaction T has obtained an exclusive lock on item Q, then T can |
| A. | write Q |
| B. | write Q but not read Q |
| C. | read Q |
| D. | both read and write Q |
| Answer» E. | |
| 39. |
Three SQL, DDL, CREATE commands are ________ . |
| A. | Schema, Base and Table |
| B. | Key, Base and Table |
| C. | Schema, Table and View |
| D. | Base, Table and Schema |
| Answer» D. Base, Table and Schema | |
| 40. |
Which of the following will NOT eliminates the ambiguities of a null value? |
| A. | Define subtypes |
| B. | Define supertypes |
| C. | Define the attribute as required |
| D. | Define each attribute as having an initial value that is recognized as blank |
| Answer» C. Define the attribute as required | |
| 41. |
_________ requires that data should be made available to only authorised users. |
| A. | Data integrity |
| B. | none |
| C. | Security |
| D. | Privacy |
| Answer» D. Privacy | |
| 42. |
Which of the following aggregate functions does not ignore nulls in its results?. |
| A. | COUNT (*) |
| B. | MIN |
| C. | COUNT |
| D. | MAX |
| Answer» B. MIN | |
| 43. |
The raw facts and figures are _________ |
| A. | DBASE |
| B. | DBMS |
| C. | Data field |
| D. | Data |
| Answer» E. | |
| 44. |
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is ____________ |
| A. | Procedural DDL |
| B. | Non-Procedural DML |
| C. | Procedural DML |
| D. | Cartesian Product |
| Answer» D. Cartesian Product | |
| 45. |
The metadata is created by the _________ |
| A. | Query interpreter |
| B. | DDL interpreter |
| C. | DML pre-processor |
| D. | DML compiler |
| Answer» C. DML pre-processor | |
| 46. |
In SQL the word ‘natural’ can be used with |
| A. | full outer join |
| B. | all of the above |
| C. | inner join |
| D. | right outer join |
| Answer» D. right outer join | |
| 47. |
Tree structures are used to store data in _________ |
| A. | File based system |
| B. | Hierarchical model |
| C. | Relational model |
| D. | Network model |
| Answer» C. Relational model | |
| 48. |
The normal form that is not necessarily dependency preserving is _________ |
| A. | 4NF |
| B. | BCNF |
| C. | 3NF |
| D. | 2NF |
| Answer» E. | |
| 49. |
Database redesign is not terribly difficult if the ____________ |
| A. | database is relatively small |
| B. | database has no data |
| C. | database is well-designed |
| D. | database is structured |
| Answer» C. database is well-designed | |
| 50. |
The language used in application programs to request data from the DBMS is referred to as the ____________ |
| A. | DDL |
| B. | SDL |
| C. | DML |
| D. | VDL |
| Answer» D. VDL | |