Interview Questions

Q:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Report Error

View answer Workspace Report Error Discuss

5 2275
Q:

Demand is said to be inelastic when

A) Percentage change in demand is less than the percentage change in price of the good B) Percentage change in demand is greater than the percentage change in price of the good
C) Percentage change in demand is equal to the percentage change in price of the good D) None of the above
 
Answer & Explanation Answer: A) Percentage change in demand is less than the percentage change in price of the good

Explanation:

Demand is said to be inelastic, when the demand for the good doesn't change much or it is negotiable when the price of the good changed.

Report Error

View Answer Report Error Discuss

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

1 2274
Q:

What is DHCP scope?

Answer

A scope is a range, or pool, of IP addresses that can be leased to DHCP clients on a given subnet.

Report Error

View answer Workspace Report Error Discuss

0 2273
Q:

Depreciation is a process of

A) Allocation B) Valuation
C) Both A & B D) Appropriation
 
Answer & Explanation Answer: A) Allocation

Explanation:

Depreciation is a process of cost allocation, not valuation. In accounting, the term depreciation refers to the allocation of cost of a tangible asset to expense to the periods in which the asset is expected to be used to obtain the economic benefit.

 

In brief, Depreciation is fall in the value of assets due to wear and tear over a period of time, it is a loss.

Report Error

View Answer Report Error Discuss

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

0 2270
Q:

How can you prevent a class from overriding in C# and Visual Basic?

Answer

You can prevent a class from overriding in C# by using the sealed keyword; whereas, the NotInheritable keyword is used to prevent a class from overriding in Visual Basic.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2270
Q:

What are the uses of synonyms?

Answer

- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 2266
Q:

What do you mean by a tablespace?

Answer

- These are the Logical Storage Units into which a database is divided.
- It is used to group together the related logical structures.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2266
Q:

What are the usages of the Command object in ADO.NET?

Answer

The following are the usages of the Command object in AD0.NET:

The Command object in AD0.NET executes a command against the database and retrieves a DataReader or DataSet object.

  =>  It also executes the INSERT, UPDATE, or DELETE command against the database.
  =>  All the command objects are derived from the DbCommand class.
  =>  The command object is represented by two classes: SqlCommand and OleDbCommand.
  =>  The Command object provides three methods to execute commands on the database:
  =>  The ExecuteNonQuery() method executes the commands and does not return any value.
  =>  The ExecuteScalar() method returns a single value from a database query.
  =>  The ExecuteReader() method returns a result set by using the DataReader object.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2266