FINAL TERM EXAMINATION
SPRING 2010
CS403- DATABASE MANAGEMENT SYSTEMS
Question No: 1 ( 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: 2 ( Marks: 1 ) - Please choose one
What is the alternate name of Data Dictionary?
► Index
► Metadata
► Data
► System Catalog
Question No: 3 ( Marks: 1 ) - Please choose one
IN function helps reduce the need to use multiple AND conditions.
►True
► False
Question No: 4 ( 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: 5 ( 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: 6 ( Marks: 1 ) - Please choose one
Which of the following is not true about De-normalization?
► It is the process of attempting to optimize the performance of a database
► De-normalization is a technique to move from lower to higher normal forms of database modeling
► In de-normalization it is required to add redundant data.
► It enhances the performance of DB
Question No: 7 ( Marks: 1 ) - Please choose one
Which of the following gives all the fields from employee table named as EMP?
► SELECT * from EMP;
► SELECT emp* from EMP'
► SELECT emp_id where EMP;
► SELECT * where EMP;
Question No: 8 ( Marks: 1 ) - Please choose one
Which of the following types of partitioning reduces the chances of unbalanced partitions?
► Vertical
► List
► Hash
► Range
Question No: 9 ( Marks: 1 ) - Please choose one
While recovering data, which of the following files does a recovery manager examines at first?
► A system file
► Log file
► Data dictionary
► Metadata
Question No: 10 ( 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: 11 ( 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.
Question No: 12 ( Marks: 1 ) - Please choose one
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
ALTER TABLE exams
RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.
Syntax of ALTER TABLE is NOT correct.
► True
► False
Question No: 14 ( Marks: 1 ) - Please choose one
Which of the following SQL commands deletes a record of an employee with the employee_id
12345, from a table named PERSON.
► DELETE FROM person WHERE employee_id = ‘12345’
► DELETE WHERE person FROM employee_id = 12345
► DROP FROM person WHERE employee_id = 12345
► DELETE WHERE person WHERE employee_id = 12345
Question No: 15 ( Marks: 1 ) - Please choose one
Which of the following is not a form of optical disk?
► CD ROM
► WORM
► Erasable Optical
► EEPROM
Question No: 16 ( 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: 17 ( Marks: 1 ) - Please choose one
In which of the following situations, Clustering is suitable:
► Frequently updating
► Relatively static
► Relatively deletion
► Relatively dynamic
Question No: 18 ( 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: 19 ( Marks: 1 ) - Please choose one
Which of the following is NOT a component of a DFD? Select correct option:
►Dataflow
►Datastore
►External entities
►Relationship between external entities
Question No: 20 ( Marks: 1 ) - Please choose one
__________records data by burning microscopic holes in the surface of the disk with a laser.
► Hard disk
► RAM
► Optical disk
► Floppy disk
Question No: 21 ( 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: 22 ( Marks: 1 ) - Please choose one
Which of the following is NOT a feature of a good interface?
► Consistency
► Process based
► Data structure based
► User friendly
Question No: 1 ( Marks: 1 ) - Please choose one
Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
► Physical data independence.
► Concurrency control.
► Logical data independence.
► Functional dependency
Question No: 2 ( Marks: 1 ) - Please choose one
GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION;
What does this SQL statement do?
► Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table.
► Grant permission to Hiruni in order to grant, select and update permission to Amali.
► Grant permission to Amali & Hiruni to update designation of employees in the Employee table.
► Grant permission to Amali and Hiruni to update all data except designation in Employee table.
Question No: 3 ( Marks: 1 ) - Please choose one
Which key word is available in SQL to enforce referential integrity?
► Check
► Primary Key
► Set Default
► Unique
Question No: 4 ( Marks: 1 ) - Please choose one
Which of the following statements are Data Definition Language command?
► INSERT
► UPDATE
► GRANT
► TRUNCATE
Question No: 5 ( Marks: 1 ) - Please choose one
How many clustered index(es) do each database table have?
► 2
► 3
► 5
► 1
Question No: 6 ( Marks: 1 ) - Please choose one
Which of the following is true about DELETE command?
► is DDL Command.
► Resets identity of the table.
► cannot activate a trigger.
► Can be Rolled back.
Question No: 7 ( Marks: 1 ) - Please choose one
Which of the following will be deleted relating to a table if you use TRUNCATE command?
► all rows in a table
► indexes
► table structure and its columns
► constraints
Question No: 8 ( Marks: 1 ) - Please choose one
Which of the following is not true about De-normalization?
► It is the process of attempting to optimize the performance of a database
► De-normalization is a technique to move from lower to higher normal forms of database modeling
► In de-normalization it is required to add redundant data.
► It enhances the performance of DB
Question No: 9 ( Marks: 1 ) - Please choose one
Which of the following is not a feature of TRANSACTION?
► Users should be able to regard the execution of each transaction as atomic.
► Each transaction, run by itself.
► must preserve the consistency of the database
► dependant on other concurrent transactions
Question No: 10 ( Marks: 1 ) - Please choose one
Which of the following gives all the fields from employee table named as EMP?
► select * from EMP;
► select emp* from EMP'
► select emp_id where EMP;
► select * where EMP;
Question No: 11 ( Marks: 1 ) - Please choose one
Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?
► SELECT * FROM CUST WHERE last_name='ALI';
► SELECT * FROM CUST WHERE last_name=ALI;
► SELECT * FROM CUSTOMER WHERE name=ALI;
► SELECT * FROM CUSTOMER WHERE last_name=ALI;
Question No: 12 ( Marks: 1 ) - Please choose one
Identify the correct statement with respect to normalization.
► Normalization is a formal technique that can be used only at the starting phase of the database design.
► Normalization can be used as a top-down standalone database design technique.
► The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.
► The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.
www.allvupastpapers.blogspot.com
www.allvupastpapers.blogspot.com
Question No: 13 ( Marks: 1 ) - Please choose one
Which of the following is not true with respect to denormalization?
► A denormalized data model is not the same as a data model that has not been normalized
► Denormalization takes place before the normalization process
► It is an attempt to optimize the performance of database
► Denormalization process can not be initiated before the Database design
Question No: 14 ( 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: 15 ( Marks: 1 ) - Please choose one
Which of the following types of partitioning reduces the chances of unbalanced www.allvupastpapers.blogspot.com
partitions?
► vertical
► List
► Hash
► Range
Question No: 16 ( Marks: 1 ) - Please choose one
DML commands are used for:
► inserting data into databases
► creating databases
► destroying databases
► creating DB objects
Question No: 17 ( Marks: 1 ) - Please choose one
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: 18 ( Marks: 1 ) - Please choose one
Which of the following is correct regarding Dataflow diagram?
► Single DFD is required to represent a system
► The dataflow must be bidirectional
► Created at increasing levels of detail
► Used to represent the relationships among the external entities
Question No: 19 ( 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: 20 ( 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.
► the constraints applicable in granting access to tables, columns and views in a database schema.
Question No: 21 ( Marks: 1 ) - Please choose one
Identify the correct statement.
► Entity integrity constraints specify that primary key values can be composite.
► Entity integrity constraints are specified on individual relations.
► Entity integrity constraints are specified between weak entities.
► When entity integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an existing tuple.
Question No: 22 ( 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: 23 ( Marks: 1 ) - Please choose one
Which of the following is not true regarding Indexes?
► Index can be defined even when there is no data in the table
► It support Range selections
► It can be created using ‘Create Index’ statement
► It can not be created on composite attributes
Question No: 24 ( Marks: 1 ) - Please choose one
While recovering data, which of the following files does a recovery manager examines at first?
► A system file
► Log file
► Data dictionary
► Metadata
Question No: 25 ( Marks: 1 ) - Please choose one
Question No: 25 ( Marks: 1 ) - Please choose one
The main memory of a computer system is also known as
► ROM
► RAM
► PROM
► Hard disk
Question No: 26 ( Marks: 1 ) - Please choose one
_______is a control that enables users to select one option from an associated list; users can also type an option.
► Combo box
► Button
► Text box
► Static area
Question No: 27 ( Marks: 1 ) - Please choose one
_______ records data by burning microscopic holes in the surface of the disk with a laser.
► Hard disk
► RAM
► Optical disk
► Floppy disk
Question No: 28 ( Marks: 1 ) - Please choose one
Which of following is NOT generally the aim of data partitioning and placement of data?
► Reduce Workload
► Balance Workload
► Merging different relations
► Speed up rate of useful works.
Question No: 29 ( Marks: 1 ) - Please choose one
ALTER TABLE exams
RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.
RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.
Syntax of ALTER TABLE is NOT correct.
► True
► False
Question No: 30 ( Marks: 1 ) - Please choose one
Which of the following is true regarding Index?
► Index can only be created for a single table in database
► Index can maximum be created for two tables in database
► Index should be created for every table in the database
► Index can be created for every table in the database
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.