Q. What is the main function of a foreign key in a relational database?
A.
To uniquely identify a record
B.
To establish a relationship between two tables
C.
To enforce data integrity
D.
To improve query performance
Show solution
Solution
A foreign key is used to establish a relationship between two tables and enforce referential integrity.
Correct Answer:
B
— To establish a relationship between two tables
Learn More →
Q. What is the main function of a fuse in a programmable logic device?
A.
To store data
B.
To connect logic gates
C.
To provide power
D.
To reset the device
Show solution
Solution
In a programmable logic device, a fuse is used to connect logic gates, allowing the device to be configured for specific logic functions.
Correct Answer:
B
— To connect logic gates
Learn More →
Q. What is the main function of a network intrusion detection system (NIDS)?
A.
To block unauthorized access
B.
To monitor network traffic for suspicious activity
C.
To manage IP addresses
D.
To encrypt data
Show solution
Solution
A network intrusion detection system (NIDS) monitors network traffic for suspicious activity and potential threats.
Correct Answer:
B
— To monitor network traffic for suspicious activity
Learn More →
Q. What is the main function of a router in a TCP/IP network?
A.
To connect devices within the same network
B.
To forward packets between different networks
C.
To encrypt data packets
D.
To manage bandwidth
Show solution
Solution
A router's main function is to forward packets between different networks, determining the best path for data transmission.
Correct Answer:
B
— To forward packets between different networks
Learn More →
Q. What is the main function of a web server?
A.
To store data
B.
To serve web pages
C.
To create web pages
D.
To design web pages
Show solution
Solution
The main function of a web server is to serve web pages to clients over the internet.
Correct Answer:
B
— To serve web pages
Learn More →
Q. What is the main function of a zener diode?
A.
To rectify AC signals
B.
To allow current in one direction only
C.
To provide voltage regulation
D.
To amplify signals
Show solution
Solution
A zener diode is designed to allow current to flow in the reverse direction when a specific reverse voltage is reached, providing voltage regulation.
Correct Answer:
C
— To provide voltage regulation
Learn More →
Q. What is the main function of an Intrusion Detection System (IDS)?
A.
To block unauthorized access
B.
To monitor network traffic for suspicious activity
C.
To encrypt data
D.
To manage IP addresses
Show solution
Solution
An Intrusion Detection System (IDS) monitors network traffic for suspicious activity and alerts administrators.
Correct Answer:
B
— To monitor network traffic for suspicious activity
Learn More →
Q. What is the main goal of concurrency control in a DBMS?
A.
To prevent data redundancy
B.
To ensure data consistency
C.
To improve query performance
D.
To manage user access
Show solution
Solution
The main goal of concurrency control in a DBMS is to ensure data consistency when multiple transactions are executed simultaneously.
Correct Answer:
B
— To ensure data consistency
Learn More →
Q. What is the main goal of creating an ER model?
A.
To define the physical structure of the database
B.
To visualize the data requirements and relationships
C.
To write SQL queries
D.
To implement security measures
Show solution
Solution
The main goal of creating an ER model is to visualize the data requirements and relationships.
Correct Answer:
B
— To visualize the data requirements and relationships
Learn More →
Q. What is the main goal of normalization?
A.
To increase data redundancy
B.
To eliminate data anomalies
C.
To improve query performance
D.
To simplify database design
Show solution
Solution
The main goal of normalization is to eliminate data anomalies and ensure data integrity by organizing data efficiently.
Correct Answer:
B
— To eliminate data anomalies
Learn More →
Q. What is the main goal of the Third Normal Form (3NF)?
A.
To eliminate transitive dependencies
B.
To ensure all attributes are dependent on the primary key
C.
To remove duplicate rows
D.
To create a unique identifier for each record
Show solution
Solution
The main goal of 3NF is to eliminate transitive dependencies, ensuring that non-key attributes are only dependent on the primary key.
Correct Answer:
A
— To eliminate transitive dependencies
Learn More →
Q. What is the main goal of transaction management in a DBMS?
A.
To ensure data redundancy
B.
To maintain data integrity
C.
To improve performance
D.
To simplify queries
Show solution
Solution
The main goal of transaction management is to maintain data integrity by ensuring that transactions are processed reliably.
Correct Answer:
B
— To maintain data integrity
Learn More →
Q. What is the main goal of using an ER model in database design?
A.
To create complex SQL queries
B.
To visually represent data and relationships
C.
To enforce data integrity
D.
To optimize database performance
Show solution
Solution
The main goal of using an ER model is to visually represent data and the relationships between them.
Correct Answer:
B
— To visually represent data and relationships
Learn More →
Q. What is the main purpose of a decoder in digital circuits?
A.
To convert binary data to decimal
B.
To select specific outputs based on input combinations
C.
To perform arithmetic operations
D.
To store data
Show solution
Solution
A decoder converts binary input into a unique output line, selecting specific outputs based on input combinations.
Correct Answer:
B
— To select specific outputs based on input combinations
Learn More →
Q. What is the main purpose of a digital-to-analog converter (DAC)?
A.
To convert analog signals to digital
B.
To amplify analog signals
C.
To convert digital signals to analog
D.
To filter digital signals
Show solution
Solution
A digital-to-analog converter (DAC) is used to convert digital signals into analog signals.
Correct Answer:
C
— To convert digital signals to analog
Learn More →
Q. What is the main purpose of a router in a WAN?
A.
To connect devices within a local network
B.
To filter traffic based on MAC addresses
C.
To route data packets between different networks
D.
To provide wireless connectivity
Show solution
Solution
Routers are used in WANs to route data packets between different networks, making them essential for inter-network communication.
Correct Answer:
C
— To route data packets between different networks
Learn More →
Q. What is the main purpose of an ER model?
A.
To define SQL queries
B.
To visualize database structure
C.
To manage transactions
D.
To optimize indexing
Show solution
Solution
The main purpose of an ER model is to visualize the structure of a database, including entities, attributes, and relationships.
Correct Answer:
B
— To visualize database structure
Learn More →
Q. What is the main purpose of an operational amplifier (op-amp) in AC circuits?
A.
To convert AC to DC
B.
To amplify AC signals
C.
To rectify AC signals
D.
To filter AC signals
Show solution
Solution
Operational amplifiers are used to amplify AC signals, making them suitable for various applications in analog electronics.
Correct Answer:
B
— To amplify AC signals
Learn More →
Q. What is the main purpose of an operational amplifier?
A.
To amplify current
B.
To amplify voltage
C.
To convert AC to DC
D.
To switch signals
Show solution
Solution
Operational amplifiers are primarily used to amplify voltage signals.
Correct Answer:
B
— To amplify voltage
Learn More →
Q. What is the main purpose of concurrency control in a DBMS?
A.
To prevent data loss
B.
To ensure data consistency
C.
To speed up data retrieval
D.
To manage user permissions
Show solution
Solution
The main purpose of concurrency control in a DBMS is to ensure data consistency when multiple transactions are executed simultaneously.
Correct Answer:
B
— To ensure data consistency
Learn More →
Q. What is the main purpose of data normalization in a data warehouse?
A.
To reduce data redundancy
B.
To improve query performance
C.
To enhance data integrity
D.
To simplify data retrieval
Show solution
Solution
Data normalization aims to reduce data redundancy and improve data integrity, although it is less common in data warehousing compared to operational databases.
Correct Answer:
A
— To reduce data redundancy
Learn More →
Q. What is the main purpose of error control in networking?
A.
To increase bandwidth
B.
To ensure data integrity during transmission
C.
To manage network traffic
D.
To provide encryption
Show solution
Solution
The main purpose of error control is to ensure data integrity during transmission by detecting and correcting errors.
Correct Answer:
B
— To ensure data integrity during transmission
Learn More →
Q. What is the main purpose of indexing in a database?
A.
To store data
B.
To enforce data integrity
C.
To speed up data retrieval
D.
To manage transactions
Show solution
Solution
The main purpose of indexing in a database is to speed up data retrieval operations.
Correct Answer:
C
— To speed up data retrieval
Learn More →
Q. What is the main purpose of normalization in databases?
A.
To reduce data redundancy
B.
To increase data redundancy
C.
To improve query performance
D.
To create indexes
Show solution
Solution
Normalization is the process of organizing data to reduce redundancy and improve data integrity.
Correct Answer:
A
— To reduce data redundancy
Learn More →
Q. What is the main purpose of normalization?
A.
To reduce data redundancy
B.
To increase data redundancy
C.
To improve query performance
D.
To create backups
Show solution
Solution
The main purpose of normalization is to reduce data redundancy and improve data integrity in a database.
Correct Answer:
A
— To reduce data redundancy
Learn More →
Q. What is the main purpose of using pull-up resistors in TTL circuits?
A.
To increase speed
B.
To ensure a defined logic level
C.
To reduce power consumption
D.
To improve noise immunity
Show solution
Solution
Pull-up resistors are used to ensure that inputs are at a defined logic level when not actively driven.
Correct Answer:
B
— To ensure a defined logic level
Learn More →
Q. What is the main reason NAT is used in home networks?
A.
To improve internet speed
B.
To allow multiple devices to access the internet using one IP address
C.
To provide a direct connection to the internet
D.
To enable wireless connectivity
Show solution
Solution
NAT is primarily used in home networks to allow multiple devices to access the internet using one public IP address, conserving IP address space.
Correct Answer:
B
— To allow multiple devices to access the internet using one IP address
Learn More →
Q. What is the maximum capacity of a standard DVD?
A.
4.7 GB
B.
8.5 GB
C.
25 GB
D.
50 GB
Show solution
Solution
A standard single-layer DVD can hold up to 4.7 GB of data.
Correct Answer:
A
— 4.7 GB
Learn More →
Q. What is the maximum clock frequency of the 8051 microcontroller?
A.
1 MHz
B.
12 MHz
C.
24 MHz
D.
40 MHz
Show solution
Solution
The maximum clock frequency of the 8051 microcontroller is 12 MHz.
Correct Answer:
B
— 12 MHz
Learn More →
Q. What is the maximum data rate of 802.11ac Wi-Fi technology?
A.
54 Mbps
B.
600 Mbps
C.
1.3 Gbps
D.
3.5 Gbps
Show solution
Solution
The maximum data rate of 802.11ac can reach up to 1.3 Gbps under optimal conditions.
Correct Answer:
C
— 1.3 Gbps
Learn More →
Showing 541 to 570 of 1509 (51 Pages)
