ICD521 C# Programming and SQL Basics Quiz 2

What is C#?

• C# is a type of musical note.

• C# is a programming language developed by Microsoft.

• C# is a new brand of coffee.

• C# is a term used in carpentry.

What are the basic data types in C#?

• int, double, char, bool, string

• array

• long

• float

Explain the concept of classes and objects in C#.

• Classes in C# define the structure and behavior of objects, while objects are specific instances of classes with their own data and functionality.

• Classes are used to define functions in C#

• Classes and objects are interchangeable in C#

• Objects are only used for data storage in C#

What is SQL and its importance in database management?

• SQL is primarily used for video editing

• SQL is only used for graphic design

• SQL is a programming language for web development

• SQL is a standard language for managing relational databases and is crucial for data manipulation and retrieval tasks.

Differentiate between SQL and NoSQL databases.

• SQL databases are relational and use structured query language, while NoSQL databases are non-relational and more flexible.

• NoSQL databases are relational and less flexible.

• SQL databases are non-relational and use structured query language.

• SQL databases are non-relational and less flexible.

What are the basic SQL commands for data manipulation?

• SELECT, INSERT, UPDATE, DELETE

• CLEAR

• ADD

• MODIFY

How can you connect a C# application to a SQL database?

• Use ADO.NET classes like SqlConnection, SqlCommand, and SqlDataReader to establish a connection, execute queries, and retrieve data from the SQL database.

• Utilize JavaScript frameworks like React to interact with the SQL database

• Manually write SQL queries in the C# code to connect to the database

• Use Python libraries like Pandas and NumPy to establish a connection

Explain the concept of primary keys and foreign keys in SQL.

• Foreign keys are used to delete records from a table

• Primary keys can have duplicate values in SQL

• In SQL, primary keys uniquely identify each record in a table, while foreign keys establish relationships between tables by referencing the primary key of another table.

• Primary keys are used for sorting data in SQL

What is normalization in database design?

• Normalization in database design is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization is the process of adding redundancy to improve data integrity

• Normalization involves organizing data in a database to increase redundancy

• Normalization in database design is the process of reducing data integrity

Discuss the importance of indexing in SQL.

• Indexing in SQL only works for specific data types.

• Indexing in SQL is irrelevant and slows down query performance.

• Indexing in SQL is primarily used for data encryption.

• Indexing in SQL is important for enhancing query performance by facilitating quick data retrieval.