Technology Questions

Q:

What is IUnknown and what are its three parts?

Answer

IUnknown as an interface of a COM object. Every COM object has to support IUnknown, besides optionally adding other interfaces.


IUnknown is made of QueryInterface, AddRef and Release.

Report Error

View answer Workspace Report Error Discuss

0 2456
Q:

What is RAC and how is it different from non RAC databases?

Answer

Oracle Real Application Clusters (RAC) is a software component we can add to a high-availability solution that enables users on multiple machines to access a single database with increased performance. RAC comprises two or more Oracle database instances running on two or more clustered machines and accessing a shared storage device via cluster technology. To support this architecture, the machines that host the database instances are linked by a high-speed interconnect to form the cluster. Oracle RAC offers features in the following areas:


- Scalability


- Availability


- Load balancing


- Failover

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2456
Q:

How do you insert a record with a nullable column?

Answer

To insert a NULL, move -1 to the null indicator


To insert a valid value, move 0 to the null indicator


 

Report Error

View answer Workspace Report Error Discuss

0 2454
Q:

Define Common Type System

Answer

.Net allows developers to write program logic in at least 25 languages. The classes written in one language can be used by other languages in .Net. This service of .Net is possible through CTS which ensure the rules related to data types that all language must follow. It provides set of types that are used by all .NET languages and ensures .NET language type compatibility.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2453
Q:

Describe Android Application Architecture.

Answer

Android Application Architecture has the following components:
* Services – like Network Operation
* Intent - To perform inter-communication between activities or services
* Resource Externalization - such as strings and graphics
* Notification signaling users - light, sound, icon, notification, dialog etc.
* Content Providers - They share data between applications

Report Error

View answer Workspace Report Error Discuss

0 2451
Q:

How to open a file?

Answer

<?php
$file = fopen("file.txt","r");
?>

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2451
Q:

Explain how to create random passwords.

Answer

Generating random passwords in PHP can be done in multiple ways depending on how much security the application demands:-


Md5 function can be passed one parameter as uniqid() function which in turn generates a random number. Passing the parameter as TRUE in uniqid() adds additional uniqueness.


<?php
   $passwd = md5(uniqid(rand(), true));
   Echo $passwd;
?>

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2449
Q:

What are user defined data-types and when do you use them?

Answer

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.


We use them to format the database and segregate specific repetitions of rows and columns in the database.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2448