Computer GK Questions for Informatics Assistant Exam
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
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.
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.
Which of the following is not an Internet Protocol?
(A) TCP/IP
(B) FTP
(C) OOP
(D) HTTP
Correct Answer : C
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
Which of the following is the most difficult and secure device that LAN uses?
(A) static router
(B) IP Enabled Router
(C) dynamic router
(D) RIP enabled router
Correct Answer : A
The company has a large network which is divided into smaller parts. By using which device LAN can be divided into different parts?
(A) an internal firewall
(B) router between subnets
(C) individual switch for department
(D) all of the above
Correct Answer : D
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.
The full form of CPC is –
(A) Cost pay for customer
(B) Cost per click
(C) Charge per click
(D) None of these
Correct Answer : B