Friday 30 September 2011
Oracle Interview Questions Part 2
What is use of a cursor variable? How it is defined.
A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type(like a pointer in C). Declaring a cursor variable: TYPE type_name IS REF CURSOR RETURN return_type type_name is the name of the reference type,return_type is a record type indicating the types of the select list that will eventually be returned by the cursor variable.
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE
How you open and close a cursor variable.Why it is required?
OPEN cursor variable FOR SELECT…Statement CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used.In order to free the resources used for the query CLOSE statement is used.
How you were passing cursor variables in PL/SQL 2.2?
In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2,the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter. Can cursor variables be stored in PL/SQL tables.If yes how.If not why. No, a cursor variable points a row which cannot be stored in a two-dimensional PL/SQL table.
Difference between procedure and function.
Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.
What are different modes of parameters used in functions and procedures.
IN OUT INOUT
What is difference between a formal and an actual parameter?
The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are passed to a procedure and receive results. Formal parameters are the placeholders for the values of actual parameters
Can the default values be assigned to actual parameters?
Yes
Can a function take OUT parameters.If not why.
No.A function has to return a value,an OUT parameter cannot return a value.
What is syntax for dropping a procedure and a function .Are these operations possible?
Drop Procedure procedure_name Drop Function function_name
What are ORACLE PRECOMPILERS?
Using ORACLE PRECOMPILERS ,SQL statements and PL/SQL blocks can be contained inside 3GL programs written in C,C++,COBOL,PASCAL, FORTRAN,PL/1 AND ADA. The Precompilers are known as Pro*C,Pro*Cobol,… This form of PL/SQL is known as embedded pl/sql,the language in which pl/sql is embedded is known as the host language. The prcompiler translates the embedded SQL and pl/sql ststements into calls to the precompiler runtime library.The output must be compiled and linked with this library to creater an executable.
What is OCI. What are its uses?
Oracle Call Interface is a method of accesing database from a 3GL program. Uses–No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides -functions to parse SQL statements -bind input variables -bind output variables -execute statements -fetch the results
Difference between database triggers and form triggers?
a) Data base trigger(DBT) fires when a DML operation is performed on a data base table.Form trigger(FT) Fires when user presses a key or navigates between fields on the screen b) Can be row level or statement level No distinction between row level and statement level. c) Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms. d) Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger. e) Can cause other database triggers to fire.Can cause other database triggers to fire,but not other form triggers.
A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type(like a pointer in C). Declaring a cursor variable: TYPE type_name IS REF CURSOR RETURN return_type type_name is the name of the reference type,return_type is a record type indicating the types of the select list that will eventually be returned by the cursor variable.
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE
How you open and close a cursor variable.Why it is required?
OPEN cursor variable FOR SELECT…Statement CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used.In order to free the resources used for the query CLOSE statement is used.
How you were passing cursor variables in PL/SQL 2.2?
In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2,the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter. Can cursor variables be stored in PL/SQL tables.If yes how.If not why. No, a cursor variable points a row which cannot be stored in a two-dimensional PL/SQL table.
Difference between procedure and function.
Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.
What are different modes of parameters used in functions and procedures.
IN OUT INOUT
What is difference between a formal and an actual parameter?
The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are passed to a procedure and receive results. Formal parameters are the placeholders for the values of actual parameters
Can the default values be assigned to actual parameters?
Yes
Can a function take OUT parameters.If not why.
No.A function has to return a value,an OUT parameter cannot return a value.
What is syntax for dropping a procedure and a function .Are these operations possible?
Drop Procedure procedure_name Drop Function function_name
What are ORACLE PRECOMPILERS?
Using ORACLE PRECOMPILERS ,SQL statements and PL/SQL blocks can be contained inside 3GL programs written in C,C++,COBOL,PASCAL, FORTRAN,PL/1 AND ADA. The Precompilers are known as Pro*C,Pro*Cobol,… This form of PL/SQL is known as embedded pl/sql,the language in which pl/sql is embedded is known as the host language. The prcompiler translates the embedded SQL and pl/sql ststements into calls to the precompiler runtime library.The output must be compiled and linked with this library to creater an executable.
What is OCI. What are its uses?
Oracle Call Interface is a method of accesing database from a 3GL program. Uses–No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides -functions to parse SQL statements -bind input variables -bind output variables -execute statements -fetch the results
Difference between database triggers and form triggers?
a) Data base trigger(DBT) fires when a DML operation is performed on a data base table.Form trigger(FT) Fires when user presses a key or navigates between fields on the screen b) Can be row level or statement level No distinction between row level and statement level. c) Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms. d) Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger. e) Can cause other database triggers to fire.Can cause other database triggers to fire,but not other form triggers.
Oracle Interview Questions Part 1
1. How would you determine the time zone under which a database was operating?
2. Explain the use of setting GLOBAL_NAMES equal to TRUE?
3. What command would you use to encrypt a PL/SQL application?
4. Explain the difference between a FUNCTION, PROCEDURE and PACKAGE?
5. Explain the use of table functions?
6. Name three advisory statistics you can collect?
7. Where in the Oracle directory tree structure are audit traces placed?
8. Explain materialized views and how they are used?
9. When a user process fails, what background process cleans up after it?
10. What background process refreshes materialized views?
11. How would you determine what sessions are connected and what resources they are waiting for?
12. Describe what redo logs are?
13. How would you force a log switch?
14. Give two methods you could use to determine what DDL changes have been made?
15. What does coalescing a tablespace do?
16. What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
17. Name a tablespace automatically created when you create a database?
18. When creating a user, what permissions must you grant to allow them to connect to the database?
19. How do you add a data file to a tablespace?
20. How do you resize a data file?
21. What view would you use to look at the size of a data file?
22. What view would you use to determine free space in a tablespace?
23. How would you determine who has added a row to a table?
24. How can you rebuild an index?
25. Explain what partitioning is and what its benefit is?
26. You have just compiled a PL/SQL package but got errors, how would you view the errors?
27. How can you gather statistics on a table?
28. How can you enable a trace for a session?
29. What is the difference between the SQL*Loader and IMPORT utilities?
30. Name two files used for network connection to a database?
.Net Interview Questions Part 6
1. What is “Common Type System” (CTS)?
CTS defines all of the basic types that can be used in the .NET Framework and the operations performed on those type. All this time we have been talking about language interoperability, and .NET Class Framework. None of this is possible without all the language sharing the same data types. What this means is that an int should mean the same in VB, VC++, C# and all other .NET compliant languages. This is achieved through introduction of Common Type System (CTS).
2.What is “Common Language Specification” (CLS)?
CLS is the collection of the rules and constraints that every language (that seeks to achieve .NET compatibility) must follow. It is a subsection of CTS and it specifies how it shares and extends one another libraries.
3. What is “Common Language Runtime” (CLR)?
CLR is .NET equivalent of Java Virtual Machine (JVM). It is the runtime that converts a MSIL code into the host machine language code, which is then executed appropriately. The CLR is the execution engine for .NET Framework applications. It provides a number of services, including:
- Code management (loading and execution)
- Application memory isolation
- Verification of type safety
- Conversion of IL to native code.
- Access to metadata (enhanced type information)
- Managing memory for managed objects
- Enforcement of code access security
- Exception handling, including cross-language exceptions
- Interoperation between managed code, COM objects, and pre-existing DLL’s (unmanaged code and data)
- Automation of object layout
- Support for developer services (profiling, debugging, and so on).
4. Using COM Component in .Net
As most of you know that .Net does not encourage the development of COM components and provides a different solution to making reusable components through Assemblies. But, there are a lot of COM components present which our .Net application might need to use. Fortunately, .Net provides an extremely simple approach to achieve this. This is achieved by using ‘Wrapper Classes’ and ‘Proxy Components’. .Net wraps the COM component into .Net assembly technically called ‘Runtime Callable Wrapper’ or RCW. Then u can call and use your COM component just as a .Net (or C#, if u are using C#) Assembly.
5. What is a Web Service?
A web service is a software component that exposes itself through the open communication channels of the Internet. Applications running on remote machines, on potentially different platforms, can access these components in a language and platform-independent manner. A Web Service is a group of functions, packaged together for use in a common framework throughout a network.
6. What is a formatter?
A formatter is an object that is responsible for encoding and serializing data into messages on one end, and deserializing and decoding messages into data on the other end.
7. What are channels in .NET Remoting?
Channels represent the objects that transfer the other serialized objects from one application domain to another and from one computer to another, as well as one process to another on the same box. A channel must exist before an object can be transferred.
8.What’s a Windows process?
It’s an application that’s running and had been allocated memory.
9. What’s SingleCall activation mode used for?
If the server object is instantiated for responding to just one single request, the request should be made in SingleCall mode.
10. How do you trigger the Paint event in System.Drawing?
Invalidate the current form, the OS will take care of repainting. The Update method forces the repaint.
11.What is the base class of .NET?
Base class provides a base set of methods that all derived classes can use
12. What is “Microsoft Intermediate Language” (MSIL)?
A .NET programming language (C#, VB.NET, J# etc.) does not compile into executable code; instead it compiles into an intermediate code called Microsoft Intermediate Language (MSIL). As a programmer one need not worry about the syntax of MSIL – since our source code in automatically converted to MSIL. The MSIL code is then send to the CLR (Common Language Runtime) that converts the code to machine language, which is, then run on the host machine. MSIL is similar to Java Byte code. MSIL is the CPU-independent instruction set into which .NET Framework programs are compiled. It contains instructions for loading, storing, initializing, and calling methods on objects. Combined with metadata and the common type system, MSIL allows for true cross- language integration Prior to execution, MSIL is converted to machine code. It is not interpreted.
13. How is meant by DLL ?
A DLL (Dynamic Link Library) is a file that can be loaded and executed by programs dynamically. Basically it’s an external code repository for programs. Since usually several different programs reuse the same DLL instead of having that code in their own file, this dramatically reduces required storage space. A synonym for a DLL would be library.
14. What is the base class of Button control?
Listing from visual studio .net > Button Class
System.Object
System.MarshalByRefObject
System.ComponentModel.Component
System.Windows.Forms.Control
System.Windows.Forms.ButtonBase
System.Windows.Forms.Button
CTS defines all of the basic types that can be used in the .NET Framework and the operations performed on those type. All this time we have been talking about language interoperability, and .NET Class Framework. None of this is possible without all the language sharing the same data types. What this means is that an int should mean the same in VB, VC++, C# and all other .NET compliant languages. This is achieved through introduction of Common Type System (CTS).
2.What is “Common Language Specification” (CLS)?
CLS is the collection of the rules and constraints that every language (that seeks to achieve .NET compatibility) must follow. It is a subsection of CTS and it specifies how it shares and extends one another libraries.
3. What is “Common Language Runtime” (CLR)?
CLR is .NET equivalent of Java Virtual Machine (JVM). It is the runtime that converts a MSIL code into the host machine language code, which is then executed appropriately. The CLR is the execution engine for .NET Framework applications. It provides a number of services, including:
- Code management (loading and execution)
- Application memory isolation
- Verification of type safety
- Conversion of IL to native code.
- Access to metadata (enhanced type information)
- Managing memory for managed objects
- Enforcement of code access security
- Exception handling, including cross-language exceptions
- Interoperation between managed code, COM objects, and pre-existing DLL’s (unmanaged code and data)
- Automation of object layout
- Support for developer services (profiling, debugging, and so on).
4. Using COM Component in .Net
As most of you know that .Net does not encourage the development of COM components and provides a different solution to making reusable components through Assemblies. But, there are a lot of COM components present which our .Net application might need to use. Fortunately, .Net provides an extremely simple approach to achieve this. This is achieved by using ‘Wrapper Classes’ and ‘Proxy Components’. .Net wraps the COM component into .Net assembly technically called ‘Runtime Callable Wrapper’ or RCW. Then u can call and use your COM component just as a .Net (or C#, if u are using C#) Assembly.
5. What is a Web Service?
A web service is a software component that exposes itself through the open communication channels of the Internet. Applications running on remote machines, on potentially different platforms, can access these components in a language and platform-independent manner. A Web Service is a group of functions, packaged together for use in a common framework throughout a network.
6. What is a formatter?
A formatter is an object that is responsible for encoding and serializing data into messages on one end, and deserializing and decoding messages into data on the other end.
7. What are channels in .NET Remoting?
Channels represent the objects that transfer the other serialized objects from one application domain to another and from one computer to another, as well as one process to another on the same box. A channel must exist before an object can be transferred.
8.What’s a Windows process?
It’s an application that’s running and had been allocated memory.
9. What’s SingleCall activation mode used for?
If the server object is instantiated for responding to just one single request, the request should be made in SingleCall mode.
10. How do you trigger the Paint event in System.Drawing?
Invalidate the current form, the OS will take care of repainting. The Update method forces the repaint.
11.What is the base class of .NET?
Base class provides a base set of methods that all derived classes can use
12. What is “Microsoft Intermediate Language” (MSIL)?
A .NET programming language (C#, VB.NET, J# etc.) does not compile into executable code; instead it compiles into an intermediate code called Microsoft Intermediate Language (MSIL). As a programmer one need not worry about the syntax of MSIL – since our source code in automatically converted to MSIL. The MSIL code is then send to the CLR (Common Language Runtime) that converts the code to machine language, which is, then run on the host machine. MSIL is similar to Java Byte code. MSIL is the CPU-independent instruction set into which .NET Framework programs are compiled. It contains instructions for loading, storing, initializing, and calling methods on objects. Combined with metadata and the common type system, MSIL allows for true cross- language integration Prior to execution, MSIL is converted to machine code. It is not interpreted.
13. How is meant by DLL ?
A DLL (Dynamic Link Library) is a file that can be loaded and executed by programs dynamically. Basically it’s an external code repository for programs. Since usually several different programs reuse the same DLL instead of having that code in their own file, this dramatically reduces required storage space. A synonym for a DLL would be library.
14. What is the base class of Button control?
Listing from visual studio .net > Button Class
System.Object
System.MarshalByRefObject
System.ComponentModel.Component
System.Windows.Forms.Control
System.Windows.Forms.ButtonBase
System.Windows.Forms.Button
.Net Interview Questions Part 5
1. What is .NET?
.NET is essentially a framework for software development.It is similar in nature to any other software development framework (J2EE etc) in that it provides a set of runtime containers/capabilities, and a rich set of pre-built functionality in the form of class libraries and APIs The .NET Framework is an environment for building, deploying, and running Web Services and other applications. It consists of three main parts: the Common Language Runtime, the Framework classes, and ASP.NET.
2. How many languages .NET is supporting now?
When .NET was introduced it came with several languages. VB.NET, C#, COBOL and Perl, etc. The site DotNetLanguages.Net says 44 languages are supported.
3. How is .NET able to support multiple languages?
A language should comply with the Common Language Runtime standard to become a .NET language. In .NET, code is compiled to Microsoft Intermediate Language (MSIL for short). This is called as Managed Code. This Managed code is run in .NET environment. So after compilation to this IL the language is not a barrier. A code can call or use a function written in another language.
4. How ASP .NET different from ASP?
Scripting is separated from the HTML, Code is compiled as a DLL, these DLLs can be executed on the server.
5. What is smart navigation?
The cursor position is maintained when the page gets refreshed due to the server side validation and the page gets refreshed.
6. What is view state?
The web is stateless. But in ASP.NET, the state of a page is maintained in the in the page itself automatically. How? The values are encrypted and saved in hidden controls. this is done automatically by the ASP.NET. This can be switched off / on for a single control
7. How do you validate the controls in an ASP .NET page?
Using special validation controls that are meant for this. We have Range Validator, Email Validator.
8. Can the validation be done in the server side? Or this can be done only in the Client side?
Client side is done by default. Server side validation is also possible. We can switch off the client side and server side can be done.
9. How to manage pagination in a page?
Using pagination option in DataGrid control. We have to set the number of records for a page, then it takes care of pagination by itself.
10. What is ADO .NET and what is difference between ADO and ADO.NET?
ADO.NET is stateless mechanism. I can treat the ADO.Net as a separate in-memory database where in I can use relationships between the tables and select insert and updates to the database. I can update the actual database as a batch.
11. What is Web.config?
In classic ASP all Web site related information was stored in the metadata of IIS. This had the disadvantage that remote Web developers couldn’t easily make Web-site configuration changes. For example, if you want to add a custom 404 error page, a setting needs to be made through the IIS admin tool, and you’re Web host will likely charge you a flat fee to do this for you. With ASP.NET, however, these settings are moved into an XML-formatted text file (Web.config) that resides in the Web site’s root directory. Through Web.config you can specify settings like custom 404 error pages, authentication and authorization settings for the Web sitempilation options for the ASP.NET Web pages, if tracing should be enabled, etc. The Web.config file is an XML-formatted file. At the root level is the tag. Inside this tag you can add a number of other tags, the most common and useful one being the system.web tag, where you will specify most of the Web site configuration parameters. However, to specify application-wide settings you use the tag. For example, if we wanted to add a database connection string parameter we could have a Web.config file like so.
12. Creating a Key Pair?
You can create a key pair using the Strong Name tool (Sn.exe). Key pair files usually have an .snk extension. To create a key pair At the command prompt, type the following command:
“sn k” In this command, file name is the name of the output file containing the key pair. The following example creates a key pair called sgKey.snk. sn -k sgKey.snk
13. What are the Types of Assemblies?
Assemblies are of two types:
1. Private Assemblies
2. Shared Assemblies
14.What is Private Assemblies ?
This assembly is intended only for one application. The files of that assembly must be placed in the same folder as the application or in a sub folder. No other application will be able to make a call to this assembly. The advantage of having a private assembly is that, it makes naming the assembly very easy, since the developer need not worry about name clashes with other assemblies. As long as the assembly has a unique name within the concerned application, there won’t be any problems.If the assembly is to be made into a Shared Assembly, then the naming conventions are very strict since it has to be unique across the entire system. The naming conventions should also take care of newer versions of the component being shipped. These are accomplished by giving the assembly a Shared Name. Then the assembly is placed in the global assembly cache, which is a folder in the file system reserved for shared assemblies.
.NET is essentially a framework for software development.It is similar in nature to any other software development framework (J2EE etc) in that it provides a set of runtime containers/capabilities, and a rich set of pre-built functionality in the form of class libraries and APIs The .NET Framework is an environment for building, deploying, and running Web Services and other applications. It consists of three main parts: the Common Language Runtime, the Framework classes, and ASP.NET.
2. How many languages .NET is supporting now?
When .NET was introduced it came with several languages. VB.NET, C#, COBOL and Perl, etc. The site DotNetLanguages.Net says 44 languages are supported.
3. How is .NET able to support multiple languages?
A language should comply with the Common Language Runtime standard to become a .NET language. In .NET, code is compiled to Microsoft Intermediate Language (MSIL for short). This is called as Managed Code. This Managed code is run in .NET environment. So after compilation to this IL the language is not a barrier. A code can call or use a function written in another language.
4. How ASP .NET different from ASP?
Scripting is separated from the HTML, Code is compiled as a DLL, these DLLs can be executed on the server.
5. What is smart navigation?
The cursor position is maintained when the page gets refreshed due to the server side validation and the page gets refreshed.
6. What is view state?
The web is stateless. But in ASP.NET, the state of a page is maintained in the in the page itself automatically. How? The values are encrypted and saved in hidden controls. this is done automatically by the ASP.NET. This can be switched off / on for a single control
7. How do you validate the controls in an ASP .NET page?
Using special validation controls that are meant for this. We have Range Validator, Email Validator.
8. Can the validation be done in the server side? Or this can be done only in the Client side?
Client side is done by default. Server side validation is also possible. We can switch off the client side and server side can be done.
9. How to manage pagination in a page?
Using pagination option in DataGrid control. We have to set the number of records for a page, then it takes care of pagination by itself.
10. What is ADO .NET and what is difference between ADO and ADO.NET?
ADO.NET is stateless mechanism. I can treat the ADO.Net as a separate in-memory database where in I can use relationships between the tables and select insert and updates to the database. I can update the actual database as a batch.
11. What is Web.config?
In classic ASP all Web site related information was stored in the metadata of IIS. This had the disadvantage that remote Web developers couldn’t easily make Web-site configuration changes. For example, if you want to add a custom 404 error page, a setting needs to be made through the IIS admin tool, and you’re Web host will likely charge you a flat fee to do this for you. With ASP.NET, however, these settings are moved into an XML-formatted text file (Web.config) that resides in the Web site’s root directory. Through Web.config you can specify settings like custom 404 error pages, authentication and authorization settings for the Web sitempilation options for the ASP.NET Web pages, if tracing should be enabled, etc. The Web.config file is an XML-formatted file. At the root level is the tag. Inside this tag you can add a number of other tags, the most common and useful one being the system.web tag, where you will specify most of the Web site configuration parameters. However, to specify application-wide settings you use the tag. For example, if we wanted to add a database connection string parameter we could have a Web.config file like so.
12. Creating a Key Pair?
You can create a key pair using the Strong Name tool (Sn.exe). Key pair files usually have an .snk extension. To create a key pair At the command prompt, type the following command:
“sn k” In this command, file name is the name of the output file containing the key pair. The following example creates a key pair called sgKey.snk. sn -k sgKey.snk
13. What are the Types of Assemblies?
Assemblies are of two types:
1. Private Assemblies
2. Shared Assemblies
14.What is Private Assemblies ?
This assembly is intended only for one application. The files of that assembly must be placed in the same folder as the application or in a sub folder. No other application will be able to make a call to this assembly. The advantage of having a private assembly is that, it makes naming the assembly very easy, since the developer need not worry about name clashes with other assemblies. As long as the assembly has a unique name within the concerned application, there won’t be any problems.If the assembly is to be made into a Shared Assembly, then the naming conventions are very strict since it has to be unique across the entire system. The naming conventions should also take care of newer versions of the component being shipped. These are accomplished by giving the assembly a Shared Name. Then the assembly is placed in the global assembly cache, which is a folder in the file system reserved for shared assemblies.
.Net Interview Questions Part 4
- What are the Advantages and Disadvantages of view state?
- Describe session handling in a webform, how does it work and what are the limitations?
- How would you get ASP.NET running in Apache web servers? Explain it’s limitations.
- What is MSIL and why should my developers need an appreciation of it if at all?
- Which methos do you invoke on the DataAdapter control to load your generated dataset with data?
- Can you edit data in Repeater control? How?
- Which template must you provide, in order to display data in a Repeater control?
- How can you provide an alternating color scheme in a Repeater control?
- What property must you set, and what method must you call in your code, in order to bind the data from some data source to the repeater control?
- What base class do all web forms inherit from?
- What method do you use to explicitly kill a user’s session? How?
- How do you turn off cookies for one page in your site? Give an example.
- Which two properties are on every validation control?
- What tags do you need to add within the asp:datagrid tags to bind columns manually? Give an example.
- How do you create a permanent cookie?
- What tag do you use to add a hyperlink column to the data Grid?
- What is the standard you use to wrap up a call to a Web Service?
- Which method do you use to redirect the user to another page without performing a round trip to the client? How?
- What is the transport protocol you use to call a Seb Service SOAP?
- What does WSDL stand for?
- What property do you have to set to tell the grid which page to go to when using the Pager object?
- Where on the Internet would you look for Web Services?
- What tags do you need to add within the asp:datagrid tags to bind columns manually? How?
- Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
- How is a property designated as read-only?
.Net Interview Questions Part 3
- Write a program to create a user control with name and surname as data members and login as method and also the code to call it.
- How can you read 3rd line from a text file?
- Explain the code behind wors and contrast that using the inline style.
- Explain different types of HTML, Web and server controls.
- What are the differences between user control and server control?
- How server form post-back works?
- Can the action attribute of a server-side tag be set to a value and if not how can you possibly pass data from a form page to a subsequent page?
- How would ASP and ASP.NET apps run at the same time on the same server?
- What are good ADO.NET object to replace to ADO Recordset object.
- Explain the differences between Server-side code and Client-side code.
- What type of code(server or client) is found in a Code-Behind class?
- Should validation (did the user enter a real date) occur server-side or client-side? Why?
- What does the “EnableViewState” property do? Why would I want it on or off?
- What is the difference between Server.Transfer and response.Redirect? Why?
- Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced.NET component?
- Let’s say I have an existing application written using VB6 and this application utilizes Windows 2000 COM+ transaction services. How would you approach migrating this application to.NET?
- If I am developing an application that must accomodate multiple security levels though secure login and my ASP.NET web application is spanned across three web-servers (using round-robin load balancing). What would be the best approach to maintain login-in state for the users?
- What are ASP.NET web forms? How is this technology different than what is available though ASP(1.0-3.0)?
- How does VB.NET achieve polymorphism?
- How does C# achieve polymorphism?
- Can you explain what is Inheritance and an example in VB.NET and C# of when you might use it?
- Describe difference between inline and code-behind?
- What is loosely coupled solution in.NET?
- What is diffgram?
- Where would you use an iHTTPModule and what are the limitations of any approach you might take in implementing one?
.Net Interview Questions Part 2
- Can we copy a COM dll to GAC folder?
- What is Shared and Repeatable Inheritance?
- Can you explain what inheritance is and an example of when you might use it?
- How can you write a class to restrict that only one object of this class can be created (Singleton class)?
- What are virtual destructors?
- What is close method? How its different from Finalize and Dispose?
- What is Boxing and UnBoxing?
- What is check/uncheck?
- What is the use of base keyword? Tell me a practical example for base keyword’s usage?
- What are the different.NET tools which you used in projects?
- What will do to avoid prior case?
- What happens when you try to update data in a dataset in.NET while the record is already eleted in SQL Server as backend?
- What is concurrency? How will you avoid concurrency when dealing with dataset?
- One user deleted one row after that another user through his dataset was trying to update same row.What will happen? How will you avoid this problem?
- How do you merge two datasets into the third dataset in a simple manner?
- If you are executing these statements in commandObject. “Select * from Table1; Select * from Table2? How you will deal result set?
- How do you sort a dataset.
- If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
- What is the use of Parameter object?
- How to generateXML from a dataset and vice versa?
- How do you implement locking concept for dataset?
- How will you do Redo and Undo in TextBox control?
- How to implement DataGrid in.NET? How would you make a combo-box appear in one column of a DataGrid? What are the ways to show data grid inside a data grid for a master details type of tables? If we write any code for DataGrid methods. what is the access specifier used for that methods in the code behind file and why?
- How can we create Tree control in asp.NET?
- Write a program in C# to find the angle between the hours and minutes in a clock?
.Net Interview Questions Part 1
1. What is a static class? 2. What is static member?
3. What is static function?
4. What is static constructor?
5. How can we inherit a static variable?
6. How can we inherit a static member?
7. Can we use a static function with a non-static variable?
8. How can we access static variable?
9. Why main function is static?
10. How will you load dynamic assembly? How will create assemblies at run time?
11. What is Reflection?
12. If I have more than one version of one assembly, then how will I use old version
(how/where to specify version number?) in my application?
13. How do you create threading in.NET? What is the namespace for that?
14. What do you mean by Serialize and MarshalByRef?
15. What is the difference between Array and LinkedList?
16. What is Asynchronous call and how it can be implemented using delegates?
17. How to create events for a control? What are custom events? How to create it?
18. If you want to write your own dot net language, what steps you will you take care?
19. Describe the difference between inline and code behind – which is best in a loosely coupled solution?
20. How dot net compiled code will become platform independent?
21. Without modifying source code if we compile again, will it be generated MSIL again?
22. How does you handle this COM components developed in other programming languages in.NET?
23. How CCW (Com Callable Wrapper) and RCW (Runtime Callable Wrappers) works?
24. What are the new thee features of COM+ services, which are not there in COM (MTS)?
25. What are the differences between COM architecture and.NET architecture?
3. What is static function?
4. What is static constructor?
5. How can we inherit a static variable?
6. How can we inherit a static member?
7. Can we use a static function with a non-static variable?
8. How can we access static variable?
9. Why main function is static?
10. How will you load dynamic assembly? How will create assemblies at run time?
11. What is Reflection?
12. If I have more than one version of one assembly, then how will I use old version
(how/where to specify version number?) in my application?
13. How do you create threading in.NET? What is the namespace for that?
14. What do you mean by Serialize and MarshalByRef?
15. What is the difference between Array and LinkedList?
16. What is Asynchronous call and how it can be implemented using delegates?
17. How to create events for a control? What are custom events? How to create it?
18. If you want to write your own dot net language, what steps you will you take care?
19. Describe the difference between inline and code behind – which is best in a loosely coupled solution?
20. How dot net compiled code will become platform independent?
21. Without modifying source code if we compile again, will it be generated MSIL again?
22. How does you handle this COM components developed in other programming languages in.NET?
23. How CCW (Com Callable Wrapper) and RCW (Runtime Callable Wrappers) works?
24. What are the new thee features of COM+ services, which are not there in COM (MTS)?
25. What are the differences between COM architecture and.NET architecture?
SSC Combined Graduate Level: PART VI
SSC Combined Graduate Level
Practice Model Questions Papers
1 “Grass Court” is connected with
(a) French open (b) US open
(c) Australian open (d) Wimbledon
2 Where will be held the 15th SAARC summit
(a) Kathmandu (b) Dhaka
(c) New Delhi (d) Colombo
3 The Kailash Temple at Ellora is a specimen of
(a) Gupta architecture (b) Rashtrakuta architecture
(c) Chalukya architecture (d) Chola architecture
4 Which one of the following Articles of the constitution accord special status to the state of Jammu and Kashmir
(a) 368 (b) 370
(c) 365 (d) 380
5 Which one of the following had been a powerful naval power in the south
(a) Chalukya (b) Pandya
(c) Chola (d) Rashtrakuta
6 Pindaris were
(a) Snake charmers
(b) Marauding robber bands
(c) People living in Antarctica region
(d) None of these
7 In which of the following battles was Prithvi Raj defeated by Mohammad Ghauri
(a) Plassey (b) Paniput
(c) Tarain (d) Wandiwash
8 The Indian constitution can be amended under article
(a) 312 (b) 368
(c) 390 (d) 249
9 Which part of the body is rhinoplasty associated with
(a) Lips (b) Ears
(c) Nose (d) Hands
10 Which one of the following pairs in not correct
(a) Kaziranga Sanctuary – Assam
(b) Jog- Falls – Karnataka
(c) Jim Corbett national park – Bihar
(d) Periyar wild life sanctuary – kerala
11 Jawahar Lal Nehru Awards for international understanding for 1996 has been awarded to
(a) Aung San Suu Kyi (b) Mahathir Mohammad
(c) Yaser Arafat (d) Hasina Khilji
12 The Hindustan Shipyard is located at
(a) Mumbai (b) Calcutta
(c) Chennai (d) Visakhapatanam
13 In which order did the following come to India
(a) Thomas Roe
(b) Fehien
(c) Hieun Tsang
(a) A,B,C
(b) B,A,C (c) B,C,A (d) C,A,B
14 The words Satyameva Jayate have been taken from
(a) Vedas (b) Bhagwad Gita
(c) Mundaka Upanishada (d) Mahanharata
15 Which of the following events in not correctly matched
(a) Simon Commission – 1926 (b) Salt Satyagraha – 1930
(c) Gandhi – Irwin Pact (d) Quit India movement – 1942
16 Tipu Sultan was ruler of
(a) Hyderabad (b) Ahmednagar
(c) Mysore (d) Ahmeddabad
17 Which one of the following colloidal system is represented by fog
(a) Gas in liquid (b) Liquid in gas
(c) Solid in gas (d) Liquid in liquid
18 Chanakya was also known as
(a) Bhattasvamin (b) Vishnugupta
(c) Vishnu Sharma (d) Visakhadatta
19 Mahakali Treaty was signed between
(a) India and Bangladesh (b) India and Burma
(c) India and Nepal (d) Nepal and Bangladesh
20 Which one of the following bodies finalises the five – year plans proposal
(a) Planning commission (b) union Cabinet
(c) National Development Council (d) Ministry of planning
21 What is the Choglamsar
(a) A solar village in Ladakh (b) A Himalayan Animal Which resembles yak
(c) Name of the river Brahmputra in Tibet
(d) None of these
22 Siraj – ud – daula was defeated in the battle of
(a) Buxar (b) Plassey
(c) Wandiwash (d) None of these
23 What is Wisden
(a) A famous painting by Picasso
(b) An authoritative cricket almanac
(c) Official report of proceedings in British Parliament
(d) None of these
24 Which country and city hosted the first Asian games in 1951 ?
(a) Japan and Tokyo (b) India and Delhi
(c) Thailand and Bangkok (d) Malaysia and Kuala
25 Which is the odd one out
(a) The security council (b) The U.N. General Assembly
(c) NATO (d) The economic and Social council
ANSWER
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
d d b b c b c b c c b d c c a
16 17 18 19 20 21 22 23 24 25
c b b c c a b b b c
SSC Tax. Assistant Examination PART V
SSC Tax. Assistant Examination
Previous Year Paper - General Awareness
1. What is the International Date Line?
(a) It is the equator
(b) It is the 00 longitude
(c) It is the 900 east longitude
(d) It is the 1800 longitude
2. The oldest type of energy known to man is
(a) wind power
(b) solar power
(c) tidal power
(d) geothermal energy
3. Rusting of iron takes place due to
(a) oxidation
(b) carbonation
(c) exidiation
(d) corrosion
4. The river also known as Tsangpo in Tibet is
(a) Ganga
(b) Brahmaputra
(c) Indus
(d) Teesta
5. The largest ocean is
(a) Atlantic Ocean
(b) Indian Ocean
(c) Arctic Ocean
(d) Pacific Ocean
6. Energy that is produced commercially from coal is called
(a) Light energy
(b) Kinetic energy
(c) Thermal energy
(d) Potential energy
7. Jhum cultivation is a method of cultivation which used to be practiced in
(a) Himachal Pradesh
(b) Central Highland
(c) Coastal Tamil Nadu
(d) Nagaland
8. Earthquake is caused by
(a) disturbance of earth surface
(b) adjustment of layers of earth’s crust
(c) breakage of rock system
(d) upliftment of rocks
9. We always see the same face of the moon, because
(a) it is smaller than the earth
(b) it revolves on its axis in a direction opposite to that of the earth
(c) it takes equal time for revolution around the earth and rotation on its own axis
(d) it rotates at the same speed as the earth around the sun
10. The largest producer of gold in the world is
(a) Australia
(b) Canada
(c) Russia
(d) South Africa
11. The busiest and the most important sea route of the world is
(a) North Pacific Sea Route
(b) North Atlantic Sea Route
(c) South Atlantic Sea Route
(d) Indian Ocean Route
12. In terms of area, India is the – largest country of the world.
(a) Second
(b) Fourth
(c) Sixth
(d) Seventh
13. The word ‘Veda’ means
(a) knowledge (b) wisdom
(c) skill
(d) power
14. Ain-i-Akbari was written by
(a) Firishta
(b) Ibn Batuta
(c) Abul Fazl
(d) Birbal
15. The medieval city of Vijayanagar is not known as
(a) Chandragiri
(b) Halebidu
(c) Hampi
(d) Kondavidu
16. Which one of the following Mughal buildings is said to possess the unique feature of being exactly equal in length and breadth?
(a) Agra Fort
(b) Red Fort
(c) Taj Mahal
(d) Buland Darwaza
17. With the fall of which among the following, the French Revolution began?
(a) Bastille
(b) Communes
(c) Jacobin Club
(d) Pillnitz
18. The founder of the ‘Brahmo Samah’ was
(a) Swami Dayananda Sarawati
(b) Ishwar Chandra Vidyasagar
(c) Raja Ram Mohan Roy
(d) Swami Vivekananda
19. The correct chronological order in which the British established their trading centre in the places mentioned below is
(a) Calcutta, Bombay, Madras, Surat
(b) Bombay, Madras, Surat, Calcutta
(c) Surat, Madras, Bombay, Calcutta
(d) Surat, Madras, Calcutta, Bombay
20. The Revolt of 1857 was started by
(a) the Sepoys
(b) the Zamindars
(c) the Peasants
(d) the Plantation Workers
21. After leaving the congress, Subhash Chandra Bose formed, in 1939, his own party, named
(a) Socialist Block
(b) Revolutionary Socialist Block
(c) Forward Block
(d) Socialist-Congress Block
22. Bal Gangadhar Tilak was given the epithet of Lokmanya during
(a) his imprisonment in 1908
(b) Home Rule Movement
(c) Revolutionary Movement
(d) Swadeshi Movement
23. ‘Do or Die’ (Karenge ya Marenge) – Gandhiji gave this Mantra to the nation on the eve of which mass movement?
(a) Rowlatt Satyagraha
(b) Salt Satyagraha
(c) Quit India Movement
(d) Non-Cooperation Movement
24. Who among the following was the President of the Constituent Assembly of India?
(a) Dr. Rajendra Prasad
(b) Jawaharlal Nehru
(c) M A Jinah
(d) Lal Bahadur Shastri
25. ‘Directive Principle’’ in our Constitution are
(a) enforceable in the courts of law
(b) quasi-enforceable
(c) partly non-enforceable
(d) non-enforceable in the courts of law
26. CTBT denotes
(a) arms control measure
(b) drugs control measure
(c) financial control measure
(d) trade control and regulation
27. Name the State carved out of Madhya Pradesh after the Parliament passed the legislation in the year 2000
(a) Vanachal
(b) Chhattisgarh
(c) Vidarbha
(d) Uttaranchal
28. Dialectial Materialism is associated with the theory of
(a) Fabianism
(b) Communism
(c) Liberalism
(d) Individualism
29. A motion moved by a member in a legislature when it is desired to have a discussion on a matter of urgent public importance is called
(a) Adjournment motion
(b) No-confidence motion
(c) Cut motion
(d) None of the above
30. Which of the following was established by B R Ambedkar?
(a) Swaraj Party
(b) Samaj Samata Party
(c) Bahujan Samaj Party
(d) The Independent Labour Party
31. No Government Expenditure can be incurred in India except with the sanction of
(a) the Parliament
(b) the Prime Minister
(c) the President
(d) the Supreme Court
32. Which one country is not a permanent member of the Security Council of the United Nations?
(a) France (b) Germany
(c) Russia
(d) USA
33. When does Lok Sabha or a Vidhan Sabha election candidate forfeit his security deposit?
(a) When he fails to win the election
(b) When he fails to secure even 1/4 of total votes polled
(c) When he fails to secure even 1/5 of total votes polled
(d) When he fails to secure even 1/6 of total votes polled
34. The term of office of the members of the UPSC is
(a) 3 years, or till they attain 58 years of age
(b) 5 years, or till they attain 60 years of age
(c) 6 years, or till they attain 65 years of age
(d) 6 years
35. Who was in favour of a partyless democracy?
(a) Jai Prakash Narain
(b) Bhupendra Nath Dutta
(c) M N Roy
(d) Jawaharlal Nehru
36. The majority of the provisions of the Indian Constitution can be amended
(a) by the State Legislatures acting together
(b) by the Parliament alone
(c) with the major approval of the Parliament and State Legislatures
(d) only on ratification by half of the States
37. Economics of Scales means reduction in
(a) unit cost of production
(b) unit cost of distribution
(c) total cost of production
(d) total cost of distribution
38. RBI does not transact the business of which State Government?
(a) Nagaland (b) Jammu & Kashmir (c) Punjab (d) Assam
39. The famous book The General Theory of Employment, Interest and Money is written by
(a) J B Say
(b) J M Keynes
(c) Amartya Sen
(d) Carincross
40. The definition of ‘small-scale industry’ in India is based on
(a) sales by the unit (b) investment in machines and equipments
(c) market coverage (d) export capacity
41. When the total product rises at an increasing rate, the
(a) marginal product is zero
(b) marginal product is rising
(c) marginal product is falling
(d) marginal product remains constant
42. Water pipes in hilly areas often burst on a cold frosty night, because
(a) the material of which pipes are made contracts due to cold and so breaks
(b) water in the pipes freezes and on freezing water expands, so pipes
(c) burst makes the pipes rusty, so they break
(d) none of the above
43. With which form of economy is the term ‘Laissez-faire’ associated?
(a) Capitalist economy
(b) Socialist economy
(c) Mixed economy
(d) Command economy
44. In the budget figures of the Government of India, interest payments, subsidies, pensions, social services and the like are parts of the
(a) Plan Expenditure (b) State Government Expenditure
(c) Public Debt in the form of Capital Expenditure
(d) Non-plan Expenditure
45. ‘Green Accounting’ means measuring the National Income of the country taking into account estimation of
(a) the total forest area of the country
(b) the destruction of forest cover of the country
(c) pollution and environmental damage
(d) area of reclaimed fallow land
46. The supply of agricultural products is generally
(a) elastic
(b) inelastic
(c) perfectly elastic
(d) perfectly inelastic
47. Which of the following taxes is not collected by the Central Government?
(a) Income tax
(b) Customs duty
(c) Professional tax
(d) Excise duty
48. The latest addition to the list of UNESCO’s world heritage sites in India is
(a) Qutub Minar
(b) Humayun’s Tomb
(c) Khajuraho Temple
(d) Red Fort
49. The countries separated by the Mac-Mahon Line are
(a) Afghanistan and Pakistan
(b) Bangladesh and India
(c) China and India
(d) Pakistan and India
50. The permission given to a bank customer to draw cheques in excess of his current account balance is called
(a) a personal loan
(b) an ordinary loan
(c) discounting a bill of exchange
(d) an overdraft
51. A proclamation of emergency, under Article 352, on account of war or aggression requires approval of the Parliament within
(a) one month
(b) two months
(c) four months
(d) six months
52. The first Defence Minister of India was
(a) K M Cariappa (b) Gopalaswami Aiyangar
(c) Baldev Singh (d) Sardar Patel
53. Provincial Autonomy was introduced in India by the
(a) Indian Councils Act, 1909
(b) Government of India Act, 1919
(c) Government of India Act, 1935
(d) Indian Independence Act, 1947
54. Which one country is still governed by a monarch?
(a) Afghanistan
(b) Iran
(c) Iraq
(d) Saudi Arabia
55. Article 370 of the Indian Constitution upholds
(a) land reforms legislation in India
(b) diplomatic privileges and immunities
(c) special status of Jammu and Kashmir State
(d) duties and rights of Lokpal
56. Who amongst the following is the author of the classic book Life Divine?
(a) Ravi Shankar
(b) Swami Vivekananda
(c) Radha Krishnan
(d) Aurobindo Ghosh
57. The first woman to become a Chief Minister of any State in India was
(a) Nandini Satpathy
(b) Dr. J. Jayalalitha
(c) Sucheta Kripalani
(d) Mayawati
58. A parachute descends slowly whereas a stone dropped from the same height falls rapidly, because
(a) stone is heavier then parachute
(b) special mechanisms are present in parachute
(c) a parachute has a larger surface area and air resistance is more
(d) None of these
59. Jaduguda is associated with the mining of
(a) iron
(b) mica
(c) uranium
(d) copper
60. Salim Ali was an eminent
(a) Urdu poet
(b) Ornithologist
(c) Ghazal singer
(d) None of the above
61. ‘Survey of India’ is under the Ministry of
(a) Defence
(b) Environment and Forests
(c) Home Affairs (
(d) Science and Technology
62. Name the President of India who was elected unopposed
(a) Dr. Shankar Dayal Sharma
(b) Dr. Neelam Sanjiva Reddy
(c) Dr. Fakhruddina Ali Ahmed
(d) Dr. Zakir Husain
63. The authority which is not established by the constitutional provisions is
(a) Finance Commission
(b) Planning Commission
(c) UPSC
(d) Election Commission
64. Which of the following organizations is the oldest?
(a) IMF
(b) WHO
(c) ILO
(d) FAO
65. The Department of Space proposed setting up of Indian Institute of Space Technology on the line of the seven IITs. It will have its independent campus at
(a) Chennai
(b) Thumba
(c) Thiruvananthapuram
(d) Sriharikota
66. Which metal was first used by the Vedic people?
(a) Silver
(b) Gold
(c) Iron
(d) Copper
67. Ryder Cup is related with which sports?
(a) Football
(b) Golf
(c) Badminton
(d) Cricket
68. In our Constitution, Economic Planning is included in
(a) Union list
(b) State list
(c) Concurrent list
(d) Not any specified list
69. ‘NABARD’ is associated with the dev
elopment of
(a) agricultural sector and rural area (b) heavy industries
(c) banking sector
(d) real estates
70. World No. 2 Rafael Nadal won the French Open, 2007 defeating
(a) Stegan Edberg
(b) Andy Roddick
(c) Roger Federer
(d) Fred Alexander
71. Which one of the following is not a plantation crop?
(a) Tea
(b) Coffee
(c) Rubber
(d) Sugarcane
72. Imputed gross rent of owner-occupied buildings is a part of
(a) capital formation
(b) final consumption
(c) intermediate consumption
(d) consumer durable
73. How many strings are there on a Sarod?
(a) 7
(b) 19
(c) 5
(d) 4
74. Which one of the following is the tallest bird?
(a) Peacock
(b) Penguin
(c) Ostrich
(d) Emu
75. Which one of the following animals is called farmer’s friend?
(a) Ant
(b) Earthworm
(c) Bee
(d) Butterfly
76. The largest planet in our solar system is
(a) Mars
(b) Jupiter
(c) Saturn
(d) Butterfly
77. The term ‘gene’ was coined by
(a) T.H.Morgan
(b) W.L.Johanssen
(c) G.Mendel
(d) De Vries
78. Which of the following creatures has maximum number of ribs?
(a) Crocodile
(b) Snake
(c) Ray fish
(d) Flying mammal
79. Which one of the following is most important for the growth of children up to the age of 14?
(a) Protein
(b) Vitamin
(c) Fat
(d) Milk
80. Study of newly born up to the age of 3 months is called
(a) Chorology
(b) Conchology
(c) Nematology
(d) Neonatology
81. Which one of the following does not secrete any digestive enzyme?
(a) Liver
(b) Salivery gland
(c) Glands of small intestine
(d) Pancreas
82. In a tribute to Mahatma Gandhi’s philosophy of brotherhood and peace, the UN General Assembly declared his birth anniversary, October 2, as the
(a) International Day of Non-Violence
(b) International Day of Co-operation
(c) International Day of Peace and Co-operation
(d) International Day of Prace and Non-Violence
83. Which one of the following is related to Silviculture?
(a) Culture of Hilsa
(b) Culture of silver carp
(c) Culture of oil-producing plants
(d) Forests crops
84. The term ‘GM food’ refers to the food
(a) that grows under genetic measures
(b) that is genetically modified
(c) that grows under geographical modification
(d) with greater glucose metabolism capacity
85. The only age of India found in hill forests of Assam and Nagaland is
(a) Orangutan
(b) Gibbon
(c) Chimpanzee
(d) Gorilla
86. Free Trade refers to
(a) free movement of goods from one country to another
(b) movement of goods free of cost
(c) unrestricted exchange of goods and service
(d) trade free of duty
87. Which gas is used as fire extinguisher?
(a) Carbon dioxide
(b) Carbon monoxide
(c) Carbon suboixde
(d) Sulphur dioxide
88. Which one of the following is extensively used for sterilizing water?
(a) Bleaching powder
(b) Alum
(c) Borax powder
(d) Soda powder
89. Which mixture of gases is mainly stored as a liquid under pressure in LPG cylinder?
(a) Methane and Ethane
(b) Ethane and Hexane
(c) Propane and Butane
(d) Hexane and Octane
90. The energy stored in a watch spring is
(a) kinetic energy
(b) potential energy
(c) heat energy
(d) chemical energy
91. Which one of the following acids is used in battery?
(a) Hydrochloric acid
(b) Hydrofluoric acid
(c) Sulphuric acid
(d) Sulphurous acid
92. The sensation of weightlessness in a spacecraft in an orbit is due to the
(a) absence of gravity outside
(b) acceleration in the orbit which is equal to the acceleration due to gravity outside
(c) presence of gravity outside but not inside the spacecraft
(d) fact that spacecraft in the orbit has no energy
93. The major constituent of air is
(a) nitrogen
(b) carbon dioxide
(c) oxygen
(d) hydrogen
94. Which of the following organisms is most likely to produce greenhouse gases such as nitrous oxide and methane?
(a) Fungi
(b) Earthworm
(c) Bacteria
(d) Green plants
95. Where is the largest reflecting telescope of Asia?
(a) Kodaikanal
(b) Ooty
(c) Kavalur
(d) Naintal
96. ‘Therm’ is the unit of
(a) power
(b) heat
(c) light
(d) distance
97. Cream gets separated out of milk when it is churned. This is due to
(a) gravitational force
(b) centripetal force
(c) centrifugal force
(d) frictional force
98. Newton’s 1st law of motion gives the concept of
(a) energy
(b) work
(c) momentum
(d) inertia
99. The process by which sun’s rays reach the earth is
(a) radiation
(b) conduction
(c) convection
(d) diffusion
100. A pond of water appears less deep due to
(a) reflection
(b) diffraction
(c) refraction
(d) polarisation
ANSWER KEYS
1. (d) 2. (d) 3. (a) 4. (b) 5. (d) 6. (c) 7. (d) 8. (a) 9. (c)
10. (d) 11. (b) 12. (d) 13. (a) 14. (c) 15. (c) 16. (c) 17. (a) 18. (c)
19. (d) 20. (a) 21. (c) 22. (b) 23. (c) 24. (a) 25. (d) 26. (a) 27. (b)
28. (b) 29. (a) 30. (d) 31. (a) 32. (b) 33. (d) 34. (c) 35. (a) 36. (d)
37. (a) 38. (b) 39. (b) 40. (b) 41. (b) 42. (b) 43. (a) 44. (d) 45. (c)
46. (b) 47. (c) 48. (d) 49. (c) 50. (d) 51. (a) 52. (c) 53. (c) 54. (d)
55. (c) 56. (d) 57. (c) 58. (c) 59. (c) 60. (b) 61. (d) 62. (b) 63. (b)
64. (c) 65. (c) 66. (c) 67. (b) 68. (c) 69. (a) 70. (c) 71. (d) 72. (b)
73. (b) 74. (c) 75. (b) 76. (b) 77. (b) 78. (b) 79. (a) 80. (d) 81. (a)
82. (a) 83. (d) 84. (b) 85. (b) 86. (c) 87. (a) 88. (a) 89. (c) 90. (b)
91. (c) 92. (b) 93. (a) 94. (c) 95. (c) 96. (b) 97. (b) 98. (d) 99. (a)
