Interview Questions

Q:

Explain the use of keyword WITH ENCRYPTION. Create a Store Procedure with Encryption

Answer

It is a way to convert the original text of the stored procedure into encrypted form. The stored procedure gets obfuscated and the output of this is not visible to


CREATE PROCEDURE Abc


WITH ENCRYPTION


AS


<< SELECT statement>>


GO

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2962
Q:

A data warehouse is composed of

A) current data B) internal and external data sources
C) historical data from legacy systems D) historical & current data
 
Answer & Explanation Answer: C) historical data from legacy systems

Explanation:

A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. Data warehouses are designed to help you analyze your data.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle
Job Role: Database Administration , IT Trainer

3 2961
Q:

What is ODBC SQLPASSTHROUGH option?

Answer

We use SQLPASSTHROUGH options when we need applications to access data both in the front-end and back-end data servers with a single connection. SQL statements that cannot be executed in the solidDB front-end server are passed over to the back end. 


SQLPASSTHROUGH mode can be set as per session or per transaction. The connection between the front end and back end is made with a back-end compatible ODBC driver which is loaded dynamically in solidDB server.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2961
Q:

What command-line tool would help you discover for which port numbers your computer is listening?

Answer

netstat -n  (on Dos prompt)

Report Error

View answer Workspace Report Error Discuss

1 2960
Q:

Describe the .NET base class library

Answer

.NET’s Base class library exists in order to encapsulate huge number of common functions and makes them easily accessible to the developer. .NET base class library provides the functionality like ADO.NET, XML, Threading, IO, Security, Diagnostics, Resources, Globalization, collections etc. It serves as the main point of interaction between developer and runtime.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2960
Q:

What is the way in which the Asynchronous Transfer Mode works?

Answer

The Asynchronous Transfer Mode or ATM is a connection technology that works by transmitting data into organized 53 bytes (small) packages through a physical environment with a high efficiency. Packing data into small cells reduces transportation delay so the speeds reached by this technology are very high; it can reach even 10 Gb per second.

Report Error

View answer Workspace Report Error Discuss

1 2959
Q:

A Website address is a unique name that identifies a specific

A) Link B) PDA
C) Web browser D) Website
 
Answer & Explanation Answer: D) Website

Explanation:
Report Error

View Answer Report Error Discuss

0 2958
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 2956