Computer Science and Engineering

Computer Science and Engineering This page is designed to give a student a strong background in the fundamentals of mathematics and computer science.

All the time there is a requirement to take logical backup whatever the backup strategy is... It's important to know how...
13/04/2017

All the time there is a requirement to take logical backup whatever the backup strategy is... It's important to know how to take export backup efficiently. The post which I wrote long back still holds good in terms of providing what's required to efficiently use the utility. All the points mentioned holds true for 12c as well. Reposting as it would benefit a few DBAs at least :)
Follow my blog for instant updates as and when posted..

http://orabliss.blogspot.in/2012/05/datapump-some-tips_84.html

Data Pump is a utility for unloading/loading data and metadata into a set of operating system files called a dump file set. The dump file...

02/01/2017

NVL, Decode And Case Functions in SQL:

Handling NULL values:
Ø NULL: It is value which is…
Unavailable
Unassigned
Unknown

Inapplicable
Ø A NULL is not same as zero or blank space.
Ø If a row lacks the data for a particular column, than that value is said to be null or to containing null.
Select Ename, job, sal, comm from emp;
Ø If any column value in an arithmetic expression is null, the overall result is also null.
Ø The above situation is termed as null propagation and has to be handled very carefully.
Select ename, job, sal, comm, sal+comm from emp;
Select ename, job, sal, comm, 12 * (sal + comm) from emp;
NVL Function:
Ø The NVL function is used to convert a null value to an actual value.
Syntax: NVL(expr1, expr2)
Ø Expr1: it is the source value or expression that may contain null.
Ø Expr2: it is the target value for converting NULL.
Ø NVL function can be used to convert any data type; the return value is always the same as the data type of expr1.
Ø The data types of the source and destination must match.
NVL(comm,0)
NVL(hiredate,’01-JUN-99’)
NVL(job, ‘NOT ASSIGNED’)
Ex:
Select ename, sal, comm, sal + nvl(comm,0) from emp;
Select ename, sal, comm, (sal * 12) + nvl(comm,0) from emp;
Select ename, sal, comm, (sal+500) + nvl(comm,0) from emp;
DECODE Function:
Ø It is a single row function.
Ø The function works on the same principle as the if – then – else.
Ø We can pass a variable number of values into the call of the decode ()
Ø Function.
Ø The first item is always the name of the column that needs to be decoded.
Ø Once all value-substitute pairs have been defined, we can optionally specify a default value.
Syntax:
Select decode(colname, value 1, substitute1, value 2, substitute2, … returndefault) from tablename;
Ø The function has no restriction on the input and output data type.
Ø It is the most power full function in oracle.
Ø The Function can work for only an analysis that considers an equality operator in the logical comparison.
Ex:
Select Ename, job, sal,
Decode(deptno,
10,’ACCOUNTING’,
20,’RESEARCH’,
30,’SALES’,
40,’OPERATIONS’,
’OTHERS’) Departments
From Emp
Order by Departments;

Working with CASE expressions:
Ø The case expression can be used to perform if-then-else logic in SQL.
Ø Case is similar to decode but it is ANSI-compliant.
Ø It can be used even for executing conditions on range based comparison.
Ø Case expressions are of two types
Simple case expressions
Searched case expressions
Simple case expressions:
Ø These expressions are used to determine the returned value.
Ø They work with equality comparison only, almost all similar to decode.
Ø It has a selector which associates to the compared value either from the column or constant.
Ø The value in the selector is used for comparison with the expressions used in the when clause.
Syntax:
Case search_expr
When expr_1 then result 1
When expr_2 then result 2
Else default_result
End
Ex:
Select Ename, Deptno,
Case
When 10 then ’ACCOUNTS’
When 20 then ’RESEARCH’
When 30 then ’SALES’
When 40 then ’OPERATIONS’
Else ’NOT FOUND’
End
From emp;
Searched case expressions:
Ø The statement uses conditions to determine the returned value.
Ø It helps in writing multiple conditions for evaluation.
Ø Used in range analysis of values also.
Syntax:
Case
When condition1 then result1
When condition2 then result2
When condition N then result
Else default result
End
Ex:
Select ename, deptno,
Case
When deptno = 10 then ’ACCOUNTS’
When deptno = 20 then ’RESEARCH’
When deptno = 30 then ’SALES’
When deptno = 40 then ’OPERATIONS’
Else ’not specified’
End
From emp;
Select Ename, Sal,
Case
When sal >= 800 and sal =2001 and sal

02/01/2017

SQL Introduction :

What is a Database?

The answer to this question is very simple. Database is the place where we can store our data. The Oracle database is designed in such a way that any data we want to store in it, we can store it in the form of tables. A table will contain Rows (In database terminology we will call them as Records) and Columns (In database terminology we will call them as Attributes).

Why we need a Database?

Let me explain this with small example. Let us take the example of GMAIL, through which we can send mails; we can chat with friends.... by logging in with our credentials (Username and Password).

Here in Gmail our Usernames should be unique. While registering it will ask to enter unique user name by checking the availability and each username will be associated with a password. So, where this information will be stored? This information will be stored in the tables of a database server which is located at the company. So, each time when you are trying to login then it will validate the information with the data stored in the database and it will do appropriate action.

Similarly in real life almost in the entire places database becomes a mandatory thing as we can store data into it from any place and we can access that data from any place. Take Banking, Railways ticket reservations, Bus ticket reservations, Cinema ticket reservations and information, Hospitals..... Any place you take... they need a database to maintain the information.

So, now we understand the importance of the database in our real life. Now, here comes most important question. What is SQL?

What is SQL?

SQL means Structured Query Language. The statements which we are going to write in this language will be called as Queries. Each query will be having its own structure. That is why this language is called as Structured Query Language. Ok fine. Now we know what SQL is. The next question is why we need SQL?

Why we need SQL?

So as discussed in the above sections, we will store the information in the database in the form of tables. How will you store? We cannot take it by hand and we cannot put it in the database right... Similarly how will you see the information? How will you modify the information? To do all these things we need a mode of communication with the database. We need to interact with the database by some medium. Here comes the usage of a Database language by which we can perform all the above mentioned tasks on the database. One such type of Language is SQL.

So, SQL is a communication language which will be used to interact with the database. So, as part of SQL we are going to learn about how to perform all the above mentioned tasks.

13/07/2015

1. Accessibility Controls - access.cpl
2. Accessibility Wizard - accwiz
3. Add Hardware Wizard - hdwwiz.cpl
4. Add/Remove Programs - appwiz.cpl
5. Administrative Tools - control admintools
6. Automatic Updates - wuaucpl.cpl
7. Bluetooth Transfer Wizard - fsquirt
8. Calculator - calc
9. Certificate Manager - certmgr.msc
10. Character Map - charmap
11. Check Disk Utility - chkdsk
12. Clipboard Viewer - clipbrd
13. Command Prompt - cmd
14. Component Services - dcomcnfg
15. Computer Management - compmgmt.msc
16. Control Panel - control
17. Date and Time Properties - timedate.cpl
18. DDE Shares - ddeshare
19. Device Manager - devmgmt.msc
20. Direct X Troubleshooter - dxdiag
21. Disk Cleanup Utility - cleanmgr
22. Disk Defragment - dfrg.msc
23. Disk Management - diskmgmt.msc
24. Disk Partition Manager - diskpart
25. Display Properties - control desktop
26. Display Properties - desk.cpl
27. Dr. Watson System Troubleshooting Utility - drwtsn32
28. Driver Verifier Utility - verifier
29. Event Viewer - eventvwr.msc
30. Files and Settings Transfer Tool - migwiz
31. File Signature Verification Tool - sigverif
32. Findfast - findfast.cpl
33. Firefox - firefox
34. Folders Properties - control folders
35. Fonts - control fonts
36. Fonts Folder - fonts
37. Free Cell Card Game - freecell
38. Game Controllers - joy.cpl
39. Group Policy Editor (for xp professional) - gpedit.msc
40. Hearts Card Game - mshearts
41. Help and Support - helpctr
42. HyperTerminal - hypertrm
43. Iexpress Wizard - iexpress
44. Indexing Service - ciadv.msc
45. Internet Connection Wizard - icwconn1
46. Internet Explorer - iexplore
47. Internet Properties - inetcpl.cpl
48. Keyboard Properties - control keyboard
49. Local Security Settings - secpol.msc
50. Local Users and Groups - lusrmgr.msc
51. Logs You Out Of Windows - logoff
52. Malicious Software Removal Tool - mrt
53. Microsoft Chat - winchat
54. Microsoft Movie Maker - moviemk
55. Microsoft Paint - mspaint
56. Microsoft Syncronization Tool - mobsync
57. Minesweeper Game - winmine
58. Mouse Properties - control mouse
59. Mouse Properties - main.cpl
60. Netmeeting - conf
61. Network Connections - control netconnections
62. Network Connections - ncpa.cpl
63. Network Setup Wizard - netsetup.cpl
64. Notepad - notepad
65. Object Packager - packager
66. ODBC Data Source Administrator - odbccp32.cpl
67. On Screen Keyboard - osk
68. Outlook Express - msimn
69. Paint - pbrush
70. Password Properties - password.cpl
71. Performance Monitor - perfmon.msc
72. Performance Monitor - perfmon
73. Phone and Modem Options - telephon.cpl
74. Phone Dialer - dialer
75. Pinball Game - pinball
76. Power Configuration - powercfg.cpl
77. Printers and Faxes - control printers
78. Printers Folder - printers
79. Regional Settings - intl.cpl
80. Registry Editor - regedit
81. Registry Editor - regedit32
82. Remote Access Phonebook - rasphone
83. Remote Desktop - mstsc
84. Removable Storage - ntmsmgr.msc
85. Removable Storage Operator Requests - ntmsoprq.msc
86. Resultant Set of Policy (for xp professional) - rsop.msc
87. Scanners and Cameras - sticpl.cpl
88. Scheduled Tasks - control schedtasks
89. Security Center - wscui.cpl
90. Services - services.msc
91. Shared Folders - fsmgmt.msc
92. Shuts Down Windows - shutdown
93. Sounds and Audio - mmsys.cpl
94. Spider Solitare Card Game - spider
95. SQL Client Configuration - cliconfg
96. System Configuration Editor - sysedit
97. System Configuration Utility - msconfig
98. System Information - msinfo32
99. System Properties - sysdm.cpl
100. Task Manager - taskmgr
101. TCP Tester - tcptest
102. Telnet Client - telnet
103. User Account Management - nusrmgr.cpl
104. Utility Manager - utilman
105. Windows Address Book - wab
106. Windows Address Book Import Utility - wabmig
107. Windows Explorer - explorer

23/06/2015

< Important Mathematics Formulas >

1. (α+в)²= α²+2αв+в²
2. (α+в)²= (α-в)²+4αв b
3. (α-в)²= α²-2αв+в²
4. (α-в)²= f(α+в)²-4αв
5. α² + в²= (α+в)² - 2αв.
6. α² + в²= (α-в)² + 2αв.
7. α²-в² =(α + в)(α - в)
8. 2(α² + в²) = (α+ в)² + (α - в)²
9. 4αв = (α + в)² -(α-в)²
10. αв ={(α+в)/2}²-{(α-в)/2}²
11. (α + в + ¢)² = α² + в² + ¢² + 2(αв + в¢ + ¢α)
12. (α + в)³ = α³ + 3α²в + 3αв² + в³
13. (α + в)³ = α³ + в³ + 3αв(α + в)
14. (α-в)³=α³-3α²в+3αв²-в³
15. α³ + в³ = (α + в) (α² -αв + в²)
16. α³ + в³ = (α+ в)³ -3αв(α+ в)
17. α³ -в³ = (α -в) (α² + αв + в²)
18. α³ -в³ = (α-в)³ + 3αв(α-в)

ѕιη0° =0
ѕιη30° = 1/2
ѕιη45° = 1/√2
ѕιη60° = √3/2
ѕιη90° = 1
¢σѕ ιѕ σρρσѕιтє σƒ ѕιη
тαη0° = 0
тαη30° = 1/√3
тαη45° = 1
тαη60° = √3
тαη90° = ∞
¢σт ιѕ σρρσѕιтє σƒ тαη
ѕє¢0° = 1
ѕє¢30° = 2/√3
ѕє¢45° = √2
ѕє¢60° = 2
ѕє¢90° = ∞
¢σѕє¢ ιѕ σρρσѕιтє σƒ ѕє¢
2ѕιηα¢σѕв=ѕιη(α+в)+ѕιη(α-в)
2¢σѕαѕιηв=ѕιη(α+в)-ѕιη(α-в)
2¢σѕα¢σѕв=¢σѕ(α+в)+¢σѕ(α-в)
2ѕιηαѕιηв=¢σѕ(α-в)-¢σѕ(α+в)
ѕιη(α+в)=ѕιηα ¢σѕв+ ¢σѕα ѕιηв.
» ¢σѕ(α+в)=¢σѕα ¢σѕв - ѕιηα ѕιηв.
» ѕιη(α-в)=ѕιηα¢σѕв-¢σѕαѕιηв.
» ¢σѕ(α-в)=¢σѕα¢σѕв+ѕιηαѕιηв.
» тαη(α+в)= (тαηα + тαηв)/ (1−тαηαтαηв)
» тαη(α−в)= (тαηα − тαηв) / (1+ тαηαтαηв)
» ¢σт(α+в)= (¢σтα¢σтв −1) / (¢σтα + ¢σтв)
» ¢σт(α−в)= (¢σтα¢σтв + 1) / (¢σтв− ¢σтα)
» ѕιη(α+в)=ѕιηα ¢σѕв+ ¢σѕα ѕιηв.
» ¢σѕ(α+в)=¢σѕα ¢σѕв +ѕιηα ѕιηв.
» ѕιη(α-в)=ѕιηα¢σѕв-¢σѕαѕιηв.
» ¢σѕ(α-в)=¢σѕα¢σѕв+ѕιηαѕιηв.
» тαη(α+в)= (тαηα + тαηв)/ (1−тαηαтαηв)
» тαη(α−в)= (тαηα − тαηв) / (1+ тαηαтαηв)
» ¢σт(α+в)= (¢σтα¢σтв −1) / (¢σтα + ¢σтв)
» ¢σт(α−в)= (¢σтα¢σтв + 1) / (¢σтв− ¢σтα)

α/ѕιηα = в/ѕιηв = ¢/ѕιη¢ = 2я
» α = в ¢σѕ¢ + ¢ ¢σѕв
» в = α ¢σѕ¢ + ¢ ¢σѕα
» ¢ = α ¢σѕв + в ¢σѕα
» ¢σѕα = (в² + ¢²− α²) / 2в¢
» ¢σѕв = (¢² + α²− в²) / 2¢α
» ¢σѕ¢ = (α² + в²− ¢²) / 2¢α
» Δ = αв¢/4я
» ѕιηΘ = 0 тнєη,Θ = ηΠ
» ѕιηΘ = 1 тнєη,Θ = (4η + 1)Π/2
» ѕιηΘ =−1 тнєη,Θ = (4η− 1)Π/2
» ѕιηΘ = ѕιηα тнєη,Θ = ηΠ (−1)^ηα

1. ѕιη2α = 2ѕιηα¢σѕα
2. ¢σѕ2α = ¢σѕ²α − ѕιη²α
3. ¢σѕ2α = 2¢σѕ²α − 1
4. ¢σѕ2α = 1 − ѕιη²α
5. 2ѕιη²α = 1 − ¢σѕ2α
6. 1 + ѕιη2α = (ѕιηα + ¢σѕα)²
7. 1 − ѕιη2α = (ѕιηα − ¢σѕα)²
8. тαη2α = 2тαηα / (1 − тαη²α)
9. ѕιη2α = 2тαηα / (1 + тαη²α)
10. ¢σѕ2α = (1 − тαη²α) / (1 + тαη²α)
11. 4ѕιη³α = 3ѕιηα − ѕιη3α
12. 4¢σѕ³α = 3¢σѕα + ¢σѕ3α

🍄🍄🍄🍄🍄
» ѕιη²Θ+¢σѕ²Θ=1
» ѕє¢²Θ-тαη²Θ=1
» ¢σѕє¢²Θ-¢σт²Θ=1
» ѕιηΘ=1/¢σѕє¢Θ
» ¢σѕє¢Θ=1/ѕιηΘ
» ¢σѕΘ=1/ѕє¢Θ
» ѕє¢Θ=1/¢σѕΘ
» тαηΘ=1/¢σтΘ
» ¢σтΘ=1/тαηΘ
» тαηΘ=ѕιηΘ/¢σѕΘ

17/08/2014

Technical interview Questions

1. What is your strongest programming language (Java, ASP, C, C++, VB, HTML, C #, etc.)?
Point to remember: Before interview You should decide your Favorite programming language and be prepared based on that question.
2.Differences between C and Java?
1.JAVA is Object-Oriented while C is procedural.
2.Java is an Interpreted language while C is a compiled language.
3.C is a low-level language while JAVA is a high-level language.
4.C uses the top-down approach while JAVA uses the bottom-up approach.
5.Pointer go backstage in JAVA while C requires explicit handling of pointers.
6.The Behind-the-scenes Memory Management with JAVA & The User-Based Memory Management in C.
7.JAVA supports Method Overloading while C does not support overloading at all.
8.Unlike C, JAVA does not support Preprocessors, & does not really them.
9.The standard Input & Output Functions--C uses the printf & scanf functions as its standard input & output while JAVA uses the System.out.print & System.in.read functions.
10.Exception Handling in JAVA And the errors & crashes in C.
3.In header files whether functions are declared or defined?
Functions are declared within header file. That is function prototypes exist in a header file,not function bodies. They are defined in library (lib).
4.What are the different storage classes in C ?
There are four types of storage classes in C. They are extern, register, auto and static
5.What does static variable mean?
Static is an access qualifier. If a variable is declared as static inside a function, the scope is limited to the function,but it will exists for the life time of the program. Values will be persisted between successive
calls to a function
6.How do you print an address ?
Use %p in printf to print the address.
7.What are macros? what are its advantages and disadvantages?
Macros are processor directive which will be replaced at compile time.
The disadvantage with macros is that they just replace the code they are not function calls. similarly the advantage is they can reduce time for replacing the same values.
8.Difference between pass by reference and pass by value?
Pass by value just passes the value from caller to calling function so the called function cannot modify the values in caller function. But Pass by reference will pass the address to the caller function instead of value if called function requires to modify any value it can directly modify.
9.What is an object?
Object is a software bundle of variables and related methods. Objects have state and behavior
10.What is a class?
Class is a user-defined data type in C++. It can be created to solve a particular kind of problem. After creation the user need not know the specifics of the working of a class.
11.What is the difference between class and structure?
Structure: Initially (in C) a structure was used to bundle different type of data types together to perform a particular functionality. But C++ extended the structure to contain functions also.
The major difference is that all declarations inside a structure are by default public.
Class: Class is a successor of Structure. By default all the members inside the class are private.
12. What is ponter?
Pointer is a variable in a program is something with a name, the value of which can vary. The way the compiler and linker handles this is that it assigns
a specific block of memory within the computer to hold the value of that variable.
13.What is the difference between null and void pointer?
A Null pointer has the value 0. void pointer is a generic pointer introduced by ANSI. Generic pointer can hold the address of any data type.
14.what is function overloading
Function overloading is a feature of C++ that allows us to create multiple functions with the same name, so long as they have different parameters.Consider the following function:
int Add(int nX, int nY)
{
return nX + nY;
}
15.What is function overloading and operator overloading?
Function overloading: C++ enables several functions of the same name to be defined, as long as these functions have different sets of parameters (at least as far as their types are concerned). This capability is called function overloading. When an overloaded function is called, the C++ compiler selects the proper function by examining the number, types and order of the arguments in the call. Function overloading is commonly used to create several functions of the same name that perform similar tasks but on different data types.
Operator overloading allows existing C++ operators to be redefined so that they work on objects of user-defined classes. Overloaded operators are syntactic sugar for equivalent function calls. They form a pleasant facade that doesn't add anything fundamental to the language (but they can improve understandability and reduce maintenance costs).
16.what is friend function?
A friend function for a class is used in object-oriented programming to allow access to public, private, or protected data in the class from the outside.
Normally, a function that is not a member of a class cannot access such information; neither can an external class. Occasionally, such access will be advantageous for the programmer. Under these circumstances, the function or external class can be declared as a friend of the class using the friend keyword.
17.What do you mean by inline function?
The idea behind inline functions is to insert the code of a called function at the point where the function is called. If done carefully, this can improve the application's performance in exchange for increased compile time and possibly (but not always) an increase in the size of the generated binary executables.
18. Tell me something about abstract classes?
An abstract class is a class which does not fully represent an object. Instead, it represents a broad range of different classes of objects. However, this representation extends only to the features that those classes of objects have in common. Thus, an abstract class provides only a partial description of its objects.
19.What is the difference between realloc() and free()?
The free subroutine frees a block of memory previously allocated by the malloc subroutine. Undefined results occur if the Pointer parameter is not a valid pointer. If the Pointer parameter is a null value, no action will occur. The realloc subroutine changes the size of the block of memory pointed to by the Pointer parameter to the number of bytes specified by the Size parameter and returns a new pointer to the block. The pointer specified by the Pointer parameter must have been created with the malloc, calloc, or realloc subroutines and not been deallocated with the free or realloc subroutines. Undefined results occur if the Pointer parameter is not a valid pointer.
20.What is the difference between an array and a list?
Array is collection of homogeneous elements. List is collection of heterogeneous elements.
For Array memory allocated is static and continuous. For List memory allocated is dynamic and Random.
Array: User need not have to keep in track of next memory allocation.
List: User has to keep in Track of next location where memory is allocated.
Array uses direct access of stored members, list uses sequential access for members.
21.What are the differences between structures and arrays?
Arrays is a group of similar data types but Structures can be group of different data types
22.What is data structure?
A data structure is a way of organizing data that considers not only the items stored, but also their relationship to each other. Advance knowledge about the relationship between data items allows designing of efficient algorithms for the manipulation of data.
23. Can you list out the areas in which data structures are applied extensively?
Compiler Design,
Operating System,
Database Management System,
Statistical analysis package,
Numerical Analysis,
Graphics,
Artificial Intelligence,
Simulation
24.What are the advantages of inheritance?
It permits code reusability. Reusability saves time in program development. It encourages the reuse of proven and debugged high-quality software, thus reducing problem after a system becomes functional.
25. what are the two integrity rules used in DBMS?
The two types of integrity rules are referential integrity rules and entity integrity rules. Referential integrity rules dictate that a database does not contain orphan foreign key values. This means that
A primary key value cannot be modified if the value is used as a foreign key in a child table. Entity integrity dictates that the primary key value cannot be Null.
26. Tell something about deadlock and how can we prevent dead lock?
In an operating system, a deadlock is a situation which occurs when a process enters a waiting state because a resource requested by it is being held by another waiting process, which in turn is waiting for another resource. If a process is unable to change its state indefinitely because the resources requested by it are being used by other waiting process, then the system is said to be in a deadlock.
Mutual Exclusion: At least one resource must be non-shareable.[1] Only one process can use the resource at any given instant of time.
Hold and Wait or Resource Holding: A process is currently holding at least one resource and requesting additional resources which are being held by other processes.
No Preemption: The operating system must not de-allocate resources once they have been allocated; they must be released by the holding process voluntarily.
Circular Wait: A process must be waiting for a resource which is being held by another process, which in turn is waiting for the first process to release the resource. In general, there is a set of waiting processes, P = {P1, P2, ..., PN}, such that P1 is waiting for a resource held by P2, P2 is waiting for a resource held by P3 and so on till PN is waiting for a resource held by P1.[1][7]
Thus prevention of deadlock is possible by ensuring that at least one of the four conditions cannot hold.
27. What is Insertion sort, selection sort, bubble sort( basic differences among the functionality of the three sorts and not the exact algorithms)
28. What is Doubly link list?
A doubly linked list is a linked data structure that consists of a set of sequentially linked records called nodes. Each node contains two fields, called links, that are references to the previous and to the next node in the sequence of nodes. The beginning and ending nodes' previous and next links, respectively, point to some kind of terminator, typically a sentinel node or null, to facilitate traversal of the list. If there is only one sentinel node, then the list is circularly linked via the sentinel node. It can be conceptualized as two singly linked lists formed from the same data items, but in opposite sequential orders.
29.What is data abstraction? what are the three levels of data abstraction with Example?
Abstraction is the process of recognizing and focusing on important characteristics of a situation or object and leaving/filtering out the un-wanted characteristics of that situation or object.
Lets take a person as example and see how that person is abstracted in various situations
A doctor sees (abstracts) the person as patient. The doctor is interested in name, height, weight, age, blood group, previous or existing diseases etc of a person
An employer sees (abstracts) a person as Employee. The employer is interested in name, age, health, degree of study, work experience etc of a person.
Abstraction is the basis for software development. Its through abstraction we define the essential aspects of a system. The process of identifying the abstractions for a given system is called as Modeling (or object modeling).
Three levels of data abstraction are:
1. Physical level : how the data is stored physically and where it is stored in database.
2. Logical level : what information or data is stored in the database. eg: Database administrator
3.View level : end users work on view level. if any amendment is made it can be saved by other name.
30.What is command line argument?
Getting the arguments from command prompt in c is known as command line arguments. In c main function has three arguments.They are:
Argument counter
Argument vector
Environment vector
31.Advantages of a macro over a function?
Macro gets to see the Compilation environment, so it can expand . It is expanded by the preprocessor.
32.What are the different storage classes in C?
Auto,register,static,extern
33.Which header file should you include if you are to develop a function which can accept variable number of arguments?
stdarg.h
34.What is cache memory ?
Cache Memory is used by the central processing unit of a computer to reduce the average time to access memory. The cache is a smaller, faster memory
which stores copies of the data from the most frequently used main memory locations. As long as most memory accesses are cached memory locations, the average
latency of memory accesses will be closer to the cache latency than to the latency of main memory.
35.What is debugger?
A debugger or debugging tool is a computer program that is used to test and debug other programs
36. Const char *p , char const *p What is the difference between the above two?
1) const char *p - Pointer to a Constant char ('p' isn't modifiable but the pointer is)
2) char const *p - Also pointer to a constant Char
However if you had something like:
char * const p - This declares 'p' to be a constant pointer to an char. (Char p is modifiable but the pointer isn't)
37. What is Memory Alignment?
Data structure alignment is the way data is arranged and accessed in computer memory. It consists of two separate but related issues: data alignment and data structure padding.
38.Explain the difference between 'operator new' and the 'new' operator?
The difference between the two is that operator new just allocates raw memory, nothing else. The new operator starts by using operator new to allocate memory, but then it invokes the constructor for the right type of object, so the result is a real live object created in that memory. If that object contains any other objects (either embedded or as base classes) those constructors as invoked as well.
39. Difference between delete and delete[]?
The keyword delete is used to destroy the single variable memory created dynamically which is pointed by single pointer variable.
Eg: int *r=new(int)
the memory pointed by r can be deleted by delete r.
delete [] is used to destroy array of memory pointed by single pointer variable.
Eg:int *r=new(int a[10])
The memory pointed by r can be deleted by delete []r.
40. What is conversion constructor?
A conversion constructor is a single-parameter constructor that is declared without the function specifier 'explicit'. The compiler uses conversion constructors to convert objects from the type of the first parameter to the type of the conversion constructor's class.To define implicit conversions, C++ uses conversion constructors, constructors that accept a single parameter and initialize an object to be a copy of that parameter.
41.What is a spanning Tree?
A spanning tree is a tree associated with a network. All the nodes of the graph appear on the tree once. A minimum spanning tree is a spanning tree organized so that the total edge weight between nodes is minimized.
42. Why should we use data ware housing and how can you extract data for analysis with example?
If you want to get information on all the techniques of designing, maintaining, building and retrieving data, Data warehousing is the ideal method. A data warehouse is premeditated and generated for supporting the decision making process within an organization.
Here are some of the benefits of a data warehouse:
o With data warehousing, you can provide a common data model for different interest areas regardless of data's source. In this way, it becomes easier to report and analyze information.
o Many inconsistencies are identified and resolved before loading of information in data warehousing. This makes the reporting and analyzing process simpler.
o The best part of data warehousing is that the information is under the control of users, so that in case the system gets purged over time, information can be easily and safely stored for longer time period.
o Because of being different from operational systems, a data warehouse helps in retrieving data without slowing down the operational system.
o Data warehousing enhances the value of operational business applications and customer relationship management systems.
o Data warehousing also leads to proper functioning of support system applications like trend reports, exception reports and the actual performance analyzing reports.
Data mining is a powerful new technology to extract data for analysis.
43.Explain recursive function & what is the data structures used to perform recursion?
a) A recursive function is a function which calls itself.
b) The speed of a recursive program is slower because of stack overheads. (This attribute is evident if you run above C program.)
c) A recursive function must have recursive conditions, terminating conditions, and recursive expressions.
Stack data structure . Because of its LIFO (Last In First Out) property it remembers its caller so knows whom to return when the function has to return. Recursion makes use of system stack for storing the return addresses of the function calls. Every recursive function has its equivalent iterative (non-recursive) function. Even when such equivalent iterative procedures are written, explicit stack is to be used.
44.Differentiate between Complier and Interpreter?
An interpreter reads one instruction at a time and carries out the actions implied by that instruction. It does not perform any translation. But a compiler translates the entire instructions
45.What is scope of a variable?
Scope refers to the visibility of variables. It is very useful to be able to limit a variable's scope to a single function. In other words, the variable wil have a limited scope
46.What is an interrupt?
Interrupt is an asynchronous signal informing a program that an event has occurred. When a program receives an interrupt signal, it takes a specified action.
47.What is user defined exception in Java?
The keywords used in java application are try, catch and finally are used in implementing used-defined exceptions. This Exception class inherits all the method from Throwable class.
48.What is java Applet?
Applet is java program that can be embedded into HTML pages. Java applets runs on the java enables web browsers such as mozila and internet explorer. Applet is designed to run remotely on the client browser, so there are some restrictions on it. Applet can't access system resources on the local computer. Applets are used to make the web site more dynamic and entertaining.
49.What do you know about the garbage collector?
Garbage collection is the systematic recovery of pooled computer storage that is being used by a program when that program no longer needs the storage. This frees the storage for use by other programs
(or processes within a program). It also ensures that a program using increasing amounts of pooled storage does not reach its quota (in which case it may no longer be able to function).
Garbage collection is an automatic memory management feature in many modern programming languages, such as Java and languages in the .NET framework. Languages that use garbage collection are often interpreted or run within a virtual machine like the JVM. In each case, the environment that runs the code is also responsible for garbage collection.
50.Write a Binary Search program
int binarySearch(int arr[],int size, int item)
{
int left, right, middle;
left = 0;
right = size-1;
while(left arr[middle])
{
left = middle+1;
}
else
{
right = middle-1;
}
}
return(-1);
}
51.What are enumerations?
An enumeration is a data type, used to declare variable that store list of names. It is act like a database, which will store list of items in the variable. example: enum shapes{triangle, rectangle,...
52.What is static identifier?
The static identifier is used for initializing only once, and the value retains during the life time of the program / application. A separate memory is allocated for ‘static’ variables. This value can be used between function calls. The default value of an uninitialized static variable is zero. A function can also be defined as a static function, which has the same scope of the static variable.
53.What is Cryptography?
Cryptography is the science of enabling secure communications between a sender and one or more recipients. This is achieved by the sender scrambling a message (with a computer program and a secret key) and leaving the recipient to unscramble the message (with the same computer program and a key, which may or may not be the same as the sender's key).
There are two types of cryptography: Secret/Symmetric Key Cryptography and Public Key Cryptography
54.What is encryption?
Encryption is the transformation of information from readable form into some unreadable form.
55.What is decryption?
Decryption is the reverse of encryption; it's the transformation of encrypted data back into some intelligible form.
56.What exactly is a digital signature?
Just as a handwritten signature is affixed to a printed letter for verification that the letter originated from its purported sender, digital signature performs the same task for an electronic message. A digital signature is an encrypted version of a message digest, attached together with a message.

Address

Secunderabad
500019

Website

Alerts

Be the first to know and let us send you an email when Computer Science and Engineering posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share