 |
|
#1
12-01-2011, 03:32 PM
|
||||
|
||||
cs403 final term paper of 2011
Briefly describe any two properties of Transactions? 2 Marks
State the two conditions which are imposed on candidate key? 2 Marks How many places to the right of the decimal can be stored in a CURRENCY data field? 2 Marks Name the two types of caching that are commonly used in personal computers? 2 Marks What is “Data Definition"? 3 Marks What is the general purpose of using DML commands? 3 Marks Write the salient features of Indexed sequential files? 3 Marks What effect can be occurred if a transaction lacks durability? 3 Marks Briefly explain super key in relation with primary key. 5 Marks Write a statement to create a table named "Person", with four columns. The column names will be "LastName", "FirstName", "Address", and "Age". 5 Marks What is a transaction and what are ACID properties? 5 Marks Explain the technique of RE-HASHING? 5 Marks MCQS were from past papers 70% These are questions which i remember write 2 similarities between materialized views and indexes? What is the purpose of testing DB syatem? Why fixed length files are advantageous over variable length files? Give and explain the LIKE clause? How attributes are related to eentities? What is the purpose of processing of database usage authority? Write 5 features of views? When the GROUP BY clause is used? When is the LOST UPDATE is used? People the paper is quite lengthy(and the dusty keyboards makes it more lengthy  ) ) )52 questionions 42(objectives) What is the difference between Commit and rollback?(2marks) What is the problem which occur in normalization of 1 form of normalization(2marks) Why will u prefer direct access over sequential access?(2marks) This question i have forgotten(5marks) What type of information is stored in data dictionary?(3marks) What problem occurs when data concurrency is not controlled?(3marks) What is the purpose of file protection?(3marks) What are database objects?(5marks) Write sql statement for display list of persons in table PERSON and show only that records whose first name is Ahmed and who's Last name is Ali(5marks) What is unary and ternary Relationship?(5marks) 1.Application programmer as user of database systems, (5) 2.different b/w rollback and rollforward.(5) 3.why will you prefer delete command on drop command while deleting a table,(5) 4.how many number of clusters are used in database and reason of limit, 5.purpose of having clause, 6.purpose of protection, 7.explain data independency 8.two types of interface, 9.write DML statement that changes the values of one or more than one attribute based on some condition. 10.describe insertion anomaly, 11.COMMIT and ROLLBACK What is the purpose of IN Fucntions? In which situation join is used? What is serial execution? Write three advantages of views? What are locking protocols, explain? What is rehashing? In which situation self join is used? Why direct access is preferred over sequential access? objective koe nae past ppr sy aya.........bas thora thora aya tha.............subjective molahiza farmaye......... 1-Name 2 types of ordered indices? (2) (saara ppr main zahen pr zoor daity rahy akhir kar last main yaad a hi gea.......;p) 2-Briefly explain any 2 property of transactions? (2) (briefly v likha hai n explain v likha hai wo v 2 marks ka....haad nae ho gae....) 3-In which sitiuation it is require to use a join? (2) 4-what is meant by Inter Schema Mapping (2) (is main apna concept lika.....ataa nae tha........;p) 5-how do the time stamping approch works to give priorties tothe transaction? (3) (shukr hai akhei wakt main me yahi prh rae thi......) 6-how can we identify records in case of sequential files (3) (is main main ny apna concept likha......aata nae tha........;p) 7-what is purpose of IN operator? 8-what does controlled redundacy as a advantages of database system mean? (3) (yai to mid hi wala tha....kr lia) 9-Briefly eplain 3rd normal form (5) (yai v mid wala tha.....ho gea) 10-what is the significance of check point in recovery procedure.How it is used in recovery procedure (5) (last time peha tha........kr hi lia thora thora) 11-shortly eplain index?give 2 types of indexes (5) (mostly mcqs idex pr thy....main ny copy paste wahein sy vaikh kr kr liya.....;p) 12-wo question ganda tha........mjy pasad nae aya.....aur choor dia.......query likhni thi..... What are two primary modes for taking locks---2 marks How minimum cardinality finding is important for relationship --2 What are purpose of INPUT form ---2 marks What are three concurrency problems --3 marks Define composite key --3 marks Write down factors in defining key for index sequenced file --3 marks What is purpose behind HAVING clause ---3 marks Write down five features of VIEWS --- 5 marks What is purpose of VIEWS in DBMS--- 5 marks Write down syntax for IN clause --5 marks Differentiate Total and Partial completeness -- 5mark keep remember in ur prayers 40Mcqs.90%mcqs were from chap#20-45.7-8mcqs were from past papers. Some subjective questions which I remember are What is a transaction? What are ACID properties? What happened when lack of durability in transaction? What is alternate key? What are five features of Views? Difference b/w Delete and truncate commands? What is the purpose of DML commands? What is serial execution? What are the features of indexed serial execution? What is Unary and Ternary relationship? 1.Application programmer as user of database systems, (5) 2.different b/w rollback and rollforward.(5) 3.why will you prefer delete command on drop command while deleting a table,(5) 4.how many number of clusters are used in database and reason of limit, 5.purpose of having clause, 6.purpose of protection, 7.explain data independency 8.two types of interface, 9.write DML statement that changes the values of one or more than one attribute based on some condition. 10.describe insertion anomaly, 11.COMMIT and ROLLBACK 1.Application programmer as user of database systems, (5) 2.different b/w rollback and rollforward.(5) 3.why will you prefer delete command on drop command while deleting a table,(5) 4.how many number of clusters are used in database and reason of limit, 5.purpose of having clause, 6.purpose of protection, 7.explain data independency 8.two types of interface, 9.write DML statement that changes the values of one or more than one attribute based on some condition. 10.describe insertion anomaly, 11.COMMIT and ROLLBACK What is the difference between Commit and rollback?(2marks) What is the problem which occur in normalization of 1 form of normalization(2marks) Why will u prefer direct access over sequential access?(2marks) This question i have forgotten(5marks) What type of information is stored in data dictionary?(3marks) What problem occurs when data concurrency is not controlled?(3marks) What is the purpose of file protection?(3marks) What are database objects?(5marks) Write sql statement for display list of persons in table PERSON and show only that records whose first name is Ahmed and who's Last name is Ali(5marks) What is unary and ternary Relationship?(5marks) Which of the following is not one of the properties of Transaction? ► atomicity ► consistency ► redundancy ► durability 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 Which of the following serves as a milestone or reference point in the log file? ► Constraints ► Relations ► Check points ► Transactions identities 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 Which of the following are the general activities, which are performed during the development of application programs? ► Data input programs ► Editing ► Display The main memory of a computer system is also known as ► ROM ► RAM ► PROM ► Hard disk The main memory of a computer system is also known as ► ROM ► RAM ► PROM ► Hard disk While recovering data, which of the following files does a recovery manager examines at first? ► A system file ► Log file ► Data dictionary ► Metadata What is the alternate name of Data Dictionary? ► Index ► Metadata ► Data ► System Catalog Which of the following statements are Data Definition Language command? ► INSERT ► UPDATE ► GRANT ► TRUNCATE Questions were 1) Difference Bet Delete Table and Drop Table? 2) Commanlities bet Materialized View and Indexes? 3)Difference bet partial Completeness and Total Completeness Constraints 4)What is Entity Extension? Pray For me as well Thx ► All of given ▶ Reply M.Tariq MalikPermalink Reply by M.Tariq Malik on February 15, 2011 at 9:17pm Dear Fellows in paper of CS 403 following were few questions that i m able to keep in memory 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 Which of the following is not one of the properties of Transaction? ► atomicity ► consistency ► redundancy ► durability 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 Which of the following serves as a milestone or reference point in the log file? ► Constraints ► Relations ► Check points ► Transactions identities 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 Which of the following are the general activities, which are performed during the development of application programs? ► Data input programs ► Editing ► Display The main memory of a computer system is also known as ► ROM ► RAM ► PROM ► Hard disk The main memory of a computer system is also known as ► ROM ► RAM ► PROM ► Hard disk While recovering data, which of the following files does a recovery manager examines at first? ► A system file ► Log file ► Data dictionary ► Metadata What is the alternate name of Data Dictionary? ► Index ► Metadata ► Data ► System Catalog Which of the following statements are Data Definition Language command? ► INSERT ► UPDATE ► GRANT ► TRUNCATE Questions were 1) Difference Bet Delete Table and Drop Table? 2) Commanlities bet Materialized View and Indexes? 3)Difference bet partial Completeness and Total Completeness Constraints 4)What is Entity Extension? In which situation join is used? Join Joins can be used in SELECT, UPDATE and DELETE statements. What is serial execution? Serial execution is when tasks are completed consecutively (one after the other), as opposed to concurrently (at the same time, in parallel). Write three advantages of views? Advantages of views: 1. View the data without storing the data into the object. 2. Restict the view of a table i.e. can hide some of columns in the tables. 3. Join two or more tables and show it as one object to user. 4. Restict the access of a table so that nobody can insert the rows into the table. Disadvatages: 1. Can not use DML operations on this. 2. When table is dropped view becomes inactive.. it depends on the table objects. 3. It is an object so it occupies space. What are locking protocols, explain? What is rehashing? One has to use 'rehash' to get table and field completion. This gives a quicker start of mysql and disables rehashing on reconnect. WARNING: options deprecated; use --disable-auto-rehash instead. In which situation self join is used? Self Join is nothing but a table joining with itself. It is very helpful to fetching duplicate data from a table.. if we want to fetch the emp_id from emp whice are duplicate in emp tab. examp: select a.emp_id b.emp_id from emp a emp b where a.emp_id=b.emp_id and a.rowid<>b.rowid. we can get duplicate value easily by help of self join Why direct access is preferred over sequential access? Disk storage has several characteristics to recommend it: it is physically secure, requiring no handling; it provides both sequential and direct access to records; and it is reasonable in cost. These factors make disk storage the preferred medium today. While tape storage is relatively simple, disk storage can be complex. Although sequential access on disk is no more complex than on tape, direct access may involve complex file structures. Efficient use of these structures requires an understanding of the physical medium and the operating system components that perform the actual reading and writing of data on the disk. 
|
|
Linear Mode
