Basic .NET Framework - DOT NET Chapter Wise Interview Questions Question 1: What is an IL code?(B)What is a IL? Answer: IL code is a partially compiled code. Note: Half compiled means this code is not yet compiled to machine/CPU (Central Processing Unit) specific instructions. Question 2: Why is IL code not fully compiled? Answer: We do not know in what kind of … [Read more...]
Top 50 Technical and Non-Technical Questions – DOT NET Chapter Wise Interview Questions
Top 50 Technical and Non-Technical Questions - DOT NET Chapter Wise Interview Questions Question 1: Can you explain architecture of your current project? Answer: Note: I think 40% of .NET interview starts with this question. Below is a sample answer and will differ from developer to developer. My current architecture is a three-layer architecture with Ul (User Interface) … [Read more...]
HR Questions – Frequently Asked
HR Questions - Frequently Asked Question 1: How would you handle a negative coworker? Answer: Everyone has to deal with negative coworkers - and the single best way to do so is to remain positive. You may try to build a relationship with the coworker or relate to them in some way, but even if your efforts are met with a cold shoulder, you must retain your positive attitude. … [Read more...]
Operators – ORACLE PL/SQL Chapter Wise Interview Questions
Operators - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: How to use %LIKE operator? Answer: LIKE operator is used to compare a character, string, or CLOB value to a pattern. Case is significant. LIKE returns the Boolean value TRUE if the patterns match or FALSE if they do not match. The patterns matched by LIKE can include two special-purpose characters called … [Read more...]
Packages & Triggers – ORACLE PL/SQL Chapter Wise Interview Questions
Packages & Triggers - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What is a package spec and package body? Why the separation? Answer: Spec declares public constructs. Body defines public constructs, additionally declares and defines Private constructs Separation helps make development easier Dependency is simplified. You can modify body without … [Read more...]
Joins – ORACLE PL/SQL Chapter Wise Interview Questions
Joins - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What are various types of joins? Answer: Types of joins are: Equijoins Non-equijoins Self join Outer join Question 2: What is a Join and explain different types of joins. Answer: Joins are used in queries to explain how different tables are related. Joins also let you select data from a … [Read more...]
Sequence-Index – ORACLE PL/SQL Chapter Wise Interview Questions
Sequence-Index - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What is a sequence? Answer: A database object that offers high-speed access to an integer value Guaranteed to be unique (within that sequence). Used commonly to generate Primary key values Question 2: How does one get the value of a sequence into a PL/SQL variable? Answer: select … [Read more...]
Procedures & Functions – ORACLE PL/SQL Chapter Wise Interview Questions
Procedures & Functions - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What are the constructs of a procedure, function or a package? Answer: The constructs of a procedure, function or a package are: variables and constants cursors exceptions Question 2: What is the advantage of a Stored Procedure over a Database Trigger? Answer: We have … [Read more...]
Cursors – ORACLE PL/SQL Chapter Wise Interview Questions
Cursors - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors? Answer: Cursors allow row-by-row processing of the resultsets. Types of cursors: Static, Dynamic, Forward-only, Keyset-driven. Disadvantages of cursors: Each time you fetch a row from … [Read more...]
Execution Control Statements – ORACLE PL/SQL Chapter Wise Interview Questions
Execution Control Statements - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What Are the Execution Control Statements in Oracle? Answer: PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly … [Read more...]