Interview Questions

Q:

What are the differences between GET and POST methods in form submitting?

Answer

On the server side, the main difference between GET and POST is where the submitted is stored. The $_GET array stores data submitted by the GET method. The $_POST array stores data submitted by the POST method.

On the browser side, the difference is that data submitted by the GET method will be displayed in the browser’s address field. Data submitted by the POST method will not be displayed anywhere on the browser.

GET method is mostly used for submitting a small amount and less sensitive data.
POST method is mostly used for submitting a large amount or sensitive data.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2311
Q:

Define authentication and authorization.

Answer

Authorization: The process of granting access privileges to resources or tasks within an


application.


Authentication: The process of validating the identity of a user.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET
Job Role: Software Architect

0 2310
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 2309
Q:

What is AWB?. What is its purpose?

Answer

AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2308
Q:

What is the information does assembly manifest provide?

Answer

Information provided by Assembly Manifest:



  1.  Assembly Name

  2.  Version Number

  3.  Culture

  4.  Strong name

  5.  List of files inside the assembly

  6.  Reference information

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2307
Q:

We can modify an existing Company from

A) Company Info > Alter B) Gateway of Tally > Modify Company
C) Company Info > Alter Company D) All of the above
 
Answer & Explanation Answer: A) Company Info > Alter

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 2305
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 2303
Q:

Can you work in shifts?

Answer

Say “Yes” if you have made up your mind to work for a call center. Call centers would usually work 24 X 7 which needs some executives to be always present in the center. This means that you would need to work in shifts. 

Report Error

View answer Workspace Report Error Discuss

Subject: Call Center

1 2303