1000+ DBMS Multiple Choice Question Answer [Solved]

1. _____is a full form of SQL.
A. Standard query language
B. Sequential query language
C. Structured query language
D. Server side query language
Answer : C

2. In an ER model,_____ is described in the database by storing its data.
A. Entity
B. Attribute
C. Relationship
D. Notation
Answer : A

3. The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
A. Clustered
B. Hashed
C. Un-clustered
D. Collision
Answer : C

4. What are the desirable properties of a decomposition
A. Partition constraint.
B. Dependency preservation.
C. Redundancy.
D. Security.
Answer : B

5. Which of the following is not comparison operator?
A. <>
B. <
C. =<
D. >=
Answer : C

6. Which of the following is true for network structure?
A. It is a physical representation of the data.
B. It allows many to many relationship.
C. It is conceptually simple.
D. It will be the dominant database of the future.
Answer : A

7. _____clause is an additional filter that is applied to the result.
A. Select
B. Order by
C. Group-by
D. Having
Answer : D

8. Which of the following addressing modes permits relocation without any change over in the code?
A. Indirect addressing
B. Indexed addressing
C. PC relative addressing
D. Base register addressing
Answer : B

9. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.
A. 1:1
B. 1: Many
C. Many: One
D. Many : Many
Answer : A

10. The metadata is created by the
A. DML compiler
B. DML pre-processor
C. DDL interpreter
D. Query interpreter
Answer : C

11. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
A. left outer join
B. right outer join
C. full outer join
D. inner join
Answer : D

12. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
A. 4,0
B. 0,0
C. 4,5
D. 8,5
Answer : A

13. Protection of data from unauthorized Disclosure results in loss of _______
A. Integrity
B. Availability
C. Confidentiality
D. Discretionary Security
Answer : C

14. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
A. Union
B. Intersection
C. Difference
D. Join
Answer : D

15. Which of the following aggregate functions does not ignore nulls in its results?.
A. COUNT .
B. COUNT (*)
C. MAX
D. MIN
Answer : B

16. ______contains information that defines valid values that are stored in a column or data type.
A. Default
B. Index
C. Rule
D. View
Answer : B

17. According to the levels of abstraction, the schema at the intermediate level is called
A. Logical schema.
B. Physical schema.
C. Subschema.
D. None of the above.
Answer : D

18. ______is a preferred method for enforcing data integrity
A. Constraints
B. Triggers
C. Stored procedure
D. Cursors
Answer : A

19. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
A. Operationally, if Y is deleted, so is X
B. existence is dependent on Y.
C. Operationally, if X is deleted, so is Y.
D. Operationally, if X is deleted, & remains the same.
Answer : C

20. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.
A. Direct
B. Indirect
C. Existence
D. No
Answer : C

21. A transaction is in state after the final statement has been executed.
A. partially committed
B. active
C. committed
D. none of the above
Answer : C

22. The _____ category includes storage media that can be operated on directly by the computers central processing unit.
A. Primary storage
B. Secondary Storage
C. All
D. Tertiary Storage
Answer : A

23. A table can have only one
A.B. Alternate key
C. Unique key
D. Primary key
Answer : D

24. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.
A. UPDATE S CITY = KANPUR WHERE SNO=S1
B. UPDATE S SET CITY = KANPUR FOR SNO=S1
C. UPDATE S SET CITY = KANPUR WHERE SNO=S1
D. UPDATE S RENAME CITY = KANPUR WHERE SNO=S1
Answer : C

25. ………………… approach reduces time and effort required for design and lesser risk in database management.
A. Single global database
B. Multiple databases
C. Top-down approach
D. None of the above
Answer : B

26. Which of the following is not a consequence of non-normalized database?
A. Update Anomaly
B. Insertion Anomaly
C. Redundancy
D. Lost update problem
Answer : D

27. The collection of information stored in a database at a particular moment is called as ......
A. schema
B. instance of the database
C. data domain
D. independence
Answer : B

28. Which one is true statement :
A. With finer degree of granularity of locking a high degree of concurrency is possible.
B. Locking prevents non-serializable schedules.
C. Locking cannot take place at field level.
D. An exclusive lock on data item X is granted even if a shared lock is already held on X.
Answer : A

29. Drop Table cannot be used to drop a table referenced by a ______ constraint.
A. Primary Key
B. Local Key
C. Foreign Key
D. Composite Key
Answer : C

30. Which of the following is not a characteristic of a relational database model?
A. Table
B. Tree like structure
C. Complex logical relationship
D. Records
Answer : B

31. The clause alter table in SQL can be used to
A. add an attribute
B. delete an attribute
C. alter the default values of an attribute
D. all of the above
Answer : D

32. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).
A. Vulcanizing
B. Galvanizing
C. Magnetizing
D. Passing UV rays
Answer : C

33. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
A. Create table Employee(EMPNO int, EMPNAME char(10));
B. Create table Employee(EMPNO integer, EMPNAME String(10));
C. Create table Emplo(EMPNO number, EMPNAME string);
D. Create table Emp(EMPNO int, EMPNAME char(10));
Answer : A

34. A logical schema
A. is the entire database
B. Describes how data is actually stored on disk.
C. is a standard way of organizing information into accessible parts.
D. All of the above
Answer : C

35. Key to represent relationship between tables is called
A. primary key
B. secondary key
C. foreign key
D. none of the above
Answer : C

36. Which of the following concurrency control schemes is not based on the serializability property?
A. Two - phase locking
B. Graph-based locking
C. Time-stamp based locking
D. None of these .
Answer : D

37. Which of the following is not a property of transactions?
A. Atomicity
B. Concurrency
C. Isolation
D. Durability
Answer : B

38. If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
A. M:N
B. M:1
C.
D. 1:M
Answer : C

39. Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
A. (i) and (ii)
B. (iv) only
C. (i) and (iv)
D. (ii) and (iii)
Answer : D

40. DBMS is a collection of _____ that enables user to create and maintain a database.
A. Keys
B. Program
C. Translators
D. Language Activity
Answer : B

41. If the closure of an attribute set is the entire relation then the attribute set is a
A. superkey
B. candidate key
C. primary key
D. not a key
Answer : A

42. The keyword to eliminate duplicate rows from the query result in SQL is
A. DISTINCT
B. NO DUPLICATE
C. UNIQUE
D. None of the above
Answer : C

43. operator is used to compare a value to a list of literals values that have been specified.
A. Like
B. COMPARE
C. BETWEEN
D. IN
Answer : A

44. An advantage of the database management approach is
A. data redundancy increases
B. data is dependent on programs
C. data is integrated and can be accessed by multiple programs
D. none of the above
Answer : C