Interview Questions

Q:

Define Structure in C++.?

Answer

The C++ programming technique allows defining user defined datatypes through structure. The


syntax to declare structure is as follows:


struct student


{


char name[100]


char address[250]


};

Report Error

View answer Workspace Report Error Discuss

Subject: C++

0 2260
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 2258
Q:

XML preserves white spaces.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

True, the given statement that xml preserves white spaces is correct.

Report Error

View Answer Workspace Report Error Discuss

1 2256
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 2256
Q:

What is the difference between verification and validation?

Answer

Verification: Verification is a process to ensure that the software that is made, matches the original design. In other words, it checks whether the software is made according to the criteria and specification described in the requirement document. It is to check whether you built the product right as per design. It is a low level checking. (It is done in walk-through meetings generally). It checked whether it is made accordingly to the design..


Validation: Validation is a process to check whether the product design fits the client’s need. It checks whether you built the right thing. It checks whether it is designed properly.

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 2255
Q:

What is the importance of Doctype in HTML?

Answer

Doctype tag is not a HTML tag, it is just an instruction that is passed to the web browser to check for the information that is being provided by the markup language in which the page is written. Doctype is sometimes referred as Document type definition (DTD) that describes some rules that has to be followed while writing the markup language so to make the web browser understand the language and the content correctly. Doctype is very important to be placed in the beginning of the HTML and before the <HTML> tag to allow easy rendering of the pages that are used.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

1 2253
Q:

What are constraints? Mention the different types of constraints?

Answer

Constraints enable the RDBMS to enforce the integrity of the database automatically, without the need to create triggers, rule or defaults.


Types of Constraints: NOT NULL, CHEQUE, UNIQUE, PRIMARY KEY, FOREIGN KEY.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2253
Q:

What is the difference between XML and HTML?

A) HTML is used for exchanging data, XML is not B) XML is used for exchanging data, HTML is not
C) HTML can have user defined tags, XML cannot D) XML can have user defined tags, HTML cannot
 
Answer & Explanation Answer: B) XML is used for exchanging data, HTML is not

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Web Technology

0 2252