Database Concepts — GK Questions with Answers

1. Where does a computer check a username and password for a match?
   1. Website
   2. Network
   3. Backup file
   4. Database
   Show answer

   Answer: (D) Database

   In the database.

2. Records kept electronically, one after another, in a table form this —
   1. Spreadsheet
   2. Presentation
   3. Database
   4. Web page
   Show answer

   Answer: (C) Database

   A database.

3. An organised collection of a large amount of related data used for manipulation and updating —
   1. Database
   2. File
   3. Folder
   4. Data-mining
   Show answer

   Answer: (A) Database

   A database.

4. A list of names and addresses is an example of —
   1. Input
   2. Data
   3. Output
   4. Records
   Show answer

   Answer: (B) Data

   Data.

5. In which database is data organised like a tree with nodes?
   1. Network
   2. Hierarchical
   3. Relational
   4. Multiple
   Show answer

   Answer: (B) Hierarchical

   Hierarchical.

6. In what does a database store information?
   1. Rows and columns
   2. Blocks
   3. Tracks and sectors
   4. All of these
   Show answer

   Answer: (A) Rows and columns

   Rows and columns.

7. In a relational database, the structure that holds one topic’s information in rows and columns —
   1. Block
   2. Record
   3. Tuple
   4. Table
   Show answer

   Answer: (D) Table

   A table.

8. Which is the tiniest piece of information in a record —
   1. Cell
   2. Field
   3. Record
   4. Query
   Show answer

   Answer: (B) Field

   The field.

9. The cardinality of a relation refers to the —
   1. Number of databases
   2. Number of columns
   3. Number of rows
   4. Number of tables
   Show answer

   Answer: (C) Number of rows

   The number of rows.

10. The rows of a relation are called —
    1. Relations
    2. Tuples
    3. Data structure
    4. Entity
    Show answer

    Answer: (B) Tuples

    Tuples.

11. Several linked files together are called a —
    1. Character
    2. Field
    3. Database
    4. Record
    Show answer

    Answer: (C) Database

    A database.

12. Which holds information about a single ‘entity’ like a person, place or event?
    1. Query
    2. Form
    3. Record
    4. Table
    Show answer

    Answer: (C) Record

    A record.

13. In a DBMS, rows and columns are called, respectively —
    1. Fields, records
    2. Records, fields
    3. Address, fields
    4. Ranges, sheet
    Show answer

    Answer: (B) Records, fields

    Row = record; column = field.

14. A stored question about information in a database —
    1. Query
    2. Sort
    3. Report
    4. Record
    Show answer

    Answer: (A) Query

    A query.

15. A program with a friendlier interface than the DBMS is called a —
    1. Front end
    2. Repository
    3. Back end
    4. Form
    Show answer

    Answer: (A) Front end

    Front end.

16. The correct order of data elements from smallest to largest —
    1. Character, file, record, field, database
    2. Character, record, field, file, database
    3. Character, field, record, file, database
    4. Bit, byte, record, field, file
    Show answer

    Answer: (C) Character, field, record, file, database

    Character → field → record → file → database.

17. What does the database administrator do in a company —
    1. Responsible for the technical aspects of managing the databases
    2. Executive-level decisions on information
    3. Showing relationships in a data warehouse
    4. Defining data-mining tools
    Show answer

    Answer: (A) Responsible for the technical aspects of managing the databases

    Technical management.

18. The code that relational DBMS use to perform their tasks —
    1. QBE
    2. SQL
    3. OLAP
    4. Sequel Server
    Show answer

    Answer: (B) SQL

    SQL.

19. What does a DBMS help to achieve?
    1. Data independence
    2. Centralised control of data
    3. Selection of data
    4. Both (1) and (2)
    Show answer

    Answer: (D) Both (1) and (2)

    Independence and centralised control.

20. Restoring the database to the last consistent state after a system failure —
    1. Backup
    2. Recovery
    3. Redundancy
    4. Security
    Show answer

    Answer: (B) Recovery

    Recovery.

21. The total solution to reduce redundancy, inconsistency and unauthorised access —
    1. DBMS
    2. Tables
    3. Database
    4. Protection password
    Show answer

    Answer: (A) DBMS

    The DBMS.

22. Periodically adding, changing and deleting file records is called —
    1. Updating
    2. Upgrading
    3. Restructuring
    4. Renewing
    Show answer

    Answer: (A) Updating

    Updating.

23. The architecture of a DBMS can be viewed as how many levels?
    1. Two
    2. Four
    3. Three
    4. One
    Show answer

    Answer: (C) Three

    Three.

24. The set of conceptual tools to describe data, links, meaning and constraints —
    1. E-R model
    2. Database
    3. Data model
    4. DBMS
    Show answer

    Answer: (C) Data model

    A data model.

25. One reason for problems of data integrity —
    1. Data availability constraints
    2. Data inconsistency
    3. Security constraints
    4. Data redundancy
    Show answer

    Answer: (D) Data redundancy

    Redundancy.

26. The data in a database being accurate and reliable —
    1. Data redundancy
    2. Data integrity
    3. Data reliability
    4. Data consistency
    Show answer

    Answer: (B) Data integrity

    Integrity.

27. The description that defines the name, type and length of every field —
    1. Data dictionary
    2. Data table
    3. Data record
    4. Data field
    Show answer

    Answer: (A) Data dictionary

    The data dictionary.

28. A plus point of the DBMS approach —
    1. Data is dependent on programs
    2. Data redundancy increases
    3. Data is pooled and several programs can reach it
    4. All of the above
    Show answer

    Answer: (C) Data is pooled and several programs can reach it

    Integrated data.

29. The drawback of a DBMS —
    1. Improvement in data
    2. Backup and recovery
    3. Complexity
    4. Maintenance of data integrity
    Show answer

    Answer: (C) Complexity

    Complexity.

30. Tables joined through shared fields make up a —
    1. Centralised database
    2. Flat file database
    3. Relational database
    4. All of these
    Show answer

    Answer: (C) Relational database

    Relational.

31. Oracle is a(n) —
    1. Hardware
    2. High-level language
    3. Operating system
    4. System software
    5. RDBMS
    Show answer

    Answer: (E) RDBMS

    RDBMS.

32. All the values an attribute may take form its —
    1. Attribute
    2. Degree
    3. Tuple
    4. Domain
    Show answer

    Answer: (D) Domain

    Domain.

33. Why does a table have a primary key —
    1. To unlock the database
    2. To draw a plan of the data
    3. To uniquely identify a record
    4. To establish constraints on database operations
    Show answer

    Answer: (C) To uniquely identify a record

    Unique identification.

34. Under entity integrity the primary key may be —
    1. Not null
    2. Null
    3. Both
    4. Any value
    Show answer

    Answer: (A) Not null

    Never null.

35. The key used to differentiate among different records in a file —
    1. Unique key
    2. Prime attribute
    3. Index key
    4. Primary key
    Show answer

    Answer: (D) Primary key

    The primary key.

36. The table constraint that prevents duplicate rows —
    1. Primary key
    2. Unique
    3. Null
    4. Foreign key
    Show answer

    Answer: (A) Primary key

    Primary key.

37. The field that tells one record apart from every other —
    1. Key field
    2. Primary field
    3. Master field
    4. Order field
    Show answer

    Answer: (A) Key field

    The key field.

38. A file’s primary key that is repeated in another file —
    1. Physical key
    2. Primary key
    3. Foreign key
    4. Logical key
    Show answer

    Answer: (C) Foreign key

    Foreign key.

39. An invalid type of database key —
    1. Structured primary key
    2. Atomic primary key
    3. Primary key
    4. Composite primary key
    Show answer

    Answer: (A) Structured primary key

    Structured is invalid.

40. The key that represents a relationship between tables —
    1. Primary key
    2. Secondary key
    3. Foreign key
    4. Composite key
    Show answer

    Answer: (C) Foreign key

    Foreign key.

41. How many rules did Dr. E. F. Codd give for a truly relational database?
    1. 10
    2. 8
    3. 12
    4. 6
    Show answer

    Answer: (C) 12

    12 rules.

42. The more serious problem promoted by data duplication —
    1. Isolation
    2. Data inconsistency
    3. Another
    4. Program dependency
    Show answer

    Answer: (B) Data inconsistency

    Inconsistency.

43. The database language used to access data in an existing database —
    1. DDL
    2. DML
    3. DCL
    4. None of these
    Show answer

    Answer: (B) DML

    DML.

44. What does an E-R diagram show in picture form —
    1. Primary keys and their relationships
    2. Primary keys and their relationships to instances
    3. Entity classes and their relationships
    4. Entity classes and their relationships to primary keys
    Show answer

    Answer: (C) Entity classes and their relationships

    Entities and relationships.

45. Which shape stands for an entity set in an E-R diagram —
    1. Rectangle
    2. Square
    3. Ellipse
    4. Triangle
    Show answer

    Answer: (A) Rectangle

    A rectangle.

46. Which shape stands for attributes in an E-R diagram —
    1. Rectangle
    2. Square
    3. Ellipse
    4. Circle
    Show answer

    Answer: (C) Ellipse

    An ellipse.

47. In an E-R diagram a relationship type is represented by —
    1. Ellipse
    2. Dashed ellipse
    3. Rectangle
    4. Diamond
    Show answer

    Answer: (D) Diamond

    A diamond.

48. An entity set too poor in attributes to have a primary key is —
    1. Strong entity set
    2. Weak entity set
    3. Simple entity set
    4. Primary entity set
    Show answer

    Answer: (B) Weak entity set

    A weak entity set.

More chapters in this subject

• Computer Hardware46 questions
• Introduction to Computer30 questions
• Computer Memory52 questions
• Internet & Its Services71 questions
• Data Communication & Networking52 questions
• Computer Security71 questions