Class Test 2
F.M 20 P.S 10
1 Which if the following address is the broadcast address of the class b ip address
a. 147.255.255.255 b. 147.14.255.255
c. 147.13.0.0 d. 147.1.1.1
2 How many host addresses are available to a class C network
a 254 b 255
c 256 d 128
3 How many useable subnets are created in a class C network when 5 bits are borrowed
a 14 b 16
c 30 d 32
4 What is the minimum no of bits that can be borrowed to form useable subnets
a.1 b 2
c 4 d 8
5 How many bits are in a subnet mask
a. 16 b. 32
c. 64 d. 128
6 What is the maximum no of bits that can be borrowed to create the subnets in a class C network
a. 2 b 4
c 6 d 7
7 With an ipaddress 202.211.19.162 and a subnet mask of 255.255.255.224 how many bits have been borrowed to create subnets
a. 1 b. 2
c. 3 d. 4
8 What is the subnet of the class B address when 4 bits are borrowed?
a. 255.240.0.0 b. 255.255.0.0
c. 255.255.240.0 d. 255.255.255.0
9 For what purpose does the router perform the logical AND using the destination host’s ip address and subnet mask ?
a. to derive the host numbers so it knows where to send the packet
b. to derive the subnet mask and compare it with information in routing table
c. to determine the destination network and the subnet address
d to compare the source address with the routing table
10 Packets are encapsulated in the frames in which layer of the OSI model
a Data Link Layer b. Network Layer
c. Transport Layer d. Session Layer
11. Explain the various classes of IP address with suitable example [6]
12 What is the function of DNS server [2]
13 What is the function of the proxy server [2]
Sunday, October 24, 2010
Joining Tables in database (inner join)
Joining tables:
Joins are a fundamental aspect of relation databases. They allow us to extract data on intites related by design represented by related tables in our data.
A join occurs when you retrieve data from tables related by some shared data, often a shared reference number or index. Foe example, if you have a table of customers as a table of orders, good design in a relation database will ensure that the two are related together by some common data between the tables, perhaps by storing a customer number on every order record . By performing a join, you can retrieve information in a result set where each row combines data from both tables: information about each order will be combined with information about the customer who placed it, and the combination will appear as such in the result set.
INNER JOIN:
IT IS THE MOST COMMON TYPE OF JOIN. WHEN YOU PERFORM AS INNER JOIN BETWEEN tables, rows with matching values are put into the result set, but where values do not match they are ignored. Because the joins looks for equivalence between the column it specifies and is considered the default type of join, it is sometimes called an equip-join or simply a join.
We can wrore a join using INNER JOIN like this select * from table1 inner join table 2
On table1.d-column =table2.d-column;
Or
Select *from table1,table2 wher table1’d_column= table2.’d-column.
Now we are going to perform an inner join between the tables to see who’s written which articles. We are going to relate the tables as the user_id column, which exist in both tables.
Mysql> select u.name ,u auth –group a headline.
From user as u
Inner join articles as n on
u.user _id =a.user_id;
in this example,the user –id column has the same name in both tables. So we can use the keyword using rather than on to simplify sql.
Select u.name ,u auth_group, a headline from usres as u
Inner join articles as a using (user_i.d):
Soppose we want to ensure that we only list people who have their auth_group set to writer:
Select u.name ,a headline from user as u
Inner join articles as a on u.user_id+ a.user_id where u.auth_group=’writer’.
Select u.name a headline from user asu ,articles as a where u.user _id+a.user_id
And u.auth_group=’writer’
Data types in database with description
Data types
Mysql can handle the following data types:
Numeric values
String values
Data and time values
The null values
Numeric column types
The mysql can represent both integers (number with no fractional part) and floating point numbers (those with fractional part).
Numeric column attributes
When declaring a numeric column not only can the column name and type be specified but also some column attributes.
Column_ name column_ type [column _attributes] [genersl_arribute]
Zero fill: it can be used with any numeric column type. Whenever displaying a value of a column with zero fill specified “the output will be padded with leading zero up to the display width of the column.
Auto_ increment
We can use the auto_ increment attribute to generate a unique alto numbered identifier.
Mysql permits only one auto_ increment column per table and requires that it is also declared as a key.
‘By default an auto increment column will have it’s start of sequence valueset to 1. you can override this start of sequence number in your table declaration by setting _increment =number.
Create table invoices (
Invoice_num int auto_ increment not null primary key”
Amount decimal (9, 2)
Auto increment= 100000
Char defines a fixed length column type, wheras varchar and the text and blob types are variable length types.
Char and Varchar are intended for small strings up to 255 characters long, whereas text and blob types are intended for longer strings.
CHAR AND VARCHAR COLUMN TYPES:
The char and Varchar column types both take the m parameter, which sets the maximum length permissible. M must be between 1and 255.
The main difference between char and varchar is the way they use their storage . a char(m) type always uses M bytes of storage ,value being padded out to the right with spaces to the specified length ,m. when you retrived a value from a char field , the traling spaces will be removed.
BINARY COLOMN ATTRIBUTES;
We can specify binary column attribute for char and varchar columns. Thos causes values ih those column to be treated as binary strings.
Values in those columns will then be handled in a case sensitive way in comparision and sorting operation.
BLOB AND TEXT COLUMN TYPES :
BLOB AND TEXT ARE FAMILIES OF COLUMN TYPES INTENTED AS HIGH CAPACITY BINARY AND TEXTUAL STORAGE.
Blob means binary large object and this family of types is intended for storing binary data. Whereas text types are intended for large amounts of text.
ENUM AND SET COLUMN TYPES;
The enum ans set column types can be used to hold column values chosen from a given set of strings. The possible strings are declared at table creation time, and after that only these values may be inserted into the column.
ENUM
We can use enum column type where we want the column to contain exactly one of the allowed members specified at table creation time.
Create table my table (
Number enum (“one”, “two”,” three”,) null)
The enum column would be allowed to hold any one of the string values: null,””,”one”,”two”, and “three”.
For each enum column a corresponding index exits which is a numeric representation of the number of each possible member, starting from 1.
SET
The set column type work’s in much the same way as enum. However, enum can hold only one of the enumerative members; SET can hold any number of members, including all of them.
CREATE TABLE PIZZA (
Topping set (pepperose”,”prawns”, anchovies”,) null)
Insert into pizza values (““),
(“pepperose”,”anchovies”)
DATE
Date values can range from 1000-01-01 to 9999-12-31 and occupy 3 byres of storage. we can specify dates as yyy-mm-dd, yyyy/mm/d or almost any punctuates separating the components of date .
TIME
Time values occupy 3 bytes of storage .time values can range not just from 00:00:00 to 23:59:59 but also can include negative time; in fact from 838:59:59 to 838:59:59. This allows us to represent not just time of day but also the lapsed time between two events, or even degrees, minutes and Seconds of longitude and latitude.
We can use any punctuation marks as delimiters to separate the hours, minutes and seconds. Thus 08:32:20 could be represented as 08-32-20 or we can do without leading zero as 8-32-20.
We can specify time delimiters as is 08_32_20 or 83220. mysql reads time from the right expecting seconds to be declared but not necessarily pairs . So 8-32 or 0832 will be interpreted as 8 minutes 32 seconds.
TIMESTAMP; is a useful field format where by a timestamp column will be set to the current system date and time whenever that row is updated or inserted into the table
A timestamp column occupies 4 byres of storage and although it can be declared to display between 2 and 14 digits of date and time, it always hold the same data internally.
Saturday, October 23, 2010
Writing Resume for health sector
RESUME
Personal Details
Name ---------------------
Address GPO -----, EPC 2405
Kathmandu, Nepal
Telephone --------------(Residence)
-----------------(Office)
Email --------------@hotmail.com
Date of Birth 23/11/1975
Sex Female
Marital Status Married
Nationality Nepali
Religions Hindu
Health Condition No specific diseases and abnormality
Career Objective
A position in health institute where I can contribute the knowledge and skills gained from experiences in professional and academic areas combined with my tertiary degree in primary health care.
Education
Institute Flinders University of South Australia, Australia
Duration 2003-2004 (1.5 years)
Qualification Master of Primary Health Care
Key Subject areas Research in Primary Health Care
Health Service Management
Community Organization for Health
Evaluation in Primary Health Care
Achievement Distinction
AusAid Scholarship throughout the course
Relevant Experiences A reproductive health project for Nepalese Adolescent was designed to complete the practicum requirement of the degree. The project was planned for rural adolescent which contains teacher training, peer education, sexual health education, counseling, referral and health service components.
During the practicum, I did participate in sexual health education and teacher’s training conducted by a project called Sexual Health and Relationship Education (SHARE) in Australia.
A proposal for the qualitative research of sexual health knowledge and behavior of adolescent girl was prepared to conduct research work in carpet industries in Nepal. The issue of abortion, girl trafficking, equity in health care and health service, management were discussed in various presentations.
Institute Tribhuvan University
Duration 2000-ongoing
Qualification Master of Education
Specialization Health
Key Subject areas Reproductive Health
Health Service Management
School Health Promotion
Relevant Experiences To carryout the thesis of the degree, a proposal on cultural influences on development of reproductive behavior of adolescent was approved by the department. A seminar paper on adolescent sexuality and cultural barriers was presented among academics and colleagues.
Institute Tribhuvan University, Institute of Medicine, Nursing Campus, Maharajgunj, Kathmandu, Nepal
Duration 2000-2001 (2 years)
Qualification Bachelor Degree in Nursing
Specialization Community Nursing
Achievement Distinction
Relevant Experiences A research on reproductive health knowledge and behavior of secondary level school adolescents was undertaken during the field work based on remote areas of Dhading district.
Institute Tribhuvan University, Prithivi Narayan Multiple Campus, Pokhara, Nepal
Duration 1997-2000
Qualification Bachelor’s Degree in Education
Specialization Health and Physical Education
Key subject areas School health program
Field study in health education program
Relevant Experiences A school health education program combined with field work and survey was conducted in Kaski district.
Institute Tribhuvan University, Institute of Medicine, Nursing Campus, Maharajgunj, Nepal
Duration 1992-1995
Qualification Proficiency Certificate Level of Nursing
Achievement Distinction
Relevant Experiences Field work, survey and presentation
Training, Short Course and Conference
Introductory Academic Program, 2004
Institute Flinders University of South Australia, Student Learning Centre
Duration One Month
Key Areas Computer and Information Technology
Academic and Research skills
English in an academic context
Introduction to Australian Society and Culture
Grief and Loss short Course, 2004
Institute Flinders University of South Australia, Department of Public Health in Conjunction with The University of Queensland, School of Population Health
Duration 5 Days
Key Areas Grief, Loss and Mental health
Counseling
Mental Health Promotion
National Health Conference on essentials, differentials and Potentials in Health, 2004
Organization Public Health Association of Australia
Duration 5 Days
Key Issues Equity in Health Care
Indigenous Health
Globalization in Health
Community Development Training, 1995
Organization Rural Reconstruction Nepal (RRN)
Duration One week
Key Issues Identification of Community’s needs and demands
Community Participation in Program Operation
Leadership
Program planning and Management
Research Studies
- An interventional study on sexual health knowledge and behaviour of rural adolescents in Nepal, 2001.
- A descriptive study on the health status of marginalized population in Mulpani village of Katmandu in Nepal, 2001.
- A survey on the health status of the indigenous population in a remote village of Dhading district in Nepal, 2001.
- A descriptive study on health care practice of rural women of Katmandu district in Nepal, 2000.
- A survey on the nutritional status of under five children in Gurung community of the Kaski district in Nepal, 1999.
Work Experiences
Professional Experiences
Position Lecturer
Organization Nepal Institute of Health Sciences, Kathmandu
Duration April 2005 to date
Key Duties Conduct classroom teaching and learning activities
Supervise clinical practicum of the students
Guide student in their research practicum
Participate in research programme of the institute
Work in a research committee of the university
Assess the performance of the students using evaluation tool
Coordinate with other resources and organizations for the theory and clinical practice of the students
Position Staff Nurse
Organization Western Regional Hospital, Pokhara, Nepal
Duration 1997-2002
Key Duties General Nursing duties and responsibilities that includes
Guidance and supervisions of students and juniors
Patient teaching and education
Conduct normal delivery
Assist in complicated delivery and operation procedures
Conflict Management
Management of high risk conditions
Communication, coordination, cooperation in team partners, visitors and public
Presentation, documentation and reporting
Position Community Health Development Officer
Organization Rural Reconstruction, Nepal
Duration 1995-1997
Key Duties Design and conduct health related training
Conduct health related campaign
Coordinate health clinics and cooperate with other government and non government organization
Supervise non formal education classes
Conduct TBA training
Supervise and monitor the activities of TBA
Conduct mobile health clinics
Design and develop health education materials
Participate in other project activities
Conduct school health education program in case of epidemic outbreak
Presentations, documentations and reporting
Part Time Employment
Position Instructor
Organization Western Technical Institute, Pokhara, Nepal
Duration 1997-1999
Key Duties Teaching, guidance and evaluation of students
Manage field work
Coordinate with local health agencies, staff and community for practicum
Casual Employment
Position Carer
Organization Southern Cross Care of South Australia
Duration November 2003- April 2004
Key Duties General nursing care
Physiotherapy and divers ional therapy
Fire management
Manual handling and lifting
Referral care
Coordinate with team, other hospital clinics and family groups
Documentation and reporting
Skills Profile
- High level Communication skill developed through professional and academic experiences in Public Health combined with leadership roles in Public Health Association.
- Ability to work in a team demonstrated involvement in group work, conferences, presentations and projects of University and volunteer work at community health Projects.
- Effective planning, organizing and management skills were demonstrated in my supervisory role in TBA program or Rural Reconstruction Nepal and project management during the course.
- High level written and spoken skills in English.
- Basic computer skills including MS Word, Excel, Power Point, Internet and others.
Refrees
Letter Writing for working experience
Date: - 2010-10-23
To whom it may concern
This is to certify that Mr. -------- is working in this college as a part time Lecturer since August 2004. He conducted lectures in “Computer Network and Data Communication” and .NET Technology for the BCIS (Bachelor of Computer Information System) 5Th semester students. Under his supervision the students also took part in laboratory work. In laboratory, he taught the students about networking using the Window 2000 Server and Red Hat Linux 9 platform. Under his supervision, the student had come across a good software project in the .NET Technology. At present he is conducting lectures in “Data Base Management System” for BCIS (Bachelor of Computer Information System) 4Th semester students .He is also handling the Laboratory session of the Database Management System where student are taught to design laboratory in Oracle 8i Apart from conducting lectures he also helped us design and install the college LAN. He also installed and configured the mail server, web server, proxy server, samba server using Red Hat Linux 9.
I found him sincere, co-operative and hardworking with dynamic personality. I’m very much impressed with his honesty, diligence, academic and technical experience.
-----------------
Principal
Subscribe to:
Posts (Atom)