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.@@@@
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 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.
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
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.
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
Question No: 31 ( Marks: 1 )
What is procedural DML?
Question No: 32 ( Marks: 1 )
What does RAM stand for?
Question No: 33 ( Marks: 2 )
Which DML statement changes the values of one or more columns based on some conditions.
Question No: 34 ( Marks: 2 )
Name the two primary modes for taking Locks.
Question No: 35 ( Marks: 3 )
Give three reasons of partitioning in the process of denormalization.
Question No: 36 ( Marks: 3 )
Write any three factors which we consider while defining key in designing an indexed sequential file?
Question No: 1 ( Marks: 1 ) - Please choose one
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 ( 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: 3 ( 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: 4 ( Marks: 1 ) - Please choose one
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 ( 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: 6 ( Marks: 1 ) - Please choose one
Which of the following is not one of the properties of Transaction?
► atomicity
► consistency
► redundancy
► durability
Question No: 7 ( 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: 8 ( Marks: 1 ) - Please choose one
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 ( Marks: 1 ) - Please choose one
Which of the following is used to add or drop columns in an existing table?
► ALTER
► HAVING
► SELECT
► THEN
Question No: 10 ( Marks: 1 ) - Please choose one
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 ( 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: 12 ( 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.
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
Which of the following serves as a milestone or reference point in the log file?
► Constraints
► Relations
► Check points
► Transactions identities
Question No: 14 ( 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: 15 ( 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: 16 ( 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: 17 ( Marks: 1 ) - Please choose one
Which of the following is not a form of optical disk?
► CD ROM
► WORM
► Erasable Optical
► EEPROM
Question No: 18 ( 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: 19 ( Marks: 1 ) - Please choose one
In which of the following situations, Clustering is suitable:
► Frequently updating
► Relatively static
► Relatively deletion
► Relatively dynamic
Question No: 20 ( Marks: 1 ) - Please choose one
Only one type of constraint can be enforced in any table by CREATE command
► True
► False
Question No: 21 ( 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: 22 ( Marks: 1 ) - Please choose one
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 ( Marks: 1 ) - Please choose one
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 ( Marks: 1 ) - Please choose one
An entity can be logically connected to another by defining a ____.
► hyperlink
► common attribute
► primary key
► superkey
Question No: 25 ( Marks: 1 ) - Please choose one
You can't modify more than one table at a time through a view.
► True
► False
Question No: 26 ( Marks: 1 ) - Please choose one
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
FINAL TERM EXAMINATION SPRING 2010
CS403- DATABASE MANAGEMENT SYSTEMS (10 Aug 2010)
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.@@@@@@@@
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 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.
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
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.
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
FINALTERM EXAMINATION
Fall 2008
CS403- Database Management Systems (Session - 3)
Ref No: 318064
Time: 120 min
Marks: 75
| Student Info | |
| StudentID: | |
| Center: | |
| ExamDate: | 2/2/2009 12:00:00 AM |
| For Teacher's Use Only | |||||||||
| Q No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total |
| Marks | | | | | | | | | |
| Q No. | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | |
| Marks | | | | | | | | | |
| Q No. | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | |
| Marks | | | | | | | | | |
| Q No. | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | |
| Marks | | | | | | | | | |
| Q No. | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | |
| Marks | | | | | | | | | |
| Q No. | 41 | | | | | | | | |
| Marks | | | | | | | | | |
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
FINALTERM EXAMINATION
Fall 2009
CS403- Database Management Systems (Session - 4)
Ref No: 1134506
Time: 120 min
Marks: 75
| For Teacher's Use Only | |||||||||
| Q No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total |
| Marks | | | | | | | | | |
| Q No. | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | |
| Marks | | | | | | | | | |
| Q No. | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | |
| Marks | | | | | | | | | |
| Q No. | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | |
| Marks | | | | | | | | | |
| Q No. | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | |
| Marks | | | | | | | | | |
| Q No. | 41 | | | | | | | | |
| Marks | | | | | | | | | |
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
► 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.
FINALTERM EXAMINATION
Spring 2010
CS403- Database Management Systems
Time: 90 min
Marks: 58
| Student Info | ||
| Student ID: | |
|
| Center: | |
|
| Exam Date: | |
|
| For Teacher's Use Only | |||||||||
| Q No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total |
| Marks | | | | | | | | | |
| Q No. | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | |
| Marks | | | | | | | | | |
| Q No. | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | |
| Marks | | | | | | | | | |
| Q No. | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | |
| Marks | | | | | | | | | |
| Q No. | 33 | 34 | 35 | 36 | | | | | |
| Marks | | | | | | | | | |
Question No: 1 ( Marks: 1 ) - Please choose one
Which one of the following E-R diagrams most correctly represents the relationship between Student and Grade entities?
►
►
►
►
Answer is a
Question No: 2 ( Marks: 1 ) - Please choose one
Which of the following statements are Data Definition Language command?
► INSERT
► UPDATE
► GRANT
► TRUNCATE
Question No: 3 ( 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: 4 ( Marks: 1 ) - Please choose one
How many clustered index(es) do each database table have?
► 2
► 3
► 5
► 1
Question No: 5 ( Marks: 1 ) - Please choose one
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 ( Marks: 1 ) - Please choose one
Which of the following is not one of the properties of Transaction?
► atomicity
► consistency
► redundancy
► durability
Question No: 7 ( 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: 8 ( 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: 9 ( Marks: 1 ) - Please choose one
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 ( Marks: 1 ) - Please choose one
Which of the following types of partitioning reduces the chances of unbalanced partitions?
► vertical
► List
► Hash
► Range
Question No: 11 ( 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: 12 ( Marks: 1 ) - Please choose one
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 ( 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: 14 ( Marks: 1 ) - Please choose one
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
<Tn, Z, 33>
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
Question No: 15 ( 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: 16 ( 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: 17 ( Marks: 1 ) - Please choose one
Which of the following is an example of volatile memory?
► RAM
► ROM
► Flash memory
► CPU
Question No: 18 ( 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: 19 ( 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: 20 ( 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: 21 ( 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: 22 ( Marks: 1 ) - Please choose one
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 ( Marks: 1 ) - Please choose one
A software package designed to store and manage databases
► Database
► DBMS
► Data model
► Data
Question No: 24 ( Marks: 1 ) - Please choose one
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 ( Marks: 1 ) - Please choose one
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 ( Marks: 1 ) - Please choose one
A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
► strong
► weak
► business
► relationship
Which of the following SQL statements used to control access to the data and
to the database?
Select correct option:
GRANT
REVOKE
Both GRANT and REVOKE
SELECT
Value of Function is SQL is always determined by the input parameters.
True
False
Objective of an order by clause is to display or arrange to output of a select in a particular order?
True
False
Subjective Portion
Question No: 27 ( Marks: 2 )
Write any two similarities between materialized views and indexes?
Question No: 28 ( Marks: 2 )
Define domain of an attribute.
Ans:
Domain is the set of possible values that an attribute can have, that is, we specify a set of values either in the form of a range or some discrete values, and then attribute can have value out of those values. Domain is a form of a check or a constraint on attribute that it cannot have a value outside this set.
Question No: 29 ( Marks: 2 )
Write the main feature of volatile storage media?
Computer storage that is lost when the power is turned off is called as volatile storage. For example RAM
Question No: 30 ( Marks: 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?
DELETE * FROM student WHERE name="Abrar";
Question No: 31 ( Marks: 3 )
Write three benefits of using VIEWS.
Views are generally used to focus, simplify, and customize the perception
each user has of the database. Views can be used as security mechanisms
by allowing users to access data through the view, without granting the users
permissions to directly access the underlying base tables of the view.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. This also increases the security of the data because users
Question No: 32 ( Marks: 3 )
SELECT * FROM Persons
WHERE FirstName LIKE '%da%';
what does the above statement return?
Ans:
Question No: 33 ( Marks: 3 )
What is the difference between a primary key and a unique key with reference to clustered and nonclustered indexes?
Question No: 34 ( Marks: 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.
SELECT COMPANY_NAME FROM COMPANY ORDER BY COMPANY_NAME DESC;
Question No: 35 ( Marks: 5 )
Name the five main components of Database management systems software.
Question No: 36 ( Marks: 5 )
Give 4 similarities between Materialized views and indexes.
I. They consume storage space.
II. They must be refreshed when the data in their master tables changes.
III. They improve the performance of SQL execution when they are used for
IV. query rewrites.
V. Their existence is transparent to SQL applications and users.
No comments:
Post a Comment