Interview Questions and Answers for 'T' | Search Interview Question

Interview Questions and Answers - Order By Rating

Q1681. How to Bulk upload the data into Oracle database?

Database

Ans. We can use external table feature of Oracle.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies Intermediate}

Q1682. Write code for Binary tree traversal ?

Core Java

Ans. http://javabeat.net/binary-search-tree-traversal-java/

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q1683. Design a Library system ?

Design

Ans. Following Tables can be created

ASSET - Entity Table With foreign key reference to Table AssetType

ASSET_TYPE - Entity Table specifying information related to Asset Type like Books, CDs etc.

MEMBER - Registration information for the member

MEMBERSHIP_TYPE - Membership Types provided by Library

MEMBERSHIP - Relation table with foreign key for MEMBER ,

MEMBERSHIP_TYPE

ASSET_ISSUE_LEDGER - Relationship between MEMBER and ASSET. This specify the issue of particular asset to a particular member.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve design Asked in 1 Companies}

Q1684. Can you assign value to a static final type at runtime ?

Core Java

Ans. No

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve static final static final Asked in 1 Companies}

Q1685. In case of a synchronized method, Does the method only gets locked or the whole object ?

Core Java

Ans. Just the method gets locked.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve synchronization multithreading Asked in 1 Companies}

Q1686. There is a Table Student having Student Id, Name and Total Marks. Can you please write an SQL that will display the maximum marks obtained by a student ?

Database

Ans. SELECT MARKS FROM STUDENT ORDER BY MARKS DESC LIMIT 1;

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database query Asked in 1 Companies}

Q1687. What is an IP address ?

Java EE

Ans. An Internet Protocol address is a numerical label assigned to each device participating in a computer network.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve ip address Asked in 2 Companies basic frequent}

Q1688. How to count total number of tables in database ?

Database

Ans. SELECT COUNT(*) FROM information_schema.tables

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database query Asked in 1 Companies}

Very Frequently asked to fresh graduates and less experienced.

Q1689. What are the principle concepts of Object Oriented Programming ?

Core Java

Ans. Abstraction Polymorphism Inheritance Encapsulation

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve oops oops concepts Asked in 1 Companies basic frequent}

Q1690. Have you heard about the external table feature of Oracle ?

Database

Ans. The external tables feature is a complement to existing SQL Loader functionality. It enables to access data in external sources as if it were in a table in the database. We have used it few times for replicating tables across different database systems.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve external table oracle Asked in 1 Companies rare}

Q1691. Can we have try statement without catch? If try statement contains return will the finally block be executed? What happens if there is an exception inside finally block?

Core Java

Ans. Yes, with finally.

Yes, finally block will be executed even if there is no exception in try block.

If finally throws an exception, the exception gets thrown to the calling module.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve exception handling Asked in 1 Companies intermediate}

Q1692. What do you know about JQuery ?

Java EE

Ans. jQuery is a cross platform JavaScript library designed to simplify the client-side scripting of HTML. JQuery is the most popular JavaScript library.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve jquery Asked in 1 Companies}

Q1693. What is a Database Trigger ?

Database

Ans. A trigger is a special kind of stored procedure that automatically gets executed upon an event in the database server.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database trigger Asked in 10 Companies basic frequent}

Q1694. What is a Database sequence ?

Database

Ans. Its a feature wherein database creates unique values incremental values to be stored as primary key for the table.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database sequence Asked in 1 Companies}

Q1695. What is a Database Procedure ?

Database

Ans. Stored procedures are a batch of SQL statements along with programming constructs ( if else, loops etc ) and stored as a single program that can be called by different clients and hence reused.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database stored procedure Asked in 2 Companies basic frequent}

Q1696. Explain Exception Hierarchy in Java SE ?

Core Java

Ans. <a href="http://www.programcreek.com/2009/02/diagram-for-hierarchy-of-exception-classes/" rel="nofollow">http://www.programcreek.com/2009/02/diagram-for-hierarchy-of-exception-classes/</a>

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve exception hierarchy exceptions Asked in 3 Companies}

Q1697. Which data structure would you recommend for ordered and sorted data?

Core Java

Ans. TreeSet and TreeMap are used for maintaining sorted elements.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve ordered collections sorted collections Asked in 1 Companies basic frequent}

Frequently asked to Fresh graduates.

Q1698. Write a program to implement Binary search ?

Core Java

Ans. http://algs4.cs.princeton.edu/11model/BinarySearch.java.html

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve binary search search Asked in 5 Companies basic frequent}

Try 1 Question(s) Test

Q1699. Write a java program to implement Quick sort ?

Core Java

Ans. http://www.programcreek.com/2012/11/quicksort-array-in-java/

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve quick sort sort Asked in 2 Companies frequent}

Q1700. What are the phases in Software Testing process ?

Process

Ans. Test Planning -> Test Design -> Test Execution -> Evaluating Exit Criteria and Closure

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve testing testing phases process}

Q1701. What is the use of Combiners ?

BigData

Ans. Combiners are used to increase the efficiency of a Map Reduce program. They are used to aggregate intermediate map output locally on individual mapper outputs. Combiners can help you reduce the amount of data that needs to be transferred across to the reducers.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Hadoop Systems BigData hadoop combiners Asked in 1 Companies}

Q1702. Can you narrate some sample usage for Bigdata ?

BigData

Ans. One common usage is predictive analytic using huge current or past data. For example - Using recent medical data ( diagnosis and procedure ), one can identify the pattern of diseases or the procedures that has to eventually applied upon certain diagnosis. This analysis might help in predicting the diseases that might occur to a patient. the other usage could be to identify the future spending patterns of the population by analyzing the past and current habits.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve BigData}

Q1703. What is Hadoop Framework ?

BigData

Ans. Hadoop is an open source framework , written in java by apche software foundation. This framework is used to write applications to process vast amount of data. Processing happens in parallel on large clusters which could have 1000 of computers. It processes data in a very reliable and fault tolerant manner.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Hadoop framework BigData}

Q1704. What are the two main components of Hadoop System ?

BigData

Ans. Distributed file system and Map Reduce system.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hadoop bigdata hadoop system components frequent}

Q1705. What is the character limit of url and doesn it apply to GET and POST Requests ?

Java EE

Ans. Its 2048 and Yes it applies to get request but not POST. As in Get Request , elements are passed as part of the url, this limit applies to Get requests.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve url internet address}

Q1706. In this url

http://javasearch.buggybread.com/InterviewQuestions/questionSearch.php?searchOption=label&keyword=url

What is protocol , domain , path and query param ?

Java EE

Ans. the web URI starts with the protocol which is http in this case, javasearch.buggybread.com is the domain in this case which is a subdomain of buggybread.com, /InterviewQuestions is the path, questionSearch.php is the resource, searchOption and keyword are query params.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve url internet address}

Q1707. What is the difference between URI, URL and URN ?

Java EE

Ans. URI stands for Uniform Resource Indicator
URL stands for Uniform Resource Locator
URN stands for Uniform Resource Name

URI = URL + URN

For ex - http://javasearch.buggybread.com/InterviewQuestions/questionSearch.php?keyword=url

This is URI. The string from start till .php is URL whereas keyword=url is URN.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve url urn uri web address internet address Asked in 1 Companies}

Q1708. Which is the root interface of Collection classes in Java ?

Core Java

Ans. java.util.Collection

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve collection interface collections}

Q1709. What are the disadvantages of multithreading ?

Core Java

Ans. 1. Switching Overheads - Even though multi threading aims at improving performance by reducing the wait time and hence improving overall throughput, there is a cost of switching resources between threads and sometime this cost can surpass the benefits if there isnt much wait for IO or external communication.

2. Debugging is hard with multi threaded code.

3. Deadlock - Execution of multi threaded code many a times lead to deadlock due to shared resources.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve multithreading threads Asked in 4 Companies}

Q1710. What happens to the Exception object after the exception handling is done ?

Core Java

Ans. As with all other objects its garbage collected after its usage unless its rethrown.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve exceptions exception handling rare}

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.