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'
Question No: 8 ( Marks: 1 ) - Please choose one
Which of the following types of partitioning reduces the chances of unbalanced
partitions?
► Hash
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: 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
Laser records data by burning microscopic holes in the surface of the disk with a
► Hard disk
► RAM
► Optical disk
► Floppy disk
Optical disks record data by burning microscopic holes in the surface of the disk with a laser. To read the disk, another laser beam shines on the disk and detects the holes by changes in the reflection pattern.
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
No comments:
Post a Comment