Q#1: Hash partitioning is applied on
(A) Columns
(B) Constraints
(C) Attributes
(D) None of these
Answer: (A) Columns

Q#2: At which stage of database development process are the schema rules defined and identified?
(A) Analyzing user requirements
(B) Development of the conceptual design
(C) Development of the physical design
(D) Testing phase
Answer: (B) Development of the conceptual design

Q#3: Which of the following is INCORRECT about “Materialized Views”?
(A) They are suitable in data warehouses
(B) These are schema objects which can be used to summarize data
(C) They cannot be partitioned
(D) Their existence is transparent to SQL applications and users
Answer: (C) They cannot be partitioned

Q#4: Identify the incorrect statement among the given options
(A) An entity may be an object with physical existence like a car
(B) Age can be considered as a single-valued attribute of a person
(C) The attribute Date_of_birth can be considered as a derived attribute
(D) Skill is a multivalued attribute
Answer: (D) Skill is a multivalued attribute

Q#5: ________ is used to manage the database and its users
(A) DBMS
(B) File processing system
(C) DFD
(D) Cross reference matrix
Answer: (A) DBMS

Q#6: A student has five courses at max registered in a semester and there are many students in a course. The cardinality between student and course entities is
(A) One to One
(B) One to Many
(C) Many to One
(D) Many to Many
Answer: (D) Many to Many

Q#7: Attributes on which we do not need to access the unique instances of an entity type are called
(A) Primary key
(B) Alternate key
(C) Foreign key
(D) Secondary key
Answer: (B) Alternate key

Q#8: In which of the following situations is clustering suitable?
(A) Frequently updating
(B) Relatively static
(C) Frequently deleting
(D) Relatively dynamic
Answer: (B) Relatively static

Q#9: Which is NOT a feature of hash access?
(A) Indexes to search or maintain
(B) Very fast direct access
(C) Inefficient sequential access
(D) Use when direct access is needed but sequential access is not
Answer: (D) Use when direct access is needed but sequential access is not

Q#10: Minimal super key can also be named as
(A) Candidate key
(B) Alternate key
(C) Foreign key
(D) Secondary key
Answer: (A) Candidate key

Q#11: Which of the following commands shows data from PRODUCT-VIEW?
(A) SELECT * FROM PRODUCT-VIEW
(B) SELECT PRODUCT-VIEW
(C) SHOW ALL PRODUCT-VIEW
(D) PRODUCT-VIEW SELECT
Answer: (A) SELECT * FROM PRODUCT-VIEW

Q#12: If W, X, Y, and Z are attributes of a relation, which of the following inference rules for functional dependencies is correct?
(A) If (X,Z) -> Y then X -> Y and Z -> Y
(B) If X -> Y and X -> Z then X -> Y,Z
(C) Both A and B
(D) None of the above
Answer: (B) If X -> Y and X -> Z then X -> Y,Z

Q#13: While recovering data, which file does a recovery manager examine first?
(A) A system file
(B) Log file
(C) Data dictionary
(D) Metadata
Answer: (B) Log file

Q#14: The purpose of ________ is to maintain the consistency of a database during concurrent access
(A) Outer join
(B) Inner join
(C) Clustered index
(D) Locking mechanism
Answer: (D) Locking mechanism

Q#15: Which of the following is the correct syntax for SELECT statement?
(A) SELECT column-name(s) FROM table-name
(B) SELECT FROM table-name column-name
(C) FROM SELECT column-name table-name
(D) FROM table-name SELECT column-name
Answer: (A) SELECT column-name(s) FROM table-name

Q#16: Must identify a record in the table uniquely
(A) Hash Algorithm
(B) Key
(C) SQL Statement
(D) Index
Answer: (B) Key

Q#17: Which of the following is an example of volatile memory?
(A) RAM
(B) ROM
(C) Flash memory
(D) CPU cache
Answer: (A) RAM

Q#18: A perfect hash function maps a key to a distinct location having search time
(A) O(n)
(B) O(n+1)
(C) O(n-1)
(D) O(1)
Answer: (D) O(1)

Q#19: A super key for which no subset is a super key is called
(A) Primary key
(B) Super key
(C) Secondary key
(D) Candidate key
Answer: (A) Primary key

Q#20: Which of the following specifies the tables which we access in the query?
(A) SELECT clause
(B) FROM clause
(C) WHERE clause
(D) ORDER BY clause
Answer: (B) FROM clause

Q#21: Which of the following statements is NOT true?
(A) Any super-type linked entity is inherited by subtype entities
(B) Relationship between subtypes defines the existence of a supertype in a subtype entity
(C) Disjointness constraint defines the existence of a super entity
(D) We never identify sub-type/subtype on the basis of general knowledge
Answer: (C) Disjointness constraint defines the existence of a super entity

Q#22: Which command gives all the fields from employee table named EMP?
(A) SELECT * FROM EMP
(B) SELECT EMP
(C) SHOW EMP FIELDS
(D) SELECT ALL EMP
Answer: (A) SELECT * FROM EMP

Q#23: To read a database object, it is first brought into ________ from disk, and then its values are copied into a program variable
(A) Main memory
(B) Flash memory
(C) Hard disk
(D) Solid-state drive
Answer: (A) Main memory

Q#24: CLUSTERED indexes are created automatically when we create
(A) ERD
(B) Database
(C) Cross Reference Matrix
(D) Primary key
Answer: (D) Primary key

Q#25: Wait-for graph is maintained by
(A) Lock manager
(B) Index manager
(C) View manager
(D) Constraint manager
Answer: (A) Lock manager

Q#26: Which of the following is NOT a feature of a good interface?
(A) Consistency
(B) Process based
(C) Data structure based
(D) User friendly
Answer: (C) Data structure based

Q#27: Which SQL keyword is not used with DDL statements?
(A) TABLE
(B) UPDATE
(C) CREATE
(D) ALTER
Answer: (B) UPDATE

Q#28: Which of the following is not a type of VIEWS?
(A) Materialized View
(B) Simple View
(C) Complex View
(D) Indexed View
Answer: (D) Indexed View

Q#29: Which of the following is incorrect about Database transaction?
(A) It can only end in one way which is rollback
(B) It must preserve the consistency of the database
(C) It must follow the ACID properties
(D) None of the above
Answer: (A) It can only end in one way which is rollback

Q#30: Which command is used to TRUNCATE the table named STUDENT?
(A) TRUNCATE TABLE STUDENT
(B) TABLE TRUNCATE STUDENT
(C) TABLE STUDENT TRUNCATE
(D) STUDENT TABLE TRUNCATE
Answer: (A) TRUNCATE TABLE STUDENT