Computer GK Practice Question and Answer

Q:

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

515 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:

While using a database management system, the first thing you have to do is ________.

426 0

  • 1
    Create a database file
    Correct
    Wrong
  • 2
    Activate file editor
    Correct
    Wrong
  • 3
    Load the software into your computer
    Correct
    Wrong
  • 4
    Keep a floppy disk in readiness
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Load the software into your computer "
Explanation :

While using a database management system, the first thing you have to do is install the software on your computer. Loading the software involves the installation process, which includes copying the necessary files and configuring the system to run the database management software effectively. Once installed, you can then create databases, define data structures, and start working with the DBMS to manage your data.

Q:

Which files are used during the operation of DBMS?

482 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:

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.

552 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:

By using which tab can you add page numbers in an MS-Word 2019 document? 

660 1

  • 1
    edit
    Correct
    Wrong
  • 2
    format
    Correct
    Wrong
  • 3
    insert
    Correct
    Wrong
  • 4
    Home
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "insert "
Explanation :

In Microsoft Word 2019, you can add page numbers to your document by using the "Insert" tab. The "Insert" tab contains various options, including the "Page Number" option, which allows you to insert page numbers at different locations in your document.

Q:

The CPU, motherboard and RAM are ........ components of a computer hardware system. 

709 1

  • 1
    input device
    Correct
    Wrong
  • 2
    secondary storage device
    Correct
    Wrong
  • 3
    output device
    Correct
    Wrong
  • 4
    internal
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "internal "
Explanation :

The CPU (Central Processing Unit), motherboard, and RAM (Random Access Memory) are internal components of a computer hardware system. These components are essential for the computer to function and are located inside the computer's casing.

Q:

In which printer ribbon is used? 

810 1

  • 1
    plotter
    Correct
    Wrong
  • 2
    laser printer
    Correct
    Wrong
  • 3
    dot matrix printer
    Correct
    Wrong
  • 4
    inkjet printer
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "dot matrix printer "
Explanation :

Dot matrix printers use printer ribbons. A dot matrix printer is a type of impact printer that produces characters and images on paper by striking a series of dots against an ink-soaked ribbon. The ribbon transfers ink onto the paper to create text and graphics. Dot matrix printers were widely used in the past for tasks such as printing invoices, receipts, and multipart forms.

Q:

what is the default chart type in Microsoft excel?

1141 1

  • 1
    pie chart
    Correct
    Wrong
  • 2
    line chart
    Correct
    Wrong
  • 3
    surface chart
    Correct
    Wrong
  • 4
    column chart
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "column chart"
Explanation :

In Microsoft Excel, the default chart type for most data is the "Column Chart." When you create a new chart in Excel without specifying a specific type, it usually starts with a column chart where data points are represented as vertical bars. Of course, you can change the chart type later based on your preferences and the type of data you want to visualize.

      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