Technical Interview Questions and Answers

Q:

What is PHP's configuration file called?

Answer

PHP’s configuration file is called php.ini.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

13 10958

Q:

Write SQL Query to display current date?

Answer

The built in function called GetDate() returns the time stamp.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

22 10939

Q:

What is DataStage?

Answer

- A tool for designing Extraction, Transformation and Loading

- An ideal tool for data integration projects system migrations

- Importing, extracting and creating metadata are within these jobs

- Data stage allows scheduling, monitoring and running the jobs

- Allows to administer the development and execution in a single environment

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Data Warehousing

6 10850

Q:

How do define the user-defined exceptions?

A) inheriting and overriding exception class functionality.	B) overriding class functioality.
C) inheriting class functionality	D) none of the mentioned

Answer & Explanation Answer: A) inheriting and overriding exception class functionality.

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: C++

4 10831

Q:

What is the difference between operational data stage (ODS) and data warehouse?

Answer

Data warehouse

- It is a decision support database system for the purpose of organizational needs.

-It is non volatile, integrated and time variant collection of data

Operational Data Stage

- It is an integrated collection of information.

-It can contain 90 days of information at maximum.

-ODS supports dynamic data.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Data Warehousing

6 10777

Q:

What’s the difference between md5( ), crc32( ) and sha1( ) crypto on PHP?

Answer The major difference is the length of the hash generated. CRC32 is, evidently, 32 bits, while sha1() returns a 128 bit value, and md5() returns a 160 bit value. This is important when avoiding collisions.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

13 10690

Q:

What are the components of DataStage?

Answer

Datastage has two components

-Client Components – Designer, Director, Manager and Administrator

-Server Components – Server, Repository and Plug-ins.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Data Warehousing

7 10680

Q:

Which of the following is not the member of class?

A) Virtual function	B) Static function
C) Friend function	D) Const function

Technology Questions

Quick Links