Computer GK Practice Question and Answer
8 Q: Which command is used to remove a table from the database in SQL?
870 063e9ee077312b71d33d794fb
63e9ee077312b71d33d794fb- 1DELETE TABLEfalse
- 2DROP TABLEtrue
- 3ERASE TABLEfalse
- 4UNATTACH TABLEfalse
- Show Answer
- Workspace
- SingleChoice
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 ________.
661 063e9edbeaa2a114c95182ea5
63e9edbeaa2a114c95182ea5- 1Create a database filefalse
- 2Activate file editorfalse
- 3Load the software into your computertrue
- 4Keep a floppy disk in readinessfalse
- Show Answer
- Workspace
- SingleChoice
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?
726 063e9ed787312b71d33d7943a
63e9ed787312b71d33d7943a- 1Query language and utilitiesfalse
- 2Data manipulation language and query languagefalse
- 3Data dictionary and transaction logtrue
- 4Data dictionary and query languagefalse
- Show Answer
- Workspace
- SingleChoice
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.
819 063e9ed089353301b5cd70ce7
63e9ed089353301b5cd70ce7- 1network databasefalse
- 2relational databasefalse
- 3distributed databasefalse
- 4hierarchical databasetrue
- Show Answer
- Workspace
- SingleChoice
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?
952 163ac0ff5fb04114b2d3b656e
63ac0ff5fb04114b2d3b656e- 1editfalse
- 2formatfalse
- 3inserttrue
- 4Homefalse
- Show Answer
- Workspace
- SingleChoice
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.
975 163ac0f9ae541fa7a012ee8b3
63ac0f9ae541fa7a012ee8b3- 1input devicefalse
- 2secondary storage devicefalse
- 3output devicefalse
- 4internaltrue
- Show Answer
- Workspace
- SingleChoice
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?
1139 163ac13efe541fa7a012f06e2
63ac13efe541fa7a012f06e2- 1plotterfalse
- 2laser printerfalse
- 3dot matrix printertrue
- 4inkjet printerfalse
- Show Answer
- Workspace
- SingleChoice
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?
1524 163bfea5574eba5069d5bea6a
63bfea5574eba5069d5bea6a- 1pie chartfalse
- 2line chartfalse
- 3surface chartfalse
- 4column charttrue
- Show Answer
- Workspace
- SingleChoice
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.