Page 1 of 1

Gotta have them, can't live without them

Posted: Wed Apr 10, 2013 11:39 pm
by hudatolah
I always look at people's resume before and during their interview and lead my questions based on what they have put in.

Sometimes I get people that put in things into their resume that they don't have the correct answers for. For example if you've put into your resume that you know MySQL but can't answer what is the default listening port of that database then you've given away a clue that you've never had to connect to it and therefore you've revealed that you experience is limited to maybe some occasional SQL query.

Speaking of SQL queries, you should always know the basic select statement, like:

select FIELD from TABLE where FIELD = VALUE;

Here is a list of default listening ports for the most common databases used in production:

Oracle : 1521
MSSQL: 1433
MySQL: 3606

Other ports that I'd ask about in interviews:

Default HTTP and HTTPS ports: 80 and 443.
SNMP port: 161
Mail POP and SMTP: 25 and 110

Re: Gotta have them, can't live without them

Posted: Thu Jun 04, 2015 9:19 pm
by hudatolah
At work, I blog. At home,I reach out.