Owner: IT Interview Questions URL:http://www.itinterviewquestion.com/ Join Date: Wed, 14 Nov 2007 02:48:21 -0600 Rating:0 Site Description: Tech Interview Questions | .Net Interview Questions | Java Interview questions | Testing Tools Interview questions | Database Interview Questions | Resume Writing | Resume Tips | Testing tools Interview questions | Candidate Interview Questions | IT inter Site statistics:Click here
OS important Interview Questions 2007-11-15 12:48:03 1) Write short note o the following:
A) Semaphore
b) Critical section
c) Resource allocation
2) Explain the functions of operating system
3) What is a dead lock? Explain deadlock detection and prevention.
4) Explain process management in multiprocessor operating systems.
5) Explain virtual storage implementation using paging and segmentation.
6) What is a file system? Explain operations on UNIX file system.
7) Explain software implementation of critical section.
Should the following instructions be privileged or not?
I) clear memory ii) turn off interrupts
9) What is a system call?
10) What is the difference between job scheduling and process scheduling?
11) Is RR scheduling preemptive or not? Why?
12) What is busy waiting?
13) What is starvation?
14) Explain the difference between logical and physical address?
15) What is a page fault?
16) What is a boot block?
17) What is a shell?
18) Discuss briefly the advantages of distributed counting?
19) What is dual mode operation? How it is
General Technical Interview Questions 2007-11-14 04:21:01 1. A 2MB PCM(pulse code modulation) has
a) 32 channels
b) 30 voice channels & 1 signalling channel.
c) 31 voice channels & 1 signalling channel.
d) 32 channels out of which 30 voice channels, 1 signalling channel, & 1 Synchronizatio channel.
Ans: (c)
2. Time taken for 1 satellite hop in voice communication is
a) 1/2 second
b) 1 seconds
c) 4 seconds
d) 2 seconds
Ans: (a)
3. Max number of satellite hops allowed in voice communication is :
a) only one
b) more han one
c) two hops
d) four hops
Ans: (c)
4. What is the max. decimal number that can be accomodated in a byte.
a) 128
b) 256
c) 255
d) 512
Ans: (c)
5. Conditional results after execution of an instruction in a micro processor is stored in
a) register
b) accumulator
c) flag register
d) flag register part of PSW(Program Status Word)
Ans: (d)
6. Frequency at which VOICE is sampled is
a) 4 Khz
b) 8 Khz
c) 16 Khz
d) 64 Khz
Ans: (a)
7. Line of Sight is
a) Straight Line
b) Parabolic
c) Tx & Rx should be visible to each othe Read more:General
, Technical
MS SQL Server Interview Question 2007-11-14 04:16:24 What are different normalization forms?
1NF: Eliminate Repeating Groups
Make a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain.
2NF: Eliminate Redundant Data If an attribute depends on only part of a multi-valued key, remove it to a separate table.
3NF: Eliminate Columns Not Dependent On Key If attributes do not contribute to a description of the key, remove them to a separate table. All attributes must be directly dependent on the primary key
BCNF: Boyce-Codd Normal Form If there are non-trivial dependencies between candidate key attributes, separate them out into distinct tables.
4NF: Isolate Independent Multiple Relationships No table may contain two or more 1:n or n:m relationships that are not directly related.
5NF: Isolate Semantically Related Multiple Relationships There may be practical constrains on information that justify separating logically related many-to-many
relationshi Read more:SQL
, Question
, SQL Server
Interview Question on VB.NET 2007-11-14 04:13:06 What is the different between ASP.NET and VB.NET?
What debugging tools come with the .NET SDK?
What is the difference between structures and enumeration?
What is Value type and reference type in .Net?
What are the types of assemblies?
What is manifest?
How would you implement inheritance using VB.NET/C#?
What is the difference between repeater over datalist and datagrid?
What are VSDISCO files?
Name two properties common in every validation control?
What namespace does the Web page belong in the .NET Framework class hierarchy?
Advantages of VB.NET?
Are there any third party logging components available?
Does the .NET Framework have in-built support for serialization?
Is it true that objects don’t always get destroyed immediately when the last reference goes away?
How does assembly versioning work?
How do assemblies find each other?
What is the CTS?
Difference Between VB and VB.Net.
What is Structured Exception Handling?
How can we Handle Exception in VB.Net?
Which of the following is Read more:Question
C++ Interview Questions 2007-11-14 04:12:27 1) List object oriented methodologies
2) Name some object oriented languages
3) What are the features of object oriented language
4) What is method overloading
5) What is method overriding
6) When would one define a static variable / global variable ? Difference between them?
7) What is Default constructor?
What is Copy constructor?
9) What is Conversion constructor?
10) Difference between method and message?
11) Difference between C++ Struct and C++ class?
12) What is an abstract class?
13) What is pure virtual class?
14) What do you understand by namescape?
15) What is Virtual Destructor?
16) What is the diff between “new” and “operator new” ?
17) What is operator overloading? What operators can be overloaded?
18) What does static variable mean?
19) What is static identifier?
20) What is a pointer?
21) What is a reference?
22) Difference between pointer and reference?
23) What is a structure?
24) What are the differences between structures and arrays?
25) What is difference
.Net Web services & Remoting interview questions 2007-11-14 04:10:46 1. What is a application domain?
2. What is .NET Remoting
?
3. Which class does the remote object has to inherit
4. What are two different types of remote object creation mode in .NET ?
5. Describe in detail Basic of SAO architecture of Remoting?
6. What are the situations you will use singleton architecture in remoting ?
7. What is fundamental of published or precreated objects in Remoting ?
8. What are the ways client can create object on server in CAO model ?
9. Are CAO stateful in nature ?
10. In CAO model when we want client objects to be created by “NEW” precautions to be taken ?
11. Is it a good design practice to distribute the implementation to Remoting Client ?
12. What is LeaseTime,SponsorshipTime ,RenewonCallTime and LeaseManagerPollTime?
13. Which config file has all the supported channels/protocol ?
14. How can you specify remoting parameters using Config files ?
15. Can Non-Default constructors be used with Single Call SAO?
16. How can we call methods in remoting Asy Read more:interview
, questions
JSP interview questions 2007-11-14 04:09:55 1. Can you explain JSP page life cycle?
2. What is EL?
3. how does EL search for an attribute?
4. What are the implicit EL objects in JSP?
5. How can we disable EL?
6. what is JSTL?
7. Can you explain in short what the different types of JSTL tags are?
8. How can we use beans in JSP?
9. What is tag for
10. What are JSP directives?
11. what are Page directives?
12. what are include directives?
13. Can you explain taglib directives?
14. How does JSP engines instantiate tag handler classes instances?
15. what’s the difference between JavaBeans and taglib directives?
16. what are the different scopes an object can have in a JSP page?
17. what are different implicit objects of JSP?
18. what are different Authentication Options available in servlets?
19. Can you explain how do we practically implement security on a resource?
20. How do we practically implement form based authentication?
21. How do we authenticate using JDBC?
22. Can you explain JDBCRealm?
23. Can you explain how do you con Read more:interview
, questions
Servlets Interview questions 2007-11-14 04:09:23 1. What are Servlets?
2. What are advantages of servlets over CGI?
3. Can you explain Servlet life cycle?
4. What are the two important API’s in for Servlets?
5. Can you explain in detail “javax.servlet” package?
6. What’s the use of ServletContext?
7. How do we define an application level scope for servlet?
8. What’s the difference between GenericServlet and HttpServlet?
9. Can you explain in detail javax.servlet.http package?
10. What’s the architecture of a Servlet package?
11. Why is HTTP protocol called as a stateless protocol?
12. What are the different ways we can maintain state between requests?
13. What is URL rewriting?
14. What are cookies?
15. What are sessions in Servlets?
16. What’s the difference between getSession(true) and getSession(false) ?
17. What’s the difference between “doPost” and “doGet” methods?
18. Which are the different ways you can communicate between servlets?
19. What is functionality of “RequestDispatcher” object?
20. How do Read more:questions
GD Tips & Topics 2007-11-14 04:06:41 1. Always are the initiator and concluder of the GD then being a participant.
2. But if you are participant always try to be the most vainly/key participant.
3. Put points firmly and always try to get others support too.
4. If you find that the discussion is going off-track then never loose an opportunity to bring it back to stream this is the best point to score max.
5. Try to keep latest information on the topic.
6. Be very polite, people may try to provoke you to get more points but try to keep cool.
7. Most important don’t wait for your turn to speak when discussion is on. Interrupt politely if you want to put forward your points.
8. Last but not the least keeps a tab on the time given for discussion. Score points by wrapping up the discussion if you feel that the discussion is heating but the time is going to be over.
9. During conclusion, do end with the conclusion note. That shows your leadership quality.
Best scoring points are:
1. initiation of discussion,
2. always keeping/
General Guidelines In Answering Interview Questions 2007-11-14 04:06:10 Be realistic: You know your worth more than any other person. Are you perfect? No. Nobody is, then how can life be perfect? As such, achieving everything is next to impossible. You have to find out what your priorities are; a decision has to be made by you about what you really want to have and what you can let go of.
Say in the initial years of your career, you have limited earnings. You plan to buy your own house, isn’t it practical to think of buying an apartment rather than a penthouse?
Be self-reliant : Your life is in your own hands and so is your career. Gone are the days of government jobs, the new set-up demands a change in your thought process. The economy is fast paced and one has to live up to it. Security is extinct in the job sphere. Your boss can also be fired if he is not performing as per the organization’s expectations.
So you can’t rely on him for job security. You have to take charge of your career yourself, plan it in such a way that there is a constant growt Read more:General
, Guidelines
Oracle Interview Questions-7 2007-11-20 12:51:52 131. How do you know which index a table is using?
132. How will you test the stored procedure taking two parameters namely first name and last name returning full name?
133. How do you find the error, how can you know the number of rows effected by last SQL statement?
134. How can you get @@error and @@row count at the same time?
135. What are sub-queries? Give example? In which case sub-queries are not feasible?
136. What is the type of joins? When do we use Outer and Self joins?
137. Which virtual table does a trigger use?
138. How do you measure the performance of a stored procedure?
139. Questions regarding raise error?
140. Questions on identity?
141. If there is failure during updating of certain rows, what will be the state?
ShareThis
Bookmark It
Hide Sites
Read more:Oracle
Oracle Interview Questions-6 2007-11-20 12:51:10 111. Difference between Cluster and Non-cluster index?
112. What is a table called, if it does have neither Cluster nor Non-cluster Index?
113. Explain DBMS, RDBMS?
114. Explain basic SQL queries with SELECT from where Order By, Group By-Having?
115. Explain the basic concepts of SQL server architecture?
116. Explain couple pf features of SQL server 2000(Scalability, Availability, Integration with internet, etc.)?
117. Explain fundamentals of Data ware housing & OLAP?
118. Explain the new features of SQL server 2000?
119. How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
120. What is data integrity? Explain constraints?
121. Explain some DBCC commands?
122. Explain sp_configure commands, set commands?
123. Explain what are db_options used for?
124. What are the basic functions for master, msdb, tempdb databases?
125. What is a job?
126. What are tasks?
127. What are primary keys and foreign keys?
128. How would you update the rows which are divisible by 10, given a set Read more:Oracle
Oracle Interview Questions-5 2007-11-20 12:50:25 81. What is the purpose of using COLLATE in a query?
82. What is a trigger?
83. What is one of the first things you would do to increase performance of a query? Example “a query ran yesterday took 30 seconds, today it takes 6 minutes”
84. What is an execution plan? When would you use it? How would you view the execution plan?
85. What is the STUFF function and how does it differ from the REPLACE function?
86. What does it mean to have quoted_identifier on? What are the implications of having it off?
87. What are the different types of replication? How are they used?
88. What is the difference between a local and a global variable?
89. What is the difference between a Local temporary table and a Global temporary table? How is each one used?
90. What are cursors? Name four types of cursors and when each one would be applied?
91. What is the purpose of UPDATE STATISTICS?
92. How do you use DBCC statements to monitor various aspects of a SQL server installation?
93. How do you load lar Read more:Oracle
Oracle Interview Questions-4 2007-11-20 12:48:48 61. Can you explain the role of each service?
SQL SERVER - is for running the databases
SQL AGENT - is for automation such as Jobs, DB Maintenance, Backups
DTC - Is for linking and connecting to other SQL Servers
62. How do you troubleshoot SQL Server if it’s running very slow?
First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes
63. Let’s say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
First I will look to ensure that port settings are proper on server and client Network utility for connections. ODBC is properly configured at client end for connection ——Make pipe & read pip Read more:Oracle
Oracle Interview Questions-3 2007-11-20 12:45:29 41. What are the basic difference between clustered and a non-clustered index?
The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.
42. What are cursors?
Well cursors help us to do an operation on a set of data that we retrieve by commands such as Select columns from table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retrieval one by one and remove rows which have duplicate values.
43. When do we use the UPDATE_STATISTICS command?
This command is basically used when we do a large processing of data. If we do a large amount of deletions any modification or Bulk Copy in Read more:Oracle
Oracle Interview Questions-2 2007-11-20 12:40:29 1. What is an oracle instance?
2. What is a view?
3. What is referential integrity?
4. Name the data dictionary that stores user-defined constraints?
5. What is a collection of privileges?
6. What is a snapshot?
7. What is a synonym?
8. What is a cursor?
9. What is a sequence?
10. What is a trigger?
11. What is an exception?
12. What is a partition of table?
13. What are pseudo-columns in SQL? Give examples?
14. What are the Data Control statements?
15. What is a schema?
16. What is a type?
17. What is a data model?
18. What is a relation?
19. Advantages of redo log files?
20. What is an Archiver?
21. What is a database buffer cache?
22. What are the 5 background processes in Oracle
?
23. %type and %row type are attributes for?
24. What are the 2 steps in a two-phase commit?
25. What is a union, intersect, minus?
26. What is a join, explain the types of joins?
27. What is a co-related sub-query?
28. ODBC stands for?
29. Data-type used to work with integers is?
30. Describe data models?
50 Servlets Interview Questions & Answers 2007-11-20 12:09:32 1) What is servlet?
Servlets are modules that extend request/response-oriented servers, such as java-enabled web servers. For example, a servlet might be responsible for taking data in an HTML order-entry form and applying the business logic used to update a company’s order database.
2) What are the classes and interfaces for servlets?
There are two packages in servlets and they are javax.servlet and javax.servlet.http.
Javax.servlet contains:
Interfaces Classes
Servlet Generic Servlet
ServletRequest ServletInputStream
ServletResponse ServletOutputStream
ServletConfig ServletException
ServletContext UnavailableException
Single
Interview questions on C/C++ 2007-11-17 13:33:02 Tell how to check whether a linked list is circular.
A: Create two pointers, each set to the start of the list. Update each as follows:
while (pointer1) {
pointer1 = pointer1->next;
pointer2 = pointer2->next; if (pointer2) pointer2=pointer2->next;
if (pointer1 == pointer2) {
print (”circular
”);
}
}
OK, why does this work?
If a list is circular, at some point pointer2 will wrap around and be either at the item just before pointer1, or the item before that. Either way, it’s either 1 or 2 jumps until they meet.
How can you quickly find the number of elements stored in a a) static array b) dynamic array ?
Why is it difficult to store linked list in an array?
How can you find the nodes with repetitive data in a linked list?
Write a prog to accept a given string in any order and flash error if any of the character is different. For example : If abc is the input then abc, bca, cba, cab bac are acceptable but aac or bcd are unacceptable.
This is a C question that I h Read more:questions
Core Java & OOP’s Interview questions 2007-11-17 13:28:22 1. What is JVM (Java Virtual Machine)?
2. What is JIT (Just-in-Time) Compilation?
3. What is Object Oriented Programming?
4. What’s a Class?
5. What’s an Object?
6. What’s the relation between Classes and Objects?
7. What are different properties provided by Object-oriented systems?
8. How can we implement polymorphisms in Java?
9. What’s an interface and how will you go about implementing an interface?
10. What is an Abstract class?
11. What are Abstract methods?
12. What’s the difference between “Abstract” classes and “Interfaces”?
13. What’s difference between Static and Non-Static fields of a class?
14. What are inner classes and what’s the practical implementation of inner classes?
15. What are packages?
16. What is a constructor in class?
17. Can constructors be parameterized?
18. What is the use if “instanceof” keyword?
19. What are Native methods in Java?
20. How do refer to a current instance of object?
21. Explain in depth Garbage collector?
22. How Read more:questions
.NET Integration Interview Questions 2007-11-17 13:26:35 1. What are steps to load a .NET code in SQL SERVER 2005?
2. How can we drop an assembly from SQL SERVER?
3. Are changes made to assembly updated automatically in database?
4. Why do we need to drop assembly for updating changes?
5. How to see assemblies loaded in SQL Server?
6. I want to see which files are linked with which assemblies?
7. Does .NET CLR and SQL SERVER run in different process?
8. Does .NET controls SQL SERVER or is it vice-versa?
9. Is SQLCLR configured by default?
10. How to configure CLR for SQL SERVER?
11. Is .NET feature loaded by default in SQL Server?
12. How does SQL Server control .NET run-time?
13. What’s a “SAND BOX” in SQL Server 2005?
14. What is an application domain?
15. How are .NET Appdomain allocated in SQL SERVER 2005?
16. What is Syntax for creating a new assembly in SQL Server 2005?
17. Do Assemblies loaded in database need actual .NET DLL?
18. You have a assembly which is dependent on other assemblies, will SQL Server load the dependent asse
SQL Server architecture Interview Questions 2007-11-26 03:39:58 What is a transaction and what are ACID properties?
A transaction is a logical unit of work in which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, Durability. These are the properties of a transaction. For more information and explanation of these properties, see SQL
Server books online or any RDBMS fundamentals text book.
Explain different isolation levels
An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server
isolation level is Read Committed. Here are the other isolation levels (in the ascending order of isolation): Read Uncommitted, Read Committed, Repeatable Read, Serializable. See SQL Server books online for an explanation of the isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets you customize the isolation level at the connection level.
CREATE INDEX myIndex ON myTable(myColumn)
What type of Index will get created after executing the above
PHP Interview Questions 2007-11-26 03:34:22 1. How can we repair a MySQL table?
2. What are the advantages of stored procedures, triggers, indexes?
3. What is maximum size of a database in MySQL?
4. Give the syntax of Grant and Revoke commands?
5. Explain Normalization concept?
6. What is the maximum length of a table name, database name, and fieldname in MySQL?
7. How many ways we can we find the current date using MySQL?
8. What are the advantages and disadvantages of Cascading Style Sheets?
9. What type of inheritance that PHP supports?
10. How can increase the performance of MySQL select query?
11. How many values can the SET function of MySQL take?
12. What are the other commands to know the structure of table using MySQL commands except explain command?
13. How many tables will create when we create table, what are they?
14. What is the purpose of the following files having extensions 1) .frm 2) .myd 3) .myi? What do these files contain?
15. How can we find the number of rows in a table using MySQL?
16. How can we find the
Important ASP.NET Interview Questions 2007-11-26 03:29:27 What are steps in an asp .net page lifecycle?
Init() - when the page is instantiated
Load() - when the page is loaded into server memory
PreRender() - the brief moment before the page is displayed to the user as HTML
Unload() - when page finishes loading.
2.What is the main difference between Response.Write() and Response.Output.Write()?
With Response.Outout.Write options are available to you to write the formatted out put.
3.When implementing classes what are the specifics of an abstract method?
An Abstract method does not provide any implementation. The class containing it can not be instantiated it must be inherited. The deriving class must override abstract methods declared in parent class, unless it is an abstract class it self.
4.List all Validation Controls available in asp .net?
RequiredFieldValidator : Checks if a control has a value.
RangeValidator : Checks if the control’s value is within a certain range.
RegularExpressionValidator : Checks whether the value of an input co
Core Java Interview Questions 2007-11-26 03:22:57 How could Java classes direct program messages to the system console, but error messages, say to a file?
The class System has a variable out that represents the standard output, and the variable err that represents the standard error device. By default, they both point at the system console. This how the standard output could be re-directed:
Stream st = new Stream(new FileOutputStream(”output.txt”)); System.setErr(st); System.setOut(st);
What’s the difference between an interface and an abstract class?
An abstract class may contain code in method bodies, which is not allowed in an interface. With abstract classes, you have to inherit your class from it and Java does not allow multiple inheritance. On the other hand, you can implement multiple interfaces in your class.
Why would you use a synchronized block vs. synchronized method?
Synchronized blocks place locks for shorter periods than synchronized methods.
Explain the usage of the keyword transient?
This keyword ind
General Programming Interview Questions 2007-11-26 03:14:47 1. John weighs twice as much as Marcia. Marcia’s weight is 60% of Bob’s weight. Dave weighs 50% of Lee’s weighs 190% of John’s wight. Which of these 5 persons wighs the least?
A) Bob B) Dave C) John D) Lee E) Marcia?
Ans: E
2. A trip takes 6 hours to complete. After traveling 1/4 of an hour, 1 3/8hours, and 2 1/3 hours, how much time does need to complete the trip?
A) 2 1/12hours B) 2hours, 2 1/2 minutes C) 2 hours,5minutes D) 2 1/8 hours?
Ans) B
3. It takes 30 days to fill a laboratory dish with bacteria. If the size of the bacteria doubles each day, how long did it take for the bacteria to fill one half of dish?
Ans) 29 days
4. A car wash can wash 8 cars in 18 minutes. At this rate, how many cars can the car wash wash in 3 hours?
Ans) 80
5. If the ratio of the areas of 2 squares is 2:1, then what is the ratio of the perimeters of the squares?
Ans) sqrt(2):1
6. There are three types of tickets available for a concert: orchestra, which cost $12 each; balcony, which cost$9 Read more:General
, Programming
Puzzles Interview Questions 2007-11-26 03:10:53 A boy multiplied a number with 10 and got 100. If he divided it by 10, what would be the answer?
1
If a 12 shell cupboard requires 18 ft of wall space then how much wall space would a 30 cup shelf require?
45
The average salary of three employee is $950 per week. If one employee earns $1150 and other earns $650 rupees, how much will third be earn?
$1050
During a given week a programmer spend 1/4 of his time preparing charts,3/8 of his time for coding,rest of his time for debugging the programs.If he had 48 hrs during the week how many hours did he spend debugging the program.
18hrs
A 16 story building has 12000ft on each floor. Company A rents 7 floors and company B rents 4 floors. What is the number of square feet of unrented floor space?
60000 sqft
A man owns 2/3 of a computer service buroue business and sells 3/4 of his share for $75000. What is the value of the business?
150,000
A computer printer produces 176400 lines in a given day. If the printer is in operation for 7 hrs d Read more:Puzzles
Oracle Data Access Interview Questions 2007-11-26 03:04:07 1. Define Transaction ?
A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user.
2. When does a Transaction end ?
When it is committed or Rollbacked.
3. What does COMMIT do ?
COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.
4. What does ROLLBACK do ?
ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.
5. What is SAVE POINT ?
For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction.
6. What is Read-Only Transaction ?
A Read-Only transaction ensur Read more:Oracle
, Access
Oracle System Architecture Interview Questions 2007-11-26 02:57:32 1. What constitute an ORACLE Instance ?
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
2. What is SGA ?
The System
Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance.
3. What are the components of SGA ?
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
4. What do Database Buffers contain ?
Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.
5. What do Redo Log Buffers contain ?
Redo Log Buffer stores redo entries a log of changes made to the database.
6. What is Shared Pool ?
Shared Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas.
7. What is Shared SQL Area ?
A Shared SQL area is required to process every unique SQL statement submitted to a database and contains inform Read more:Oracle
, Architecture
Oracle Concepts & Architecture Database Structure Interview Questions 2007-11-26 02:51:34 1. What are the components of Physical database structure of OracleDatabase
?.
ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.
2. What are the components of Logical database structure of ORACLE database?
Tablespaces and the Database’s Schema Objects.
3. What is a Tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.
4. What is SYSTEM tablespace and When is it Created?
Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.
5. Explain the relationship among Database, Tablespace and Data file.
Each databases logically divided into one or more tablespaces One or more data files are explicitly created for each tablespace.
6. What is schema?
A schema is Read more:Architecture
, Concepts
, Structure
SCJP Interview Questions Part8 2008-05-13 04:10:56 QUESTION NO 121
1. import java.awt.*; 2. 3. public class X extends Frame {
4. public static void main (String [] args) {
5. X x = new X();
6. x.pack();
7. x.setVisible(true);
8. }
9. 10. public X() {
11. setLayout (new BordrLayout());
12. Panel p = new Panel ();
13. add(p, BorderLayout.NORTH);
14. Button b = new Button (”North”);
15. p.add(b):
16. Button b = [...]
Recommend Site To A Friend
