(A) Balance workload
(B) Reduce workload
(C) Merging different relations
(D) Speed up rate of useful works
Tag: DBMS Mcqs
__ is a control that enables users to select one option from an associated list; users can also type an option.
(A) Combo Box
(B) Button
(C) Text Box
(D) Static Area
While recovering data, which of the following files does a recovery manager examines at first?
(A) A system file
(B) Log file
(C) Data dictionary
(D) Metadata
Which of the following is not true regarding Indexes?
(A) Index can be defined even when there is no data in the table
(B) It can be created using ‘Create Index’ statement
(C) It support Range selections
(D) It can not be created on composite attributes
What is the impact of setting multiple indexes for the same key, in index sequential files?
(A) Multiple indexes for the same key can not be set
(B) It will increase complexity as the access time will be increased
(C) It increases efficiency
(D) It decreases efficiency
Which of the following is correct regarding Dataflow diagram?
(A) Single DFD is required to represent a system
(B) Created at increasing levels of detail
(C) The dataflow must be bidirectional
(D) Used to represent the relationships among the external entities
DML commands are used for:
(A) Inserting data into databases
(B) Creating databases
(C) Destroying databases
(D) Creating DB objects
Which of the following types of partitioning reduces the chances of unbalanced partitions?
(A) Hash
(B) Vertical
(C) List
(D) Range