Archive

Archive for the ‘Interview Questions’ Category

Wireless engineer interview questions

Wireless engineer interview questions

A recruiter from Atlanta submitted this set of questions for interviewing at a wireless equipment company.

Describe your home WLAN setup.(Pay attention to candidate’s confidence. Plus if the candidate built it himself. Plus if the network is secured additionally, regardless of the protocols used. Plus if the candidate fought poor coverage.)

Ad-hoc vs. infrastructure topology. Advantages and disadvantages. Ad-hoc networks are easy to set up. By definition ad-hoc WLANs do not require access point, so they are cheaper. With infrastructured WLANs one can connect to wired LAN, enable wireless roaming for office workers, centralize WLAN management, boost the range.

Your preferred brand for wireless cards and access points. (An experienced candidate will be able to come up with strong argument to defend his preferences. He will point to the past projects as well.) Read more…

Categories: Networking Tags:

Unix sysadmin interview questions

Unix sysadmin interview questions

Q: How would you make the following SQL statement run faster? SELECT * FROM TABLEA WHERE COL1=’A’ AND COL2=’B’;
A: Make sure that COL1 and COL2 have indexes.
Find out which condition will return less values and use that as the first conditonal.

Q: What is Data Mining
A: Data Minig is the process of sifting through extremeley large amounts of Data to find trends or relevent information.

Q: Name the Seven layers in the OSI Model.
A: Appication, Presentation, Session, Transport, Network, Data Link, Phyiscal Read more…

Categories: Unix/Linux Tags:

C interview questions part1

C interview questions part1

What will print out?

main()
{
char *p1=“name”;
char *p2;
p2=(char*)malloc(20);
memset (p2, 0, 20);
while(*p2++ = *p1++);
printf(“%sn”,p2);

}

Answer:empty string.

What will be printed as the result of the operation below:

main()
{
int x=20,y=35;
x=y++ + x++;
y= ++y + ++x;
printf(“%d%dn”,x,y);

}
Answer : 5794

What will be printed as the result of the operation below:

main()
{
int x=5;
printf(“%d,%d,%dn”,x,x< <2,x>>2);

}
Answer: 5,20,1

What will be printed as the result of the operation below:

#define swap(a,b) a=a+b;b=a-b;a=a-b;

void main()
{
int x=5, y=10;
swap (x,y);
printf(“%d %dn”,x,y);
swap2(x,y);
printf(“%d %dn”,x,y);
}

int swap2(int a, int b)
{
int temp;
temp=a;
b=a;
a=temp;
return 0;

}
Answer: 10, 5 Read more…

Categories: C++ Tags:

Linux admin interview questions

Linux admin interview questions

How do you list the files in an UNIX directory while also showing hidden files? ls -ltra

How do you execute a UNIX command in the background? Use the “&”.

What UNIX command will control the default file permissions when files are created? umask

Explain the read, write, and execute permissions on a UNIX directory. Read allows you to see and list the directory contents. Write allows you to create, edit and delete files and subdirectories in the directory. Execute gives you the permissions to run programs or shells from the directory. Read more…

Categories: Unix/Linux Tags:

.NET Deployment questions

.NET Deployment questions

What do you know about .NET assemblies?
Assemblies are the smallest units of versioning and deployment in the .NET application. Assemblies are also the building blocks for programs such as Web services, Windows services, serviced components, and .NET remoting applications.

What’s the difference between private and shared assembly? Private assembly is used inside an application only and does not have to be identified by a strong name. Shared assembly can be used by multiple applications and has to have a strong name.

What’s a strong name? A strong name includes the name of the assembly, version number, culture identity, and a public key token.

How can you tell the application to look for assemblies at the locations other than its own install? Use the
directive in the XML .config file for a given application.

Categories: .NET Tags:

CCNA/Cisco admin interview questions

CCNA/Cisco admin interview questions

You need to retrieve a file from the file server for your word processing application, which layer of the OSI model is responsible for this function?

Presentation layer
Application layer
Session layer
Transport layer
Datalink layer

You are working in a word processing program, which is run from the file server. Your data comes back to you in an unintelligible manner. Which layer of the OSI model would you investigate?

Application layer
Presentation layer
Session layer
Network layer
Datalink layer
Read more…

Categories: Networking Tags:

SAS interview questions

SAS interview questions

What is a universe?

Analysis in business objects?

Who launches the supervisor product in BO for the first time?

How can you check the universe?

What are universe parameters?

Types of universes in business objects?

What is security domain in BO?

Where will you find the address of repository in BO?

What is broad cast agent?

In BO 4.1 version what is the alternative name for broadcast agent?

What services the broadcast agent offers on the server side?

How can you access your repository with different user profiles?

How many built-in objects are created in BO repository?

What are alerters in BO?

What are different types of saving options in web intelligence?

What is batch processing in BO?

How can you first report in BO by using broadcast agent?

Can we take report on Excel in BO?

Categories: Interview Questions Tags:

VB 6, COM, DCOM, Microsoft platform interview questions

VB 6, COM, DCOM, Microsoft platform interview questions

3 main differences between flexgrid control and dbgrid control

ActiveX and Types of ActiveX Components in VB

Advantage of ActiveX Dll over ActiveX Exe

Advantages of disconnected recordsets

Benefit of wrapping database calls into MTS transactions

Benefits of using MTS

Can database schema be changed with DAO, RDO or ADO?

Can you create a tabletype of recordset in Jet-connected ODBC database engine? Read more…

Categories: VB Tags:

SQL Server interview questions

SQL Server interview questions

How do you read transaction logs?

How do you reset or reseed the IDENTITY column?

How do you persist objects, permissions in tempdb?

How do you simulate a deadlock for testing purposes?

How do you rename an SQL Server computer?

How do you run jobs from T-SQL?

How do you restore single tables from backup in SQL Server 7.0/2000? In SQL Server 6.5?

Where to get the latest MDAC from?

I forgot/lost the sa password. What do I do? Read more…

Categories: Database Tags:

Unix/Linux administration interview questions

Unix/Linux administration interview questions

What is LILO?

LILO stands for Linux boot loader. It will load the MBR, master boot record, into the memory, and tell the system which partition and hard drive to boot from.

What is the main advantage of creating links to a file instead of copies of the file?

A: The main advantage is not really that it saves disk space (though it does that too) but, rather, that a change of permissions on the file is applied to all the link access points. The link will show permissions of lrwxrwxrwx but that is for the link itself and not the access to the file to which the link points. Thus if you want to change the permissions for a command, such as su, you only have to do it on the original. With copies you have to find all of the copies and change permission on each of the copies.

Write a command to find all of the files which have been accessed within the last 30 days.

find / -type f -atime -30 > December.files

This command will find all the files under root, which is ‘/’, with file type is file. ‘-atime -30? will give all the files accessed less than 30 days ago. And the output will put into a file call December.files. Read more…

Categories: Unix/Linux Tags:

C# developer interview questions

C# developer interview questions

A representative of a high-tech company in United Kingdom sent this in today noting that the list was used for interviewing a C# .NET developer. Any corrections and suggestions would be forwarded to the author. I won’t disclose the name of the company, since as far as I know they might still be using this test for prospective employees. Correct answers are in green color.

1) The C# keyword ‘int’ maps to which .NET type?

System.Int16

System.Int32

System.Int64

System.Int128

2) Which of these string definitions will prevent escaping on backslashes in C#?

string s = #”n Test string”;

string s = “’n Test string”;

string s = @”n Test string”;

string s = “n Test string”;

3) Which of these statements correctly declares a two-dimensional array in C#?

int[,] myArray;

int[][] myArray;

int[2] myArray;

System.Array[2] myArray;

4) If a method is marked as protected internal who can access it?

Classes that are both in the same assembly and derived from the declaring class.

Only methods that are in the same class as the method in question. Read more…

Categories: .NET Tags:

Advanced SAS interview questions

Advanced SAS interview questions

Describe the types of SAS programming tasks that you performed: Tables? Listings? Graphics? Ad hoc reports? Other?

Have you been involved in editing the data or writing data queries?

What techniques and/or PROCs do you use for tables?

Do you prefer PROC REPORT or PROC TABULATE? Why?

Are you involved in writing the inferential analysis plan? Tables specifications?

What do you feel about hardcoding?

How experienced are you with customized reporting and use of DATA _NULL_ features?

How do you write a test plan?

What is the difference between verification and validation?

What was the last computer book you purchased? Why?

What is your favorite all time computer book? Why?

Will it bother you if the guy at the next desk times the frequency and duration of your bathroom/coffee breaks on the grounds that ‘you are getting paid twice as much as he is’?

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says: ‘hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book!’

Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?

Can you start on Monday?

Do you think professionally?

How do you put a giraffe into the refrigerator? Correct answer: Open the refrigerator door, put the giraffe in, and close the door. This question tests whether or not the candidate is doing simple things in a complicated way.

How do you put an elephant in the refrigerator? Incorrect answer: Open the refrigerator door, put in the elephant, and close the door. Correct answer: Open the refrigerator door, take out the giraffe, put in the elephant, and close the door. This question tests your foresight.

The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend? Correct answer: The elephant. The elephant is in the refrigerator, remember? This tests if you are capable of comprehensive thinking.

There is a river notoriously known for it’s large crocodile population. With ease, how do you safely cross it? Correct answer: Simply swim across. All of the crocodiles are attending the Lion King’s animal conference. This questions your reasoning ability.

Describe a time when you were really stuck on a problem and how you solved it.

Describe the function and utility of the most difficult SAS macro that you have written.

Give me an example of ..

Tell me how you dealt with …

How do handle working under pressure?

Of all your work, where have you been the most successful?

What are the best/worst aspects of your current job?

If you could design your ideal job, what would it look like?

How necessary is it to be creative in your work?

If money were no object, what would you like to do?

What would you change about your job?

Categories: Interview Questions Tags:

Embedded systems interview questions

Embedded systems interview questions

Can structures be passed to the functions by value?

Why cannot arrays be passed by values to functions?

Advantages and disadvantages of using macro and inline functions?

What happens when recursion functions are declared inline?

Scope of static variables?

Difference between object oriented and object based languages?

Multiple inheritance – objects contain howmany multiply inherited ancestor? Read more…

Categories: Hardware Tags:

Oracle DBA interview questions

Oracle DBA interview questions

A reader submitted this via e-mail without explanation whether these questions were used for hiring a DBA at Oracle Corp., or whether it was the Oracle database admin position that someone interviewed for somewhere else.

Explain the difference between a hot backup and a cold backup and the benefits associated with each. – A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is shut down and does not require being in archive log mode. The benefit of taking a hot backup is that the database is still available for use while the backup is occurring and you can recover the database to any point in time. The benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process. In addition, since you are taking cold backups the database does not require being in archive log mode and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database? – I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

How do you switch from an init.ora file to a spfile? – Issue the create spfile from pfile command.

Explain the difference between a data block, an extent and a segment. – A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.
Read more…

Categories: Database, Interview Questions Tags:

Good C++ Interview questions

Good C++ Interview questions

TSome good C++ questions to ask a job applicant.

How do you decide which integer type to use?

What should the 64-bit integer type on new, 64-bit machines be?

What’s the best way to declare and define global variables?

What does extern mean in a function declaration?

What’s the auto keyword good for?

I can’t seem to define a linked list node which contains a pointer to itself.

How do I declare an array of N pointers to functions returning pointers to functions returning pointers
to characters?

ow can I declare a function that returns a pointer to a function of its own type?

My compiler is complaining about an invalid redeclaration of a function, but I only define it once and call it once. What’s happening?

What can I safely assume about the initial values of variables which are not explicitly initialized?

Why can’t I initialize a local array with a string?

What is the difference between char a[] = “string”; and char *p = “string”; ?

How do I initialize a pointer to a function.

Categories: C++ Tags:

Interview questions for network engineer

Interview questions for network engineer

Describe the OSI model.

What is the difference between a repeater, bridge, router? Relate this to the OSI model.

Describe an Ethernet switch and where it fits into the OSI model.

What is a VLAN? What is an ELAN? What is the difference?

Relate FDDI/ATM/SONET to the OSI model.

Explain how to configure a host network interface (e.g. IP address, netmask, broadcast address)? Read more…

Categories: Networking Tags:

ASP, ADO and IIS interview questions

ASP, ADO and IIS interview questions

This came in the mail from the reader who recently went through a job interview process. He didn’t mention the company name.
Why do you use Option Explicit?

What are the commonly used data types in VBScript?

What is a session object?

What are the three objects of ADO?

What are the lock-types available in ADO? Explain.

What are the cursor types available in ADO? Explain.

What is a COM component?

How do you register a COM component? Read more…

Categories: VB Tags:

SQL interview questions

SQL interview questions

Which of the following statements contains an error?

SELECT * FROM emp WHERE empid = 493945;
SELECT empid FROM emp WHERE empid= 493945;
SELECT empid FROM emp;
SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

Which of the following correctly describes how to specify a column alias?

Place the alias at the beginning of the statement to describe the table.
Place the alias after each column, separated by white space, to describe the column.
Place the alias after each column, separated by a comma, to describe the column.
Place the alias at the end of the statement to describe the table.

The NVL function

Assists in the distribution of output across multiple columns.
Allows the user to specify alternate output for non-null column values.
Allows the user to specify alternate output for null column values.
Nullifies the value of the column output.

Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?

PLAY_TABLE
————————————-
“Midsummer Night’s Dream”, SHAKESPEARE
“Waiting For Godot”, BECKETT
“The Glass Menagerie”, WILLIAMS
SELECT play_name || author FROM plays;
SELECT play_name, author FROM plays;
SELECT play_name||’, ‘ || author FROM plays;
SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;

Issuing the DEFINE_EDITOR=”emacs” will produce which outcome?

The emacs editor will become the SQL*Plus default text editor.
The emacs editor will start running immediately.
The emacs editor will no longer be used by SQL*Plus as the default text editor.
The emacs editor will be deleted from the system.

The user issues the following statement. What will be displayed if the EMPID selected is 60494?

SELECT DECODE(empid,38475, “Terminated”,60494, “LOA”, “ACTIVE”)
FROM emp;
60494
LOA
Terminated
ACTIVE

SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.

TRUE
FALSE

The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is

EMP
The table containing the column values
DUAL
An Oracle-defined table

Which of the following is not a group function?

avg( )
sqrt( )
sum( )
max( )

Once defined, how long will a variable remain so in SQL*Plus?

Until the database is shut down
Until the instance is shut down
Until the statement completes
Until the session completes

The default character for specifying runtime variables in SELECT statements is

Ampersand
Ellipses
Quotation marks
Asterisk

A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?

select e.empid, d.head from emp e, dept d;
select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;
select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);
select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;

Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?

A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU.
A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER.
A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.
A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.

User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?

INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
INSERT INTO employee VALUES (59694,’HARRIS’);
INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,’HARRIS’);
INSERT INTO employee (SELECT 59694 FROM ‘HARRIS’);

Which three of the following are valid database datatypes in Oracle? (Choose three.)

CHAR
VARCHAR2
BOOLEAN
NUMBER

Omitting the WHERE clause from a DELETE statement has which of the following effects?

The delete statement will fail because there are no records to delete.
The delete statement will prompt the user to enter criteria for the deletion
The delete statement will fail because of syntax error.
The delete statement will remove all records from the table.

Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.

TRUE
FALSE

Dropping a table has which of the following effects on a nonunique index created for the table?

No effect.
The index will be dropped.
The index will be rendered invalid.
The index will contain NULL values.

To increase the number of nullable columns for a table,

Use the alter table statement.
Ensure that all column values are NULL for all rows.
First increase the size of adjacent column datatypes, then add the column.
Add the column, populate the column, then add the NOT NULL constraint.

Which line of the following statement will produce an error?

CREATE TABLE goods
(good_no NUMBER,
good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),
CONSTRAINT pk_goods_01
PRIMARY KEY (goodno));
There are no errors in this statement.

MAXVALUE is a valid parameter for sequence creation.

TRUE
FALSE

Which of the following lines in the SELECT statement below contain an error?

SELECT DECODE(empid, 58385, “INACTIVE”, “ACTIVE”) empid
FROM emp
WHERE SUBSTR(lastname,1,1) > TO_NUMBER(’S’)
AND empid > 02000
ORDER BY empid DESC, lastname ASC;
There are no errors in this statement.

Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?

SQRT
DECODE
NEW_TIME
ROWIDTOCHAR

Which two of the following orders are used in ORDER BY clauses? (choose two)

ABS
ASC
DESC
DISC

You query the database with this command

SELECT name
FROM employee
WHERE name LIKE ‘_a%’;

Which names are displayed?
Names starting with “a”
Names starting with “aR
or “A”
Names containing “aR
as second character
Names containing “aR
as any letter except the first

Categories: Interview Questions Tags:

Intel interview questions

Intel interview questions

The following questions are used for screening the candidates during the first interview. The questions apply mostly to fresh college grads pursuing an engineering career at Intel.
Have you studied buses? What types?

Have you studied pipelining? List the 5 stages of a 5 stage pipeline. Assuming 1 clock per stage, what is the latency of an instruction in a 5 stage machine? What is the throughput of this machine ?

How many bit combinations are there in a byte?

For a single computer processor computer system, what is the purpose of a processor cache and describe its operation?

Explain the operation considering a two processor computer system with a cache for each processor.

What are the main issues associated with multiprocessor caches and how might you solve them?

Explain the difference between write through and write back cache.

Are you familiar with the term MESI?

Are you familiar with the term snooping?

Describe a finite state machine that will detect three consecutive coin tosses (of one coin) that results in heads.

In what cases do you need to double clock a signal before presenting it to a synchronous state machine?

You have a driver that drives a long signal & connects to an input device. At the input device there is either overshoot, undershoot or signal threshold violations, what can be done to correct this problem?

What are the total number of lines written by you in C/C++? What is the most complicated/valuable program written in C/C++?

What compiler was used?

What is the difference between = and == in C?

Are you familiar with VHDL and/or Verilog?

What types of CMOS memories have you designed? What were their size? Speed?

What work have you done on full chip Clock and Power distribution? What process technology and budgets were used?

What types of I/O have you designed? What were their size? Speed? Configuration? Voltage requirements?

Process technology? What package was used and how did you model the package/system? What parasitic effects were considered?

What types of high speed CMOS circuits have you designed?

What transistor level design tools are you proficient with? What types of designs were they used on?

What products have you designed which have entered high volume production?

What was your role in the silicon evaluation/product ramp? What tools did you use?

If not into production, how far did you follow the design and why did not you see it into production?

Categories: C++ Tags:

Windows admin interview questions

Windows admin interview questions

Describe how the DHCP lease is obtained. It’s a four-step process consisting of (a) IP request, (b) IP offer, © IP selection and (d) acknowledgement.

I can’t seem to access the Internet, don’t have any access to the corporate network and on ipconfig my address is 169.254.*.*. What happened? The 169.254.*.* netmask is assigned to Windows machines running 98/2000/XP if the DHCP server is not available. The name for the technology is APIPA (Automatic Private Internet Protocol Addressing).

We’ve installed a new Windows-based DHCP server, however, the users do not seem to be getting DHCP leases off of it. The server must be authorized first with the Active Directory.

How can you force the client to give up the dhcp lease if you have access to the client PC? ipconfig /release

What authentication options do Windows 2000 Servers have for remote clients? PAP, SPAP, CHAP, MS-CHAP and EAP. Read more…

Categories: Networking Tags:
Pages: 1 2 3 4 Next