2008-06-06 13:44
1. Explain by one sentences, role, references, privilege on a table and profile?2. What can trigger a snapshot to old error?3. What are the DB files, how oracle discover them?4. Where do you… Read More
Blog Directory > Software Blogs > Programming Blogs > Java Interview Questions programming Blog >
Java Interview Questions Blog
java-interview-questions-bank.blogspot.com
Tags:
table
integrity
database
rollback
hide complexity
tomcat
maximum size
constraint
amp physical architecture
export
Daily Updated Interview Questions Bank : Core Java, JSP, Servlet, J2EE, Spring, Hibernate, Struts, Web Server
2008-06-06 13:42
1. What is the difference between the WHERE clause and the HAVING clause on a SQL statement?2. What is SQL.BSQ?3. What is the difference between a static and a dynamic cursor and when would… Read More
2008-06-06 13:37
1. How many memory layers are in the shared pool? 1/3 of physical memory, can be 2/4k depending on bit of 32 or 642. How do you find out from the RMAN catalog if a particular archive log h… Read More
2008-06-06 13:31
1. What are the different tablespaces in database?2. How to drop the index?3. How to drop the column in a table?4. How to take the export and import of users level?5. What are the new parame… Read More
2008-06-04 15:15
4 easy Step for Configuring tomcat with SSL==============================================================1) Prepare certificate Keystore%JAVA_HOME%\bin\keytool -genkey -alias tomcat -keyal… Read More
2008-06-03 08:59
Oracle Concepts and Architecture Database Structures 1http://java-interview-questions-bank.blogspot.com/2008/06/oracle-concepts-and-architecture.htmlOracle Concepts and Architecture Databa… Read More
2008-06-03 05:46
126. Can a view be updated/inserted/deleted? If Yes - under what conditions? A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or… Read More
2008-06-03 05:45
121. If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE? It won't, Because SYSDATE format contains time attached with it.122. What… Read More
2008-06-03 05:45
116. What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type? CHAR pads blank spaces to the maximum length.VARCHAR2 does not pad blank spaces.For CHAR… Read More
2008-06-03 05:44
111. What is an integrity constraint? Integrity constraint is a rule that restricts values to a column in a table.112. What is referential integrity constraint? Maintaining data integrity th… Read More
2008-06-03 05:44
106. Explain CONNECT BY PRIOR? Retrieves rows in hierarchical order eg. select empno, ename from emp where.107. Difference between SUBSTR and INSTR? INSTR (String1, String2 (n, (m)),INSTR re… Read More
2008-06-03 05:43
100. What are the types of SQL statement? Data Definition Language: CREATE, ALTER, DROP, TRUNCATE, REVOKE, NO AUDIT & COMMIT.Data Manipulation Language: INSERT, UPDATE, DELETE, LOCK TAB… Read More
2008-06-03 05:42
97. What is user Account in Oracle database?A user account is not a physical structure in database but it is having important relationship to the objects in the database and will be having… Read More
2008-06-03 05:42
96. List the factors that can affect the accuracy of the estimations?- The space used transaction entries and deleted records, does not become free immediately after completion due to delay… Read More
2008-06-03 05:41
91. What is use of rollback segments in Oracle database?They allow the database to maintain read consistency between multiple transactions.92. What is a rollback segment entry?It is the set… Read More
2008-06-03 05:40
84. How can we plan storage for very large tables?Limit the number of extents in the tableSeparate table from its indexes.Allocate sufficient temporary storage.85. How will you estimate the… Read More
2008-06-03 05:39
79. How the space utilization takes place within rollback segments?It will try to fit the transaction in a cyclic fashion to all existing extents. Once it found an extent is in use then it… Read More
2008-06-03 05:39
74. How does Space allocation table place within a block?Each block contains entries as followsFixed block headerVariable block headerRow Header, row date (multiple rows may exists)PCTEREE (… Read More
2008-06-03 05:38
69. List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance?SYSTEM - Data dictionary tables.DAT… Read More
2008-06-03 05:37
64. What is Database Buffers?Database buffers are cache in the SGA used to hold the data blocks that are read from the data segments in the database such as tables, indexes and clusters DB… Read More
2008-06-03 05:35
59. What is SGA?The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural… Read More
2006-06-07 11:16
http://www.justajax.net/ http://www.ajaxdaddy.com/ http://www.ajaxrain.com/ http://www.ajaxrain.com/ http://ajax.solutoire.com/ http://sixrevisions.com/ajax/ajax_techniqu… Read More
2006-06-07 11:16
If you are expert in DBA, then you should know answer of below questions. Give your answer by comment.Good DBA Questions (15)Senior Oracle DBA Questions (69)OCP certified DBA Interview… Read More
2006-06-07 11:16
CSS Expert !!!!! , then give answer of below questions by comment.What is CSS? What are Cascading Style Sheets? How do I center block-elements with CSS1? If background and color s… Read More
2006-06-07 11:16
21: What is GROUP BY?A: The GROUP BY keywords have been added to SQL because aggregate functions (like SUM) return the aggregate of all column values every time they are called. Withou… Read More
Subscribe to Java Interview Questions
Get updates delivered right to your inbox!