Interview Questions

Q:

Explain i) Rename ii) Alias.

Answer

- Rename : It is a permanent name provided to a table or column.
- Alias : It is a temporary name provided to a table or column which gets over after the execution of SQL statement.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 3103
Q:

What Is a Session in PHP?

Answer

A PHP Session persist the user information to be used later. For example, user name, password, shopping item details. The session is temporary and will be removed soon after the user has left the web site. The session can be persisted for long term usage on databases like MySQL. Each session is identified by a unique Id number for every visitor. The first step to use PHP session is to start the session. The starting session must precede the operations like HTML or the other.


The statement session_start() starts the PHP session and registers the user’s information on the server.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 3101
Q:

What is WHEN-Database-record trigger?

Answer

Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

Report Error

View answer Workspace Report Error Discuss

2 3100
Q:

What is locking ? what are the advantages of locking?

Answer

Locking is a mechanism to ensure data integrity while allowing maximum concurrent access to data. It is used to implement concurrency control when multiple users access table to manipulate its data at the same time.


Advantages :


- Avoids deadlock conditions


- Avoids clashes in capturing the resources

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 3100
Q:

What is the meaning of Copy IDMS Subschema-Binds?

Answer

It generates a bind run-unit and binds all the records for the sub-schema the program is referencing.

Report Error

View answer Workspace Report Error Discuss

0 3095
Q:

What’s the special meaning of __sleep and __wakeup?

Answer __sleep returns the array of all the variables than need to be saved, while __wakeup retrieves them.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 3095
Q:

In HTML document the tags are

A) hidden keywords B) used to display the content
C) Both A & B D) None of the above
 
Answer & Explanation Answer: C) Both A & B

Explanation:

Hypertext Markup Language (HTML) is the standard markup language for creating web pages and web applications.

HTML tags are the hidden keywords within a web page that define how your web browser must format and display the content. Most tags must have two parts, an opening and a closing part. For example, <html> is the opening tag and </html> is the closing tag.

Report Error

View Answer Report Error Discuss

Filed Under: Web Technology
Job Role: IT Trainer

8 3093
Q:

Commercial banks are funded through which of the following?

A) Customer deposits B) Services
C) Stock holders D) Government funding
 
Answer & Explanation Answer: A) Customer deposits

Explanation:

A commercial bank is a financial body which performs the functions of accepting deposits from the general public and giving short term loans for investment with the aim of earning profit.

Report Error

View Answer Report Error Discuss

Filed Under: Bank Interview
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 3090