KING'S IT WORLD
please register to watch content in detail
THANKS
ADMIN KINGSIT WORLD

KING'S IT WORLD


 
HomeHome  CalendarCalendar  GalleryGallery  FAQFAQ  SearchSearch  UsergroupsUsergroups  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
Mon Aug 20, 2012 2:59 am by YOUSUFHALI

» PHY301 CIRCUIT THEORY REFERENCE BOOK
Wed Jul 25, 2012 11:36 am by shabbir1915

» MTH202 ASSIGNMENT NO 3 SOLUVED
Mon Jun 11, 2012 9:51 am by jaffarhussain

» Retrieve the DTC In the Jewel Module of 1995 Ford
Thu May 31, 2012 11:51 am by obd2tool

» How you can Obvious the Check Engine Light on the
Thu May 31, 2012 11:43 am by obd2tool

» send free sms and send free sms update on facebook
Tue May 15, 2012 8:33 pm by rizwan269

» United Bank Limited (UBL) - Fee Deposit
Thu May 10, 2012 3:33 pm by irumnaz

» PHOTO MIXER SOFTWARE
Fri Apr 20, 2012 10:02 am by sacredwkb

» Entrepreneurship Survey
Thu Mar 08, 2012 2:20 pm by Admin

» Fall 2011 Semester Result Announced
Thu Mar 08, 2012 2:19 pm by Admin

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
kings it world text ad
Social bookmarking
Social bookmarking Digg  Social bookmarking Delicious  Social bookmarking Reddit  Social bookmarking Stumbleupon  Social bookmarking Slashdot  Social bookmarking Yahoo  Social bookmarking Google  Social bookmarking Blinklist  Social bookmarking Blogmarks  Social bookmarking Technorati  

Bookmark and share the address of KING'S IT WORLD on your social bookmarking website
visitors counter
Powered by website analytics technology.
Keywords
assignment mth301 papers mth302 mgt502 midterm final cs101 cs401 quiz cs605 2010 MCM301 paper SPRING quran solved STA301 cs403 MTH202 MTH101 FALL MKT621 term 2011 CS302
kings it world text ad
FLAG COUNTER
free counters
LIVE TRAFFIC

Share | 
 

 cs403 finalterm paper 2010

View previous topic View next topic Go down 
AuthorMessage
Admin
Admin
avatar

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

PostSubject: cs403 finalterm paper 2010   Sun Aug 08, 2010 10:19 pm


Question No: 1 ( Marks: 1 ) - Please choose one
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

► User accessible catalog

► Data processing

► Authorization service

► Recovery service


Question No: 2 ( Marks: 1 ) - Please choose one
Which of the following statements is true about the views?
► view is always a complete set of all the tables in a database
► View can not be used for retrieving data

► The results of using a view are not permanently stored in the database.

► Rows can not be updated or deleted in the view


Question No: 3 ( Marks: 1 ) - Please choose one
Which of the following is true about TRUNCATE?
► Can be Rolled back.

► Activates Triggers.

► is DML Command.

► Resets identity of the table.


Question No: 4 ( Marks: 1 ) - Please choose one
Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?
► the number of columns in the first table multiplied by the number of columns in the second table.

► the number of columns in the first table multiplied by the number of rows in the second table.

► the number of rows in the first table multiplied by the number of columns in the first table.

► the number of rows in the first table multiplied by the number of rows in the second table.


Question No: 5 ( Marks: 1 ) - Please choose one
Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?
► 24
► 32
► 12
► 16

Question No: 6 ( Marks: 1 ) - Please choose one
Which of the following is not one of the properties of Transaction?
► atomicity
► consistency
► redundancy
► durability

Question No: 7 ( Marks: 1 ) - Please choose one
Which of the following is INCORRECT about VIEWS?
► It is not possible to left out the data which is not required for a specific view.

► A database view displays one or more database records on the same page.

► Views can be used as security mechanisms

► Views are generally used to focus the perception each user
has of the database.


Question No: 8 ( Marks: 1 ) - Please choose one
Each course section is assigned a particular faculty member, and each course section corresponds to a particular course. Conceptually, what is the relationship between faculty and course (not course section).
► 1:1
► 1:M
► M:M
► Ternary

Question No: 9 ( Marks: 1 ) - Please choose one
Which of the following is used to add or drop columns in an existing table?

► ALTER
► HAVING
► SELECT
► THEN

Question No: 10 ( Marks: 1 ) - Please choose one
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
► SELECT FROM * Persons

► SELECT * FROM Persons

► SELECT * WHERE Persons

► SELECT WHERE * Persons


Question No: 11 ( Marks: 1 ) - Please choose one
Which of the following is NOT a feature of Indexed sequential files?
► Records are stored in sequence and index is maintained.

► Dense and nondense types of indexes are maintained.

► Track overflows and file overflow areas can not be ensured.

► Cylinder index increases the efficiency


Question No: 12 ( Marks: 1 ) - Please choose one
Consider the given relations Student and Instructor as given below. Please note that
Fname and Lname also denote the First Name and Last Name respectively.



Which of the following statements is correct with respect to the two relations given above?

► The two relations are not union-compatible since their attribute names differ.
► The two relations are union-compatible since they have the same type of tuples.
► The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these
two relations.

► To find out the students who are not instructors, it is necessary to perform the operation
Student ÷ Instructor.


Question No: 13 ( Marks: 1 ) - Please choose one
Which of the following serves as a milestone or reference point in the log file?

► Constraints

► Relations

► Check points

► Transactions identities


Question No: 14 ( Marks: 1 ) - Please choose one
Which of the following is not true regarding DB transactions?

► A set of database operations that are processed partly
► A database transaction is a logical unit of database operations

► A database transaction must be atomic

► A database transaction must contains the ACID property


Question No: 15 ( Marks: 1 ) - Please choose one
Which of the following are the general activities, which are performed during the development of application programs?

► Data input programs
► Editing

► Display

► All of given


Question No: 16 ( Marks: 1 ) - Please choose one
Browser based forms are developed in the following tools EXCEPT

► HTML

► Scripting language

► Front Page

► Web-based Forms


Question No: 17 ( Marks: 1 ) - Please choose one
Which of the following is not a form of optical disk?

► CD ROM

► WORM

► Erasable Optical

► EEPROM


Question No: 18 ( Marks: 1 ) - Please choose one
Which of the following is the correct description of cache hit?
► When data is found in the cache

► When data is removed in the cache
► The number of times the cache is accessed directly by the processor

► When data is lost from the cache

Question No: 19 ( Marks: 1 ) - Please choose one
In which of the following situations, Clustering is suitable:
► Frequently updating
► Relatively static
► Relatively deletion
► Relatively dynamic

Question No: 20 ( Marks: 1 ) - Please choose one
Only one type of constraint can be enforced in any table by CREATE command
► True
► False

Question No: 21 ( Marks: 1 ) - Please choose one
Which of the following is disadvantage of chaining technique to handle the collisions?
► Unlimited Number of elements
► Fast re-hashing
► Overhead of multiple linked lists
► Maximum number of elements must be known

Question No: 22 ( Marks: 1 ) - Please choose one
Consider the following relation R and its sample data. (Consider that these are the only tuples for the given relation)


Which of the following statements is NOT correct?

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

Question No: 23 ( Marks: 1 ) - Please choose one
An entity type is

► defined when the database is actually constructed
► a specific type such as an integer, text, date, logical etc
► a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
► defined by the database designer

Question No: 24 ( Marks: 1 ) - Please choose one
An entity can be logically connected to another by defining a ____.
► hyperlink
► common attribute
► primary key
► superkey

Question No: 25 ( Marks: 1 ) - Please choose one
You can’t modify more than one table at a time through a view.
► True
► False

Question No: 26 ( Marks: 1 ) - Please choose one
Which of the following is one of the purposes of using DML commands?



► Creating databases
► Destroying databases
► Inserting data in tables
► Non of the above

Question No: 27 ( Marks: 2 )


Question No: 28 ( Marks: 2 )
Define domain of an attribute.

Question No: 29 ( Marks: 2 )
Write the main feature of volatile storage media?

Question No: 30 ( Marks: 2 )
Suppose you want to delete a table row by row and record an entry in the transaction log for each deleted row. Which DML command will you use?

Question No: 31 ( Marks: 3 )
Write three benefits of using VIEWS.

Question No: 32 ( Marks: 3 )
SELECT * FROM Persons
WHERE FirstName LIKE '%da%';

what does the above statement return?

Question No: 33 ( Marks: 3 )
What is the difference between a primary key and a unique key with reference to clustered and nonclustered indexes?


Question No: 34 ( Marks: 5 )
Consider a table named COMPANY with fields COMPANY_NAME,
DESCRIPTION, ORDER_NUMBER. Write an SQL statement to display company names in reverse alphabetical order.

Question No: 35 ( Marks: 5 )
Name the five main components of Database management systems software.


Question No: 36 ( Marks: 5 )
Give 4 similarities between Materialized views and indexes.

WWW.VUSR.NET


Back to top Go down
View user profile
 
cs403 finalterm paper 2010
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» Court upholds ruling on LTO security paper bidding
» Mercredi 10 mars 2010 : l'horoscope
» Noah Paper Mills Wins Bid to Supply Paper for Barangay and Sangguniang Kabataan (SK) Polls
» OTC Paper Supply and Smartmatic bag COMELEC contracts
» Is The Iraqi Dinar Worthless Paper Or Maker Of Millionaires?

Permissions in this forum:You cannot reply to topics in this forum
KING'S IT WORLD :: EDUCATION :: PAPERS :: SPRING 2010 FINAL TERM PAPERS (updated daily)-
Jump to: