Computer General Knowledge Questions and Answers
Which command is used to remove a table from the database in SQL?
(A) DELETE TABLE
(B) DROP TABLE
(C) ERASE TABLE
(D) UNATTACH TABLE
Correct Answer : B
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.
While using a database management system, the first thing you have to do is ________.
(A) Create a database file
(B) Activate file editor
(C) Load the software into your computer
(D) Keep a floppy disk in readiness
Correct Answer : C
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.
Which files are used during the operation of DBMS?
(A) Query language and utilities
(B) Data manipulation language and query language
(C) Data dictionary and transaction log
(D) Data dictionary and query language
Correct Answer : C
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.
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.
(A) network database
(B) relational database
(C) distributed database
(D) hierarchical database
Correct Answer : D
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.
The work done on the Internet is called -
(A) surfing
(B) Gambling
(C) both a and B
(D) none of the above
Correct Answer : A
What is the first name in an email address called?
(A) domain
(B) user id
(C) Range
(D) none of the above
Correct Answer : B
The inventor of the web is
(A) Bill Gates
(B) Robert Tanenbaum
(C) Team burner lee
(D) none of the above
Correct Answer : C
Which of the following is not an Internet Protocol?
(A) TCP/IP
(B) FTP
(C) OOP
(D) HTTP
Correct Answer : C
The device used to carry digital data on analog lines is called as
(A) Modem
(B) Multiplexer
(C) Modulator
(D) Demodulator
Correct Answer : A
SMPS stands for
(A) Switched mode power supply
(B) Start mode power supply
(C) Store mode power supply
(D) Single mode power supply
Correct Answer : A
Showing page 2 of 4
enhttps://www.examsbook.com/computer-general-knowledge-questions-and-answers/242computer-general-knowledge-questions-and-answersAbout author
Rajesh Bhatia
A Writer, Teacher and GK Expert. I am an M.A. & M.Ed. in English Literature and Political Science. I am highly keen and passionate about reading Indian History. Also, I like to mentor students about how to prepare for a competitive examination. Share your concerns with me by comment box. Also, you can ask anything at linkedin.com/in/rajesh-bhatia-7395a015b/.
Read more articles