IM Quizzes

The database structure in a DBMS is stored as a _____.
Answer: collection of files
single file
set of key/value pairs
collection of queries
Accurate, relevant, and timely information is the key to ____.
data management
understanding
knowledge
Answer: good decision making
A(n) _____ is the equivalent of a field in a file system.
relationship
constraint
entity
Answer: attribute
Which of the following is true of business rules?
Answer: They can serve as a communication tool between the users and designers.
They allow the designer to set company policies with regard to data.
They allow the designer to develop business processes.
They provide a framework for the company’s self-actualization.
Constraints are important because they help to ensure data integrity.
Answer: Constraints
MySQL is an example of the relational data model.
A noun in a business rule translates to an entity the data model.
Metadata provide a description of the data characteristics and the set of relationships that link the data found within the database.
An entity is anything about which data are to be collected and stored.
Information is the result of revealing the meaning of raw facts.
A/an Enterprise database is used by an organization and supports many users across many departments.
A/an workgroup database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
The relational data model was developed in the 1970s.
A desktop database is a single-user database.
A/an ____ is a logically connected set of one or more fields that describes a person, place, or thing.
Answer: Record
Discovery of user requirements, existing system evaluation, and logical system design are part of the analysis phase of the Systems Development Life Cycle (SDLC).
Coding, testing, and debugging are part of the _____ phase of the Systems Development Life Cycle (SDLC).
planning
detailed systems design
Answer: implementation
analysis
When using the ALTER TABLE statement, what action is taken to add a new column to a table?
Answer: ADD COLUMN
Select the correct option/s regarding the RENAME statement in MySQL.
Answer: It can be used to rename a table.
It can be used to rename a database.
It can be used to rename a records.
It can be used to rename a column within a table.
The _____ statement in DDL is used to permanently remove an object, such as a table, from a MySQL database.
Answer: DROP
Which DDL statements are used to delete objects from a MySQL database?
Answer: DROP
What is the purpose of the MODIFY clause in the ALTER statement in MySQL?
Answer: To change the data type or size of an existing column.
What does the TRUNCATE statement do in MySQL?
Answer: Removes all records from a table, including allocated spaces.
The TRUNCATE statement in DDL deletes only specific records from a table.
Answer: False
If you want to rename an existing table in MySQL, which DDL statement would you use?
Answer: Rename
The COMMENT statement in DDL can be used to rename an object in a MySQL database.
Answer: False
What is the purpose of the DROP statement in DDL?
Answer: To remove an object, such as a table, from the database.
The traditional Systems Development Life Cycle (SDLC) is divided into _____ phases.
Answer: Five
The process of creating an information system is known as _____.
Answer: Systems Development
The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC).
Answer: Analysis
A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.
Answer: SELECT
A(n) _______ enables a database administrator to describe schema components.
Answer: data definition language (DDL)
MySQL is an example of the _____.
Answer: Relational Data Model
Which category of SQL statements is responsible for managing data within schema objects?
Answer: Data Manipulation Language (DML)
Select the correct DML statements used for manipulating existing data in a MySQL database.
There are Multiple Answers:
UPDATE
INSERT
DELETE
INCORRECT: Truncate
Which command is used for creating or exporting a new .sql file in MySQL?
Answer: mysqldump
The mysqldump command is used to create a backup of a MySQL database.
Answer: TRUE
What does the UPDATE statement do in SQL?
Answer: Modifies existing records in a table.
Which DML statement is used to add new records to a table?
Answer: ADD
Select the correct options regarding the mysqldump command in MySQL.
ANSWERS:
It is used to create a backup of a MySQL database.
What is the purpose of the SELECT statement in SQL?
Answer: To retrieve data from one or more tables.
What is the purpose of the SELECT statement in SQL?
Answer: To retrieve data from one or more tables.
The SELECT statement in SQL is used to modify existing records in a table.
Answer: False
Which of the following is true of NoSQL databases?
They do not support very large amounts of sparse data.
They are geared toward transaction consistency rather than performance.
They do not support distributed database architectures.
Answer: They are not based on the relational model.
A(n) _____ is an alternate name given to a column or table in any SQL statement.
Answer: Alias
The _____ data model uses the concept of inheritance.
Answer: Object-oriented
What is the purpose of the SELECT statement in SQL?
Answer: To retrieve data from one or more tables.
The SELECT statement in SQL is used to modify existing records in a table.
Answer: FALSE
Which of the following is true of NoSQL databases?
Answer: They are not based on the relational model.
They do not support very large amounts of sparse data.
They are geared toward transaction consistency rather than performance.
They do not support distributed database architectures.
A(n) _____ is an alternate name given to a column or table in any SQL statement.
Answer: Alias
The _____ data model uses the concept of inheritance.
Answer: Object-oriented
A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.'
Answer: Weak
Database design is a(n) _____ process based on repetition.
Answer: Iterative
_____ are underlined in an ER diagram.
Answer: Primary Key
A relationship is an association between _____.
Answer: Entities
The Crow’s foot symbol with two vertical parallel lines indicates _____ cardinality.
Answer: (1,1)
When using the Crow's Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity.
Answer: Solid
_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
Answer: Cardinality
The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.
Answer: Derived
The _____ notation of entity-relationship modelling can be used for both conceptual and implementation modelling.
Answer: UML
In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities.
Answer: (min, max)
Identifying the attributes of entities helps in the better understanding of _____ among entities.
Answer: Relationships
When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____.
Answer: Symbols
When indicating cardinality, the first value represents the _____ number of associated entities.
Answer: Minimum
The conceptual model can handle _____ relationships and multivalued attributes.
Answer: M:N
Participation is _____ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
Optional
A(n) _____ process is based on repetition of processes and procedures.
Iterative
In Crow’s Foot notation, an optional relationship between entities is shown by drawing a(n) _____ on the side of the optional entity.
Small Circle
Failure to understand the distinction between mandatory and optional _____ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.
Answer: Participation
To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent _____ relationships whenever possible.
Answer: Binary
A _____ attribute can be further subdivided to yield additional attributes.
Answer: Composite