Interview Questions

Q:

Which among the following are the capabilities of the Cursor?

A) It reads every row one by one. B) It can be parameterised and hence are flexible
C) It can be positioned to specific rows D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:

All the above listed actions are the functions of cursor

Report Error

View Answer Report Error Discuss

3 2622
Q:

Accounts that normally have debit balances are

A) Assets,Expenses,and Common stock B) Assets,Dividends,and Expenses
C) Assets,Expenses,and Revenues D) All of the above
 
Answer & Explanation Answer: B) Assets,Dividends,and Expenses

Explanation:
Report Error

View Answer Report Error Discuss

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

3 2621
Q:

Which capital gains tax on property?

Answer

Capital Gains Tax on Property:


1. Short term,


2. Long term


 


Short Term Capital Gain on property is considered as a gain from selling a property which was held by you for less than 36 months. As a taxpayer, you are liable to pay tax on short term capital gain on property as per your applicable marginal income tax slab.


* Current Short Term Capital Gains tax rate is 30%.


 


Long Term Capital Gain



When you sell your property that is owned by you for more than three years, any gain arising from such sale will be considered as long term capital gain. Long term capital gain is calculated as the difference between net sales consideration and indexed cost of property.


* Current Long Term Capital Gains tax rate is 20%.

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Payable Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

2 2618
Q:

If I call performSelector:withObject:afterDelay: – is the object retained?

Answer

Yes the object is retained. It creates a timer that calls a selector on the current threads run loop. It may not be 100% precise time-wise as it attempts to dequeue the message from the run loop and perform the selector.

Report Error

View answer Workspace Report Error Discuss

0 2617
Q:

How can we call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL?

Answer

EXECUTE IMMEDIATE command can be used to call DDL statements. 


Example:


BEGIN


EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';


END;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2616
Q:

What is the Routing Information Protocol or RIP?

Answer

RIP is a is an interior gateway protocol that was often used in interior networks and in some degree in internet networks. It helps the router adapt to the modifications that are made in a network regarding connections. Now it become less used since more efficient protocols were implemented like OSPF or IS-IS. It is limited to a lower number of routers, a maximum of fifteen router.

Report Error

View answer Workspace Report Error Discuss

0 2615
Q:

What is the difference between view and materialized view?

Answer

View:


- Tail raid data representation is provided by a view to access data from its table.


- It has logical structure can not occupy space.


- Changes get affected in corresponding tables.


 


Materialized view


- Pre calculated data persists in materialized view.


- It has physical data space occupation.


- Changes will not get affected in corresponding tables.

Report Error

View answer Workspace Report Error Discuss

0 2615
Q:

What files are important in a bootable Windows XP operating system?

Answer

There are four important files in order to make a bootable Windows XP operating system. These are Ntldr, Ntdetect, Boot.ini and Ntfs.sys

Report Error

View answer Workspace Report Error Discuss

0 2614