DBMS Professional Knowledge Questions | Set-1

DBMS-Professional-Knowledge-Questions

Here is a set of DBMS Professional Knowledge Questions for IBPS IT Officer and Other IT Exams. These questions are very important from the examination point of view. So go through these questions and make your preparation more confident.

1. Which of the following process can be used to add more tables in a database?

  1. Design view
  2. Table wizard
  3. By entering data
  4. All of the above
  5. None of these

2. The functionality that the database has allowed to access only certain records in the database is?

  1. Forms
  2. Reports
  3. Queries
  4. Tables
  5. None of these

3. You can find sort and filter group of commands in?

  1. Home ribbon
  2. Create ribbon
  3. Database tools ribbon
  4. Fields ribbon
  5. None of these

4. Arrange according to the size

  1. Record, field, byte, bit
  2. Bit, field, byte, record
  3. Field, byte, record, bit
  4. Byte, bit, record, field
  5. None of these

5. What is the maximum field size allowed for Boolean fields?

  1. 1
  2. 8
  3. 50
  4. 255
  5. None of these

6. What is a relational database?

  1. A structured database to recognize relationships between stored items of information. It is based on the relational data model.
  2. A database that is not linked to other databases
  3. A database to store human relations
  4. Both 1 and 2
  5. None of these

7. Which filtering method allows you to filter records based on criterion you specify?

  1. Filter by form
  2. Filter by selection
  3. Auto filter
  4. Advanced filter
  5. None of these

8. Which of the following types of fields is used to store employee photos?

  1. Memo
  2. OLE
  3. Photo
  4. Picture
  5. None of these

9. What is the best data type for a field that stores mobile numbers?

  1. Memo
  2. Number
  3. Date/Time
  4. Text
  5. None of these

10. Which of the following is not a function of DBA (Database Administrator)?

  1. Network maintenance
  2. Schema definition
  3. Routine maintenance
  4. Authorization for data access
  5. None of these

11. Which of the following is a data model?

  1. ER model
  2. Relational data model
  3. Object-based data
  4. Network model
  5. All of the above

12. Which of the following is not a database modification?

  1. Deletion
  2. Insertion
  3. Sorting
  4. Updating
  5. None of these

13. Which of the following represents a relationship between a set of values?

  1. A row
  2. A table
  3. A field
  4. A column
  5. None of these

14. The column header is called?

  1. Table
  2. Relation
  3. Attributes
  4. Domain
  5. None of these

15. Minimal super keys are called?

  1. Schema keys
  2. Candidate keys
  3. Domain keys
  4. Attribute keys

16. The primary key must be?

  1. Non-Null
  2. Unique
  3. Null
  4. Either 1 or 3
  5. Both 1 and 2

17. Which of the following is not a level of data abstraction?

  1. Physical level
  2. Critical level
  3. Logical level
  4. View label
  5. None of these

18. Which among the following is not a Storage Manager component?

  1. Transaction manager
  2. Logical manager
  3. Buffer manager
  4. File manager
  5. None of these

19. To view a related record from related tables in the database view, you can?

  1. Double click direct
  2. Apply filter by form command
  3. Single click on expand indicator(+) next to the record
  4. Double click on expand indicator(+) next to the record
  5. None of these

20. Who proposed the relational model?

  1. Bill Gates
  2. E.F Codd
  3. Herman Hollerith
  4. Charles Babbage
  5. None of these

21. Which type of relationship exists between a Teacher table and a Class table?

  1. One to many
  2. Many to one
  3. Many to many
  4. Two to two
  5. None of these

22. Which of the following is a unary operation?

  1. Selection operation
  2. Generalized selection
  3. Primitive operation
  4. Projection operation
  5. None of these

23. Which of the following normal forms (NF) is based on multivalued dependence?

  1. First
  2. Second
  3. Third
  4. Fourth
  5. None of these

24. A relation which has no partial dependencies is in which normal form?

  1. First
  2. Second
  3. Third
  4. BCNF
  5. None of these

25. A transaction completes its execution is said to be?

  1. Saved
  2. Loaded
  3. Rolled
  4. Committed
  5. None of these

26. A type of entity whose existence depends on another type of entity is called _________ entity.

  1. Strong
  2. Weak
  3. Codependent
  4. Variant
  5. Independent

27. Which of the following statements about the primary key is true?

  1. all primary key entries are unique
  2. the primary key may be null
  3. the primary key is not required for all tables
  4. primary key data must not be unique
  5. none of these

28. Which of the following types of index is automatically created when we don’t specify it?

  1. Bitmap
  2. Balanced Tree Index
  3. Binary Tree Index
  4. Hashed
  5. Sparse Index

29. The unit of storage that can store one or more records in a hash file organization is?

  1. Buckets
  2. Disk pages
  3. Blocks
  4. Nodes
  5. Baskets

30. If K is a foreign key in a relation R1,then

  1. every tuple of R1 has a distinct value for K
  2. K cannot have a null value for tuples in R1
  3. K is a key for some other relation
  4. K is a primary key for R1
  5. K is a composite key for R1

Answers key :

1. (4)2. (3)3. (1)4. (1)5. (1)6. (1)
7. (1)8. (2)9. (4)10. (1)11. (5)12. (3)
13. (1)14. (3)15. (2)16. (5)17. (2)18. (2)
19. (3)20. (2)21. (2)22. (2)23. (4)24. (2)
25. (4)26. (2)27. (1)28. (2)29. (1)30. (3)

Leave a Comment

Your email address will not be published. Required fields are marked *