Interview Questions

Language Integrated Query (LINQ) adds the ability to query objects using .NET languages. The LINQ to SQL object/relational mapping (O/RM) framework provides the following basic features:

- Tools to create classes (usually called entities) mapped to database tables

- Compatibility with LINQ's standard query operations

- The DataContext class, with features such as entity record monitoring, automatic SQL statement generation, record concurrency detection, and much more

Debenture holder are those who provides long term loan at specific interest rate in term of cash and creditor provides only short term credit in term of cash for purchasing of goods.

$result = mysql_query($sql, $db_link);
$num_rows = mysql_num_rows($result);
echo "$num_rows rows found";

Permissions in PHP are very similar to UNIX. Each file has three types of permissions – Read, write and execute. Permissions can be changed using the change mode or CHMOD command. CHMOD is followed by 3 digit number specifying the permission type. CHMOD 777 is for Read, Write and execute.

Unnecessary permissions can be stripped off using UNMASK command.

Unmask (777);

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );

Money market instruments are debt securities that generally give the owner the unconditional right to receive a stated, fixed sum of money on a specified date.

There are several money market instruments in most Western countries, including treasury bills, commercial paper, bankers' acceptances, deposits, certificates of deposit, bills of exchange, repurchase agreements, federal funds, and short-lived mortgage- and asset-backed securities.

The intention of the interviewer by asking this question is to discover the pain points for the candidate.

Here this can be explained with an example like this :

The administrative assistant might seem like someone whose job is simply keeping everything filed and organized and scheduled. But they actually are the building block of the entire office, making everyone's lives function more smoothly and with good access to information when they need it.

Sometimes I have so many things crossing my desk at a given time that I can get a bit overwhelmed. When this happens I take a deep breath and focus on prioritizing the work. Then I get a clear head again and can dive back in.

A junction record is a member record type that allows for many-to-many relationship between its two owner records.