MidTerm CS101 Past Paper

MidTerm CS101 Past Paper

Human are better than computers at:

Question No: 1 ( Marks: 1 ) - Please choose one

Efficiency

Accuracy

Pattern recognition

None of the given choices

Question No: 2 ( Marks: 1 ) - Please choose one

Cray-1 was first commercial _________ computer

Super

Mini

Micro

Personal

Question No: 3 ( Marks: 1 ) - Please choose one

URL is a/an ________

Device

Component

Address

Tool

Question No: 4 ( Marks: 1 ) - Please choose one

Mainframe Computers are also called _____

Enterprise Servers

Personal Servers

Enterprise Managers

Window Servers

Question No: 5 ( Marks: 1 ) - Please choose one

Which of the following is NOT a category of Mobile Computers?

Laptop

Palmtop

Desktop

Wearable

Question No: 6 ( Marks: 1 ) - Please choose one

Preliminary exploration of possible solutions, technologies, suppliers is called

Viability

Feasibility

Specification

Integration

Question No: 7 ( Marks: 1 ) - Please choose one

__________ give us the ability to manipulate data through reference instead of actual

value.

Constants

Variables

Data Types

Operators

Question No: 8 ( Marks: 1 ) - Please choose one

Consider the following statement written in JavaScript:

str = ”Hello” + ” World”

What will be the value of str ?

HelloWorld

Hello World

Hello + World

It will result in error

Question No: 9 ( Marks: 1 ) - Please choose one

A tool that helps you to find the synonyms is called ______________.

Language

Paragraph

Thesaurus

Symbol

Question No: 10 ( Marks: 1 ) - Please choose one

Communication protocol is a __________that governs the flow of information over a

network

Set of protocols

Set of rules

Device

Set of methods

Question No: 11 ( Marks: 1 ) - Please choose one

If a computer could pass the Turing test then it would be able to:

think like human beings

do the things faster

win a million dollar prize

store more information

Question No: 12 ( Marks: 1 ) - Please choose one

The first Web browser with a GUI was generally available in:

1992

1993

1994

1995

Question No: 13 ( Marks: 1 ) - Please choose one

Web is a unique invention by humans in terms that it is:

accessible to only the owners who control it

accessible from particular locations only

accessible to all humans

accessible to only the educational institutes

Question No: 14 ( Marks: 1 ) - Please choose one

In this URL http://www.msn.com , _____identifies the domain name

http

www

msn

com

Question No: 15 ( Marks: 1 ) - Please choose one

______ is simply a fast port that lets you connect computer peripherals and consumer

electronics to your computer without restart.

Freeware

Shareware

Firewire

Firmware

Question No: 16 ( Marks: 1 ) - Please choose one

Which of the following is NOT supported by PC's power supply.

-12 and +12 V DC

-10 and +10 V DC

-5 and + 5 V DC

All are supported

Question No: 17 ( Marks: 1 ) - Please choose one

In which case Cache Memory is used

To increase RAM speed

To overcome BUS speed

To overcome Speed rate between RAM and CPU

To overcome CPU speed

Question No: 18 ( Marks: 1 ) - Please choose one

To display a single line text area on the web page, we use ___ tag

TEXT

TEXTBOX

INPUT

INPUTBOX

Question No: 19 ( Marks: 1 ) - Please choose one

If an algorithm is syntactically correct, but semantically incorrect then this situation is

Very good situation

Very dangerous situation

Not very bad

Neutral situation

Question No: 20 ( Marks: 1 ) - Please choose one

Users communicate with the computer using a consistent user interface provided by the

OS.

True

False

Question No: 21 ( Marks: 1 ) - Please choose one

Application developers do not need to know much about the HW, especially the

microProcessor, while they are developing their application.

True

False

Question No: 22 ( Marks: 1 ) - Please choose one

The first spread sheet program was invented by

Charles Babbage

Dan Bricklin

Paul Graham

John von Neumann

Question No: 23 ( Marks: 1 ) - Please choose one

Which representation technique of algorithm is more suitable for developer to make

actual code___________.

pseudo code

flow chart

both pseudo code and flow chart

Heuristics

Question No: 24 ( Marks: 1 ) - Please choose one

____________

_ is used to terminate all JavaScript statements.

Colon

Semicolon

Underscore

Apostrophe

Question No: 25 ( Marks: 1 ) - Please choose one

In java script cookies can be created for future use_____.

Easily

No facility at all

This is not possible without Java language.

Cookies are files so java script can not handle it.

Question No: 26 ( Marks: 1 ) - Please choose one

When the microprocessor desires to look at a piece of data, it checks in

the __________ first.

RAM

ROM

hard disk

Question No: 27 ( Marks: 1 )

cache

What is the basic difference between 'magnetic tapes' and 'floppy disks' ?

Question No: 28 ( Marks: 1 )

What was the name of first microprocessor built by Intel ?

Question No: 29 ( Marks: 2 )

What was the name of first super computer. When it was introduced?

Question No: 30 ( Marks: 3 )

Write a short note on blue pacific Super Computer.

Question No: 31 ( Marks: 5 )

What are JavaScript literal and what are its types?

Question No: 32 ( Marks: 5 )

Can you say that URL and semantic web sites are same? Justify your answer by defining

the both terms?

MIDTERM EXAMINATION Solved Paper of CS101- Introduction to Computing

MIDTERM  EXAMINATION

Spring 2010

CS101- Introduction to Computing (Session - 4)

Ref No: 1341114

Time: 60 min

Marks: 38

Student Info
StudentID:
Center:	OPKST
ExamDate:	5/26/2010 12:00:00 AM

Question No: 1    ( Marks: 1 )    - Please choose one

Ada, Countess of Lovelace developed first:

       ► Computer

       ► Website

       ► Computer Program

       ► Analytical engine

   

Question No: 2    ( Marks: 1 )    - Please choose one

Charles Babbage was a/an

       ► Mathematician

       ► Computer Scientist

       ► Physician

       ► Analyst

   

Question No: 3    ( Marks: 1 )    - Please choose one

Detailed plan, specifying the required resources and expected deliverables, is done in ________ phase.

       ► Planning

       ► User Requirements

       ► Design

       ► Developer Specification

    

Question No: 4    ( Marks: 1 )    - Please choose one

A computer program that facilitates the communication between the computer and a peripheral device is called___________________

       ► Operating system

       ► Utilities

       ► Language Translator

       ► Device Drives

   

Question No: 5    ( Marks: 1 )    - Please choose one

To start an ordered list from 20 instead of 1, we will write

       ► <OL begin = “20">

       ► <OL initiate = “20">

       ► <OL start = “20">

       ► <OL from = “20">

   

Question No: 6    ( Marks: 1 )    - Please choose one

 _________ is the best known builder for supercomputers.

       ► Sun

       ► Cray Research

       ► Microsoft

       ► Apple

   

Question No: 7    ( Marks: 1 )    - Please choose one

Using COLSPAN, number of rows of the current cell should extend itself

       ► Upward

       ► Downward

       ► Both Upward and Downward

       ► None of the given choices

   

Question No: 8    ( Marks: 1 )    - Please choose one

 Interactive forms are always placed between ___ tag-set

       ► TITLE

       ► HEAD

       ► BODY

       ► HTML

   

Question No: 9    ( Marks: 1 )    - Please choose one

 _________ manages the HW and SW resources ( memory, disk drives etc) of the computer system, often invisibly.

       ► Explorer.exe

       ► System Files

       ► Operating System

       ► Application Software

   

Question No: 10    ( Marks: 1 )    - Please choose one

 Speakers fall into the hardware category.

       ► True

       ► False

   

Question No: 11    ( Marks: 1 )    - Please choose one

 ______________ software directly interacts with the hardware.

       ► Application software

       ► System software

       ► Dynamic software

       ► Distributed software

   

Question No: 12    ( Marks: 1 )    - Please choose one

 In spreadsheet, which of the following function is used to solve the equation

?

       ► =COUNTIF

       ► =GoalSeek

       ► None of the above

       ► =Sum

   

Question No: 13    ( Marks: 1 )    - Please choose one

_______  is known as the best feature in word processing.

       ► Cut

       ► Copy

       ► Paste

       ► Undo

   

Question No: 14    ( Marks: 1 )    - Please choose one

In java script objects may have___________ properties.

       ► Single

       ► Several

       ► Multiple

       ► All of the given options

   

Question No: 15    ( Marks: 1 )    - Please choose one

 _________ are great for showing parts of a whole that are generally expressed in percentages.

       ► Line Charts

       ► Pie Charts

       ► Bar Charts

       ► None of the options described

   

Question No: 16    ( Marks: 1 )    - Please choose one

Small Computer System Interface is

       ► Slower and harder to configure then serial and parallel ports

       ► Faster then USB

       ► Both first choices

       ► Slower then USB but Faster then serial and parallel

   

Question No: 17    ( Marks: 2 )

Write the major types of softwares with examples?

   

Question No: 18    ( Marks: 2 )

What is the major difference between paragraph <p> and Line Break <BR> tags?

   

Question No: 19    ( Marks: 2 )

Why PASCAL was designed and what is the problem with PASCAL?           

   

Question No: 20    ( Marks: 3 )

What are the key requirements of E-commerce Software?

   

Question No: 21    ( Marks: 3 )

Write down the pseudo code for the following flow chart.

    

   

Question No: 22    ( Marks: 5 )

 (a) Write down two positive features of client-side scripting.

(b) Discuss two deficiencies of JavaScript.

   

Question No: 23    ( Marks: 5 )

What are the key features of a word processor?

          

      

CS403 Midterm Past Solved paper

                                                                                       MIDTERM EXAMINATION

                                                                                                      Fall 2008

                                                                        CS403- Database Management Systems (Session - 1)

                                                                                                                                                                                  Dated 31-05-2010

                                                                                                                                                                                  Time: 60 min

                                                                                                                                                                                  Marks: 38

Question No: 1 ( Marks: 1 ) - Please choose one

Which of the following functions are NOT performed by a database administrator?

► Planning, designing and implementing database systems

► Establishing standards and procedures for database systems

► Communicating with database users

► Allocation of storage locations and data structures

Question No: 2 ( Marks: 1 ) - Please choose one

Identify the factor which enforces a relation in 3NF?

►

Every non-key attribute is fully functionally dependent on primary key

►

Every non-key attribute is partially dependent on super key

►

The domain of attribute must include only atomic values.

►

Every non-key attribute is non-transitively dependent on primary key.

Question No: 3 ( Marks: 1 ) - Please choose one

Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product

contains?

► 6

► 9

► 5

► 4

Question No: 4 ( Marks: 1 ) - Please choose one

Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

► Join

► Union

► Cartesian Product

► Set Difference

Question No: 5 ( Marks: 1 ) - Please choose one

Consider the following statements.

A. An entity integrity constraint states that no primary key value can be null.

B. A referential integrity constraint is specified between two relations.

C. A foreign key cannot be used to refer to its own relation.

Identify which of the above statements is/are correct.

► Only A (may be this)

► Only B

► Only B and C

► Only A and B

Question No: 6 ( Marks: 1 ) - Please choose one

User rights information is stored in

► Physical database

► Catalog

► Logical database

► Buffer

Question No: 7 ( Marks: 1 ) - Please choose one

Given are the relations of student and Instructor

Which relational algebra operation could have been applied on the pair of relations Student and Instructor to obtain the

above data?

►

Instructor – Student

►

Student ∩ Instructor

►

Instructor ÷ Student

►

Student – Instructor

Question No: 8 ( Marks: 1 ) - Please choose one

Which one is the corrected way to implement M to M relation which designing data base

► using junction table with keys

► By splitting data into tables with PK and FK

► As a single table rarly as to tables with PK and FK

►By creating three tables and linking them through PK and FK

Question No: 9 ( Marks: 1 ) - Please choose one

Which enforce the a relation into 2NF User rights information is stored in

► ------------------

► --------

► ----------------

► ------

Question No: 10 ( Marks: 1 ) - Please choose one

Which of the following concepts is applicable with respect to 3NF?

► Full functional dependency

► Any kind of dependency

► Transitive dependency

► Partial functional dependency

Question No: 11 ( Marks: 1 ) - Please choose one

Description on particular collection of data using data model

► Schema

► Relation

►Data base

► None of the above

Question No: 12 ( Marks: 1 ) - Please choose one

Which one is true regarding relation?

► Every attribute value Non atomic

► Attribute in table may not have unique name

►table order of the column is relevant

► the order of the rows is irrelevant

Question No: 17 ( Marks: 2 )

Label the following diagram

1.Data store

2.Entity

Question No: 18 ( Marks: 3 )

What is the degree of relation?

Degree of a Relation

We will now discuss the degree of a relation not to be confused with the degree of a

relationship. You would be definitely remembering that the relationship is a link or

association between one or more entity types and we discussed it in E-R data model.

However the degree of a relation is the number of columns in that relation. For

Question No: 19 ( Marks: 3 )

Name three kind of basic binary operation on relational algebra

Ans:

Union

Set operation

Cartesian product

Question No: 20 ( Marks: 2 )

What is the data type

Data type is defined as a set of values along with the operations that can

be performed on those values. Some common data types are Integer, Float, Varchar,

Char,

String, etc.

Question No: 21 ( Marks: 2 )

What is the importance of minimum cardinality in relation while designing the database.

Minimum Cardinality:

This is a very important point, as minimum cardinality on one side needs special

attention. Like in previous example an employee cannot exist if project is not assigned.

So in that case the minimum cardinality has to be one. On the other hand if an

instance of EMPLOYEE can exist with out being linked with an instance of the

PROJECT then the minimum cardinality has to be zero. If the minimum cardinality is

zero, then the FK is defined as normal and it can have the Null value, on the other

hand if it is one then we have to declare the FK attribute(s) as Not Null. The Not Null

constraint makes it a must to enter the value in the attribute(s) whereas the FK

constraint will enforce the value to be a legal one. So you have to see the minimum

cardinality while implementing a one to many relationship.

Question No: 22 ( Marks: 5 )

What is the Cartesian product operation algebra. What is the result of Cartesian result

product.

Cartesian product:

The Cartesian product needs not to be union compatible. It means they can be of

different degree. It is denoted by X. suppose there is a relation R with attributes (A1,

A2,...An) and S with attributes (B1, B2……B

R X S

The resulting relation will be containing all the attributes of R and all of S. Moreover,

all the rows of R will be merged with all the rows of S. So if there are m attributes and

C rows in R and n attributes and D rows in S then the relations R x S will contain m +

n columns and C * D rows. It is also called as cross product. The Cartesian product is

also commutative and associative. For Example there are two relations COURSE and

STUEDNT

n). The Cartesian product will be:

Cource

crId courseTitle

C3456 Database Systems

C4567 Financial Management

C5678 Money & Capital Market

STUDENT

stId

stName

S101 Ali Tahir

S103 Farah Hasan

COURSE X STUDENT

crId courseTitle stId

stName

C3456 Database Systems S101 Ali Tahir

C3456 Database Systems S103 Farah Hasan

C4567 Financial Management S101 Ali Tahir

C4567 Financial Management S103 Farah Hasan

C5678 Money & Capital Market S101 Ali Tahir

C4567 Financial Management S103 Farah Hasan

Question No: 23 ( Marks: 5 )

Shortly describe Procedural DML and Non procedural DML also give the alternate

names.

Procedural Languages:

These are those languages in which what to do and how to do on the database is

required. It means whatever operation is to be done on the database that has to be told

that how to perform.

Non -Procedural Languages:

These are those languages in which only what to do is required, rest how to do is done

by the manipulation language itself.

Structured query language (SQL) is the most widely language used for manipulation

of data. But we will first study Relational Algebra and Relational Calculus, which are

procedural and non – procedural respectively.