FINALTERM EXAMINATION
Fall 2008
CS403- Database Management Systems (Session - 3)
CS403 Question No: 1
_______ records data by burning microscopic holes in the surface of the disk with a
laser.
► Hard disk
► RAM
► Optical disk
► Floppy disk
Optical disks record data by burning microscopic holes in the surface of the disk with a laser. To read the disk, another laser beam shines on the disk and detects the holes by changes in the reflection pattern.P#71
CS403 Question No: 2
______ is a control that presents a set of choices from which a user can select one or more items; items can be text, graphics, or both.
► Text input
► Report
► Button
► List box
CS403 Question No: 3
_______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
A combo box is a control that enables users to select one option from an associated list; users can also type an option into an editable combo box
CS403 Question No: 4
_______ is a control that users click to perform an action, set or toggle a state, or set an option.
► Button
► Text box
► Input form
► Report
A button is a control that users click to perform an action, set or toggle a state, or set an option
CS403 Question No: 5
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
The main usage of forms is to populate multiple tables at time.
CS403 Question No: 6
Browser based forms are developed in the following tools EXCEPT
► HTML
► Scripting language
► Front Page
► Web-based Forms
Browser Based are web-based forms. They are developed in HTML, scripting language or Front Page.P#55
www.vuzs.net
http://groups.google.com/group/vuzs
CS403 Question No: 7
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
Following are the general activities, which are performed during the development of application programs:
· Data input programmes
· Editing
· Display
· Processing related to activities
· Reports
CS403 Question No: 8
Which of the following should not be a property of a database transaction?
► Atomicity
► Isolation
► Durability
► Divergence
Properties of a transaction
All transactions share these properties: atomicity, consistency, isolation, and durability (represented by the acronym ACID).
CS403 Question No: 9
The main memory of a computer system is also known as
► ROM
► PROM
► Hard disk
The main memory of the computer is also known as RAM, standing for Random
Access Memory P#70
CS403 Question No: 10
While recovering data, which of the following files does a recovery manager examines at first?
► A system file
► Data dictionary
► Metadata
When crash occurs, the recovery manager (RM), on restart, examines the log file from the disk P#117
CS403 Question No: 11
Which of the following is the correct way of removing the Index called branchNoIndex?
► DROP INDEX branchNoIndex;
► APPEND INDEX branchNoIndex;
► REMOVE INDEX branchNoIndex;
► DEL INDEX branchNoIndex;
CS403 Question No: 12
What is the alternate name of Data Dictionary?
► Index
► Metadata
► Data
► System Catalog
Metadata refers to data about the data. For example, the name of a table and the data type of a column is metadata. There are two other terms that are often used as synonyms for metadata: - Data dictionary
- System catalog
CS403 Question No: 13
The information regarding ‘views’ and ‘Integrity constraints’ are found in
► System Catalog
► Data Dictionary
► Indexes
► Both Data Dictionary and System Catalog
not sure
CS403 Question No: 14
Identify the correct statement.
► Referential integrity constraints check whether the primary key values are unique.
► Referential integrity constraints check whether an attribute value lies in the given range.
► Referential integrity constraints are specified between entities having recursive relationships.
► When Referential integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an existing tuple.
CS403 Question No: 15
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.
As a general practice, given a narrative description of the database requirements, the
nouns appearing in the narrative tend to give rise to entity type names, and the verbs tend
to indicate names of relationship types. Attribute names generally arise from additional
nouns that describe the nouns corresponding to entity types.
CS403 Question No: 16
Consider the following diagram depicting a kind of a relationship type where X and Z are entities and Y is a relationship type:
Select the correct statement among the following on the above diagram.
► The relationship type Y is of cardinality ratio 1 : N.
► The diagram depicts existence dependencies.
► The participation of X in the Y relationship type is total.
► The participation of Z in the Y relationship type is partial.
CS403 Question No: 17
Identify the correct statement about ANSI/SPARC architecture.
► The external level is not concerned with individual user perceptions
► The internal level, in a database system, will always be relational
► Any given database has exactly one conceptual schema and one physical schema, but it may have several external schemas. ► A data definition language is used to define the internal schema.
www.vuzs.net
http://groups.google.com/group/vuzs
CS403 Question No: 18
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
CS403 Question No: 19
Which of the following is NOT a feature of a good interface?
► consistency
► process based
► data structure based
► user friendly
CS403 Question No: 20
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.
CS403 Question No: 21
Which of the following concept is applicable with respect to 2NF?
► Non-transitive dependency
► Full functional dependency
► Partial dependency
► Transitive dependency
Second normal form (2NF)
To be in second normal form, a record must be in 1 NF, and all non-key fields must be functionally dependent on the entire primary key - not just part of it Functional dependency means that a value in one field determines a value in another field
CS403 Question No: 22 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;
CS403 Question No: 23 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
Views allow users to focus on specific data that interests them and on the
specific tasks for which they are responsible. Unnecessary data can be left
out of the view.
CS403 Question No: 24
Identify the advantage of DELETE command over TRUNCATE.
► Can be Rolled back.
► is DDL Command.
► cannot activate a trigger.
► faster and uses fewer system
CS403 Question No: 25
Which of the following is true about TRUNCATE?
► Can be Rolled back.
► Activates Triggers.
► is DML Command.
► Resets identity of the table.
TRUNCATE:
1. TRUNCATE is faster and uses fewer system and transaction log resources than DELETE.
2. TRUNCATE removes the data by deallocating the data pages used to store the table's data, and only the page deallocations are recorded in the transaction log.
3. TRUNCATE removes all rows from a table, but the table structure, its columns, constraints, indexes and so on, remains. The counter used by an identity for new rows is reset to the seed for the column.
4. You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY constraint. Because TRUNCATE TABLE is not logged, it cannot activate a trigger.
5. TRUNCATE cannot be rolled back.
6. TRUNCATE is DDL Command.
7. TRUNCATE Resets identity of the table
CS403 Question No: 26
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
A simple view can be thought of as a subset of a table. It can be used for retrieving data, as well as updating or deleting rows. Rows updated or deleted in the view are updated or deleted in the table the view was created with. It should also be noted that as data in the original table changes, so does data in the view, as views are the way to look at part of the original table. The results of using a view are not permanently stored in the database. The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables or even other views.
CS403 Question No: 27
Which of the following statements are Data Definition Language command?
► INSERT
► UPDATE
► GRANT
► TRUNCATE
Truncate command is a DDL statement.
DDL statements can't be rollback. Truncate statement can't be rollback.
In DDL statement we can't use WHERE. In truncate also we can't use WHERE.
DELETE is a DML statement we can rollback as well as we can use WHERE.
www.vuzs.net
CS403 Question No: 28
Which of the following statements are Data Manipulation Language command?
► INSERT
► GRANT
► TRUNCATE
► CREATE
CS403 Question No: 29
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 Amali & Hiruni to retrieve data from Employee table.
► Grant permission to Hiruni in order to grant, select and update permission to Amali.
► Grant permission to Amali and Hiruni to update all data except designation in Employee
table
CS403 Question No: 30
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
Logical data independence
Logical data independence provides the independence in a way that
changes in conceptual model do not affect the external views. Or
simply i t can be stated at the Immunity of external level from
changes at conceptual level .
www.vuzs.net
http://groups.google.com/group/vuzs
CS403 Question No: 31
What is Ordering field?
CS403 Question No: 32
Which clause is used to sort the records in the result set?
CS403 Question No: 33 ( M a r k s: 2 )
What is the major benefit of HASH paritioning?
CS403 Question No: 34 ( M a r k s: 2 )
How can we prevent deadlocks for concurrent Transactions?
CS403 Question No: 35 ( M a r k s: 3 )
State the major disadvantage of creating and using index.
CS403 Question No: 36 ( M a r k s: 3 )
Write any three factors which we consider while defining key in designing an indexed sequential file?
CS403 Question No: 37 ( M a r k s: 3 )
How do you select all records from the table using SQL statements? Write the syntax.
CS403 Question No: 38 ( M a r k s: 5 )
How can a VIEW be used for security measures?
CS403 Question No: 39 ( M a r k s: 5 )
In which situtation do you prefer DELETE command to delete a table instead of using DROP command?
CS403 Question No: 40 ( M a r k s: 10 )
Write four advantages and four disadvantages of De-normalization.
CS403 Question No: 41 ( M a r k s: 10 )
Explain and differentiate the two types of application users:
· Intermediate
· Expert
