Technology Questions

Q:

In terms of DB2 indexing, what is the root page?

Answer

The simplest DB2 index is the B-tree and the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search. 


 

Report Error

View answer Workspace Report Error Discuss

0 2391
Q:

Which function would you use to insert a record into a database?

Answer

The dba_insert() function adds a record to a database.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2391
Q:

Why an app on iOS device behaves differently when running in foreground than in background?

Answer

An application behaves differently when running in foreground than in background because of the limitation of resources on iOS devices.

Report Error

View answer Workspace Report Error Discuss

1 2390
Q:

What is correlated query? Explain its uses.

Answer

In a correlated query, the outer query is related to the inner query. This means one or more columns in the outer query are referenced. It’s used when the outer queries value is being used by inner query. For example, we need to find which employee had more perks in the current month than they did in the previous month. The correlated subquery is executed for each row of perks information in the parent query to first determine what the perks were for each employee in the previous month. This data, in turn, is compared to perks for each employee in the current month, and only those employees whose perks in the current month were greater that their previous month's perks are returned.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2390
Q:

What is the difference between primary key & unique index ?

Answer

Primary key : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.


Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table.

Report Error

View answer Workspace Report Error Discuss

0 2389
Q:

What are the three levels of definition for the VSAM DEFINE?

Answer

They are DEFINE CLUSTER, DATA and INDEX.

Report Error

View answer Workspace Report Error Discuss

0 2388
Q:

What are Child Selectors ?

Answer

A child selector is used when you want to match an element that is the child of another specific element.
The parent and child selectors are separated by spaces.
The following selector locates an unordered list element within a paragraph element and makes a text within that element bold.


p > ul {font-weight: bold;}

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

4 2387
Q:

What is the use of CSS sprites?

Answer

- A web page with large number of images takes a longer time to load. This is because each image separately sends out a http request.


- The concept of CSS sprite helps in reducing this loading time for a web page by combining various small images into one image. This reduces the numbers of http request and hence the loading time.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2386