Vuhelper
07-10-2011, 07:21 PM
Full solve paper in attachment
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
► It enhances the performance of DB
► In de-normalization it is required to add redundant data.
Physical Record and Denormalization
Denormalization is a technique to move from higher to lower normal forms of
database modeling in order to speed up database access. Denormalization process is
applied for deriving a physical data model from a logical form. In logical data base
design we group things logically related through same primary key. In physical
database design fields are grouped, as they are stored physically and accessed by
DBMS. In general it may decompose one logical relation into separate physical
records, combine some or do both. There is a valid reason for denormalization that is
to enhance the performance.
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
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
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
Indexed Sequential Summary:
Following are salient features of Indexed sequential file structure:
Records are stored in sequence and index is maintained.
Dense and nondense types of indexes are maintained.
Track overflows and file overflow areas are ensured.
Cylinder index increases the efficiency .
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: 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
► It enhances the performance of DB
► In de-normalization it is required to add redundant data.
Physical Record and Denormalization
Denormalization is a technique to move from higher to lower normal forms of
database modeling in order to speed up database access. Denormalization process is
applied for deriving a physical data model from a logical form. In logical data base
design we group things logically related through same primary key. In physical
database design fields are grouped, as they are stored physically and accessed by
DBMS. In general it may decompose one logical relation into separate physical
records, combine some or do both. There is a valid reason for denormalization that is
to enhance the performance.
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
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
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
Indexed Sequential Summary:
Following are salient features of Indexed sequential file structure:
Records are stored in sequence and index is maintained.
Dense and nondense types of indexes are maintained.
Track overflows and file overflow areas are ensured.
Cylinder index increases the efficiency .
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