Interview Questions

Q:

Define PL/SQL sequences and write syntax for a sequence

Answer

A sequence is a database object that is used to generate sequential number.


CREATE SEQUENCE seqname [increment] [minimum value][maximum value][start][cache][cycle]               Nextval and currval lets us get the next value and current value from the sequence.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2425
Q:

What is the syntax to inherit from a class in C#?

Answer

When a class is derived from another class, then the members of the base class become the members of the derived class. The access modifier used while accessing members of the base class specifies the access status of the base class members inside the derived class.

The syntax to inherit a class from another class in C# is as follows:
class MyNewClass : MyBaseclass

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2425
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 2424
Q:

What are the difference between clustered and a non-clustered index?

Answer

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.


- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2423
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 2421
Q:

Client code having direct access to internal data is called

A) Encapsulation B) DataHiding
C) Polymorphism D) DataAbstraction
 
Answer & Explanation Answer: B) DataHiding

Explanation:

Client code must use setters and getters to access internal data in DataHiding

Report Error

View Answer Report Error Discuss

Filed Under: Java

0 2420
Q:

By monitoring ad campaign performance, an advertiser may obtain the information needed to

A) determine if campaigns are meeting overall marketing and conversion goals B) create additional AdWords accounts for low-performing keywords
C) compare campaign performance to that of individual competitors D) create duplicate ad groups with identical keywords and different ad variations
 
Answer & Explanation Answer: A) determine if campaigns are meeting overall marketing and conversion goals

Explanation:

By monitoring ad campaign performance an advertiser may obtain the information needed to determine if campaigns are meeting overall marketing and conversion goals compare campaign performance to that of other advertisers create separate adwords accounts for low-performing keywords create duplicate ad groups with identical keywords and different ad variations.

Report Error

View Answer Report Error Discuss

Filed Under: Advertising and Media

4 2415
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 2415