Database Management

WhatsApp Channel Join Now
Telegram Group Join Now

41. The process of combining data from multiple databases into a single, coherent view is called:
A) Data Integration
B) Data Aggregation
C) Data Normalization
D) Data Validation

Answer: A
View Answer >

42. Which SQL keyword is used to sort the result set in ascending order?
A) ASC
B) ORDER
C) SORT
D) BY

Answer: A
View Answer >

43. In a relational database, an index is used to:
A) Create a relationship between two tables
B) Define the primary key for a table
C) Speed up data retrieval
D) Ensure data integrity

Answer: C
View Answer >

44. Which normal form allows a table to have non-key attributes that depend on other non-key attributes?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Fourth Normal Form (4NF)

Answer: B
View Answer >

45. Which SQL function is used to find the minimum value in a column?
A) MIN()
B) AVG()
C) COUNT()
D) MAX()

Answer: A
View Answer >


WhatsApp Channel Join Now
Telegram Group Join Now
                                                   

Leave a Comment

telegram Join Telegram
Join Now Join Now