PROMOTE MY BLOG: JUST CLICK BELOW BUTTON

Search Any Paper On This Blog

Friday, November 26, 2010

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?
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Thursday, November 25, 2010

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.