-
1)
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
-
2)
Which of the following is NOT a feature of Indexed sequential files?
- A) Records are stored in sequence and index is maintained.
- B) Dense and nondense types of indexes are maintained.
- C) Track overflows and file overflow areas can not be ensured.
- D) Cylinder index increases the efficiency
-
3)
ALTER TABLE exams
RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.
Syntax of ALTER TABLE is NOT correct.
- A) True
- B) False
-
4)
Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.
- A) DELETE FROM person WHERE employee_id = ‘12345’
- B) DELETE WHERE person FROM employee_id = 12345
- C) DROP FROM person WHERE employee_id = 12345
- D) DELETE WHERE person WHERE employee_id = 12345
-
5)
Which of the following is NOT a component of a DFD? Select correct option:
- A) Dataflow
- B) Datastore
- C) External entities
- D) Relationship between external entities
-
6)
Laser records data by burning microscopic holes in the surface of the disk with a
- A) Hard disk
- B) RAM
- C) Optical disk
- D) Floppy disk
-
7)
Which of the following concepts is applicable with respect to 3NF?
- A) Full functional dependency
- B) Any kind of dependency
- C) Transitive dependency
- D) Partial functional dependency
-
8)
Which of the following is NOT a feature of a good interface?
- A) Consistency
- B) Process based
- C) Data structure based
- D) User friendly
-
9)
Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
- A) Physical data independence.
- B) Concurrency control
- C) Logical data independence.
- D) Functional dependency
-
10)
GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION;
What does this SQL statement do?
- A) Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table.
- B) Grant permission to Hiruni in order to grant, select and update permission to Amali.
- C) Grant permission to Amali & Hiruni to update designation of employees in the Employee table
- D) Grant permission to Amali and Hiruni to update all data except designation in Employee table
