Get Started

Computer General Knowledge Questions and Answers

Last year 4.5K Views
Q :  

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.



Q :  

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.


Q :  

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.



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.

(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.



Q :  

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

Q :  

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

Q :  

The inventor of the web is

(A) Bill Gates

(B) Robert Tanenbaum

(C) Team burner lee

(D) none of the above

Correct Answer : C

Q :  

Which of the following is not an Internet Protocol?

(A) TCP/IP

(B) FTP

(C) OOP

(D) HTTP

Correct Answer : C

Q :  

The device used to carry digital data on analog lines is called as

(A) Modem

(B) Multiplexer

(C) Modulator

(D) Demodulator

Correct Answer : A

Q :  

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

Related categories

Very important related articles. Read now

The Most Comprehensive Exam Preparation Platform

Get the Examsbook Prep App Today