Technology Questions

Q:

Which one of the following sorts rows in SQL?

A) ORDER BY B) GROUP BY
C) SORT BY D) ALIGN BY
 
Answer & Explanation Answer: A) ORDER BY

Explanation:
Report Error

View Answer Report Error Discuss

0 5475
Q:

$message vs $$message in PHP?

Answer

$message is a variable with a fixed name. $$message is a variable whose name is stored in $message. 


If $message contains "var", $$message is the same as $var.


 

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 5457
Q:

How will you call the return code of JCL ?

Answer

Return Code in JCL can b obtained by the use of COND paramater...it is used to know the return codes of previous steps.

Report Error

View answer Workspace Report Error Discuss

2 5433
Q:

Which command displays memory usage in linux?

A) Top B) Free
C) Buffer D) Swap
 
Answer & Explanation Answer: B) Free

Explanation:

Free command displays memory usage in linux.

Report Error

View Answer Report Error Discuss

9 5404
Q:

How would apply date range filter?

Answer

One can use simple conditions like >= and <=, or use between/and but the trick here is to know your exact data type.


 


- Sometimes date fields contain time and that is where the query can go wrong so it is recommended to use some date related functions to remove the time issue. In SQL Server common function for accomplishing the task datediff () function.


- Interviewees also have to be aware of different time zones and server time zone.


-To increase query performance you may still want to use between however you should be aware of proper format you should use if not it might misbehave during filtering.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 5394
Q:

What are the 4 key phases of business development?

Answer

The 4 key phases of business development are: Forming, Storming, Norming and Performing.

Report Error

View answer Workspace Report Error Discuss

0 5377
Q:

How does cloud computing provides on-demand functionality?

Answer

Cloud computing is a metaphor used for internet. It provides on-demand access to virtualized IT resources that can be shared by others or subscribed by you. It provides an easy way to provide configurable resources by taking it from a shared pool. The pool consists of networks, servers, storage, applications and services.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

1 5359
Q:

What is the business benefits involved in cloud architecture?

Answer

1. Zero infrastructure investment : Cloud architecture provide user to build large scale system with full hardware, machines, routers, backup and other components. So, it reduces the startup cost of the business. 


2. Just-in-time Infrastructure : It is very important to scale the infrastructure as the demand rises. This can be done by taking cloud architecture and developing the application in the cloud with dynamic capacity management. 


3. More efficient resource utilization : Cloud architecture provides users to use their hardware and resource more efficiently and utilize it in a better way. This can be done only by applications request and relinquish resources only when it is needed (on-demand).

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

2 5336