Associative Entity Ans- All relationships for the (...) entity should be many.
Attribute Ans- An (...) is a property or characteristic of an entity.
Binary relationship Ans- A (...) is a relationship between two entity
...
Associative Entity Ans- All relationships for the (...) entity should be many.
Attribute Ans- An (...) is a property or characteristic of an entity.
Binary relationship Ans- A (...) is a relationship between two entity types.
Cardinality Ans- (...) represents the maximum number of entities that can be involved in a particular
relationship.
Cascade Delete Ans- Will delete all records that reference the primary key
Database Ans- A (...) is a collection of information that is organized so that it can easily be accessed,
managed, and updated.
E-R model Ans- An (...) is a data model for describing a database in an abstract way.
Entity Ans- An (...) is an object or event in our environment that we want to keep track of.
Intersection Data Ans- Associated with the concatenation of two segments
Modality Ans- (...) represents the minimum number of entity occurrences that can be involved in a
relationship.
Ternary Relationship Ans- A (...) relationship is when three entities participate in the relationship.
Unary Relationships Ans- (...) relationships associate occurrences of an entity type with other
occurrences of the same entity type.
Unique Identifier Ans- A (...) is any identifier which is guaranteed to be unique among all identifiers used
for those objects and for a specific purpose.
Data encryption Ans- When data is (...), it is changed, bit by bit or character by character, into a form
that looks totally garbled. It can and must be reconverted, or decrypted, back to its original form to be
of use.
Data normalization Ans- Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
Data volatility Ans- Describes how often stored data is updated.
Data Volume Assessment Ans- Understanding of how much data will be in a database or a table within a
database
Denormalization Ans- The act of duplicating data in a database for performance or the preservation of
historical information
Disaster recovery Ans- Involves rebuilding an entire information system or significant parts of one after a
catastrophic natural disaster such as a hurricane, tornado, earthquake, building collapse, or even a
major fire
Index Ans- Used to help a DBMS find data quickly
Logical view Ans- Is a mapping onto a physical table or tables that allows an end user to access only a
specified portion of data.
Response time Ans- Is the delay from the time that the Enter Key is pressed to execute a query until the
result appears on screen.
Throughput Ans- Is the measure of how many queries from simultaneous users must be satisfied in a
given period of time by the application set and the database that it supports.
Client/server architecture Ans- (...) architecture is a network architecture in which the server manages
services consumed by the client. It is also known as two-tier architecture.
Database directory Ans- (...) is an organized repository of databases that stores attributes such as the
database character set and collation.
GUI (graphical user interface) Ans- (...) is a computer program that enables a user to communicate with
a computer through the use of graphical icons.
MySQL Ans- (...) is an open source RDBMS based on SQL (structure query language) and used for adding,
removing, and modifying information in the database.
Option file Ans- (...) is an appropriate way of specifying commonly used options on the command line
while executing a program.
RDBMS (relational database management system) Ans- (...) is a program that lets you create, update,
and administer a relational database.
Schema Ans- In a relational database, a (...) defines tables, fields in each table, and relationships
between fields and tables.
DB2 Ans- (...) is a relational database management system product from IBM that serves a number of
operating system platforms.
DCL Ans- (...) is used to control access to data stored in a database.
DDL Ans- (...) - involves instructing the DBMS software on what tables will be in the database, what
attributes will be in the tables, which attributes will be indexed
[Show More]
.png)
.png)
