::: vuaskari.com ::: CS403 Unsolved Paper

Plz solve this Paper

Question No: 1 ( 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: 2 ( Marks: 1 ) - Please choose one
______ 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

Question No: 3 ( 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: 4 ( Marks: 1 ) - Please choose one
_______ 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

Question No: 5 ( 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: 6 ( 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: 7 ( 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: 8 ( Marks: 1 ) - Please choose one
Which of the following should not be a property of a database transaction?
► Atomicity
► Isolation
► Durability
► Divergence

Question No: 9 ( Marks: 1 ) - Please choose one
The main memory of a computer system is also known as
► ROM
► RAM
► PROM
► Hard disk

Question No: 10 ( 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: 11 ( Marks: 1 ) - Please choose one
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;

Question No: 12 ( Marks: 1 ) - Please choose one
What is the alternate name of Data Dictionary?
► Index
► Metadata
► Data
► System Catalog

Question No: 13 ( Marks: 1 ) - Please choose one
The information regarding 'views' and 'Integrity constraints' are found in
► System Catalog
► Data Dictionary
► Indexes
► Both Data Dictionary and System Catalog

Question No: 14 ( Marks: 1 ) - Please choose one
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.

Question No: 15 ( 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: 16 ( Marks: 1 ) - Please choose one
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.

Question No: 17 ( Marks: 1 ) - Please choose one
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.

Question No: 18 ( 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: 19 ( 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: 20 ( 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.

Question No: 21 ( Marks: 1 ) - Please choose one
Which of the following concept is applicable with respect to 2NF?
► Non-transitive dependency
► Full functional dependency
► Partial dependency
► Transitive dependency

Question No: 22 ( 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: 23 ( 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: 24 ( Marks: 1 ) - Please choose one
Identify the advantage of DELETE command over TRUNCATE.
► Can be Rolled back.
► is DDL Command.
► cannot activate a trigger.
► faster and uses fewer system

Question No: 25 ( 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: 26 ( 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: 27 ( Marks: 1 ) - Please choose one
Which of the following statements are Data Definition Language command?
► INSERT
► UPDATE
► GRANT
► TRUNCATE

Question No: 28 ( Marks: 1 ) - Please choose one
Which of the following statements are Data Manipulation Language command?
► INSERT
► GRANT
► TRUNCATE
► CREATE

Question No: 29 ( 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 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

Question No: 30 ( 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: 31 ( Marks: 1 )
What is Ordering field?

Question No: 32 ( Marks: 1 )
Which clause is used to sort the records in the result set?

Question No: 33 ( Marks: 2 )
What is the major benefit of HASH paritioning?

Question No: 34 ( Marks: 2 )
How can we prevent deadlocks for concurrent Transactions?

Question No: 35 ( Marks: 3 )
State the major disadvantage of creating and using index.

Question No: 36 ( Marks: 3 )
Write any three factors which we consider while defining key in
designing an indexed sequential file?

Question No: 37 ( Marks: 3 )
How do you select all records from the table using SQL statements?
Write the syntax.

Question No: 38 ( Marks: 5 )
How can a VIEW be used for security measures?

Question No: 39 ( Marks: 5 )
In which situtation do you prefer DELETE command to delete a table
instead of using DROP command?

Question No: 40 ( Marks: 10 )
Write four advantages and four disadvantages of De-normalization.

Question No: 41 ( Marks: 10 )
Explain and differentiate the two types of application users:
• Intermediate
• Expert

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en