FINALTERM EXAMINATION
Fall 2009
CS403- Database Management Systems (Session - 4)
Time: 120 min
Marks: 75
Question No: 1 ( Marks: 1 ) - Please choose one
Which of the following SQL keywords is not used with DDL statements? ► Table
► Update
► Create
► Alter
Question No: 2 ( Marks: 1 ) - Please choose one
Identify the constraint that limits the values that can be placed in a column. ► NOT NULL
► CHECK
► FOREIGN KEY
► UNIQUE
Question No: 3 ( 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: 4 ( Marks: 1 ) - Please choose one
Suppose there are 4 fields in a table named WORKER (Id, first_name, last_name, joining_year). Which of the following gives all the information of the workers who have joined after 1965? ► SELECT * FROM WORKER WHERE joining_Year>1965;
► SELECT * FROM WORKER WHERE joining_Year>'1965';
► SELECT * FROM WORKER AND joining_Year>'1965';
► SELECT * WHERE joining_Year>1965;
Question No: 5 ( Marks: 1 ) - Please choose one
Which of the following enforces a relation into 1st normal form? ► The domain of attribute must include only atomic values.
► Every non-key attribute is fully functionally dependent on primary key
► non-key attribute is non-transitively dependent on primary key.
► Every non-key attribute is partially dependent on super key
Question No: 6 ( Marks: 1 ) - Please choose one
Which of the following is NOT a feature of HASH ACCESS? ► indexes to search or maintain
► Very fast direct access
► Inefficient sequential access
► Use when direct access is needed, but sequential access is not.
Question No: 7 ( Marks: 1 ) - Please choose one
Which of the following is NOT a feature of a good interface? ► data structure based
► user friendly
► consistency
► process based
Question No: 8 ( Marks: 1 ) - Please choose one
Which of the following is true about application programs? ► develop before the database design
► Tools selection is made after the development database
► meant to perform different operations by the user
► must to design before the designing and developing database
Question No: 9 ( Marks: 1 ) - Please choose one
Which of the following is incorrect with respect to indexed sequential files? ► New records are added to an overflow file
► Record in main file that precedes it is updated to contain a pointer to the new record
► The overflow is merged with the main file during a batch update
► Multiple indexes for the same key field cannot be setup
Question No: 10 ( Marks: 1 ) - Please choose one
Which of the following is one of the purposes of using DDL commands? ► inserting records into databases
► updating records into databases
► manipulating databases
► creating and destroying databases
Question No: 11 ( Marks: 1 ) - Please choose one
Which of the following statements creates a database named COMPANY. ► CREATE DATABASE company
► CREATE DB company
► CREATE DB company
► ADD DATABASE copmany
► CREATE company DATABASE
Question No: 12 ( Marks: 1 ) - Please choose one
A relation (from the relational database model) consists of a set of tuples, which implies that ► relational model supports multi-valued attributes whose values can be represented in sets.
► for any two tuples, the values associated with all of their attributes may be the same.
► for any two tuples, the values associated with one or more of their attributes must differ.
► all tuples in a particular relation may have different attributes.
Question No: 13 ( Marks: 1 ) - Please choose one
Select the correct statement among the following on proper naming of schema constructs: ► Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type.
► In the narrative description of the database requirements, verbs tend to indicate the names of relationship types.
► The nouns arising from a database requirement description can be considered as names of attributes.
► Additional nouns which are appearing in the narrative description of the database
requirements represent the weak entity type names.
Question No: 14 ( Marks: 1 ) - Please choose one
Structural constraints of a relationship type refer to ► identifying the owner entity type relevant to a given entity type
► whether the existence of an entity depends on it being related to another entity via the relationship type.
► the role that a participating entity from the entity type plays in each relationship instance.
► the constraints applicable in granting access to tables, columns and views in a database schema.
Question No: 15 ( Marks: 1 ) - Please choose one
What is the impact of setting multiple indexes for the same key, in index sequential files? ► Multiple indexes for the same key can not be set
► It increases efficiency
► It decreases efficiency
► It will increase complexity as the access time will be increased
Question No: 16 ( Marks: 1 ) - Please choose one
The information regarding ‘views’ and ‘Integrity constraints’ are found in
► Both Data Dictionary and System Catalog
► System Catalog
► Data Dictionary
► Indexes
Question No: 17 ( Marks: 1 ) - Please choose one
Which of following is not the feature of Indexes? ► consume storage space.
► must be refreshed when the data in their master tables changes
► improve the performance of SQL execution when they are used for query rewrites
► can be accessed directly using a SELECT statement
Question No: 18 ( 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: 19 ( 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: 20 ( Marks: 1 ) - Please choose one
Which of the following is not a type of user interface? ► Graphical User Interface (GUI)
► Forms
► DB tables
► Text based
Question No: 21 ( Marks: 1 ) - Please choose one
Which of the following is not true about input forms? ► Provide an easy, effective, efficient way to enter data into a table
► Especially useful when the person entering the data is not familiar with the inner workings
► Provide different controls to add data into the tables
► One input forms can populate one table at a time
Question No: 22 ( Marks: 1 ) - Please choose one
Which of the following is an example of volatile memory? ► RAM
► ROM
► Flash memory
► CPU
Question No: 23 ( Marks: 1 ) - Please choose one
Partitions may become unbalanced in: ► Range partitioning
► Hash partitioning
► List partitioning
► Vertical partitioning
Question No: 24 ( Marks: 1 ) - Please choose one
In SQL queries, while creating tables or relations in database, key columns may be specified by
► Data type
► Null
► Not Null
► Owner
Question No: 25 ( 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: 26 ( Marks: 1 ) - Please choose one
Which of the following is Advantage of Re-Hashing technique to handle the collisions? ► Collisions don’t use primary table space
► Unlimited number of elements
► Fast access through use of main table space
► Overhead of multiple linked lists
Question No: 27 ( Marks: 1 ) - Please choose one
Materialized views and Indexes are NOT similar by the following way(s). ► They consume storage space
► They must be refreshed when the data in their master tables changes.
► They can be accessed directly using a SELECT statement
► All of the Given
Question No: 28 ( Marks: 1 ) - Please choose one
The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
► specialization
► uniqueness
► inheritance
► completeness
Question No: 29 ( Marks: 1 ) - Please choose one
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: 30 ( Marks: 1 ) - Please choose one
Which of the following is NOT one of the ways of resolving deadlocks? ► Undoing all the updates made by the particular transaction which is the cause of deadlock.
► A message is passed to the victim and depending on the system the transaction may or may not be started again automatically.
► Picking a list of all previously completed transactions and undoing all the updates.
► Rollback `victim' transaction and restart it.
www.allvupastpapers.blogspot.com
AdeelAbbasbk@gmail.com
No comments:
Post a Comment
PLEASE COMMENT ABOUT YOUR VISIT AND MY SITE
Note: Only a member of this blog may post a comment.