Q. What is a foreign key in a relational database?
A.
A key that uniquely identifies a record
B.
A key that links two tables together
C.
A key that is used for indexing
D.
A key that is automatically generated
Show solution
Solution
A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table.
Correct Answer:
B
— A key that links two tables together
Learn More →
Q. What is a foreign key?
A.
A primary key in another table
B.
A unique identifier for a table
C.
An attribute that can be null
D.
A key used for indexing
Show solution
Solution
A foreign key is a primary key in another table that establishes a relationship between the two tables.
Correct Answer:
A
— A primary key in another table
Learn More →
Q. What is a functional dependency in the context of relational databases?
A.
A relationship between two tables
B.
A constraint that describes the relationship between attributes
C.
A method of indexing data
D.
A type of normalization
Show solution
Solution
A functional dependency describes a constraint between two attributes in a relation, indicating that the value of one attribute is determined by the value of another.
Correct Answer:
B
— A constraint that describes the relationship between attributes
Learn More →
Q. What is a key benefit of data warehousing for businesses?
A.
Increased operational costs
B.
Improved data quality
C.
Reduced data access speed
D.
Limited data analysis capabilities
Show solution
Solution
Data warehousing improves data quality by consolidating data from various sources and ensuring consistency.
Correct Answer:
B
— Improved data quality
Learn More →
Q. What is a key feature of Object-Oriented Databases?
A.
Support for complex data types
B.
Use of SQL exclusively
C.
Flat file storage
D.
No support for relationships
Show solution
Solution
Object-Oriented Databases support complex data types, allowing for the representation of real-world entities more effectively.
Correct Answer:
A
— Support for complex data types
Learn More →
Q. What is a major disadvantage of distributed databases?
A.
Increased data availability
B.
Higher complexity in management
C.
Improved performance
D.
Reduced data redundancy
Show solution
Solution
A major disadvantage of distributed databases is the higher complexity in management due to the need to coordinate multiple nodes and ensure data consistency.
Correct Answer:
B
— Higher complexity in management
Learn More →
Q. What is a potential drawback of normalization?
A.
Increased data integrity
B.
More complex queries
C.
Reduced data redundancy
D.
Improved performance
Show solution
Solution
Normalization can lead to more complex queries due to the need for joins between multiple tables.
Correct Answer:
B
— More complex queries
Learn More →
Q. What is a potential drawback of Object-Oriented Databases?
A.
Limited support for complex data types
B.
Higher complexity in database design
C.
Inability to handle large volumes of data
D.
Lack of transaction support
Show solution
Solution
Object-Oriented Databases can introduce higher complexity in design due to their advanced features and data structures.
Correct Answer:
B
— Higher complexity in database design
Learn More →
Q. What is a potential drawback of using NAT?
A.
It simplifies network management
B.
It can complicate peer-to-peer applications
C.
It enhances security by hiding internal IP addresses
D.
It reduces the number of required public IP addresses
Show solution
Solution
NAT can complicate peer-to-peer applications because these applications often require direct connections between devices, which NAT can hinder.
Correct Answer:
B
— It can complicate peer-to-peer applications
Learn More →
Q. What is a potential issue with concurrent transactions in a database?
A.
Data redundancy
B.
Data inconsistency
C.
Increased performance
D.
Simplified queries
Show solution
Solution
Concurrent transactions can lead to data inconsistency if not managed properly, as multiple transactions may attempt to read and write the same data simultaneously.
Correct Answer:
B
— Data inconsistency
Learn More →
Q. What is a primary key in a database?
A.
A key that allows duplicate values
B.
A unique identifier for a record in a table
C.
A key used for indexing
D.
A key that can be null
Show solution
Solution
A primary key is a unique identifier for a record in a table, ensuring that no two records can have the same primary key value.
Correct Answer:
B
— A unique identifier for a record in a table
Learn More →
Q. What is a primary key in the context of an ER model?
A.
A key that allows for data redundancy
B.
A unique identifier for each entity instance
C.
A foreign key that links to another table
D.
A type of relationship between entities
Show solution
Solution
A primary key is a unique identifier for each instance of an entity, ensuring that no two instances are the same.
Correct Answer:
B
— A unique identifier for each entity instance
Learn More →
Q. What is a primary key?
A.
A unique identifier for a record
B.
A foreign key reference
C.
An index for faster searches
D.
A type of relationship
Show solution
Solution
A primary key is a unique identifier for a record in a database table, ensuring that no two records can have the same key value.
Correct Answer:
A
— A unique identifier for a record
Learn More →
Q. What is a Programmable Logic Device (PLD)?
A.
A device that can be programmed to perform specific logic functions
B.
A fixed-function logic device
C.
A type of microcontroller
D.
A memory storage device
Show solution
Solution
A PLD is a device that can be programmed to perform specific logic functions, allowing for custom logic designs.
Correct Answer:
A
— A device that can be programmed to perform specific logic functions
Learn More →
Q. What is a star schema in data warehousing?
A.
A type of data normalization
B.
A database design with a central fact table and dimension tables
C.
A method for indexing data
D.
A concurrency control mechanism
Show solution
Solution
A star schema is a type of database design that consists of a central fact table surrounded by dimension tables, facilitating easier data retrieval.
Correct Answer:
B
— A database design with a central fact table and dimension tables
Learn More →
Q. What is a surrogate key?
A.
A natural key derived from the data
B.
A key that is created for the purpose of uniquely identifying a record
C.
A composite key made of multiple attributes
D.
A foreign key that references another table
Show solution
Solution
A surrogate key is a key that is created for the purpose of uniquely identifying a record, often an auto-incremented number.
Correct Answer:
B
— A key that is created for the purpose of uniquely identifying a record
Learn More →
Q. What is a testbench in HDL design?
A.
A tool for synthesizing hardware
B.
A simulation environment for testing designs
C.
A method for debugging code
D.
A type of HDL syntax
Show solution
Solution
A testbench is a simulation environment used to test and verify the functionality of HDL designs.
Correct Answer:
B
— A simulation environment for testing designs
Learn More →
Q. What is a transaction in the context of a database management system?
A.
A single SQL command
B.
A sequence of operations treated as a single unit
C.
A backup of the database
D.
A method of data retrieval
Show solution
Solution
A transaction is a sequence of operations that are treated as a single unit of work, ensuring data integrity.
Correct Answer:
B
— A sequence of operations treated as a single unit
Learn More →
Q. What is a transaction in the context of a database?
A.
A single SQL command
B.
A sequence of operations treated as a single unit
C.
A backup of the database
D.
A method of data retrieval
Show solution
Solution
A transaction is a sequence of operations that are executed as a single unit of work.
Correct Answer:
B
— A sequence of operations treated as a single unit
Learn More →
Q. What is a transaction in the context of a DBMS?
A.
A single unit of work that must be completed in its entirety
B.
A method of data retrieval
C.
A type of database schema
D.
A way to create indexes
Show solution
Solution
A transaction is a single unit of work that must be completed in its entirety to maintain data integrity.
Correct Answer:
A
— A single unit of work that must be completed in its entirety
Learn More →
Q. What is a transaction in the context of databases?
A.
A single operation on the database
B.
A sequence of operations treated as a single unit
C.
A backup of the database
D.
A query to retrieve data
Show solution
Solution
A transaction in the context of databases is a sequence of operations treated as a single unit.
Correct Answer:
B
— A sequence of operations treated as a single unit
Learn More →
Q. What is a Virtual LAN (VLAN)?
A.
A physical network segment
B.
A logical grouping of devices
C.
A type of network protocol
D.
A method of data encryption
Show solution
Solution
A VLAN is a logical grouping of devices that allows them to communicate as if they are on the same physical network, regardless of their actual physical location.
Correct Answer:
B
— A logical grouping of devices
Learn More →
Q. What is a weak entity in an ER model?
A.
An entity that cannot exist without a strong entity
B.
An entity with no attributes
C.
An entity that has a composite key
D.
An entity that is not related to any other entity
Show solution
Solution
A weak entity is one that cannot exist without a strong entity.
Correct Answer:
A
— An entity that cannot exist without a strong entity
Learn More →
Q. What is ADO primarily used for?
A.
Data access in web applications
B.
Database design
C.
Data normalization
D.
Creating database backups
Show solution
Solution
ADO (ActiveX Data Objects) is primarily used for data access in web applications, allowing developers to interact with databases.
Correct Answer:
A
— Data access in web applications
Learn More →
Q. What is aliasing in digital signal processing?
A.
Loss of data during transmission
B.
Distortion caused by insufficient sampling rate
C.
Error in quantization
D.
Interference from other signals
Show solution
Solution
Aliasing occurs when a signal is sampled at a rate lower than twice its highest frequency, causing different signals to become indistinguishable.
Correct Answer:
B
— Distortion caused by insufficient sampling rate
Learn More →
A.
Application Programming Interface
B.
Application Program Interface
C.
Application Protocol Interface
D.
Application Programming Interaction
Show solution
Solution
API stands for Application Programming Interface, which allows different software applications to communicate with each other.
Correct Answer:
A
— Application Programming Interface
Learn More →
Q. What is an attribute in an ER model?
A.
A relationship between entities
B.
A property or characteristic of an entity
C.
A unique identifier for a relationship
D.
A type of entity
Show solution
Solution
An attribute is a property or characteristic of an entity in an ER model.
Correct Answer:
B
— A property or characteristic of an entity
Learn More →
Q. What is an object in Object-Oriented Data Modeling?
A.
A table in a database
B.
An instance of a class
C.
A relationship between entities
D.
A type of query
Show solution
Solution
In Object-Oriented Data Modeling, an object is an instance of a class that encapsulates data and behavior.
Correct Answer:
B
— An instance of a class
Learn More →
Q. What is concurrency control in a database system?
A.
Managing simultaneous operations without conflicting
B.
Ensuring data is backed up regularly
C.
Normalizing data to reduce redundancy
D.
Encrypting data for security
Show solution
Solution
Concurrency control in a database system is managing simultaneous operations without conflicting.
Correct Answer:
A
— Managing simultaneous operations without conflicting
Learn More →
Q. What is concurrency control in a DBMS?
A.
Managing data redundancy
B.
Ensuring data consistency during simultaneous access
C.
Optimizing query performance
D.
Backing up data
Show solution
Solution
Concurrency control in a DBMS ensures data consistency during simultaneous access by multiple transactions.
Correct Answer:
B
— Ensuring data consistency during simultaneous access
Learn More →
Showing 361 to 390 of 1509 (51 Pages)