INTERVIEW QUESTIONS

1          Tell me about yourself?

 

2      Why did you leave your last job?

 

3.     What experience do you have in this field?

 

4.     Do you consider yourself successful?

 

5.     What do co-workers say about you?

 

6.     What do you know about this organization?

 

7.     What have you done to improve your knowledge in the last year?

 

.8.     Are you applying for other jobs?

 

9.     Why do you want to work for this organization?

 

10.  Do you know anyone who works for us?

 

11.  What kind of salary do you need?

 

12.  Are you a team player?

 

13.  How long would you expect to work for us if hired?

 

14.  Have you ever had to fire anyone? How did you feel about that?

 

15.  In which position do you want to work?

 

16.  If you had enough money to retire right now, would you?

 

17.  Have you ever been asked to leave a position?

 

18.  Explain how you would be an asset to this organization?

 

.19.  Why should we hire you?

 

20.  Tell me about a suggestion you have made?

 

.21.  What irritates you about co-workers?

 

22.  What is your greatest strength?

23.  Tell me about your dream job?

 

24.  Why do you think you would do well at this job?

 

25.  What are you looking for in a job?

 

26.  What kind of person would you refuse to work with?

 

27.  What is more important to you: the money or the work?

 

28.  What would your previous supervisor say your strongest point is?

 

29.  Tell me about a problem you had with a supervisor?

 

30.  What has disappointed you about a job?

 

31.  Tell me about your ability to work under pressure?

 

32.  Do your skills match this job or another job more closely?

 

33.  What motivates you to do your best on the job?

 

34.  Are you willing to work overtime?

 

35.  Would you be willing to relocate if hired?

 

36.  How would you know you were successful on this job?

 

37. What is your philosophy towards work?

Different types of Servers

Different types of Servers used in networks are listed below.

File Server: File servers are used to store the user documents and files centrally. An ideal file server should have a large amount of memory and storage space, fast hard-disks, multiple processors, fast network adapters, redundant power supplies etc.

A File server runs FTP (File Transfer Protocol) in Windows, Linux or Unix Networks, or SMBP (Server Message Block Protocol) in Windows Networks. Well known FTP software products are Micrsoft IIS, vsftpd, Apache FTP Server etc.

The main advantage of keeping network user files and electronic documents centrally in a file server is that the network user files and documents can be managed (backup'd) easily. Think about managing network user files and electronic documents kept distributed inside user workstations in a network consists of thousands of computers! Nearly impossible.

Print Server: Print Server, which redirects print jobs from client computers to specific printers.

Mail Server: Mail Servers are used to transmit emails using email protocols. Most widely used email transmission protocol is SMTP (Simple Mail Transfer Protocol). Mail Servers exchange emails between different domains.

Most widely used Mail Server software products are Microsoft Exchange Server, SENDMAIL (now proofpoint), qmail,Postfix etc.

Application Server: Common computer applications or programs which are required by different network users can be run in a central server, which enables multiple network users to access common network applications from the network. Typically Application Servers run business logic. Which means, every business is different and the Application Server is the Server Software which controls the business process. Some examples for Application Server Software are SAP BASIS, WebLogic, WebSphere etc.

Database Server: Database Server allows authorized network clients to create, view, modify and/or delete an organization's data, stored in a common database.

Examples of Database Management Systems are Oracle 10g/11g, Microsoft SQL Server 2000/2005/2008/2012, PostgreSQL,IBM DB2, MySQL, Sybase, Informix etc.

Directory Servers: Directory Servers allows the central administration and management of network users and network resources. Directory Servers provide the basic functions of network security, Authentication, Authorization and Accounting.

Examples of Directory Servers are Microsoft Active Directory, NetIQ eDirectory, Fedora Directory Server, OpenLDAP etc.

Another logical classification of computer networks is Centralized and Distributed Computer Network Model.

Centralized computer network model

In Centralized computer network model, the network resources are placed and managed from a main location. Centralized network model allows administrators to manage the resources centrally (typically in Head Office). The network servers and other critical network resources are located in a central location in a secure and dedicated server room.

Centralized network model provides following advantages to Network and System Administrators.

Centralized network model provides Network and System Administrators better access to network devices

In Centralized network model, Network Resources can be managed more easily

Centralized network model provides better Network Security.

The main disadvantage is more work load of Network and System Administrators and increased risk of communication failure due to a catastrophe in the central location.

Distributed network model

In Distributed network model, the network resources are placed and managed from different geographical locations. Designated network and system administrators manage the network resources in different locations. These days most of the Enterprise network models are distributed.

                                                                       

Internetworks

Internetworks

Before discussing about the terms internet, intranet and extranet, we need to discuss the term Internetwork.

An internetwork can be defined as two or more computer networks (typically Local Area Networks LAN) which are connected together, usinng Network Routers.

Each network in an Internetwork has its own Network Address, which is different from other networks inside the Internetwork. Network Address is used to identify the networks inside an Internetwork.

Internetwork allows different users at different geographical locations of an organization to share data, resources and to communicate. Modern businesses cannot even function without Internetwork. Internet, Intranet and Extranet are different types of internetwork.

Internet, Intranet and Extranet

             

Internet: Internet is a worldwide, publicly accessible computer network of interconnected computer networks (internetwork) that transmit data using the standard Internet Protocol (IP). Internet is the world's largest Internetwork .

The terms World Wide Web (WWW) and Internet are not the same. The Internet is a collection of interconnected computer networks, linked by copper wires, fiber-optic cables, wireless connections, etc. World Wide Web (WWW) is a collection of interconnected documents and other resources, linked by hyperlinks and URLs. The World Wide Web is one of the services accessible via the Internet, along with various others including email, file sharing, remote administration, video streaming, online gaming etc.

Intranet: An intranet is a private network that is contained within an enterprise. It may consist of many interlinked local area networks and use any Wide Area Network (WAN) technologies for network connectivity. The main purpose of an intranet is to share company information and computing resources among employees. Intranet is a private Internetwork, which is usually created and maintained by a private organization. The content available inside Intranet are intended only for the members of that organization (usually employees of a company).

Extranet: An extranet can be viewed as part of a company's intranet that is extended to users outside the company like suppliers, vendors, partners, customers, or other business associates.

Extranet is required for normall day-to-day business activities. For example, Placing order to registered vendors, Billing & Invoices, Payments, Joint Ventures, Product Brochures for Partners, Discounted price lists for partners etc.

Difference between Windows 2003 Basic and Dynamic disks

Difference between Windows 2003 Basic and Dynamic disks

Physical disk drives are hardware device that can be installed or attached to a computer for data storage purpose. Windows 2003 should automatically detect any disk drive you install the computer. The main tool which ships with Windows 2003 for disk management is Disk Management MMC snap-in. You must be a member of the local Administrators group, the Backup Operators group, or have been delegated permission to manage basic and dynamic disks. To format a disk, you require administrator privileges. Windows 2003 supports two storage types; Basic disks and Dynamic Disks. Basic Disks Basic storage uses normal partition tables supported by MS-DOS, Microsoft Windows 95, Microsoft Windows 98, Microsoft Windows Millennium Edition (Me), Microsoft Windows NT, Microsoft Windows 2000, Windows Server 2003 and Windows XP. A disk initialized for basic storage is called a basic disk. A basic disk can have up to four primary partitions or up to three primary partitions and one extended partition. Each primary partition is represented with one logical volume. Each extended partition is represented by one or more logical drives. Dynamic Disks Dynamic storage is available in Windows XP Professional, Windows 2000 and Windows 2003 Server. A disk initialized for dynamic storage is called a dynamic disk. A dynamic disk contains dynamic volumes, such as simple volumes, spanned volumes, striped volumes, mirrored volumes, and RAID-5 volumes. With dynamic disks, we can create fault tolerant volumes. Non-fault tolerant volumes provide no data redundancy. If a non-fault tolerant drive fails, the data can be recovered only from backup. Fault tolerant volumes provide data redundancy. If a fault tolerant drive fails, you can rebuild the volume without having to recover data from backup.

Explain the PDCA cycle and where testing fits in

Software testing is an important part of the software development process. In normal software development there are four important steps, also referred to, in short, as the PDCA (Plan, Do, Check, Act) cycle.

Let's review the four steps in detail.

1.    Plan: Define the goal and the plan for achieving that goal.

2.    Do/Execute: Depending on the plan strategy decided during the plan stage we do execution accordingly in this phase.

3.    Check: Check/Test to ensure that we are moving according to plan and are getting the desired results.

4.    Act: During the check cycle, if any issues are there, then we take appropriate action accordingly and revise our plan again.

So developers and other stakeholders of the project do the "planning and building," while testers do the check part of the cycle. Therefore, software testing is done in check part of the PDCA cyle.

SQL SELECT Statement:

SQL SELECT Statement:

Syntax:

 SELECT  column1, column2....columnN

 FROM   table_name

SELECT:   Identify what columns 

FROM   :   Identify which table

Examples  :1.   Select * from Employee  ; It will Display all Details from Employee Table.

                 2 .  Select * from Department ; It will Display all Details from Department Table.

                 3.   Select * from Table ;  List all the Table .

SQL DISTINCT Clause:

We should use DISTINCT to select only Unique value from Table.

Syntax:

SELECT DISTINCT column1, column2....columnN

FROM   table_name;

Examples : 1 : Select DISTINCT Department number from  Employee ;

SQL WHERE Clause:

WHERE is Used for Restricting the Record to be Displayed .

Syntax:

SELECT column1, column2....columnN

FROM   table_name

WHERE  CONDITION;

Examples :

 1.  Select * from Employee WHERE   Department number =10 ;  It will Display all employee Details  only from Department number =10.

2.  Select Employee Name, Salary WHERE Job =' MANAGER' ; ( Here  MANAGER is case sensitive)

3.   Select * from Employee Where Hire Date = '03-Dec-2012' ;

SQL - RDBMS Databases

 RDBMS Databases

There are many popular RDBMS available to work with. This tutorial gives a brief overview of few most popular RDBMS. This would help you to compare their basic features:

MySQL

MySQL is open source SQL database, which is developed by Swedish company MySQL AB. MySQL is pronounced "my ess-que-ell," in contrast with SQL, pronounced "sequel."

MySQL is supporting many different platforms including Microsoft Windows, the major Linux distributions, UNIX, and Mac OS X.

MySQL has free and paid versions, depending on its usage (non-commercial/commercial) and features. MySQL comes with a very fast, multi-threaded, multi-user, and robust SQL database server.

History:

• Development of MySQL by Michael Widenius & David Axmark beginning in 1994.
• First internal release on 23 May 1995.
• Windows version was released on 8 January 1998 for Windows 95 and NT.
• Version 3.23: beta from June 2000, production release January 2001.
• Version 4.0: beta from August 2002, production release March 2003 (unions).
• Version 4.01: beta from August 2003, Jyoti adopts MySQL for database tracking.
• Version 4.1: beta from June 2004, production release October 2004.
• Version 5.0: beta from March 2005, production release October 2005.
• Sun Microsystems acquired MySQL AB on 26 February 2008.
• Version 5.1: production release 27 November 2008.

Features:

• High Performance.
• High Availability.
• Scalability and Flexibility Run anything.
• Robust Transactional Support.
• Web and Data Warehouse Strengths.
• Strong Data Protection.
• Comprehensive Application Development.
• Management Ease.
• Open Source Freedom and 24 x 7 Support.
• Lowest Total Cost of Ownership.

MS SQL Server

MS SQL Server is a Relational Database Management System developed by Microsoft Inc. Its primary query languages are:

• T-SQL.
• ANSI SQL.

History:

• 1987 - Sybase releases SQL Server for UNIX.
• 1988 - Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2.
• 1989 - Microsoft, Sybase, and Aston-Tate release SQL Server 1.0 for OS/2.
• 1990 - SQL Server 1.1 is released with support for Windows 3.0 clients.
• Aston-Tate drops out of SQL Server development.
• 2000 - Microsoft releases SQL Server 2000.
• 2001 - Microsoft releases XML for SQL Server Web Release 1 (download).
• 2002 - Microsoft releases SQLXML 2.0 (renamed from XML for SQL Server).
• 2002 - Microsoft releases SQLXML 3.0.
• 2005 - Microsoft releases SQL Server 2005 on November 7th, 2005.

Features:

• High Performance.
• High Availability.
• Database mirroring.
• Database snapshots.
• CLR integration.
• Service Broker.
• DDL triggers.
• Ranking functions.
• Row version-based isolation levels.
• XML integration.
• TRY...CATCH.
• Database Mail.

ORACLE

It is very large and multi-user database management system. Oracle is a relational database management system developed by 'Oracle Corporation'.

Oracle works to efficiently manage its resource, a database of information, among the multiple clients requesting and sending data in the network.

It is an excellent database server choice for client/server computing. Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare, UnixWare, OS/2 and most UNIX flavors.

History:

Oracle began in 1977 and celebrating its 32 wonderful years in the industry (from 1977 to 2009).

• 1977 - Larry Ellison, Bob Miner and Ed Oates founded Software Development Laboratories to undertake development work.
• 1979 - Version 2.0 of Oracle was released and it became first commercial relational database and first SQL database. The company changed its name to Relational Software Inc. (RSI).
• 1981 - RSI started developing tools for Oracle.
• 1982 - RSI was renamed to Oracle Corporation.
• 1983 - Oracle released version 3.0, rewritten in C language and ran on multiple platforms.
• 1984 - Oracle version 4.0 was released. It contained features like concurrency control - multi-version read consistency etc.
• 1985 - Oracle version 4.0 was released. It contained features like concurrency control - multi-version read consistency etc.
• 2007 - Oracle has released Oracle11g. The new version focused on better partitioning, easy migration etc.

Features:

• Concurrency
• Concurrency
• Read Consistency
• Locking Mechanisms
• Quiesce Database
• Portability
• Self managing database
• SQL*Plus
• ASM
• Scheduler
• Resource Manager
• Data Warehousing
• Materialized views
• Bitmap indexes
• Table compression
• Parallel Execution
• Analytic SQL
• Data mining
• Partitioning

MS- ACCESS

This is one of the most popular Microsoft products. Microsoft Access is entry-level database management software. MS Access database is not only an inexpensive but also powerful database for small-scale projects.

MS Access uses the Jet database engine which utilizes a specific SQL language dialect (sometimes referred to as Jet SQL).

MS Access comes with the professional edition of MS Office package. MS Access has easy to use intuitive graphical interface.

History:

• 1992 - Access version 1.0 was released.
• 1993 - Access 1.1 release to improve compatibility with include the Access Basic programming language.
• The most significant transition was from the Access 97 to the Access 2000
• 2007 - Access 2007, a new database format was introduced ACCDB which supports complex data types such as multi valued and attachment fields.

Features:

• Users can create tables, queries, forms and reports, and connect them together with macros.
• The import and export of data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc.
• There is also the Jet Database format (MDB or ACCDB in Access 2007) which can contain the application and data in one file. This makes it very convenient to distribute the entire application to another user, who can run it in disconnected environments.
• Microsoft Access offers parameterized queries. These queries and Access tables can be referenced from other programs like VB6 and .NET through DAO or ADO.
• The desktop editions of Microsoft SQL Server can be used with Access as an alternative to the Jet Database Engine.
• Microsoft Access is a file server-based database. Unlike client-server relational database management systems (RDBMS), Microsoft Access does not implement database triggers, stored procedures, or transaction logging.

Part time job available HERE