Database Questions Practice Question and Answer

Q:

Which of the following memory device is similar to Cache Memory mainly in terms of speed?

553 0

  • 1
    Flash memory
    Correct
    Wrong
  • 2
    D. RAM (DRAM)
    Correct
    Wrong
  • 3
    S. RAM
    Correct
    Wrong
  • 4
    E.E.P. ROM (EEPROM)
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Flash memory"
Explanation :

1. Flash memory is a portable storage device that can store data for a short period of time.

2. Unlike traditional hard drives, flash memory is capable of retaining data even after the power is turned off.

3. A flash drive is a small, portable flash memory card that plugs into a computer's USB port and acts as a portable hard drive.

4. A flash drive is a portable data storage device. Flash drives contain multiple flash chips, which are large memory modules.

Q:

In a _______, a parent record type can be associated with one or more "child" record types, but a child record type can have only one parent.

525 0

  • 1
    network database
    Correct
    Wrong
  • 2
    relational database
    Correct
    Wrong
  • 3
    distributed database
    Correct
    Wrong
  • 4
    hierarchical database
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "hierarchical database"
Explanation :

In a hierarchical database model, a parent record type can be associated with one or more child record types, but a child record type can have only one parent. This hierarchical structure is represented as a tree-like schema, where each parent record can have multiple child records, but each child record has only one parent. This model is useful for representing data with hierarchical relationships, such as organizational structures or file systems.


Q:

Which of the following statements is true?
 (I) Primary storage units have faster access time and less storage capacity than secondary storage units.
 (II) Primary storage units have sequential access.
 (III) Secondary storage units are non-volatile storage.

515 0

  • 1
    (I) and (II) only
    Correct
    Wrong
  • 2
    (I) and (III) only
    Correct
    Wrong
  • 3
    (II) and (III) only
    Correct
    Wrong
  • 4
    All (I), (II) and (III)
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "(I) and (III) only"
Explanation :

All of the following statements are true.

(I) Primary storage units have faster access time and less storage capacity than secondary storage units.

(II) Secondary storage units are non-volatile storage.

Q:

Which command is used to remove a table from the database in SQL?

491 0

  • 1
    DELETE TABLE
    Correct
    Wrong
  • 2
    DROP TABLE
    Correct
    Wrong
  • 3
    ERASE TABLE
    Correct
    Wrong
  • 4
    UNATTACH TABLE
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "DROP TABLE "
Explanation :

In SQL, the DROP TABLE command is used to remove a table from the database. When you execute DROP TABLE, it deletes the table along with all its data, indexes, triggers, constraints, and permissions. It should be used with caution as it permanently removes the table and all associated objects from the database.


Q:

Which files are used during the operation of DBMS?

458 0

  • 1
    Query language and utilities
    Correct
    Wrong
  • 2
    Data manipulation language and query language
    Correct
    Wrong
  • 3
    Data dictionary and transaction log
    Correct
    Wrong
  • 4
    Data dictionary and query language
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Data dictionary and transaction log "
Explanation :

During DBMS operation, essential files include the data dictionary, containing metadata like table structures, and the transaction log, recording all database transactions. The data dictionary guides the DBMS in understanding database organization, while the transaction log ensures data integrity by recording modifications. Both files are crucial for effective database management, enabling accurate querying, data manipulation, and system recovery in case of failures, ensuring the system's reliability and consistency.


Q:

What is the maximum number of characters in the file name?

445 0

  • 1
    256 characters
    Correct
    Wrong
  • 2
    156 characters
    Correct
    Wrong
  • 3
    356 characters
    Correct
    Wrong
  • 4
    1024 characters
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "256 characters"
Explanation :

1. The maximum number of characters a cell can contain in a worksheet is 256.

2. A file is a container in a computer system that stores data, information, settings, or commands, used with a computer program.

3. In graphical user interfaces (GUI), such as Microsoft operating systems, files are represented as icons that are associated with the program that opens the file.

Q:

U. S. B. The full form of is:

444 0

  • 1
    Universal Serial Bus
    Correct
    Wrong
  • 2
    Universal sequential bus
    Correct
    Wrong
  • 3
    Unique serial bus
    Correct
    Wrong
  • 4
    Unique sequential bus
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Universal Serial Bus"
Explanation :

1. The full form of USB is Universal Serial Bus.

2. USB is a wired device with the help of which you can connect any other device like mobile with laptop, mobile with computer etc.

3. Apart from this, you can also insert a memory card inside the laptop with its help because it is a port in which we can insert things like Pendrive, Card Reader, Data Cable etc.

Q:

What is the memory used by RAM to store frequently used information?

434 0

  • 1
    Main memory
    Correct
    Wrong
  • 2
    Cache memory
    Correct
    Wrong
  • 3
    Register
    Correct
    Wrong
  • 4
    Rome
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "Cache memory"
Explanation :

1. The memory which is used by RAM to store frequently used information is called cache memory.

2. Cache memory is much smaller than RAM, but it is much faster than RAM.

3. Recently used information is often stored in cache memory.

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully