Technology Questions

Q:

Could you explain the areas where tuning of database is required?

Answer

The following are the areas of concern for tuning:


- Memory Usage


- Data Storage


- Data Manipulation


- Physical Storage


- Logic Storage


- Network Traffic


Tuning Memory Usage: In Oracle 10g, we can use the Automatic Workload Repository (AWR) toolset to gather and manage statistical data but in case of Oracle 11g, we can use new initialization parameters such as MEMORY_TARGET to further control the overall memory used by Oracle. It helps us to tune the database automatically when we don’t have time to read the AWR report.


Tuning Data Manipulation: There are two ways to tune Data manipulation in Oracle one way is through Conventional Path mode and second is Direct Path mode.


Tuning Physical Storage: We need to tune the physical storage because it limits the disk in database. This can be done by: Distributing I/O, Striping and Mirroring.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2366
Q:

What is wrapping?

Answer

Wrapping is also called as packing or boxing.


Storing the data inside the object as private data which can accessed outside the class only by using methods.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2365
Q:

Is it cost effective to implement a private cloud rather than a public cloud and why?

Answer

It depends on the type of business that demands a cloud setup. Suppose if the subscription on a public cloud for an application that is to be deployed on OS images is proving to be more costly then to buy some new datacenters and maintain them. Then obviously the a private cloud has to be setup instead of a public cloud. This public clouds follow utility billing methodology as electricity bill for example.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

0 2364
Q:

APK full form in Android?

Answer

APK stands for Android Application Package.


 


Android Package (APK) is the package file format used by the Android operating system for distribution and installation of mobile apps and middleware.

Report Error

View answer Workspace Report Error Discuss

3 2364
Q:

The model for a record management system might be

A) a rolodex card file B) a business form
C) handwritten list D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A Records Management System is a computer program or set of programs used to manage and store records.

 

For example, a hospital record for storing new room, ward , patients, etc...

The_model_for_a_record_management_system_might_be1553926899.png image

Report Error

View Answer Report Error Discuss

Filed Under: Application Development
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 2361
Q:

What is a TCP Session?

Answer

the layer that establishes ,manages and terminates the session between two communticating devices

Report Error

View answer Workspace Report Error Discuss

0 2360
Q:

What are the different types of diagrams and what do you know about them?

Answer

Use case diagram, activity diagram, Collaboration diagram. 


Use case diagram :


It describes the business environment. Its primary goal is to show the series of events and actions within any given process that will be performed by an actor.  


 


Activity diagram:


The activity diagram is important because it gives an outline of the work flow within the business as well as the activities and action completed. 


For instance with a company, there is likely to be more than one department. In such a case each department, will have different access levels to the system. 


So if there’s a Medical, HR and Accounts team they will only have access to screens that relate to each. 


The activity diagram will highlight the differences within the departments which will be very helpful for developers when they are designing and coding. 


 


Collaboration diagram:


A collaboration diagram, also called a communication diagram or interaction diagram, is an illustration of the relationships and interactions among software objects in the Unified Modeling Language (UML). The concept is more than a decade old although it has been refined as modeling paradigms have evolved. 

Report Error

View answer Workspace Report Error Discuss

0 2356
Q:

What was the process of QA testing in your company where you worked for the last time?

Answer

The QA testing process that was followed in my last company where I worked was like this: First of all the Business Requirement Document was prepared as per the client’s requirement (with the muck-up screen shots). Then on the basis of the requirement document, Test Strategy, Test Plans and Test Cases were written in sequential order. Once the Build is made and deployed to the different testing environments where different types of testing were performed to check whether there are any defects.

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 2355