ITEC_102_PART2_MIDTERM

Question 1

Transfer of any of information from one location to another.

Communication means sending a stream of bits or bytes from one location to another via transmission medium such as copper wire, fiber optics, laser, radio, infra red light, bluetooth.

Answer 1

Data Transmission

Question 2

most basic information unit used in computing & information theory, Sing bit is ‘1’/’0’, ‘true/false’,’on/off’.

Answer 2

Bit

Question 3

a series of 8 bits also called a character.

Answer 3

Byte

Question 4

a series of 8 bits also called a _________

Answer 4

character

Question 5

electric or electromagnetic representation of Data

Answer 5

Signalscon

Question 6

convert a message into a signal, which is carried to a receiver by the communication channel

Answer 6

Transmitter

Question 7

Def: are continuous electrical signals that vary with time & represented by a _________.

Answer 7

waveform

Question 8

measure of wavelength at any given point of time ( measured in Volt [V])

Answer 8

Amplitude

Question 9

number of times waveform repeats itself in a second ( measured in Hertz[Hz] )

Answer 9

Frequency

Question 10

distance between two corresponding points on a waveform. ( measured in Meter [m] )

Answer 10

Wavelength

Question 11

progress of a wave over time in relationship to a fixed point or other wave with same frequency / amplitude. ( measured in degree [ degree] ) in relation to starting point.

Answer 11

phase

Question 12

non-continuous & they change in individual steps.

Consists of pulse constant, but there is an abrupt change from one digit to another.

have 2 amplitude levels which represents two voltage pulses. ( 1/0, true/false, high/low )

Positive voltage pulse = , no pulse = 0

Computer is a digital device & they work on digital signals.

Answer 12

Digital Signal

Question 13

signal which is transmitted at input & signal received at output does always match due to transmission channel.

Answer 13

Transmission flaws

Question 14

Unwanted signal which can disturb or harm the communication system.

Common source of noise is electromagnetic interference (EMI) or wave that is emitted from electric carrying cable or electric devices.

Answer 14

Noise

Question 15

Electric motor, power line, copier, television, lights & machines.

Answer 15

Source of EMI

Question 16

Created by the movement / collision of the electrons due to heat in a conductor (wire).

Answer 16

Thermal Noise

Question 17

Caused by varying magnetic field originated from external circuit or equipment. ( engines may also cause this ).

Answer 17

Induced noise

Question 18

pulse(s) appearing at the output point of a data line, which is not transmitted at the input point.

Answer 18

Impulse noise

Question 19

Refers to signal affecting another nearby signal

Answer 19

Crosstalk

Question 19

Device that regenerates digital signal.

Answer 19

Repeater

Question 20

Device with amplify or regenerate analog signal.

Answer 20

Amplifier

Question 21

A signal sent via a transmission media, will lose a portion of its power in form of heat or other form of energy.

Answer 21

Attenuation

Question 22

also known as delay, is an expression of how much time it takes for a packet if data to get from one designated point to another.

Answer 22

latency

Question 23

is the addition of information/signal to an electronic or optical signal carrier.

Answer 23

modulation

Question 24

A device that performs the inverse operation which is demodulation is a ___________.

Answer 24

demolulator.

Question 25

A device that can do both modulation & demodulation is a _______.

Answer 25

Modem

Question 26

the amplitude of voltage applied to the carrier is varied over time.

Answer 26

Amplitude modulation(AM)

Question 27

the frequency of the career waveform in varied in small but meaningful amounts.

Answer 27

Frequency modulation(FM)

Question 28

the natural flow of the alternating current waveform is delayed temporarily.

Answer 28

Phase modulation(PM)

Question 29

transmitting multiple signals over a single communication line or computer channel.

Answer 29

Multiplexing

Question 30

Separates signals by modulating the data onto different carrier frequencies.

Answer 30

Frequency division Multiplexing(FDM)

Question 31

separates signals by interleaving bits one after the other.

Answer 31

time division multiplexing(TDM)

Question 32

transmission of several bits one after another through a single wire.

Answer 32

Serial transmission

Question 33

multiple wires are used form transmitting bits simultaneously.

Answer 33

Parallel transmission

Question 34

A technique wide used in personal computers to provide connectivity to printers, modems, fax machines. Code are sent in untimely manner with uneven intervals between characters Sending & receiving data is controlled by start & stop bit.

Answer 34

Asynchronous transmission

Question 35

Technique of transmission in which the transmitter & receiver are synchronized Data is transmitted in continuous stream

Answer 35

Synchronous transmission

Question 36

Data transmission (2)

Answer 36

Bit byte

Question 37

Types of signals

Answer 37

Signals Transmitter

Question 38

2 types of signals

Answer 38

Analog Digital

Question 39

Waveform is characterized by 4 properties

Answer 39

Amplitude Frequency Wavelength Phase

Question 40

Cause of transmission flaws

Answer 40

Nosie Attenuation Latency

Question 41

Source of EMI

Answer 41

Electric motor power lines copier television lights & machines

Question 42

4 types of noise

Answer 42

Thermal Noise Induced noise Impulse noise Crosstalk

Question 43

2 common multiplexing techniques

Answer 43

Frequency Division multiplexing(FDM) Time Division multiplexing(TDM)

Question 44

Types of data transmission

Answer 44

Serial transmission Parallel transmission

Question 45

3 modes of communication

Answer 45

Simplex Half-duplex full-duplex

Question 46

2 types of transmission modes

Answer 46

Asynchronous transmission Synchronous transmission

Question 47

EMI stands for?

Answer 47

Electromagnetic interference

Question 48

it provide additional information about Elements. Values of the Attributes are set inside the Elements

Answer 48

Attributes

Question 49

is a set of rules that allow us to specify our own set of elements and attributes.

Answer 49

Document type Definition

Question 50

is grammar to indicate what tags are legal in XML documents.

Answer 50

Document type Definition

Question 51

is valid if it has an attached DTD and document is structured according to rules defined in DTD.

Answer 51

XML Document

Question 52

Serves same purpose as database schema

Answer 52

XML Schema

Question 53

Allows creation of user-defined complex types

Answer 53

XML Schema

Question 54

Requirement Same functionality as database query languages (such as SQL) to process Web data

Answer 54

XML Query Languages

Question 55

Query selective portions of the document (no need to transport entire document)

Answer 55

XML Query Languages

Question 56

Smaller data size mean lesser communication cost

Answer 56

XML Query Languages

Question 57

is a language that defines path expressions to locate document data

Answer 57

XPath

Question 58

an API used for database connectivity

Answer 58

JDBC

Question 59

it provides basic services to manage set of JDBC drivers

Answer 59

DriverManager

Question 60

Connection object sends queries to database server after a connection is set up

Answer 60

Oracle JDBC

Question 61

Method executes SQL statement that returns ResultSet object (ResultSet maintains cursor pointing to its current row of data. )

Answer 61

Oracle JDBC

Question 62

XML was designed to describe data. ( true/false )

Answer 62

true

Question 63

XML tags are not predefined unlike HTML ( true/ false)

Answer 63

true

Question 64

XML DTD and XML Schema define rules to describe data (true/false)

Answer 64

true

Question 65

XML example of semi structured data (true/false)

Answer 65

true

Question 66

Schemas are written in XML (true/false)

Answer 66

true

Question 67

Set of pre-defined simple types (such as string, integer) (true/false)

Answer 67

true

Question 68

Most databases supports XQuery (true/false)

Answer 68

true

Question 69

XQuery to XML is same as SQL to RDBMS (true/false)

Answer 69

true

Question 70

DTD stands for?

Answer 70

Document Type Definition

Question 71

XML stands for?

Answer 71

Extensible Markup Language

Question 72

XML Support in Oracle

Answer 72

XDK (XML Developer Kit) XML Parser for PL/SQL XPath XSLT

Question 73

Basic Steps to develop JDBC Application

Answer 73

Import JDBC classes (java.sql.*). Load JDBC drivers Connect and Interact with database Disconnect from database

Question 74

JDBC provides following three classes for sending SQL statements to server

Answer 74

Statement PreparedStatement CallableStatement