KING'S IT WORLD
please register to watch content in detail
THANKS
ADMIN KINGSIT WORLD
KING'S IT WORLD
please register to watch content in detail
THANKS
ADMIN KINGSIT WORLD
KING'S IT WORLD
Would you like to react to this message? Create an account in a few clicks or log in to continue.

KING'S IT WORLD


 
HomeHome  GalleryGallery  SearchSearch  Latest imagesLatest images  RegisterRegister  Log inLog in  
Search
 
 

Display results as :
 
Rechercher Advanced Search
kings it world text ad
KINGSITWORLD CALENDAR
Follow me on G+
KINGSITWORLD WEATHER
Latest topics
» QURAN MAJEED KE TAFSEER
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeMon Aug 20, 2012 2:59 am by YOUSUFHALI

» PHY301 CIRCUIT THEORY REFERENCE BOOK
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeWed Jul 25, 2012 11:36 am by shabbir1915

» MTH202 ASSIGNMENT NO 3 SOLUVED
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeMon Jun 11, 2012 9:51 am by jaffarhussain

» Retrieve the DTC In the Jewel Module of 1995 Ford
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeThu May 31, 2012 11:51 am by obd2tool

» How you can Obvious the Check Engine Light on the
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeThu May 31, 2012 11:43 am by obd2tool

» send free sms and send free sms update on facebook
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeTue May 15, 2012 8:33 pm by rizwan269

» United Bank Limited (UBL) - Fee Deposit
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeThu May 10, 2012 3:33 pm by irumnaz

» PHOTO MIXER SOFTWARE
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeFri Apr 20, 2012 10:02 am by sacredwkb

» Entrepreneurship Survey
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeThu Mar 08, 2012 2:20 pm by Admin

» Fall 2011 Semester Result Announced
TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeThu Mar 08, 2012 2:19 pm by Admin

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
kings it world text ad
Social bookmarking
Social bookmarking reddit      

Bookmark and share the address of KING'S IT WORLD on your social bookmarking website

Bookmark and share the address of KING'S IT WORLD on your social bookmarking website
visitors counter
TODAY CS403 PAPER SOLVED 28-5-10 Image
Powered by website analytics technology.
Keywords
assignment 2011 term MGT502 final 2010 MGMT611 HRM611 paper
kings it world text ad
FLAG COUNTER
free counters
LIVE TRAFFIC

 

 TODAY CS403 PAPER SOLVED 28-5-10

Go down 
AuthorMessage
Admin
Admin
Admin


Scorpio
Posts : 638
Points : 2155
Reputation : 19
Join date : 2010-05-15
Age : 36
Location : islamabad

TODAY CS403 PAPER SOLVED 28-5-10 Empty
PostSubject: TODAY CS403 PAPER SOLVED 28-5-10   TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeFri May 28, 2010 9:09 pm

SEE THE ATTACH FILE
Attachments
TODAY CS403 PAPER SOLVED 28-5-10 AttachmentCS403 2010.doc
You don't have permission to download attachments.
(194 Kb) Downloaded 45 times
Back to top Go down
Admin
Admin
Admin


Scorpio
Posts : 638
Points : 2155
Reputation : 19
Join date : 2010-05-15
Age : 36
Location : islamabad

TODAY CS403 PAPER SOLVED 28-5-10 Empty
PostSubject: Re: TODAY CS403 PAPER SOLVED 28-5-10   TODAY CS403 PAPER SOLVED 28-5-10 Icon_minitimeSat May 29, 2010 4:29 pm

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

Your browser may not support display of this image. Which of the following is NOT a feature of Context DFD?

► one process (which represents the entire system)

► all sources/sinks (external entities)

► data flows linking the process to the sources and sinks (external entities)

► sub-processes (which explain and decomposed the major process into small processes)



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

Your browser may not support display of this image. Which of the following is true for the relational model?

► Degree of a relation is the number of rows in a relation.

► Null value is a blank or zero value given to an attribute value when its value is inapplicable or its value is unknown.

► Complex key is a key consisting of more than one attribute.

► Constraint is a rule that restricts the values in a database.



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

Your browser may not support display of this image. Which one of the following four E-R diagrams is the typical result you obtain when you initially start with an E-R diagram containing just two entities, A and C, in a Many-to-Many relationship, and then introduce an associative entity (B).

► Your browser may not support display of this image.

► Your browser may not support display of this image.

► Your browser may not support display of this image.

► Your browser may not support display of this image.



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

Your browser may not support display of this image. Which of the following most certainly implies the need for an entire table to implement?

► A binary relationship

► A ternary relationship

► A recursive relationship

► An identifying relationship



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

Your browser may not support display of this image. Which of the following constraints enforces entity integrity?

► PRIMARY KEY

► FOREIGN KEY

► CHECK

► NOT NULL



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

Your browser may not support display of this image. Which of the following is not true about relational tables?

► Column values are of the same kind.

► Each row is unique.

► Each column must have a unique name.

► The sequence of rows is significant.



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

Your browser may not support display of this image. In a conceptual model for a university, what type of relationship exists between Grade and Student entities?

► 1:1

► 1:M

► M:M

► Ternary



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

Your browser may not support display of this image. Controlling redundancy in a database management system DOES NOT help to

► avoid duplication

► avoid unnecessary wastage of storage space

► avoid unauthorised access to data

► avoid inconsistency among data



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

Your browser may not support display of this image. Which of the following is INCORRECT with respect to file systems?

► At the physical level, pointer or hashed address scheme may be employed to provide a certain degree of data independence at the user level.

► A logical record is concerned with efficient storage of information in the secondary storage devices.

► Some physical organisations use pointers to record blocks to locate records on disk.

► The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete may be performed on the information stored in the file.



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

Your browser may not support display of this image. 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: 11 ( Marks: 1 ) - Please choose one

Your browser may not support display of this image. Select the correct statement about the ANSI/SPARC architecture.

► The conceptual level is a level of indication between the internal level and the external level.

► The internal level in a database system will definitely be relational.

► Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.

► The external level is not concerned with individual user perceptions, while the conceptual level

is concerned with a community user perception.



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

Your browser may not support display of this image. Which of the following is a correct way to implement one-to-many relationship while designing tables?

► by splitting the data into two tables with primary key and

foreign key relationships.

► using a junction table with the keys from both the tables

forming the composite primary key of the junction table.

► by splitting each table into three

► as a single table and rarely as two tables with primary

and foreign key relationships.



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

Your browser may not support display of this image. Which of the following is not a benefit of normalization?

► Minimize insertion anomolies

► Minimize deletion anomolies

► Minimize updation anomolies

► Maximize redundancy



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

Your browser may not support display of this image. Consider the following relation R and its sample data. (Consider that these are the only tuples for the given relation)

Your browser may not support display of this image.

Which of the following statements is NOT correct?

► The functional dependency (EmpNo, DeptNo) -> ProjNo holds over R.

► The functional dependency EmpNo -> DeptNo holds over R.

► The functional dependency ProjNo -> DeptNo holds over R.

► The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.



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

Your browser may not support display of this image. The Entity Relation Model models

► Entities, Relationships and Processes

► Entities and Relationships

► Relationships

► Entities



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

Your browser may not support display of this image. As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.

► primary key

► foreign key

► index

► determinant



Question No: 17 ( Marks: 2 )

Your browser may not support display of this image. For which purpose do we use relational data model?



Question No: 18 ( Marks: 2 )

Your browser may not support display of this image. What major problem can occur if we do not normalize a relation into the first normal form?



Question No: 19 ( Marks: 2 )

Your browser may not support display of this image. In which situation do a recursive relationship exist?



Question No: 20 ( Marks: 3 )

Your browser may not support display of this image. What is DML (Data Manipulation Language)?



Question No: 21 ( Marks: 3 )

Your browser may not support display of this image. What are the three important objectives for using data types while specifying attributes?



Question No: 22 ( Marks: 5 )

Your browser may not support display of this image. Briefly explain super key in relation with primary key.



Question No: 23 ( Marks: 5 )

Your browser may not support display of this image. When is a functional dependency F said to be minimal?
Back to top Go down
 
TODAY CS403 PAPER SOLVED 28-5-10
Back to top 
Page 1 of 1
 Similar topics
-
» CS101 PAPER TODAY 2010
» MGT 402 TODAY PAPER
» MTH501 TODAY PAPER
» MGT603 TODAY PAPER 2010
» ECO401 TODAY PAPER 2010

Permissions in this forum:You cannot reply to topics in this forum
KING'S IT WORLD :: EDUCATION :: PAPERS :: MIDTERM MAY 2010 LATEST PAPERS-
Jump to: