RSS Feed (xml)
1. Write a program in C to find the 3*3 matrix multiplication.
2. Write a program in C to find the complex number of a given number.
3. how to print all the combinations of a given integer.
4. what is the significance of following functions
- freopen()
- strtok()
- access()
- state()
6. what is source code of this tringle ...
A
A N I
A N I R B
A N I R B A N
A N I R B A N P A
A N I R B A N P A U L
7. What happens when you overload the stack?
8. what do you mean by preprocessor directory?
9. What is byte offset of a field within a structure?
10. What is unabridged list?
11. How is structure passing and returning implemented?
12. Write sample code or algorithim to get all possible combinations of data that will be entered from keyboard.
13. Explian Floyd Cycle finding algorithm for circular link list?
14. Why is that a pointer is depicted by '*' in C?
15. Write a program to print an 2D array in spiral manner
16. #includevoid fun(int);void main(){ inta; a=3; fun(a); }void fun(int){ if(n>0) { fun(--n);...
17. Given the values of two nodes in a *binary search tree*, write a cprogram to find the lowest common ancestor.
18. Can we define an array without any constant expression? If Yes, How?
19. For what purpose pragma.h header file is used?
20. What is the advantage of zero filling in calloc() ?
Oracle Interview Questions - Part 13
1.What are the various types of Exceptions ?
User defined and Predefined Exceptions.
2.Can we define exceptions twice in same block ?
No.
3.What is the difference between a procedure and a function ?
Functions return a single variable by value whereas procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter.
4.Can you have two functions with the same name in a PL/SQL block ?
Yes.
5.Can you have two stored functions with the same name ?
Yes.
6.Can you call a stored function in the constraint of a table ?
No.
7.What are the various types of parameter modes in a procedure ?
IN, OUT AND INOUT.
8.What is Over Loading and what are its restrictions ?
OverLoading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it.
9.Can functions be overloaded ?
Yes.
10.Can 2 functions have same name & input parameters but differ only by return datatype?
No.
11.What are the constructs of a procedure, function or a package ?
The constructs of a procedure, function or a package are : variables and constants cursors exceptions
12.Why Create or Replace and not Drop and recreate procedures ?
So that Grants are not dropped.
13.Can you pass parameters in packages ? How ?
Yes. You can pass parameters to procedures or functions in a package.
14.What are the parts of a database trigger ?
The parts of a trigger are:
A triggering event or statement
A trigger restriction
A trigger action
15.What are the various types of database triggers ?
There are 12 types of triggers, they are combination of :
Insert, Delete and Update Triggers.
Before and After Triggers.
Row and Statement Triggers.(3*2*2=12)
16.What is the advantage of a stored procedure over a database trigger ?
We have control over the firing of a stored procedure but we have no control over the firing of a trigger.
17.What is the maximum no. of statements that can be specified in a trigger statement ?
One.
18.Can views be specified in a trigger statement ?
No
19.What are the values of :new and :old in Insert/Delete/Update Triggers ?
INSERT : new = new value, old = NULL
DELETE : new = NULL, old = old value
UPDATE : new = new value, old = old value
20.What are cascading triggers? What is the maximum no of cascading triggers at a time?
When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading. Max = 32.
21.What are mutating triggers ?
A trigger giving a SELECT on the table on which the trigger is written.
22.What are constraining triggers ?
A trigger giving an Insert / Update on a table having referential integrity constraint on the triggering table.
23.Describe Oracle database's physical and logical structure ?
Physical : Data files, Redo Log files, Control file.
Logical : Tables, Views, Tablespaces, etc.
24.Can you increase the size of a tablespace ? How ?
Yes, by adding datafiles to it.
25.Can you increase the size of datafiles ? How ?
No (for Oracle 7.0)Yes (for Oracle 7.3 by using the Resize clause ----- Confirm !!).
26.What is the use of Control files ?
Contains pointers to locations of various data files, redo log files, etc.
27.What is the use of Data Dictionary ?
Used by Oracle to store information about various physical and logical Oracle structures e.g. Tables, Tablespaces, datafiles, etc
28.What are the advantages of clusters ?
Access time reduced for joins.
29.What are the disadvantages of clusters ?
The time for Insert increases.
30.Can Long/Long RAW be clustered ?
No.
31.Can null keys be entered in cluster index, normal index ?
Yes.
32.Can Check constraint be used for self referential integrity ? How ?
Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity.
33.What are the min. extents allocated to a rollback extent ?
Two
34.What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?
The various states of a rollback segment are :ONLINE, OFFLINE, PARTLY AVAILABLE, NEEDS RECOVERY and INVALID.
35.What is the difference between unique key and primary key ?
Unique key can be null; Primary key cannot be null.
36.An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?
Yes.
37.Can you define multiple savepoints ?
Yes.
38.Can you Rollback to any savepoint ?
Yes.
40.What is the maximum no. of columns a table can have ?
256.
Data Warehousing Interview Questions
1) What is source qualifier?
2) Difference between DSS & OLTP?
3) Explain grouped cross tab?
4) Hierarchy of DWH?
5) How many repositories can we create in Informatica?
6) What is surrogate key?
7) What is difference between Mapplet and reusable transformation?
8) What is aggregate awareness?
9) Explain reference cursor?
10) What are parallel querys and query hints?
11) DWH architecture?
12) What are cursors?
13) Advantages of de normalized data?
14) What is operational data source (ODS)?
15) What is meta data and system catalog?
16) What is factless fact schema?
17) What is confirmed dimension?
18) What is the capacity of power cube?
19) Difference between PowerPlay transformer and power play reports?
20) What is IQD file?
21) What is Cognos script editor?
22) What is difference macros and prompts?
23) What is power play plug in?
24) Which kind of index is preferred in DWH?
25) What is hash partition?
26) What is DTM session?
27) How can you define a transformation? What are different types of transformations in Informatica?
28) What is mapplet?
29) What is query panel?
30) What is a look up function? What is default transformation for the look up function?
31) What is difference between a connected look up and unconnected look up?
32) What is staging area?
33) What is data merging, data cleansing and sampling?
34) What is up date strategy and what are th options for update strategy?
35) OLAP architecture?
36) What is subject area?
37) Why do we use DSS database for OLAP tools?
38) What is a universe?
39) Analysis in business objects?
40) Who launches the supervisor product in BO for first time?
41) How can you check the universe?
42) What are universe parameters?
43) Types of universes in business objects?
44) What is security domain in BO?
45) Where will you find the address of repository in BO?
46) What is broad cast agent?
47) In BO 4.1 version what is the alternative name for broadcast agent?
48) What services the broadcast agent offers on the server side?
49) How can you access your repository with different user profiles?
50) How many built-in objects are created in BO repository?
51) What are alertors in BO?
52) What are different types of saving options in web intelligence?
53) What is batch processing in BO?
54) How can you first report in BO by using broadcast agent?
55) Can we take report on Excel in BO?
VB Interview Questions
- Why do you use Option Explicit?
- What are the commonly used data types in VBScript?
- What is a session object?
- What are the three objects of ADO?
- What are the lock-types available in ADO?
- Explain. What are the cursor types available in ADO? Explain.
- What is a COM component? How do you register a COM component?
- What is a virtual root and how do you create one?
- What is a database index, how do you create one, discuss its pros and cons?
- How do you use multiple record sets(rs.NextRecordSet)?
- As soon as you fetch a record set, what operations would you perform?
- Define a transaction.
- What are ACID properties of a transaction?
- How would you remotely administer IIS?
- What is RAID? What is it used for?
- What is normalization? Explain normalization types.
- What is the disadvantage of creating an index in every column of a database table?
- What are the uses of source control software?
- You have a query that runs slowly, how would you make it better?
- How would you make it better in .NET environment?
- What is a bit datatype? What is it used for?
- How would you go about securing IIS and MS-SQL Server?
- What is the difference between Request("field") and Request.Form("field")?
- What versions of VB have you used? Have you also used VBA or VBScript?
- Have you ever used classes? If so, how have you used them?
- Have you ever created ActiveX DLLs? If so, why did you create the DLLs instead of using code in the main application?
- Have you ever created ActiveX controls? If so, what did they do?
- Have you ever created ActiveX EXEs? If so, what were they used for?
- Have you ever used Collections? Collection Classes?
- Have you ever used ADO? DAO? RDO? Any other database engines?
- What database backends have you worked with? Access? SQL Server? Oracle?
- Have you ever used resource files? If so, for what reason?
- Have you used the FileSystemObject? The Dictionary Object? Regular Expressions?
- Have you developed COM+ components? Any other types of server based components?
- What source code control systems have you used?
- What versions of Windows have you used? Have you used any other operating systems?
- What third party ActiveX controls have you used?
- Are there any other programming tools, such as database diagramming, UML, or CASE tools, that you've used?
- Have you developed components for IIS? Developed ASP pages?
- If you were writing a program, what method would you use to send information from the main form of the application to a modal popup form and then pass any changes to the data back to the main form when the popup form was closed?
- How would you center a form on the screen? How about centering it on another form?
- If an event, such as a tool bar button or menu click,occurs on a MDI parent how can it invoke an action on one or more MDI child forms?
- What are some methods you can use to send data from one VB executable to another one?
- What are the differences between a standard module and a class module?
- What do you have to do to make your class visible to programs other than your own?
- How can you tell what kind of object an object variable is holding?
- Describe the different scopes of variables in VB.
- Describe the difference between a public variable in a form and one in a standard code module.
- How do you handle error conditions in your code?
- What are some uses and misuses of variants?
- What are some of the steps you can take to determine why your program is crashing with "Invalid Page Fault" errors?
- What are the different ways you can use threading in VB? When are they appropriate?
- How many tabs in a tabbed dialog do you consider appropriate?
- How many items should you make available to users in a listbox or combo box?
- What are the three main differences between flexgrid control and dbgrid(Data bound Grid) control
The Microsoft FlexGrid (MSFlexGrid) control displays and operates on tabular data. It allows complete flexibility to sort, merge, and format tables containing strings and pictures. When bound to a Data control, MSFlexGrid displays read-only data.Adaptation to existing Visual Basic code for the data-bound grid (DBGrid).
Dbgrid is A spreadsheet-like bound control that displays a series of rows and columns representing records and fields from a Recordset object.
The data grids are bound controls; that is, they require a data source that actually connects to a database and retrieves their data. And it seems that the root of the problem with DBGrid is that there's no data source that can be readily included along with the DBGrid control.In Visual Basic, the solution is simply to include the Data Control on the same form as DBGrid. But the Data Control is an intrinsic control; it's unavailable to anything outside of the Visual Basic environment itself. and VB 6.0 has a new set of data controls (DataGrid, DataList, DataCombo, MSHFlexGrid, MSFlexGrid) that once again are bound controls. Unlike DBGrid, though, they support OLE DB, and therefore rely on the an ADO Data Source (and in particular the ActiveX Data Objects Data Control, or ADO DC) for data access. Unlike the Data Control, the ADODC is a custom control (that is, an .OCX) that can be added to any project. In short, if you add ADO DC to your project along with theDataGrid control. - ActiveX and Types of ActiveX Components in VB ?
Standard EXE
ActiveX EXE
ActiveX DLL
ActiveX document
ActiveX Control - What is difference between inprocess and out of process ?
An in-process component is implemented as a DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component.Each client app that uses the component starts a new instance of it.
An out of process component is implemented as an EXE, and unlike a dll, runs in its own process space. As a result, exe's are slower then dll'sbecause communications between client and component must be marshalled across process boundaries. A single instance of an out of process component can service many clients. - Advantage of ActiveX Dll over Active Exe ?
ACTIVEX DLL:An in-process component, or ActiveX DLL, runs in another application’s process. In-process components are used by applications or other in-process components. this allows you to wrap up common functionality (like an ActiveX Exe).
ACTIVEX EXE:An out-of-process component, or ActiveX EXE, runs in its own address space. The client is usually an application running in another process.The code running in an ActiveX Exe is running in a separate process space. You would usually use this in N-Tier programming.
An ActiveX EXE runs out of process while an ActiveX DLL runs in the same process space as VB app. Also, and ActiveX EXE can be run independent of your application if desired. - Explain single thread and multithread thread apartments.
All components created with Visual Basic use the apartment model, whether they’re single-threaded or multithreaded. A single-threaded component has only one apartment, which contains all the objects the component provides.
This means that a single-threaded DLL created with Visual Basic is safe to use with a multithreaded client. However, there’s a performance trade-off for this safety. Calls from all client threads except one are marshaled, just as if they were out-of-process calls. - What is a Component?
If you compile an ActiveX dll, it becomes a component.If you compile an ActiveX Control, it becomes both a component and a control.
Component is a general term used to describe code that's grouped by functionality. More specifically, a component in COM terms is a compiled collection of properties/methods and events.
Typically a component is loaded into your project via the References whereas an ActiveX Control is loaded into your project via "components". - What is meant by "Early Binding" and "Late Binding"? Which is better?
Early binding and late binding refer to the method used to bind an interface's properties and methods to an object reference (variable). Early binding uses type library information at design time to reference procedures, while late binding handles this at run time. Late bindinghandles this by interrogating the reference before each call to insure that it supports a particular method. Since every call to a late boundobject actually requires two calls ("Do you do this?" followed by "Okay, do it then"), late binding is much less efficient than early binding. Except where early binding is not supported (ASP, scripting, etc.), late binding should only be used in very special cases.
It is a common misconception that any code using the CreateObject function instead of
Set = New is using late binding. This is not the case. The type declaration of the object variable determines whetherit is late or early bound, as in the following:
Dim A As Foo
Dim B As Foo
Dim C As Object
Dim D As Object
Set A = New Foo 'Early Bound
Set B = CreateObject("FooLib.Foo") 'Early Bound
Set C = CreateObject("FooLib.Foo") 'Late Bound
Set D = New Foo 'Late Bound
