Database Knowledge Quiz
Database Knowledge Quiz
Test your understanding of database concepts and management systems with our comprehensive quiz! Perfect for students, professionals, or anyone interested in enhancing their database knowledge.
Key Features:
- Multiple-choice questions
- Covers essential database topics
- Score and review your answers
________ is defined as known facts that can be recorded and have an implicit meaning
Data
Database
Database Management System
Database System
________ is defined as a collection of related data
Data
Database
Database Management System
Database System
________ is defined as software package/system to facilitate the creation and maintenance of a computerized database.
Data
Database
Database Management System
Database System
________ is defined as the DBMS software together with the data itself. Sometimes, the application programs and interfaces are also included.
Data
Database
Database Management System
Database System
Insulation between programs and data called ________
Program-data independence
Program-data dependence
All of the above
From Database Characteristics ________.
Self-describing nature of a database system
Insulation between programs and data
Support of multiple views of the data
All of the above
OLTP is ________.
Is a major part of database applications
Is a normal part of database applications
Is not a part of database applications
No correct answer
Those who design and develop the DBMS software and related tools are called ________.
End-user
Client on the Scene
Workers Behind the Scene
None of above
Those who design, develop and maintain database applications are called ________.
Actors on the Scene
Client on the Scene
End-user
None of above
________ use the database for queries, reports, and updating the database content.
Workers
Owners
Developers
End-users
________ mostly maintain personal databases using ready-to-use packaged applications
Stand-alone end-users
Sophisticated end-users
Casual end-users
None of the above
Additional Implications of Using the Database Approach:
Flexibility to change data storage structures
Availability of up-to-date information
Economies of scale
All of above
................Responsible for authorizing/controlling access to the database; coordinating and monitoring its use; acquiring software and hardware resources; and monitoring efficiency of operations
Database administrators
Database Designers
Database users
None of above
Advantages of Using the Database system:
Drawing inferences and actions from the stored data using deductive and active Rules
Representing complex relationships among data.
Providing backup and recovery services
All of above
What is DBMS?
DBMS is a collection of queries
DBMS is a high-level language
DBMS is a programming language
DBMS stores, modifies and retrieves data
In which of the following formats data is stored in the database management system?
Image
Text
Table
Graph
Which of the following is a function of the DBMS?
Storing data
Providing multi-users access control
Data Integrity
All of the above
It is unnecessary to use DBMS at High initial investment and possible need for additional hardware
True
False
Database administrators are responsible for defining database structure, constraints, and transactions; communicate with users to understand their need
True
False
If the database and applications are complicated, not well defined, and expected to change then a DBMS is unnecessary
True
False
Representing easy relationships among data is one of the advantages of using data base systems
True
False
Restricting unauthorized access to data is one of the advantages of using data base systems
True
False
Redundancy problems are time and storage
True
False
Data may be generated manually or computerized
True
False
DBMSs is being used in Audio and Video Data Management
True
False
Low initial investment and possible need for additional hardware is a DBMS feature
True
False
A set of concepts to describe the structure of a database, the operations for manipulating the data, and the constraints that the data should follow
Database Schema
Data Model
Valid data
Data Model Operations
Includes descriptions of the database structure, relationships, data types, and constraints
Data Model Operations
Database Schema
Valid data
Data Model
Categories of Data Model include
Conceptual
Physical
Implementation
All of the above
The DBMS schema that usually uses the same data model as conceptual schema ........
Internal schema
Internal schema
Both a&b
None of the above
The state in database management system that satisfies the structure and constraints of the database:
Valid state
Initial database state
Attribution state
Extension state
In a particular time, the data available in the database at a specific moment is called:
Database time interval
Database concept
Database construct
Database State
Internal schema typically uses ......... Data model.
Conceptual
Physical
Implementation
None of the above
Used to specify database retrievals and updates:
Data Modeling language
Data definition language
Data Manipulation language
Data declaration language
Used by the DBA and database designers to specify the conceptual schema of a database:
Data modeling language
Data definition language
Data Manipulation language
Data declaration language
Database System Utilities are here to perform certain functions such as:
Report generation utilities
Performance monitoring utilities
Backing up the database periodicallyon tape.
All of the above
Passive data dictionary accessed by
Users
DBA
DBMS software
A&B
Used to store schema descriptions and other information.......
Data dictionary
Data model
Database state
Table
Application Development Environments and CASE (computer- aided software engineering) tools often have a database design component
True
False
Active data dictionary is accessed by DBMS software and users/DBA
True
False
Logical Data Independence is the capacity to change the internal schema without having to change the external schemas and their associated application programs
True
False
Physical Data Independence is the capacity to change the external schema without having to change the conceptual schema
True
False
Data model constructs often include data elements and their data types
True
False
Operations on the data model may include basic model operations ( insert, delete, update)
True
False
Database schema changes every time the database is updated
True
False
Which of the following is not a type of database management system?
Hierarchical
Network
Relational
Sequential
Can handle most situations for modeling using record types and relationship types
Hierarchical
Network
Relational
Sequential
......... Tier Client-Server DBMS Architecture is Common for Web applications.
One
Two
Three
Four
All of these are traditional DBMSs except
Relational
Network
Hierarchical
Object-oriented
What is the classification of DBMS
Traditional
Emerging
Single-user vs multi- user
All of the above
In Three-tier client-server architecture, ……. Represents a business and processing logic
Database server
Client
Application Server
None of the above
All the following are DBMS Classifications:
Traditional
Emerging
Single user`
Centralized
All of the above
The Most classification of DBMSs used is
Single-user
Multi-user
Centralized
DBMS Server provides database query and transaction services to the clients.
True
False
Database Design Process .... Main activities
Two
Three
Four
What are Database Design Process main activities?
Database schema design
Application programs design
Both
Application programs design focuses on....
The programs and interfaces
Data
Both
Specific objects or things in the mini world that are represented in the database.
Entities
Attributes
Data values
..... Properties used to describe an entity
Entities
Attributes
Data values
..... A specific entity has a value for each of its attributes.
Entities
Attributes
Data values
Each attribute has a .... (Or data type) associated with it
Value set
Entities
Name
Types of Attributes are ....
Simple
Composite
Multi-valued attribute
All of the above
For simple attribute , each entity has .... Value for the attribute
One = single
Two
More than two
Multi-valued attribute is called .........
Repeating group or collection
Atomic
Compound
None of the above
Each key is .... in ER diagrams
Underlined
In an oval
In a square
In ER diagrams, the entity type name is displayed in .....
Rectangular box
Oval
Diamond-shaped box
Attribute is displayed in .....
Rectangular box
Oval
Diamond-shaped box
Multivalued attribute is displayed in ....... .
Double oval
Oval
Diamond-shaped box
Each entity type will have a collection of individual entities stored in the database called ...
Entity set
Value set
Entities
ER model has ...... Main concepts
One
Two
Three
A ......... Relates two or more distinct entities , with a specific meaning
Entity
Attribute
Relationship
. ....... Identifies the relationship name and the participating entity types also identifies certain relationship constraints
Relationship type
Relationship set
The current state of a relationship type is ....
Relationship type
Relationship set
..... Is used to display a relationship type
Rectangular box
Oval
Diamond-shaped box
Connected to the participating entity types via ........
Straight lines
Curved lines
Arrows
A relationship type with the same entity type participating twice in ..... Distinct roles
One
Two
Three
Degree of a relationship type is the number of participating entity types
True
False
Weak Entity is an entity type that does not have a key attribute on its own
True
False
Simple attribute is sometimes called atomic
True
False
Composite attribute is called compound
True
False
Key attribute is an attribute of an entity type for which each entity must have a unique(distinct) value.
True
False
A key attribute may be composite
True
False
An entity type may have more than one key
True
False
Entities , attributes , and relationships are the main concepts of ER model .
True
False
Relationship set is the schema description of a relationship
True
False
Total participation is specified by
Single line
Double line
Triple line
The rectangle symbol in ER diagram means:
Entity
Relationship
Attribute
The rhombus symbol in ER diagram means
Entity
Relationship
Attribute
The oval symbol in ER diagram means
Entity
Relationship
Attribute
Relation types of degree 2 are called
Binary
Ternary
N-ary
Constraints are harder to specify for high degree relationships than for.......relationships
Ternary
N-ary
Binary
Relationship types of degree 3 are called
Binary
Ternary
N-ary
Relationship types of degree n are called
Binary
Ternary
N-ary
The type of Constraints on Relationship that specifies maximum participation
Cardinality Ratio
Existence Dependency
Participation constraint
The type of Constraints on Relationship that specifies minimum participation
Cardinality Ratio
Existence Dependency
Participation constraint
B&c
In some ER diagrammatic notation, it is common to specify cardinality ration and participation constraint jointly using
Max notation
Min notation
A&b
In general, ............relationships can represent different information than a single ternary relationship
1 binary
2 binary
3 binary
..........is one popular method for displaying database schemas
ER diagrams
UML class diagrams
ORM Diagram
...........is representative of an alternative way of displaying ER concepts that is used in several automated design tools
ER diagrams
UML class diagrams
ORM Diagram
In some cases, a ternary relationship can be represented as a weak entity type if the data model allows ............ Identifying relationships
Single
None
Multiple
In ........... Relationship, both participations are same entity type in different roles
Recursive
Binary
Ternary
In recursive relationship type in ER diagrams, Role names must be displayed for other relationship types. ( can also be optionally displayed)
True
False
In general, an n-ary relationship (where n > 2) is equivalent to n binary relationships (isn’t)
True
False
Total participation specified by double line, partial participation by single line
True
False
In a recursive relationship type,Both participations are same entity type in different roles
True
False
The relational Model of Data is based on the concept of
Relations
Fields
Columns
Keys
The formal Term of row is ......
Tuple
Relation
Domain
Attribute
The informal Term of Relation is ......
Tuple
Attributes
Table
Row
In the formal model, the column header is called ...
Tuple
Relation
Domain
Attribute
All possible column values or data type is called ...... Of the column.
Tuple
Relation
Domain
Attribute
A special ........ Value is used to represent values that are unknown or inapplicable to certain tuples.
Known
NULL
Pointer
Unique
A Tuples are not considered to be ordered ,because a relation is a/an....of tuples.
Array
Set
Table
Map
Main type of built-in constraints in the relational model is.....constraints
Key
Entity integrity
Referential integrity
All of the above
....... Are conditions that must hold on all valid relation states.
Constraints
Relations
Entities
Models
If a relation has several keys, they are called ..... keys
Primary
Candidate
Super
Artificial
Which one of the following attribute can be taken as a primary key?
Name
Street
Id
Department
If all constraints are satisfied by a database state, it is called a ... state
Complete
Valid
Correct
Relational
The database state changes to another state whenever the tuples in any relation are changed via ...
Isnertions
Deletions
Updates
All of the above
) .......used to specify a relationship among tuples in two relations( The referencing relation and the referenced relation)
Key
Entity integrity
Referential integrity
Domain
The state of the relation is the formal term of table definition
True
False
Formally, a relation state is a subset of the Cross product of the domains of its attributes
True
False
The primary key attributes of each relation schema cannot have null values
True
False
The primary key value is used to uniquely identify each tuple in a relation
True
False
In general ,we Choose the smallest-sized candidate key (in bytes) as primary key
True
False
The Key in a relation is minimal superkey
True
False
The value of the superkey can be repeated
True
False
The Foreign key attributes can have null values
True
False
Any key is superkey and vice-versa
True
False
Database schema changes whenever the tuples in any relation are changed via insertions, deletions, or updates
True
False
Entity integrity constraints are not a built-in constraint
True
False
Referential Integrity Constraints involve one relation
True
False
Which of these are from the basic operations for changing the database:
INSERTING new tuples in a relation.
DELETING existing tuples from a relation
UPDATING attribute values of existing tuples
All of the above.
To avoid integrity violation during update operations , the following actions can be taken except:
Warn the user of the violation and perform the operation
Cancel the operation that causes the violation (RESTRICT or REJECT option)
Change the domain constraints of the attributes
Trigger additional updates so the violation is corrected (CASCADE option, SET NULL option).
INSERT may violate ……..constraint(s)
Domain
Referential integrity
Entity integrity
All of the above
INSERT may violate the Key Constraint if
One of the attribute values provided for a new tuple is not of the specified attribute domain
A foreign key value in a new tuple references a primary key value that does not exist in the referenced relation
The primary key value is null in a new tuple
The value of a key attribute in a new tuple already exists in another tuple in the relation
Updating an ordinary attribute (neither PK nor FK) can only violate ….
Domain constraint
Referential integrity constraints
NOT NULL constraints
A & c
Semantic Integrity Constraints (or user-defined constraints) is a built-in constraint in the model.
True
False
Whenever the database is changed, a new state arises.
True
False
UPDATE modifies the values of attributes in one or more existing tuples in a relation.
True
False
When updating the primary key the CASCADE option is suitable for not violating the referential integrity
True
False
UPDATE operation add or remove column to already existing table.
True
False
The WHERE-clause is optional in an SQL query
True
False
To retrieve all the attribute values of the selected tuples, a \ (slash) is used, which stands for all the attributes.
True
False
SQL does not treat a relation as a set but a multiset
True
False
The LIKE comparison operator is used to compare partial strings
True
False
Conditions can be used in WHERE-clause
True
False
The standard arithmetic operators can NOT be applied to numeric attributes and values in an SQL query
True
False
The default order by is in ascending order of values
True
False
A basic query in SQL can consist of up to four clauses, but only the first One is mandatory
True
False
There are three SQL commands to modify the database
True
False
Some operations may be rejected if they violate integrity constraints
True
False
Values for the attributes should be listed in different order as the attributes were specified in the Create Table command
True
False
Attributes that have defaults values can be omitted in the new record(s)
True
False
Constraints specified in the DDL are automatically enforced by the DBMS when updates are applied to the database
True
False
We can NOT insert multiple tuples in one INSERT statement
True
False
We can insert tuples from a query result into a table
True
False
Tuples are deleted from only one table at a time unless REJECT is specified on a referential integrity constraint
True
False
Missing WHERE-clause deletes all tuples in the relation; the table then becomes an empty table
True
False
Each command modifies tuples in different relation
True
False
A constraint NOT NULL may be specified on an attribute.
True
False
Real is a basic string data type.
True
False
SQL allows a table (relation) to have two or more tuples that are identical in all their attribute values
True
False
An SQL relation (table) is a set of tuples.
True
False
If more than one relation is specified in the FROM-clause and there is no WHEREclause, then all possible combinations of Tuples are joined together known as
Cartesian Product
Mathematical Product
Factorial Product
Linear Product
SELECT SSN, DNAME FROM EMPLOYEE, DEPARTMENT In this query, every EMPLOYEE is joined with every
EMPLYOEE
DEPARTMENT
DNAME
SSN
To retrieve all the attribute values of the selected tuples…………. used, which stands for all the attributes.
( )
\
<>
*
To eliminate duplicate tuples in a query result, the keyword ……….. Is used
Delete
Drop
Distinct
Define
The ……… comparison operator is used to compare partial strings
LIKE
SAME
COMPARE
DIFFER
The …………. Clause is used to sort the tuples in a query result based on the values of some attribute(s)
SORT
ORDER BY
ARRANGE
SAVE
Without ORDER BY, the rows in a query result appear in ………order
Random
Sorted
Ascending
Descending
A basic query in SQL can consist of up to ……. clauses
Five
Three
Four
Two
There are ……. SQL commands to modify the database
Five
Three
Four
Two
…….. Is used for adding one or more records to a table
Delete
Sort
Insert
Update
……. Is for removing records
Delete
Sort
Insert
Update
.……. Is for modifying existing records
Delete
Sort
Insert
Update
Values for the attributes should be listed in the same order as the attributes were specified in the ……… command
Create Table
Unique Table
New Table
Updated Table
We have to use ……….to keep table up to date.
Create Table
Create View
Create List
Create Tuple
Referential integrity should be enforced via
REJECT
CASCADE
SET NULL
All of the above
An additional …….. Specifies the attributes to be modified and their new values
WHERE-CLAUSE
SET-CLAUSE
MODIFY-CLAUSE
NEW-CLAUSE
..is a standard, comprehensive language, based on the relational model
SQL
Database
Data model
None of the above
Which of the following are capabilities for many functions in SQL?
DDL statements for creating schemas and specifying data types and constraints
Statements for specifying database retrievals
Statements for modifying the database
All of the above
Which of the following statements can be used to create a named database schema?
Data
Modify
Create
SQL
…..can also specify the primary key, unique keys, and referential integrity constraints
Create table
Create schema
None of the above
All of the above
What other commands can modify tables and constraints?
Drop statement
Alter statement
All of the above
None of the above
In its simplest form, specifies a new base relation by giving it a name, and specifying each of its attributes and their data types.
Create Table
Drop
Alter
None of the above
All of the following are basic numeric data types except
Integers
Fixed-length
Real
Formatted
Satetment that is SQL basic statement for retrieving information from a database is
Select Statement
Delete Statement
Drop Statement
SQL relations can be constrained to be sets by specifying
Unique Attributes
Primary Key
Distinct Option
All Of The Above
What is simplest form of SQL select statement called ?
Is called a mapping or a select-form-where block
Is called a list of attribute name
Is called a list of the table (relation) names
What is the meaning of DNAME?
Is called a join condition
Is called a selection condition
Is called the name and address of all employees
What is the meaning of DNUMBER?
Is called a join condition
Is called the name and address of all employees
Is called a selection condition
……………… is the basic set of operations for the theoretical relational model.
Relational algebra
Relational calculus
Relation
None of the above
Relational algebra operations are used in DBMS for…….
Updating the tables of the DB permanently
Deleting undesirable data from the DB
Query optimization
All the above
A sequence of relational algebra operations forms a ….
Relational algebra set
Relational algebra expression
Relational algebra state
Valid relational algebra
Unary Relational Operations ………….
Two input tables
More than two input tables
One input table
None of the above
Unary relational Operations include all except ….
Join
Project
Select
Rename ϝ
A relational algebra operation that applies Set theory….
Division
Join
Cartesian product
Project
Binary Relational Operations are………….
SELECT
JOIN
DIVISION
Both B&C
Which of the following is a type of relational operation?
Project Operation
Union Operation
Set Difference
All of the above
Which of the following is NOT a type of relational operation?
Select Operation
Set Difference
Set Update
Cartesian Product
.…selects a subset of the tuples from a relation based on a selection condition.
σ (sigma)
π (pi)
ϝ (rho)
None of the above
.……selects all tuples that satisfies the selection condition from a relation R.
SELECT σ
PROJECT π
UNION U
JOIN ∞
Using the select operation, you can select ___ that satisfy certain criteria
Tuples
Attributes
Operators
None of the above
To select the EMPLOYEE tuples whose department number is 4:
σ SALARY > 30,000 (EMPLOYEE)
σ DNO = 7 (EMPLOYEE)
σ DNO = 4 (EMPLOYEE)
None of the above
To select the employee tuples whose salary is greater than $30,000:
σ SALARY > 30,000 (EMPLOYEE)
σ EMPLOYEE (sal>3000)
π SALARY > 30,000 (EMPLOYEE)
π EMPLOYEE (sal>3000)
All the following are properties of SELECT operation expect….
A cascade (sequence) of SELECT operations may be applied in any order
A cascade of SELECT operations may be replaced by a single selection with a conjunction of all the conditions
The number of tuples in the result of a SELECT is more than (or equal to) the number of tuples in the input relation R
SELECT σ is commutative
PROJECT Operation is denoted by……….
σ (sigma)
π (pi)
ϝ (rho)
None of the above
A list of the attributes we wish to appear in the result is displayed in ___ operation
Select
Project
Union
Rename
PROJECT creates a ……………. partitioning
Horizontal
Vertical
Both a&b
None
……….. Produces a new relation with only some of the attributes of R and removes duplicate tuples
SELECT σ
PROJECT π
Cartesian product x
JOIN ∞
To List each employee’s first and last name and salary
σ LNAME, FNAME, SAL (EMPLOYEE)
σ EMPLOYEE (FNAME, LNAME, SAL)
π FNAME, LNAME, SAL (EMPLOYEE)
π EMPLOYEE (LNAME, FNAME, SAL)
The project operation ‘s function in relational algebra is identical to…... Clause in SQL
Where
From
Select
None of the above
The select operation ‘s function in relational algebra is identical to…… clause in SQL
Where
From
Select
None of the above
…… produces a relation that includes all the tuples in R1 or R2 or both R1 and R2 (R1 and R2 must be union compatible)
DIFFERENCE -
INTERSECTION Ⴖ
UNION U
JOIN ∞
Produces a relation that includes all the tuples in BOTH R1 and R2 (R1 and R2 must be union compatible)
DIFFERENCE -
INTERSECTION Ⴖ
UNION U
JOIN ∞
What does Set Difference Operation denote as?
+
-
U
The result of S – R (where R, S are two compatible tables) is a relation that:
All tuples that are in both R and S
All tuples that are either in R or in S or in both R and S
All tuples that are in R but not in S
All tuples that are in S but not in R
All the following are commutative operations except:
SELECT(σ)
UNION (U)
INTERSECTION(Ⴖ)
DIFFERENCE -
In ___ products, the rows in one table are combined with the rows in another table
Cross
Cartesian
Both A and B
None of the above
Produces a relation that has the attributes of R1 and R2 and includes as tuples all possible combinations of tuples from R1 and R2
Division /
Cartesian product x
UNION U
THETA JOIN ∞
The result of the relational algebra operation T1*T2 , where T1 and T2 are tables of degree 3 is
A table of degree 3 attributes
A table with degree 9 attributes
A table of degree 6 attributes
From the previous question, if T1 has 100 tuples, and T2 has 150 tuples then T1xT2 will result……tuples.
150
1000
250
15000
If T1 has n1 tuples, and T2 has n2 tuples then T1 ꚙ T2 will result……tuples.
More than n1*n2
Less than n1*n2
Equal to n1*n2
Equal to n1+n2
….. Produces all combinations of tuples from R1 and R2 that satisfy the join condition
SELECT σ
Cartesian product x
UNION U
THETA JOIN ∞
General case of JOIN operation is called a………
Beta join
Gamma join
Theta join
Alpha join
……. Operation combines the sequence of CARTESIAN PRODECT followed by SELECT into a single operation
Union
Select
Join
Difference
Produces all combinations of tuples from R1 and R2 that satisfy the join condition with only equality comparisons.
EQUIJOIN
NATURAL JOIN
UNION U
THETA JOIN
The set of operations {SELECT α, PROJECT π, UNION U , DIFFERENCE -, RENAME , and CARTESIAN PRODUCT X} is called ……..
Subset
Multi set
Complete set
Full set
Produces a relation R(X) that includes all tuples t(X) in R1(Z) that appear in R1 in combination with every tuple from R2(Y), where Z=X U Y
Division R1(Z) /R2(Y)
Cartesian product R1(Z)xR2(Y)
UNION R1(Z) U R2(Y)
JOIN R1(Z) ∞R2(Y)
Input to a relational algebra operation is one or more relations
True
False
A query can take only one relational algebra operation
True
False
Final result of relational algebra stored in the database permanently
True
False
Final result of relational algebra operations is a relation that represents the result of a database query (or retrieval request)
True
False
SELECT operation σ(R) produces a relation S that has the same schema (same attributes) as R
True
False
The output of project operation π can have redundant tuples
True
False
For CARTESIAN PRODUCT Operation, the relations have to be "type compatible’
True
False
The result of Relational Algebra operation is a new relation
True
False
The SELECT operation is same as SELECT clause of SQL
True
False
In SELECT operation, tuples that make the condition true are selected.
True
False
In UNION operation, the two-operand relations R and S must be “type compatible”.
True
False
Normalization is a process for assigning ………
Attributes to entities
Attributes to relations
Attributes to relationships
Attributes to tuples
Which of the following is true about normalization?
It reduces data redundancies.
It helps eliminate the data anomalies.
It's probably most valuable as a way of evaluating and correcting DB design.
All of the mentioned.
Which of the following is a problem with the design based?
It doesn't fit in a Relational DB – not a table.
The table displays data redundancies.
The table entries invite data inconsistencies.
All of the mentioned.
In Normalization Process each table represents a ……… subject.
Multiple
Single
Both a & b
None of the mentioned
The data redundancies yield the following anomalies
Update anomalies
Addition anomalies
Deletion anomalies
All of the above
A functional dependency is a relationship between or among………
Entities
Rows
Attributes
Tables
Which of the following is true about the dependency diagram?
It Depicts all dependencies found within a given table structure
It's Helpful in getting bird’s-eye view of all relationships among a table’s attributes
It may make an important dependency to be overlooked
Both a & b
In the Dependency Diagram, the arrows above entities indicate………
All desirable dependencies
Partial dependencies
Transitive dependencies
All of the mentioned
In the Dependency Diagram, the arrows below the dependency diagram indicate………
Dependencies that are based on PK
Transitive dependencies
All of the mentioned
None of the mentioned
The term first normal form (1NF) describes the tabular format in which………
All the key attributes are not defined
There are no repeating groups in the table
All attributes are dependent on a foreign key
All of the mentioned
What is the correct arrangement for the following steps, in order to convert a database into the (2NF) format? (1) Writing the dependent attributes after each new key. (2) Writing the original key on the last line. (3) Writing each key component on a separate line
1, 2 & 3
2, 3 & 1
3, 2 & 1
3, 1 & 2
If the table has any partial dependencies or transitive dependencies, then you may end up with anomalies during ………
Inserts
Deletes
Updates
All of the above
A table is in 2NF if it is in 1NF and if ………
No column that is not a part of the primary key is dependent on only a portion of the alternate key
NO column that is not a part of the primary key is dependent on only a portion of the primary key
No column that is not a part of the primary key is dependent on only a portion of the foreign key
None of these
A function that has no partial functional dependencies is in ………
2NF
1NF
4NF
3NF
A table is in 3NF if it is in 2NF and if it has no ………
Functional Dependencies
Transitive dependencies
Trivial Functional Dependency
Multivalued Dependencies
It's possible that one or more attributes may be functionally dependent on nonkey attributes in ………
3NF
1NF
2NF
5NF
Which of the following steps is considered during the Conversion to Third Normal Form process?
Creating a separate table with attributes in a transitive functional dependence relationship.
Making any determinant (LHS of FD) gets its own table.
Both a & b
Keeping dependent attributes from the previous table
Normalization works through a series of stages called normal forms
True
False
The highest level of normalization is always desirable for real-world reasons
True
False
Repeating groups do not fit in a rectangular table
True
False
Normalization reduces data redundancies and helps eliminate the data anomalies
True
False
Repeating groups can be eliminated by adding the appropriate entry at least in the foreign key column(s).
True
False
Dependencies identified through understanding organization and its Business Rules
True
False
Dependencies can't be depicted with the help of a diagram
True
False
In Dependency Diagram the primary key components are bold, underlined, and shaded in a different color
True
False
Dependencies that are based on a primary key are not considered as desirable dependencies.
True
False
Less desirable dependencies include partial dependencies and transitive dependencies
True
False
In 1NF, all attributes are dependent on the primary key
True
False
2NF is a good enough form because the transitive dependency
True
False
Normalization should be part of the design process
True
False
E-R Diagram provides a macro view
True
False
Normalization provides micro view of attributes
True
False
Normalization may yield additional entities.
True
False
It's easy to separate normalization from E-R modeling
True
False
{"name":"Database Knowledge Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your understanding of database concepts and management systems with our comprehensive quiz! Perfect for students, professionals, or anyone interested in enhancing their database knowledge.Key Features:Multiple-choice questionsCovers essential database topicsScore and review your answers","img":"https:/images/course8.png"}