Topic: Fundamentals of Database Systems Choose the letter of the correct answer. Answer only no explanation. Thank you. 1. Using the Navicat MySQL, what is the correct command to perform if you want to load or open a database from a different location or drive? a. Save Database b. Create Database c. Execute batch file d. Dump SQL file 2. Eliminating modification anomalies is a(n) of normalization. a. advantage b. disadvantage c. either an advantage or disadvantage d. neither an advantage nor disadvantage 3. What SQL command is used to extract records from database? a. DELETE b. INSERT c. SELECT d. UPDATE 4. What is the role of Data Definition Language in database records? a. It defines indexes and imposes constraints between database tables b. It is a syntax used for executing queries c. It is used for creating reports d. It is used for creating the graphical user interface 5. A relation is in 1NF if it doesn't contain any __? a. Determinants b. Repeating groups c. Null values in primary key fields d. Functional dependencies 6. A table is in 2NF if the table is in 1NF and what other condition is met? a. There are no functional dependencies. b. There are no null values in primary key fields. c. There are no repeating groups. d. There are no attributes that are not functionally dependent on the relation's primary key. 7. If every non-key attribute is functionally dependent on the primary key, then the relation will be in _ form a. 1NF b. 2NF c. 3NF d. Fully Normalized

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 3PSE

See similar textbooks

Related questions

Concept explainers

Question

Topic: Fundamentals of Database Systems Choose the letter of the correct answer. Answer only no explanation. Thank you. 1. Using the Navicat MySQL, what is the correct command to perform if you want to load or open a database from a different location or drive? a. Save Database b. Create Database c. Execute batch file d. Dump SQL file 2. Eliminating modification anomalies is a(n) ________ of normalization. a. advantage b. disadvantage c. either an advantage or disadvantage d. neither an advantage nor disadvantage 3. What SQL command is used to extract records from database? a. DELETE b. INSERT c. SELECT d. UPDATE 4. What is the role of Data Definition Language in database records? a. It defines indexes and imposes constraints between database tables b. It is a syntax used for executing queries c. It is used for creating reports d. It is used for creating the graphical user interface 5. A relation is in 1NF if it doesn't contain any ____________? a. Determinants b. Repeating groups c. Null values in primary key fields d. Functional dependencies 6. A table is in 2NF if the table is in 1NF and what other condition is met? a. There are no functional dependencies. b. There are no null values in primary key fields. c. There are no repeating groups. d. There are no attributes that are not functionally dependent on the relation's primary key. 7. If every non-key attribute is functionally dependent on the primary key, then the relation will be in ___ form a. 1NF b. 2NF c. 3NF d. Fully Normalized

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.