Generic interview questions to ponder

By admin | December 4, 2006
  1. Tell me about yourself?
  2. Which adjectives would you use to describe yourself?
  3. What is your greatest strength?
  4. What is your greatest weakness?
  5. Why do you want this position?”
  6. Why do you want to leave your current job? (Why did you leave your last job?)
  7. How do you handle stressful situations?
  8. What is the toughest problem you’ve had to face, and how did you overcome it?
  9. Why do you want this position?
  10. Why are you the best person for this job?
Posted in General | 1 Comment

11 advanced MySQL questions

By admin | December 4, 2006
  1. Explain MySQL architecture. - The front layer takes care of network connections and security authentications, the middle layer does the SQL query parsing, and then the query is handled off to the storage engine. A storage engine could be either a default one supplied with MySQL (MyISAM) or a commercial one supplied by a third-party vendor (ScaleDB, InnoDB, etc.)
  2. Explain MySQL locks. - Table-level locks allow the user to lock the entire table, page-level locks allow locking of certain portions of the tables (those portions are referred to as tables), row-level locks are the most granular and allow locking of specific rows.
  3. Explain multi-version concurrency control in MySQL. - Each row has two additional columns associated with it - creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers.

    4. Read More »

Posted in Database | Leave a comment

Interview questions for a sysadmin

By admin | November 21, 2006

Siddharth sent in questions he got for sysadmin interview:

  1. Difference between layer 2 and layer 3 devices?
  2. What is VLAN?
  3. What is the subnet for a class C network?
  4. Are you familiar with automounter?
  5. Have you configured an NIS server/client?
  6. Have your configured a NFS server?
  7. Windows and Linux interoperability how to?
  8. What is RAID 1?
Posted in General, Unix/Linux | 6 Comments

Business Objects interview question

By admin | November 19, 2006
  1. Explain detail objects? - Sol: Detail objects are attached to dimensions, one cannot drill on details nor link on details when linking multiple data providers. While Customer ID would be a dimension, customer name, address, phone and soon should be details.
  2. What is BOMain.Key? - BoMain.Key file contains the information about the repository site i.e it contains the address of the repository security domain.
  3. What is Business objects Repository? - it is nothing but metadata.
  4. What is domain? How many are there in a basic setup? What are they? - Domain is nothing but logical grouping of system tables, There are three domains usually in a basic setup, They are Secure, Universe, Document. Business objects are sometimes called domain objects (where the word domain means the business), and a domain model represents the set of domain objects and the relationships between them.
  5. When is the Repository created? - In 5i/6i versions after installing the software, whereas in Xi version a repository is created at the time of installation.

    6. Read More »

Posted in General | 5 Comments

QTP interview questions and answers

By admin | October 19, 2006
  1. What are the Features & Benefits of Quick Test Pro (QTP 8.0)? - Operates stand-alone, or integrated into Mercury Business Process Testing and Mercury Quality Center. Introduces next-generation zero-configuration Keyword Driven testing technology in Quick Test Professional 8.0 allowing for fast test creation, easier maintenance, and more powerful data-driving capability. Identifies objects with Unique Smart Object Recognition, even if they change from build to build, enabling reliable unattended script execution. Collapses test documentation and test creation to a single step with Auto-documentation technology. Enables thorough validation of applications through a full complement of checkpoints.
  2. How to handle the exceptions using recovery scenario manager in QTP? - There are 4 trigger events during which a recovery scenario should be activated. A pop up window appears in an opened application during the test run: A property of an object changes its state or value, A step in the test does not run successfully, An open application fails during the test run, These triggers are considered as exceptions.You can instruct QTP to recover unexpected events or errors that occurred in your testing environment during test run. Recovery scenario manager provides a wizard that guides you through the defining recovery scenario. Recovery scenario has three steps: 1. Triggered Events 2. Recovery steps 3. Post Recovery Test-Run

    3. Read More »

Posted in Testing | 74 Comments

A dozen .NET questions

By admin | October 12, 2006
  1. Differences between DLL and EXE?
  2. Can an assembly have EXE?
  3. Can a DLL be changed to an EXE?
  4. Compare & contrast rich client (smart clients or Windows-based) & browser-based Web application
  5. Compare Client server application with n-Tier application
  6. Can a try block have more than one catch block?
  7. Can a try block have nested try blocks?
  8. How do you load an assembly at runtime?
  9. If I am writing in a language like VB or C++, what are the procedures to be followed to support .NET?
  10. How do you view the methods and members of a DLL?
  11. What is shadowing?
  12. What are the collections you’ve used?
Posted in .NET | 26 Comments

31 more MySQL questions

By admin | September 30, 2006
  1. What is DDL, DML and DCL? - If you look at the large variety of SQL commands, they can be divided into three large subgroups. Data Definition Language deals with database schemas and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL. DML deals with data manipulation, and therefore includes most common SQL statements such SELECT, INSERT, etc. Data Control Language includes commands such as GRANT, and mostly concerns with rights, permissions and other controls of the database system.
  2. How do you get the number of rows affected by query? - SELECT COUNT (user_id) FROM users would only return the number of user_id’s.

    3. Read More »

Posted in Database | 7 Comments

29 MySQL interview questions

By admin | September 5, 2006
  1. How do you start and stop MySQL on Windows? - net start MySQL, net stop MySQL
  2. How do you start MySQL on Linux? - /etc/init.d/mysql start
  3. Explain the difference between mysql and mysqli interfaces in PHP? - mysqli is the object-oriented version of mysql library functions.
  4. What’s the default port for MySQL Server? - 3306
  5. What does tee command do in MySQL? - tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by command notee.
  6. Can you save your connection settings to a conf file? - Yes, and name it ~/.my.conf. You might want to change the permissions on the file to 600, so that it’s not readable by others.
  7. How do you change a password for an existing user via mysqladmin? - mysqladmin -u root -p password "newpassword"
  8. Use mysqldump to create a copy of the database? - mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql
  9. Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools.
  10. What are some good ideas regarding user security in MySQL? - There is no user without a password. There is no user without a user name. There is no user whose Host column contains % (which here indicates that the user can log in from anywhere in the network or the Internet). There are as few users as possible (in the ideal case only root) who have unrestricted access.
  11. Explain the difference between MyISAM Static and MyISAM Dynamic. - In MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.
  12. Read More »
Posted in Database | 6 Comments

Simple FreeBSD questions

By admin | August 26, 2006

Test the basic knowledge of FreeBSD.

  1. What’s in the file /etc/ttys? - Configuration for virtual consoles for the startup. By default FreeBSD has 8 virtual consoles.
  2. You’re told that the permissions of a file are 645. Quick, how do you calculate what it means? - The permissions value are always 4 for read, 2 for write, 1 for execute. The three numbers are always for owner, group, and everybody on the system. Therefore 645 means: owner - read and write, group - read only, everybody - read and execute. You’ll rarely see such a permission set, but for interview question it might just work.

    3. Read More »

Posted in Unix/Linux | Leave a comment

Apache interview questions and answers

By admin | August 25, 2006
  1. On a fresh install, why does Apache have three config files - srm.conf, access.conf and httpd.conf? - The first two are remnants from the NCSA times, and generally you should be ok if you delete the first two, and stick with httpd.conf.
  2. What’s the command to stop Apache? - kill the specific process that httpd is running under, or killall httpd. If you have apachectl installed, use apachectl stop.
  3. What does apachectl graceful do? - It sends a SIGUSR1 for a restart, and starts the apache server if it’s not running.
  4. How do you check for the httpd.conf consistency and any errors in it? - apachectl configtest

    5. Read More »

Posted in Unix/Linux, Web dev | 7 Comments

Networking questions

By admin | August 13, 2006
  1. What is a default gateway? - The exit-point from one network and entry-way into another network, often the router of the network.
  2. How do you set a default route on an IOS Cisco router? - ip route 0.0.0.0 0.0.0.0 x.x.x.x [where x.x.x.x represents the destination address]
  3. What is the difference between a domain local group and a global group? - Domain local groups grant permissions to objects within the domain in which the reside. Global groups contain grant permissions tree or forest wide for any objects within the Active Directory.
  4. What is LDAP used for? - LDAP is a set of protocol used for providing access to information directories.
  5. What tool have you used to create and analyze packet captures? - Network Monitor in Win2K / Win2K3, Ethereal in Linux, OptiView Series II (by Fluke Networks).
  6. How does HSRP work?
  7. What is the significance of the IP address 255.255.255.255? - The limited broadcast address is utilized when an IP node must perform a one-to-everyone delivery on the local network but the network ID is unknown.
Posted in Networking | 28 Comments

SAP ABAP frequent questions cheatsheet

By admin | August 11, 2006
  1. How do you call SAP script in reports & reports in SAP script?
  2. What is different between SAP script & reports?
  3. What is stack?
  4. What is the defination of ALE RFC?
  5. Why is BAPI required? How about BDC?
  6. What happens if I use control break statement in between select & endselect?
  7. What is lock Object

    8. Read More »

Posted in Database, General, SAP ABAP | 7 Comments