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 2473
Q:

What are the CICS commands available for program control?

Answer

The following commands are available for the Program Control services:


LINK: To pass control to another program at the lower level, expecting to be returned. XCTL: To pass control to another program at the same level, not expecting to be returned.


RETURN:  To return to the next higher-level program or CICS. 


LOAD: To load a program. 


RELEASE: To release a program.

Report Error

View answer Workspace Report Error Discuss

0 2472
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 2472
Q:

Why synchronization?

Answer

When ever two or more threads are sharing same data for updating then unpredicted result will be there in the data.


For Example take a thread is depositing amount in Account Object and another thread is withdrawing amount from the same Account Object.


when ever both threads are executed simultaneously then unexpected result is stored in the balance of the  Account Object. 

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2471
Q:

We can modify an existing Company from

A) Company Info > Alter B) Gateway of Tally > Modify Company
C) Company Info > Alter Company D) All of the above
 
Answer & Explanation Answer: A) Company Info > Alter

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 2470
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 2469
Q:

Dynamic remarketing lets an advertiser

A) Re-run ad to increase the volume of people who will see it. B) Show prior visitors to his site ads that are based on products or services they saw on the site.
C) Show an ad to someone on his mobile device 24 hours after visiting the website on desktop PC. D) Engage visitors to the website by opening a chat session.
 
Answer & Explanation Answer: B) Show prior visitors to his site ads that are based on products or services they saw on the site.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Advertising and Media
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk

5 2467
Q:

Difference between transparent tables and pooled tables

Answer

Transparent tables: Transparent tables in the dictionary has a one-to-one relation with the table in database. Its structure corresponds to single database field. Table in the database has the same name as in the dictionary. Transparent table holds application data.



Pooled tables: Pooled tables in the dictionary has a many-to-one relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level.

Report Error

View answer Workspace Report Error Discuss

Subject: ABAP

0 2467