Technology Questions

Q:

How do I find out the number of parameters passed into function?

Answer func_num_args() function returns the number of parameters passed in.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2990
Q:

How to create recursive query in SQL Server?

Answer

Recursive query can be create in SQL using stored procedure but you can also use CTE (Common table expression). It might be also worth asking about performance as CTE is not always very fast.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2982
Q:

Explain how to lock and unlock a user account in Oracle.

Answer

SQL> ALTER USER user_name ACCOUNT LOCK;


SQL> ALTER USER user_name ACCOUNT UNLOCK;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2976
Q:

Which of the following modifiers can be used with Local inner class?

A) Final or Abstract B) Final or Transcient
C) Abstract or Transcient D) Final or public
 
Answer & Explanation Answer: A) Final or Abstract

Explanation:

It can either be Final or Abstract

Report Error

View Answer Report Error Discuss

Filed Under: Java

0 2975
Q:

What is the purpose of garbage collection in Java, and when is it used ?

Answer

The purpose of garbage collection is to identify and discard those objects that are no longer needed by the application, in order for the resources to be reclaimed and reused.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 2973
Q:

What is factory method in AngularJS ?

A) It generates the facts and figures B) It is used to create the service
C) It is used to calculate the factorial of a number D) All the above
 
Answer & Explanation Answer: B) It is used to create the service

Explanation:

In general, Services are Javscript functions and are responsible to do a specific tasks. Factories implements module pattern in which we use a factory method to generate an object which is use for building models.

It's syntax is
module.factory('factoryName', function);

Report Error

View Answer Report Error Discuss

Filed Under: Web Technology
Job Role: Analyst , Software Architect

1 2969
Q:

What is the maximum data rate supported by a GSM system?

Answer

- The maximum data rate supported by a GSM system is 9.6 kbps.
- However there are extensions to GSM standard to improve throughput.
- GPRS is one of the extended GSM service.
- The extended standards of GSM allows theoretical data rates on the order of 114 Kbit/s, but with throughput closer to 40Kbit/s in practice.

Report Error

View answer Workspace Report Error Discuss

3 2969
Q:

How to define a constant variable in Java?

Answer The variable should be declared as static and final. So only one copy of the variable exists for all instances of the class and the value can't be changed also.
static final int PI = 2.14; is an example for constant.
Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 2968