CS403 Final term Subjective July 2012

CS403 - Database Management Systems 

Finalterm Subjective Paper July 2012

• Write down the alternative name of browser base form? 2 marks
• Different classification of indexes? 2 Marks
• List down any two problems which may come up if the concurrency is not controlled properly? 2 marks
• In three schema architecture, External schema is responsible for data storage on hard disk. Correct and justify it. 3 marks
• Create view named “Product_list” on product table which will show all the columns? 3 marks
• Describe the importance of Data link properties tool in designing form by using MS Access? 3 marks
• In recovery procedure, transaction ended before the check points are redone. Correct it and justify? 3 marks
• Draw cross Reference matrix? 5 marks diagram was given.
• Deadlock is a serious threat for the concurrent transaction; shortly explain the approach which is used to detect the deadlock by DBMS? 5 marks
• Rehashing is better than chaining in term of time. (Rehashing and chaining collision resolution technique in hashing). Justify it ? 5 Marks

CS403 Final term Subjective Solved by MOAAZ

CS403 - Database Management Systems  Solved Subjective from Finalterm Papers

 Solved by Moaaz Siddiq  

Attachments:

CS403-FINALTERM-SOLVED-SUBJECTIVE-BY-MOAAZ

[ ]

346 Kb

CS403 Final term Subjective 2012

CS403 - Database Management Systems Finalterm Subjective Paper 2012

Marks 2
· Difference between Commit and Rollback.
· Commonality between RAID technology and Tape Drive.
· Read the statement if incorrect rewrite in correct form.
“Hashing provides slow, time consuming data retrieve from sequential files”.
· How do you explain Cross Reference Matrix?

Marks 3
· Explain Redundant Data. How Data Redundancy work in sequence file.
· State the basic difference between Inner join and Left Outer Join.
· Give one example of Deadlock.
· Create unique index on “IndexNum” on Cust_Name attribute of Customer table.

Marks 5
· Relate column 1 with column 2.
 Column 1                                 Column 2
1. Sigma                                   A. Procedural DML lang
2. Table                                    B. Project operator
3. Relational Algebra                 C. Select operator
4. ÏÏ                                          D. Relational Data Model
5. Intersection operator              E. Binary operation

Crater a VIEW INSTRUCTOR_LIST which shows the list of instructor table with
Inst_Nam and City of these instructors belong to ISLAMABAD or KARACHI.
INSTRUCTOR (Inst_ID, Imst_Name, City)
· If a table 1 and table 2 have same entity and the table 1 is 20 index and the table 2 14
index. Then the sequential file access use these operations (Insertion, updation or
selection) on both table. Keep in mind the above scenario and mark the below given
statements correct or incorrect.
I. Insertion in table 1 take greater time than table 2
II. Updation in table 2 take greater time then table 1
III. Retrieving a record from table 1 take lesser time than table 2.
· Analyze the below given statements and mark as correct and incorrect and also explain.
1. Deadlock occurs when one transaction wants to read more than on object at same
time.
2. The mechanism “Wait for Graph” is used to apply join on multiple.

CS403 Final term Solved Paper 2011 - 1

FINALTERM EXAMINATION

Spring 2010

CS403- Database Management Systems (Session - 1)

  

CS403 Question No: 1     

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

       ► User accessible catalog

       ► Data processing

       ► Authorization service

       ► Recovery service

  

CS403 Question No: 2     

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

  

CS403 Question No: 3     

Which of the following is true about TRUNCATE?

       ► Can be Rolled back.

       ► Activates Triggers.

       ► is DML Command.

       ► Resets identity of the table.

  

CS403 Question No: 4      

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

  

CS403 Question No: 5     

Which of the following is not true about relational tables?

       ► Column values are of the same kind.

       ► Each row is unique.

       ► Each column must have a unique name.

       ► The sequence of rows is significant.

 

CS403 Question No: 6     

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

  

CS403 Question No: 7     

Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?

       ► the number of columns in the first table multiplied by the number of columns in the second table.

       ► the number of columns in the first table multiplied by the number of rows in the second table.

       ► the number of rows in the first table multiplied by the number of columns in the first table.

       ► the number of rows in the first table multiplied by the number of rows in the second table.

  

CS403 Question No: 8     

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.

  

CS403 Question No: 9     

What is the maximum limit of keys in context with Indexed sequential files?

       ► 7

       ► 255

       ► 1

       ► 235

  

CS403 Question No: 10     

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.

 

CS403 Question No: 11     

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

  

CS403 Question No: 12     

Which of the given techniques is/are used to improve query performance in database?

       ► Good File organization

       ► Indexing

       ► Both Indexing and Good File organization

       ► Select only one record per query

  

CS403 Question No: 13    

While recovering data, which of the following files does a recovery manager examines at first?

       ► A system file

       ► Log file

       ► Data dictionary

       ► Metadata

CS403 Question No: 14     

_______ 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

  

CS403 Question No: 15     

_______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

  

CS403 Question No: 16     

Partitions may become unbalanced in:

       ► Range partitioning

       ► Hash partitioning

       ► List partitioning

       ► Vertical partitioning

  

CS403 Question No: 17     

Only one type of constraint can be enforced in any table by CREATE command

       ► True

       ► False

  

CS403 Question No: 18     

ALTER TABLE exams

ALTER COLUMN Q_description varchar(50)

Syntax of ALTER TABLE is NOT correct.

       ► True

     ► False

  

CS403 Question No: 19     

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

  

CS403 Question No: 20     

In which of the following, Materialized Views are suitable

       ► Data warehousing

       ► Decision support

       ► Mobile computing

       ► All of the Given

  

CS403 Question No: 21     

A software package designed to store and manage databases

       ► Database

       ► DBMS

       ► Data model

       ► Data

  

CS403 Question No: 22     

A superkey that does not contain a subset of attributes that is itself a superkey is called a ____.

       ► candidate key

       ► primary key

       ► superkey

       ► secondary key

  

CS403 Question No: 23     

A ____ relationship exists when an association is maintained within a single entity.

       ► unary

       ► ternary

       ► binary

       ► weak

CS403 Question No: 24     

 

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.

  

CS403 Question No: 25     

You can’t modify more than one table at a time through a view.

       ► True

       ► False

  

CS403 Question No: 26     

Which of the following is one of the purposes of using DML commands?

       ► Creating databases

       ► Destroying databases

     ► Inserting data in tables

       ► Non of the above

  

CS403 Question No: 27   ( M a r k s: 2 )

Name the two types of ordered Indices.

1. Dense Index
2. Sparse Index

  

CS403 Question No: 28   ( M a r k s: 2 )

State any two problems that can come up as a result of inconsistent database.

1. Uncommitted update
2. Inconsistent Analysis

  

CS403 Question No: 29   ( M a r k s: 2 )

Write the main purpose of NOT operator.

It used to negate any logical expression

Example:

Select * from students where Name is Null

Above command will bring all entries where name columns are having null value.

Select * from students where Name is NOT Null;

It will be reverse of our previous command and bring all those records which are not null in name colums.

It simply reverser any expression.

CS403 Question No: 30   ( M a r k s: 2 )

 

What is ‘Serial Execution’?

   It is type of exaction where transitions are run in a sequence.

If we have two transactions first it will complete all the steps of first transaction and then steps of 2^nd transaction will step.

A single transaction can consists of multiple steps. Those steps will run in a sequential order.

CS403 Question No: 31   ( M a r k s: 3 )

State the main purpose of index in relation with the queries executions.

1. Index help to better recovery and retrieval of record from the database..
2. By building index on any attribute will help the queries to improve query performance.
3. multiple indexes provide flexibility to retrieve the data from various attributes.

  

CS403 Question No: 32   ( M a r k s: 3 )

What is the prupose of IN operator?

1. It us used to check whether any value fall in given set of values or not.
2. work whichwe perform with the help of multiple or condisiton can be easy done via IN operator.

Example: select * from Emp where Dept in (10,20,30);

By the use of IN operator we can get all records for dept = 10 ,20 and 30

We can combine No in operator with In operator to reverse the expression

  

CS403 Question No: 33   ( M a r k s: 3 )

What effect can be occurred if a transaction lacks durability?

Data can be inconsistence state, suppose if crash happened and in recovery rollback or commit is not possible in absence of durability.

  

CS403 Question No: 34   ( M a r k s: 5 )

Write the basic syntax of creating an INDEX.

CREATE INDEX indexname ON TableName (Last_Name);

  

CS403 Question No: 35   ( M a r k s: 5 )

What is the purpose of creating VIEWS in DBMS?

1. 1.views can be used as security mechanism.
2. 2.Present the data to user of their interest
3. 3.Stop the access to unnecessary access to data to irrelevant person
4. 4.simplify presentation complex extracted data for example data extracted from the multiple tables to the user.
5. 5.updated automatically when any change occur to underlying tables
6.  

CS403 Question No: 36   ( M a r k s: 5 )

Write an SQL statement which displays a list of persons from the table named PERSON. The complete information of only those person should be displayed whose first name is ALI and the last name is AHMED;

SELECT * FROM Person where FirstName = ‘ALI’ and Lastname = ‘AHMED’;

CS403 Final term Paper 2010

FINAL TERM EXAMINATION 

Spring 2010
CS403- Database Management Systems (Session - 2)

Time: 90 min
M a r k s: 58

Question No: 1 ( M a r k s: 1 ) http://vuzs.net
Which feature of database provides conversion from inconsistent state of DB to
a consistent state ensuring minimum data loss?

► User accessible catalog

► Data processing

► Authorization service

► Recovery service


Question No: 2 ( M a r k s: 1 ) http://vuzs.net
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: 3 ( M a r k s: 1 ) http://vuzs.net
Which of the following is true about TRUNCATE?
► Can be Rolled back.

► Activates Triggers.

► is DML Command.

► Resets identity of the table.


Question No: 4 ( M a r k s: 1 ) http://vuzs.net
Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?
► the number of columns in the first table multiplied by the number of columns in the second table.

► the number of columns in the first table multiplied by the number of rows in the second table.

► the number of rows in the first table multiplied by the number of columns in the first table.

► the number of rows in the first table multiplied by the number of rows in the second table.


Question No: 5 ( M a r k s: 1 ) http://vuzs.net
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: 6 ( M a r k s: 1 ) http://vuzs.net
Which of the following is not one of the properties of Transaction?
► atomicity
► consistency
► redundancy
► durability

Question No: 7 ( M a r k s: 1 ) http://vuzs.net
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: 8 ( M a r k s: 1 ) http://vuzs.net
Each course section is assigned a particular faculty member, and each course section corresponds to a particular course. Conceptually, what is the relationship between faculty and course (not course section).
► 1:1
► 1:M
► M:M
► Ternary

Question No: 9 ( M a r k s: 1 ) http://vuzs.net
Which of the following is used to add or drop columns in an existing table?

► ALTER
► HAVING
► SELECT
► THEN

Question No: 10 ( M a r k s: 1 ) http://vuzs.net
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
► SELECT FROM * Persons

► SELECT * FROM Persons

► SELECT * WHERE Persons

► SELECT WHERE * Persons


Question No: 11 ( M a r k s: 1 ) http://vuzs.net
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: 12 ( M a r k s: 1 ) http://vuzs.net
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.



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 ( M a r k s: 1 ) http://vuzs.net
Which of the following serves as a milestone or reference point in the log file?

► Constraints

► Relations

► Check points

► Transactions identities

Question No: 14 ( M a r k s: 1 ) http://vuzs.net
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: 15 ( M a r k s: 1 ) http://vuzs.net
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: 16 ( M a r k s: 1 ) http://vuzs.net
Browser based forms are developed in the following tools EXCEPT

► HTML

► Scripting language

► Front Page

► Web-based Forms


Question No: 17 ( M a r k s: 1 ) http://vuzs.net
Which of the following is not a form of optical disk?

► CD ROM

► WORM

► Erasable Optical

► EEPROM


Question No: 18 ( M a r k s: 1 ) http://vuzs.net
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: 19 ( M a r k s: 1 ) http://vuzs.net
In which of the following situations, Clustering is suitable:
► Frequently updating
► Relatively static
► Relatively deletion
► Relatively dynamic

Question No: 20 ( M a r k s: 1 ) http://vuzs.net
Only one type of constraint can be enforced in any table by CREATE command
► True
► False

Question No: 21 ( M a r k s: 1 ) http://vuzs.net
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: 22 ( M a r k s: 1 ) http://vuzs.net
Consider the following relation R and its sample data. (Consider that these are the only tuples for the given relation)


Which of the following statements is NOT correct?

► The functional dependency ProjNo -> DeptNo holds over R.
► The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.
► The functional dependency DeptNo -> ProjNo holds over R.
► The functional dependency EmpNo -> DeptNo holds over R.

Question No: 23 ( M a r k s: 1 ) http://vuzs.net
An entity type is

► defined when the database is actually constructed
► a specific type such as an integer, text, date, logical etc
► a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
► defined by the database designer

Question No: 24 ( M a r k s: 1 ) http://vuzs.net
An entity can be logically connected to another by defining a ____.
► hyperlink
► common attribute
► primary key
► superkey

Question No: 25 ( M a r k s: 1 ) http://vuzs.net
You can’t modify more than one table at a time through a view.
► True
► False

Question No: 26 ( M a r k s: 1 ) http://vuzs.net
Which of the following is one of the purposes of using DML commands?

► Creating databases
► Destroying databases
► Inserting data in tables
► Non of the above

Question No: 27 ( M a r k s: 2 )
Write any two similarities between materialized views and indexes?

Question No: 28 ( M a r k s: 2 )
Define domain of an attribute.

Question No: 29 ( M a r k s: 2 )
Write the main feature of volatile storage media?

Question No: 30 ( M a r k s: 2 )
Suppose you want to delete a table row by row and record an entry in the transaction log for each deleted row. Which DML command will you use?

Question No: 31 ( M a r k s: 3 )
Write three benefits of using VIEWS.

Question No: 32 ( M a r k s: 3 )
SELECT * FROM Persons
WHERE FirstName LIKE '%da%';

what does the above statement return?

Question No: 33 ( M a r k s: 3 )
What is the difference between a primary key and a unique key with reference to clustered and nonclustered indexes?


Question No: 34 ( M a r k s: 5 )
Consider a table named COMPANY with fields COMPANY_NAME,
DESCRIPTION, ORDER_NUMBER. Write an SQL statement to display company names in reverse alphabetical order.

Question No: 35 ( M a r k s: 5 )
Name the five main components of Database management systems software.

Question No: 36 ( M a r k s: 5 )
Give 4 similarities between Materialized views and indexes.

CS403 Final term Subjective Paper

I have given CS-403 DBMS paper. Most of the MCQ's are from past papers. Some subjective questions which i remeber are:

• 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?

CS403 Final term Solved Paper 2010 - 3

FINALTERM  EXAMINATION

Spring 2010

CS403- Database Management Systems

Time: 90 min

M a r k s: 58

Question No: 1      ( M a r k s: 1 ) http://vuzs.net

     Which one of the following E-R diagrams most correctly represents the relationship between Student and Grade entities?

Question No: 2      ( M a r k s: 1 ) http://vuzs.net

Which of the following statements are Data Definition Language command?

       ► INSERT

       ► UPDATE

       ► GRANT

       ► TRUNCATE

Question No: 3      ( M a r k s: 1 ) http://vuzs.net

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: 4      ( M a r k s: 1 ) http://vuzs.net

How many clustered index(es) do each database table have?

       ► 2

       ► 3

       ► 5

       ► 1

Question No: 5      ( M a r k s: 1 ) http://vuzs.net

Suppose there are 4 rows and 3 columns in TABLE1 and 6 rows and 5 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?

       ► 24

       ► 20

       ► 18

       ► 15

Question No: 6      ( M a r k s: 1 ) http://vuzs.net

Which of the following is not one of the properties of Transaction?

       ► atomicity

       ► consistency

       ► redundancy

       ► durability

Question No: 7      ( M a r k s: 1 ) http://vuzs.net

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: 8      ( M a r k s: 1 ) http://vuzs.net

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: 9      ( M a r k s: 1 ) http://vuzs.net

Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo)

and the following functional dependencies.

FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo

FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo

FD3 : StaffNo, InterviewDate -> RoomNo

Which of the following is correct?

       ► The relation Interview is in 3NF

       ► The relation Interview is in BCNF.

       ► The FD3 violates 3NF.

       ► The FD2 violates 2NF.

Question No: 10      ( M a r k s: 1 ) http://vuzs.net

Which of the following types of partitioning reduces the chances of unbalanced partitions?

       ► vertical

       ► List

       ► Hash

       ► Range

Hash Partitioning:

It is a type of horizontal partitioning. In this type particular algorithm is applied and

DBMS knows that algorithm. So hash partitioning reduces the chances of unbalanced

partitions to a large extent Question No: 11      ( M a r k s: 1 ) http://vuzs.net

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: 12      ( M a r k s: 1 ) http://vuzs.net

Which of the following statements creates a database named COMPANY.

       ► CREATE DATABASE company

       ► CREATE DB company

       ► ADD DATABASE copmany

       ► CREATE company DATABASE

Question No: 13      ( M a r k s: 1 ) http://vuzs.net

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

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 can be set up to increase

efficiency

Question No: 14      ( M a r k s: 1 ) http://vuzs.net

Consider a transaction which includes following operations

…

Z= Z + 10

Write Z

...

Suppose that the value of Z after addition and the execution of this operation is 17. Now against the write operation the entry made in the log file will be

What does Z reflects in the above entry?

       ► Object being updated

       ► Identity of the transaction

       ► Object value

       ► Identity of the next transaction to be executed

In the entry, Tn reflects the identity of the transaction, Z is the object being updated

and 33 is the value that has to be placed in Z.

Question No: 15      ( M a r k s: 1 ) http://vuzs.net

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

The transaction-processing system ensures that either all operations in a transaction are completed without error, or none of them are. If some of the operations are completed but errors occur when the others are attempted, the transaction-processing system “rolls back” all of the operations of the transaction (including the successful ones), thereby erasing all traces of the transaction and restoring the system to the consistent, known state that it was in before processing of the transaction began. If all operations of a transaction are completed successfully, the transaction is committed by the system, and all changes to the database are made permanent; the transaction cannot be rolled back once this is done

Question No: 16      ( M a r k s: 1 ) http://vuzs.net

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: 17      ( M a r k s: 1 ) http://vuzs.net

Which of the following is an example of volatile memory?

       ► RAM

       ► ROM

       ► Flash memory

       ► CPU

Question No: 18      ( M a r k s: 1 ) http://vuzs.net

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: 19      ( M a r k s: 1 ) http://vuzs.net

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: 20      ( M a r k s: 1 ) http://vuzs.net

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 (page29 vuzs)

       ► Overhead of multiple linked lists

Question No: 21      ( M a r k s: 1 ) http://vuzs.net

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

Unlike indexes, materialized views can be accessed directly using a SELECT statement.

Question No: 22      ( M a r k s: 1 ) http://vuzs.net

Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order

By

CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where

REGION = 'E' Order By CUSTOMER

The above statement:

       ► Has an error - the string should be in double quotes.

       ► Has an error - ORDER BY clause.

       ► Does not have an error.

       ► Has an error - the string in single quotes 'NORTH' and 'SOUTH'.

Question No: 23      ( M a r k s: 1 ) http://vuzs.net

A software package designed to store and manage databases

       ► Database

       ► DBMS

       ► Data model

       ► Data

A Database Management System (DBMS) is a software package designed to store and manage databases. Database Management Systems

Question No: 24      ( M a r k s: 1 ) http://vuzs.net

Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?

       ► Database Designers

       ► Database Administrators

       ► End Users

       ► Application Programmers

Question No: 25      ( M a r k s: 1 ) http://vuzs.net

A superkey that does not contain a subset of attributes that is itself a superkey is called a ____.

       ► candidate key

       ► primary key

       ► superkey

       ► secondary key

Question No: 26      ( M a r k s: 1 ) http://vuzs.net

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

       ► strong

       ► weak

       ► business

       ► relationship

A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship

Question No: 27      ( M a r k s: 2 )

What is the “data type”?

A data type (or datatype) In programming, a classification identifying one of various types of data, as floating-point, integer, or Boolean, stating the possible values for that type, the operations that can be done on that type, and the way the values of that type are stored.

Question No: 28      ( M a r k s: 2 )

Which DML statement changes the values of one or more columns based on some conditions.

Update command

Question No: 29      ( M a r k s: 2 )

Name the two types of caching that are commonly used  in personal computers?

Two types of caching are commonly used in personal computers: memory

caching and disk caching

Question No: 30      ( M a r k s: 2 )

What is ‘Serial Execution’?

Serial execution is an execution where transactions are executed in a sequential order,

that is, one after another. A transaction may consist of many operations. Serial

execution means that all the operations of one transaction are executer first, followed

by all the operations of the next transaction and like that.

Question No: 31      ( M a r k s: 3 )

Write three benefits of using VIEWS.

1. They work as table and, provide security from unauthorized access.
2. updated automatically when some changes occurs in original table
3. views  give a group of user’s access to just the information they are allowed to

Question No: 32      ( M a r k s: 3 )

Shortly explain BYTE data field?

Some of more frequently supported numeric data types include Byte, Integer, and Long Integer. Each of these types supports different range of numeric values and takes 1, 4 or 8 bytes to store. Now, if we declare the age attribute as Long Integer, it will definitely serve the purpose, but we will be allocating unnecessarily large space for each attribute. A Byte type would have been sufficient for this purpose since you won’t find students or employees of

age more than 255, the upper limit supported by Byte data type.

Question No: 33      ( M a r k s: 3 )

State the main purpose of index in relation with the queries executions.

It will help searching the required data by directly accessing it  via index.

Question No: 34      ( M a r k s: 5 )

Differentiate between the cluster index and non cluster index ?

1 A cluster index is a form of tables which consist of column and rows.

2 Cluster index exists on the physical level

3 It sorts the data at physical level

4 It works for the complete table

5 There is a whole table in form of sorted data

6 A table can contain only one cluster index

Non Cluster Index 

1 A non cluster index is in the form of a report about the tables.

2 They are not created on the physical level but at the logical level

3 It does not sort the data at physical level

4 A table has 255 non clustered indexes

5 A table has many non clustered indexes.

6 It work on the order of data

Question No: 35      ( M a r k s: 5 )

Consider the two relations,

Department (Dept_Code, Dep_Name,Dept_Head) and

Employee(Emp_ID,Emp_Name, Designation, DoB, Dept).

Write SQL statement to drop the primary key of Department relation? The fields in

Employee should reflect the removal in Department table.

Answer:

If you wanted to drop any Primary key column you first have to drop the primary key constraints and then you can drop the primary key column. (vuzs)

ALTER TABLE  Department DROP CONSTRAINT Pkzxyx;

ALTER TABLE Department DROP COLUMN Dept_code;

Question No: 36      ( M a r k s: 5 )

  Briefly explain rollback and rollforward.