LPIC-102 400 note 105.3 SQL data management

Weight: 2 Description: Candidates should be able to query databases and manipulate data using basic SQL commands. This objective includes performing queries involving joining of 2 tables and/or subselects. Key Knowledge Areas: Use of basic SQL commands Perform basic data manipulation Terms and Utilities: insert update select delete from where …

LPIC-102 400 note 105.2 Customize or write simple scripts

Weight: 4 Description: Candidates should be able to customize existing scripts, or write simple new Bash scripts. Key Knowledge Areas: Use standard sh syntax (loops, tests) Use command substitution Test return values for success or failure or other information provided by a command Perform conditional mailing to the superuser Correctly …

LPIC-102 400 note 105.1 Customize and use the shell environment

Weight: 4 Description: Candidates should be able to customize shell environments to meet users’ needs. Candidates should be able to modify global and user profiles. Key Knowledge Areas: Set environment variables (e.g. PATH) at login or when spawning a new shell Write Bash functions for frequently used sequences of commands …

LPIC-101 400 note 104.7 Find system files and place files in the correct location

Weight: 2 Description: Candidates should be thoroughly familiar with the Filesystem Hierarchy Standard (FHS), including typical file locations and directory classifications. Key Knowledge Areas: Understand the correct locations of files under the FHS Find files and commands on a Linux system Know the location and purpose of important file and …

LPIC-101 400 note 104.6 Create and change hard and symbolic links

Weight: 2 Description: Candidates should be able to create and manage hard and symbolic links to a file. Key Knowledge Areas: Create links Identify hard and/or soft links Copying versus linking files Use links to support system administration tasks Terms and Utilities: ln ls link A hard link is a …

LPIC-101 400 note 104.5 Manage file permissions and ownership

Weight: 3 Description: Candidates should be able to control file access through the proper use of permissions and ownerships. Key Knowledge Areas: Manage access permissions on regular and special files as well as directories Use access modes such as suid, sgid and the sticky bit to maintain security Know how …

LPIC-101 400 note 104.4 Manage disk quotas

Weight: 1 Description: Candidates should be able to manage disk quotas for users. Key Knowledge Areas: Set up a disk quota for a filesystem Edit, check and generate user quota reports Terms and Utilities: quota edquota repquota quotaon quota root@dclab-u1504s:/home/oldhorse# which quota /usr/bin/quota root@dclab-u1504s:/home/oldhorse# which quotaon /sbin/quotaon root@dclab-u1504s:/home/oldhorse# cat /etc/fstab …

LPIC-101 400 note 104.3 Control mounting and unmounting of filesystems

Weight: 3 Description: Candidates should be able to configure the mounting of a filesystem. Key Knowledge Areas: Manually mount and unmount filesystems Configure filesystem mounting on bootup Configure user mountable removable filesystems Terms and Utilities: /etc/fstab /media/ mount umount mount show up mounts FS – mount – cat /dev/mounts or …

LPIC-101 400 note 104.2 Maintain the integrity of filesystems

Weight: 2 Description: Candidates should be able to maintain a standard filesystem, as well as the extra data associated with a journaling filesystem. Key Knowledge Areas: Verify the integrity of filesystems Monitor free space and inodes Repair simple filesystem problems Terms and Utilities: du df fsck e2fsck mke2fs debugfs dumpe2fs …

LPIC-101 400 note 104.1 Create partitions and filesystems

Weight: 2 Description: Candidates should be able to configure disk partitions and then create filesystems on media such as hard disks. This includes the handling of swap partitions. Key Knowledge Areas: Manage MBR partition tables Use various mkfs commands to create various – – filesystems such as: ext2/ext3/ext4 XFS VFAT …