Solved General Science Q&A

1.At what rate percent per annum of compound interest, annually, will a sum be 16 times of

400% 200% 125% 100%

2.A sum of money amounts to Rs 5200 in 5 years and to Rs 5680 in 7 years at simple interest. The rate of

3% 4% 5% 6%

3.The difference between simple and compound interest on a certain sum of money for 2 years

Rs 2500 Rs 2400 Rs 2600 Rs 2000

4.Find out the wrong number in the sequence. 

5, 7, 13, 25, 44, 75, 117

7 13 25 44

5.Which of the following pair is incorrect?

State                     Population Density

I. West Bengal               1102

II. Kerala                        859

III. Tamil Nadu              555

IV. Arunachal Pradesh  19

V. Mizoram                     50

I, II, IV 

I, III, V 

I, IV, V 

II, III, V

Dinosaur Quiz

1. How many horns did Triceratops have?

2. True or false? The name dinosaur means ‘terrible lizard’.

3. Which came first, the Jurassic or Cretaceous Period?

4. Was Diplodocus a carnivore or herbivore?

5. True of false? Tyrannosaurus rex was the biggest dinosaur ever.

6. True or false? Iguanodon was one of three dinosaurs that inspired the appearance of Godzilla.

7. Did Theropods such as Allosaurus and Carnotaurus move on two legs or four?

8. Apatosaurus is also widely known by what other name?

9. True or false? Most dinosaurs became extinct during an event that occurred 500 years ago.

10. What type of dinosaur features on the logo of the Toronto based NBA basketball team?

11. True or false? Dinosaur fossils have been found on every continent of Earth.

12. What dinosaur themed book was turned into a blockbuster movie in 1993?

13. True or false? Ankylosaurus featured hug plates of bone that acted as body armor.

14. Did Sauropods such as Brachiosaurus and Diplodocus move on two legs or four?

15. True or false? Pentaceratops was the first dinosaur to be officially named.

16. Which came first, the Jurassic or Triassic Period?

17. True or false? The US state of Colorado lists the Allosaurus as its state dinosaur.

18. What weighed more, a fully grown Spinosaurus or Deinonychus?

19. A person who studies fossils and prehistoric life such as dinosaurs is known as a what?

20. True or false? Birds evolved from dinosaurs.

general questions

1. Which of the following types of budgeting is followed in India?

(A) Plural budgeting
(B) Cash budgeting
(C) performance budgeting
(D) Surplus budgeting

Ans: (C)

2. Which of the following Articles of the Constitution of India is related to the independence of the Union Public Service Commission?

(A) Article 323
(B) Article 324
(C) Article 325
(D) Article 326

Ans: (A)

3. Which of the following Schedules to the Constitution of India relates to languages?

(A) 7th Schedule
(B) 8th Schedule
(C) 9th Schedule
(D) 10th Schedule

Ans: (B)

4. The French philosopher Rousseau belonged to the

(A) eighteenth century
(B) sixteenth century
(C) fifteenth century
(D) seventeenth century

Ans: (A)

Introduction to SQL

1.	You can add a row using SQL in a database with which of the following?
	A. ADD B. CREATE C. INSERT D. MAKE

2.	The command to remove rows from a table 'CUSTOMER' is:
	A. REMOVE FROM CUSTOMER ... B. DROP FROM CUSTOMER ... C. DELETE FROM CUSTOMER WHERE ... D. UPDATE FROM CUSTOMER ...

3.	The SQL WHERE clause:
	A. limits the column data that are returned. B. limits the row data are returned. C. Both A and B are correct. D. Neither A nor B are correct.

4.	Which of the following is the original purpose of SQL?
	A. To specify the syntax and semantics of SQL data definition language B. To specify the syntax and semantics of SQL manipulation language C. To define the data structures D. All of the above.

5.	The wildcard in a WHERE clause is useful when?
	A. An exact match is necessary in a SELECT statement. B. An exact match is not possible in a SELECT statement. C. An exact match is necessary in a CREATE statement. D. An exact match is not possible in a CREATE statement.

Object-Oriented Database

1.	ODL supports which of the following types of association relationships?
	A. Unary B. Unary and Binary C. Unary and Binary and Ternary D. Unary and Binary and Ternary and higher

2.	An extent is which of the following?
	A. A keyword that indicates that the subclass inherits from a superclass B. A keyword that indicates that the superclass inherits from a subclass C. The set of all instances of a class within a database D. Only one instance of a class within a database

3.	Identify the class name for the following code: ABC123 course();
	A. ABC123 B. course C. course() D. All of the above.

4.	Using ODL, you can define which of the following?
	A. Attribute B. Structure C. Operation D. All of the above.

5.	The keyword "inverse" is used in which of the following?
	A. Class B. Attribute C. Relationship D. All of the above.

Distributed Databases

1.	A distributed database has which of the following advantages over a centralized database?
	A. Software cost B. Software complexity C. Slow Response D. Modular growth

2.	An autonomous homogenous environment is which of the following?
	A. The same DBMS is at each node and each DBMS works independently. B. The same DBMS is at each node and a central DBMS coordinates database access. C. A different DBMS is at each node and each DBMS works independently. D. A different DBMS is at each node and a central DBMS coordinates database access.

3.	A transaction manager is which of the following?
	A. Maintains a log of transactions B. Maintains before and after database images C. Maintains appropriate concurrency control D. All of the above.

4.	Location transparency allows for which of the following?
	A. Users to treat the data as if it is at one location B. Programmers to treat the data as if it is at one location C. Managers to treat the data as if it is at one location D. All of the above.

5.	A heterogeneous distributed database is which of the following?
	A. The same DBMS is used at each location and data are not distributed across all nodes. B. The same DBMS is used at each location and data are distributed across all nodes. C. A different DBMS is used at each location and data are not distributed across all nodes. D. A different DBMS is used at each location and data are distributed across all nodes.

Data Warehousing

1.	Data scrubbing is which of the following?
	A. A process to reject data from the data warehouse and to create the necessary indexes B. A process to load the data in the data warehouse and to create the necessary indexes C. A process to upgrade the quality of data after it is moved into a data warehouse D. A process to upgrade the quality of data before it is moved into a data warehouse

2.	The @active data warehouse architecture includes which of the following?
	A. At least one data mart B. Data that can extracted from numerous internal and external sources C. Near real-time updates D. All of the above.

3.	A goal of data mining includes which of the following?
	A. To explain some observed event or condition B. To confirm that data exists C. To analyze data for expected relationships D. To create a new data warehouse

4.	An operational system is which of the following?
	A. A system that is used to run the business in real time and is based on historical data. B. A system that is used to run the business in real time and is based on current data. C. A system that is used to support decision making and is based on current data. D. A system that is used to support decision making and is based on historical data.

5.	A data warehouse is which of the following?
	A. Can be updated by end users. B. Contains numerous naming conventions and formats. C. Organized around important subject areas. D. Contains only current data.

The Client-Server Database

1.	Which of the following statements is true about symmetric multiprocessing?
	A. A single copy of the operating system resides in each processor. B. Useful for situations where data must remain in memory to process. C. Bottlenecks increase with uniprocessor systems because tasks are not shared. D. The problems of memory contention are unlikely.

2.	Which of the following items are not necessary for client/server?
	A. Assure that tools will connect with middleware. B. Understand the requirements. C. Determine network bandwidth capabilities. D. Include the use of a file server.

3.	A benefit of the three-tier architecture is which of the following?
	A. New modules can be built to support specific business needs B. Performance improves for compiled SQL statements C. Results in a thinner client and database server D. All of the above.

4.	Which of the following statements is true concerning JDBC?
	A. It is language independent. B. It is similar in concept to ODBC. C. It is useful for all object-oriented languages. D. It consists of three main layers.

5.	A characteristic of a file server is which of the following?
	A. Manages file operations and is shared on a network. B. Manages file operations and is limited to one PC. C. Acts as a fat client and is shared on a network. D. Acts as a fat client and is limited to one PC.

Physical Database Design

1.	If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
	A. All fields are stored in one relation. B. All fields are stored in two relations. C. All fields are stored in three relations. D. All fields are stored in four relations.

2.	Selecting a data type involves which of the following?
	A. Maximize storage space B. Represent most values C. Improve data integrity D. All of the above.

3.	What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
	A. VARCHAR2 B. CHAR C. LONG D. NUMBER

4.	If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
	A. All fields are stored in one relation. B. All fields are stored in two relations. C. All fields are stored in three relations. D. All fields are stored in four relations.

5.	Which of the following is an advantage of partitioning?
	A. Complexity B. Inconsistent access speed C. Extra space D. Security