Solve all mcqs given in it

Here are the solutions to the objective type questions:

1. A collection of related fields is called: b) Record A record is a collection of related fields that represent a single entity in a database.

2. In 3NF, a non-key attribute must not depend on: a) Non-key attribute In Third Normal Form (3NF), a non-key attribute must depend only on the primary key and not on any other non-key attribute (transitive dependency).

3. In an ER diagram, a rectangle represents: a) Entity Rectangles in Entity-Relationship (ER) diagrams are used to represent entities.

4. A virtual table that is created by selecting some columns from one or more tables is called: a) View A view is a virtual table based on the result-set of a SQL query. It contains rows and columns, just like a real table, but does not store data itself.

5. Which of the following is not a DDL command? d) SELECT DDL (Data Definition Language) commands are used to define and manage database structures (CREATE, ALTER, DROP). SELECT is a DML (Data Manipulation Language) command used to retrieve data.

6. Which of the following is not a valid data type in SQL? c) CURRENCY While some database systems might have a similar type, CURRENCY is not a standard SQL data type. INT, VARCHAR, and DATE are standard SQL data types.

7. Which of the following is used to retrieve data from a database? d) SELECT The SELECT statement is used to query the database and retrieve data that matches specified criteria.

8. Which of the following is used to remove a table from a database? c) DROP The DROP TABLE command is used to delete an entire table, including its structure and all data, from the database.

9. Which of the following is used to modify existing data in a table? b) UPDATE The UPDATE statement is used to change existing records in a table.

10. Which of the following is used to add new rows to a table? b) INSERT The INSERT INTO statement is used to add new records (rows) to a table.