Showing posts with label Miscellaneous. Show all posts
Showing posts with label Miscellaneous. Show all posts

Tuesday, 5 August 2014

very good summary about linux system administrator interview questions

this is I prepared for the interview for Linux admin/System Engineer Technical questions:

1)      how to install Digital Certificates on apache/nginx
2)      Apache MPM types
3)      Linux symlink vs hardlink
4)      Linux run level (RHEL/Ubuntu)
5)      Linux static library link vs dynamic library link
6)      How to install software from source code and the meaning of each steps
7)      Files in /boot and their function
8)      The content in /etc/grub.conf
9)      Linux booting procedure
10)   MYSQL database creation and deletion
11)   MySQL primary key, unique key, foreign key
12)   MySQL b+ tree and hash index
13)   MySQL index advantage and disadvantage, how to create keys
14)   Select statement, left join, right join, inner join
15)   How to shutdown a linux box
16)   DHCP requests procedure
17)   What is a proxy and reverse proxy
18)   ASymmetric and Symmetric encryption method
19)   How to use ssh key to login to the system without a password (what’s the advantage)
20)   Some remote login security rules
21)   How to execute shell commands in MySQL
22)   Name some options of MySQLadmin
23)   What GUI tools you have used for MySQL admin
24)   How to generate a service for Linux
25)   RAID 0, 1, 5
26)   Name the method to copy a file from a linux server to another server
27)   Rsync working mode. How to setup an rsync environment
28)   Linux – how to enter the single user mode
29)   How kill works in linux, name a few common Signals in LINUX
30)   Describe the memory layout of a procedure
31)   Ext2 special file permission and ACL
32)   HDD layout? How about SSD
33)   What is the function of VFS
34)   List common Linux environment variables
35)   How does CDN work
36)   How to forbid the root user to login directly
37)   How to grant/revoke permissions to MySQL user
38)   How to change mysql user’s password
39)   OSI mode and TCPIP mode
40)   What is VLAN and it’s function
41)   Common HTTP method
42)   Common HTTP response code
43)   How to setup MySQL replication
44)   What is file’s magic number
45)   Linux file types
46)   Linux super lock content
47)   Linux inode content
48)   How ping works
49)   How tracert works
50)   DNS server type, records type
51)   How DNS query works
52)   TCP establishment and termination method
53)   TCP flags
54)   What is TCP half close
55)   TCP 2MSL function
56)   List the TCP timers
57)   The format of a standard URL
58)   How can you design an Web Server
59)   Web Server’s keepalive advantage and disadvantage
60)   The responsibility of a system administrator
61)   The difference between procedure and thread
62)   Procedure life cycle
63)   The priority of the process, nice value and RT
64)   How to track down a process
65)   How does strace/ltrace work
66)   Linux cache/buffer
67)   /etc/passwd, /etc/shadow difference
68)   How to lock a user
69)   How to add a disk to linux system and use it in production environment
70)   How to create file system (for example ext4)
71)   Explain the output of top command and the meaning of each field
72)   The difference between router and switch, what is layer 3 switch
73)   how to make the OS secure
74)   myISAM vs InnoDB
75)   what is ACID
76)   what is the isolation level
77)   explain the backup and restore for MySQL
78)   how to create user in mysql
79)   mysql log explaination
80)   explain what is PKI
81)   SSL establishment procedure
82)   List the file system Linux supports
83)   List the linux disk blocks
84)   What is init process and it’s function
85)   Explain the disk block types in linux
86)   LVS working method and common scheduler
87)   Linux should at least contains which file partitions
88)   How to add modules in Apache
89)   How to integrate Apache and Tomcat
90)   What’s the function of firewall
91)   NTFS vs FAT
92)   Hsrp vs vrrp
93)   Mysqldump common options
94)   Mysqlbinlog
95)   Common redundant method for network
96)   Apache’s tuning
97)   Windows build-in group and users
98)   File system common commands
99)   Yum configuration file and repo.d sample
100) The process status and flag
101) The baseline for linux performance (4 sub system)
102) Linux performance checking tools
103) iptables tables and chains
104) collion domain and broadcast domain
105) NAT types
106) IP private sections
107) how OSPF is working
108) swap related commands. How to setup swap partitions on the fly
109) which software Apache rely on?

110) How Apache and Nginx configure a virtual host

Sunday, 15 June 2014

Windows common command tool

nslookup - common DNS query tool
logoff - log off the user session
lusrmgr.msc - manage local users and groups
services.msc - manage services
notepad - open notepad
net start [service] - start a service
net stop  [service] - stop a service
compmgmt.msc - local computer management tool
devmgmt.msc - device management tool
regedt32/regeit.exe - register editor
mem.exe - view memory tool
wimmsd - view system information
mstsc - open remote desktop session
diskmgmt.msc - disk management tool
ntbackup - build-in backup tool
taskmgr - task manager
eventvwr - event viewer
calc - calculator
certmgr.msc - Certificates management tool
iisreset - IIS stop/start tool
secpol.msc - local security policy management tool
netstat - common netstat tool
ping - common ping tool
tracert - common traceroute tool
winver - check the windows version

Friday, 9 May 2014

regular expression cheet sheet

.any character except newline
\w \d \sword, digit, whitespace
\W \D \Snot word, digit, whitespace
[abc]any of a, b, or c
[^abc]not a, b, or c
[a-g]charcter between a & g
^abc$start / end of the string
\bword boundary
\. \* \\escaped special characters
\t \n \rtab, linefeed, carriage return
\u00A9unicode escaped ©
(abc)capture group
\1backreference to group #1
(?:abc)non-capturing group
(?=abc)positive lookahead
(?!abc)negative lookahead
a* a+ a?0 or more, 1 or more, 0 or 1
a{5} a{2,}exactly five, two or more
a{1,3}between one & three
a+? a{2,}?match as few as possible
ab|cdmatch ab or cd

Wednesday, 26 March 2014

Regular Expression

this is the study note to
http://qntm.org/files/re/re.html



1.       literal characters, which just represent themselves. Such as ‘c’, ‘ab’
2.       the dot  --- any single character
3.       Any meta character can be escaped using a backslash, \. This turns it back into a literal.
4.       A character class is a collection of characters in square brackets. This means, "find any one of these characters". eg [0-9] means any digital, [a-z] means any lower case characters. [^a] means any characters except a
5.       Special means
a.       \d – digital           \D – non-digital
b.      \w - [0-9A-Za-z_]: find a word character.  \W – non-word character
c.       \s find a space(tab, space, carriage return or line feed) character. \S non-space character.

6.       Multipliers use braces to put a multiplier after a literal or a character class.
a{3} means "find an a followed by an a followed by an a".
a{3,5} means "find aaaaa or aaaa or aaa".
? means none or once
* means any times (none, once, or more than once)
+ means one or more than once



Alternation with group: alternation is devided by |, eg: ‘cat|dog’ means cat or dog. You may use () to put your matching pattern there for example: (Mon|Tues|Wednes|Thurs|Fri|Satur|Sun)day means the day’s

\b means the word boundary
^ and $ from "start-of-line" and "end-of-line"

Advanced topics about Regular Expression
Capturing : used referring for () group. (\w+) had a (\w+)  (\w+)
And we can use back-references to refer to the captured pattern such as regular expression ([abc])\1 means "find aa or bb or cc". ([abc])\1\1 means "find aaa or bbb or ccc"