Podcast
Questions and Answers
Which file is used to store information that remains constant for a long time
Which file is used to store information that remains constant for a long time
- Backup file
- master file (correct)
- Data file
- Partial file
In 2NF which form of dependency is removed
In 2NF which form of dependency is removed
- Functional
- Transitive
- Associative
- Partial (correct)
Which of the following is a valid character constant
Which of the following is a valid character constant
- "a"
- '@' (correct)
- "b"
- 00
the output of a query is in form of a
the output of a query is in form of a
which of the following is used to associate entities with one another
which of the following is used to associate entities with one another
An attribute is also known as
An attribute is also known as
what is tge variable that is used by a function to receive an argument
what is tge variable that is used by a function to receive an argument
which of the following is used to write a character to a file
which of the following is used to write a character to a file
To find all names start with M from student table, the criteria is
To find all names start with M from student table, the criteria is
in which loop statement terminator is a part of its syntax
in which loop statement terminator is a part of its syntax
Study Notes
Database Fundamentals
- A file used to store information that remains constant for a long time is a database file.
Normalization
- In 2NF (Second Normal Form), partial dependency is removed.
Character Constants
- A valid character constant is enclosed in single quotes.
Query Output
- The output of a query is in the form of a table.
Entity Relationships
- Foreign keys are used to associate entities with one another.
Attributes
- An attribute is also known as a column.
Functions
- The variable that is used by a function to receive an argument is a parameter.
File Operations
- fputc is used to write a character to a file.
Query Criteria
- To find all names starting with M from the student table, the criteria is "WHERE name LIKE 'M%'".
Loop Statements
- In a do-while loop, the terminator is a part of its syntax.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your understanding of database normalization by answering this question about 2NF. Learn what type of dependency is removed in 2NF and improve your database design skills.
