Interview Questions

Q:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Report Error

View answer Workspace Report Error Discuss

5 2365
Q:

What is Shallow and deep cloning in Java?

Answer

Cloning refers to creating duplicate copies of objects in java.


Shallow Cloning: Shallow cloning is a bitwise copy of an object. New object is created which is an exact copy that of the original one. In case any objects are referring the fields of these objects, just the references are copied.


Deep Cloning: In deep cloning, complete duplicate copy of the original copy is created. Deep cloning creates not only the primitive values of the original objects but also copies all its sub objects as well.


Clonable interface is used to perform cloning in java.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2362
Q:

What are the uses of synonyms?

Answer

- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 2361
Q:

Describe Use Case Testing.

Answer

Use Case: A use case is a description of the process which is performed by the end user for a particular task. Use case contains a sequence of step which is performed by the end user to complete a specific task or a step by step process that describe how the application and end user interact with each other. Use case is written by the user point of view.


Use case Testing: the use case testing uses this use case to evaluate the application. So that, the tester can examines all the functionalities of the application. Use case testing cover whole application, tester performs this testing in step by step process to complete one task

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 2360
Q:

What is the difference between Load Testing and Performance Testing?

Answer

Basically Load, Stress and Performance Testing are the same. However, Load testing is the test to check the users’ response time of number of users of any one scenario of the application whereas Performance Testing is the test to check the user response time for multiple scenario of the same application.

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 2359
Q:

What is Payroll transaction?

Answer

Payroll Transaction is nothing but the calculation of salary for a month / week / day of an individual / group of employees depends upon the attendance / variable inputs / other benefits / salary component and generate the reports for IT / Statutory / PT payments.

Report Error

View answer Workspace Report Error Discuss

0 2359
Q:

The new product development process usually starts with

A) idea generation B) market strategy development
C) concept development D) idea screening
 
Answer & Explanation Answer: A) idea generation

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Marketing and Sales
Exam Prep: CAT
Job Role: Analyst

6 2357
Q:

What is COPY PENDING status?

Answer

- A status occurs when image copy on a table needs to be taken


- The table is available only for queries and can not be updated


- COPY PENDING status can be removed by taking away the image copy or by using REPAIR utility

Report Error

View answer Workspace Report Error Discuss

0 2356