This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 36 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 36 (50 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: A) GROUP BY X. B) FROM. C) ORDER BY. D) WHERE X. Show Answer Correct Answer: C) ORDER BY. 2. In a student database, which of these would most likely be a field? A) The student's age. B) The entire student body. C) A single student. D) The school building. Show Answer Correct Answer: A) The student's age. 3. You have a procedure:CREATE PROC sp ..... LogEvent @EventMessage VARCHAR(200), @EventID INT OUTPUT. Which statement correctly retrieves the auto-generated ID after logging an event? A) SET @EventID = @@IDENTITY;. B) SET @EventID = IDENT CURRENT('Events');. C) SET @EventID = SCOPE IDENTITY();. D) SET @EventID = @EventMessage;. Show Answer Correct Answer: C) SET @EventID = SCOPE IDENTITY();. 4. Which keyword in an UPDATE command decides which record gets changed? A) LIKE. B) FROM. C) SET. D) WHERE. Show Answer Correct Answer: D) WHERE. 5. What is one advantage of using a DBMS? A) Less security. B) Increased redundancy. C) Controlled redundancy. D) More manual work. Show Answer Correct Answer: C) Controlled redundancy. 6. Why should you avoid using calculated fields like 'age' in your database? A) They are difficult to format. B) They require special software. C) They can become outdated or inconsistent. D) They are hard to print. Show Answer Correct Answer: C) They can become outdated or inconsistent. 7. What is the role of fields in a database table? A) To display images. B) To send notifications. C) To play background music. D) To determine the type of information stored. Show Answer Correct Answer: D) To determine the type of information stored. 8. Indicate whether the statement is true or false:DBMS have a data definition capability to specify the structure of the content of the database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 9. Which SQL command is used to add new rows to a table? A) UPDATE. B) ALTER TABLE. C) DELETE FROM. D) INSERT INTO. Show Answer Correct Answer: D) INSERT INTO. 10. How many types of relationships are there in databases? A) 4. B) 2. C) 3. D) 1. Show Answer Correct Answer: C) 3. 11. For a 'one-to-one' relationship to be established between two tables, what specific condition must the linked fields meet? A) One field must be numeric, and the other must be alphanumeric. B) The linked fields in both tables must contain the same unique values. C) Both fields must be set to the AutoNumber data type. D) One table must be a flat-file, and the other must be relational. Show Answer Correct Answer: B) The linked fields in both tables must contain the same unique values. 12. What is meant by use case in system development? A) Model of data flow between modules. B) System performance specifications. C) Description of how users interact with the system. D) User interface design. E) List of tables in the database. Show Answer Correct Answer: C) Description of how users interact with the system. 13. Which of the following is a type of database model? A) Network model. B) Hierarchical model. C) Object-oriented model. D) Relational model. Show Answer Correct Answer: D) Relational model. 14. Indicate whether the statement is true or false:Spanner is an example of a distributed database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 15. Tables in second normal form (2NF): A) Eliminate all hidden dependencies. B) Eliminate the possibility of a insertion anomalies. C) Have a composite key. D) Have all non key fields depend on the whole primary key. Show Answer Correct Answer: A) Eliminate all hidden dependencies. 16. What is the main difference between relational and non-relational databases? A) Relational databases use tables, while non-relational do not. B) Non-relational databases are more secure. C) Non-relational databases are easier to use. D) Relational databases are faster. Show Answer Correct Answer: A) Relational databases use tables, while non-relational do not. 17. Manakah yang merupakan contoh dari relasi one to one A) Mahasiswa dan mata pelajaran. B) Warga negara dan nomor KTP. C) Negara dan kota. D) Mahasiswa dan kampus. Show Answer Correct Answer: B) Warga negara dan nomor KTP. 18. How can you optimize a subquery for better performance? A) Use JOINs instead of subqueries, limit returned data, and index relevant columns. B) Use nested subqueries for all data retrieval. C) Select all columns without filtering results. D) Avoid indexing columns to reduce complexity. Show Answer Correct Answer: A) Use JOINs instead of subqueries, limit returned data, and index relevant columns. 19. What does clicking OK after renaming a table do? A) Deletes the table. B) Saves the new table name. C) Closes MS Access. D) Restarts the software. Show Answer Correct Answer: B) Saves the new table name. 20. What must you do to maintain data integrity when you normalize a relation by breaking it into two smaller relations? A) Create a primary key(s) for the new relation. B) Denormalize the data. C) Assign both relations the same primary key field(s). D) Remove any functional dependencies from both relations. Show Answer Correct Answer: A) Create a primary key(s) for the new relation. 21. Which symbol is used as a wildcard for multiple characters in LIKE? A) . B) *. C) ?. D) %. Show Answer Correct Answer: D) %. 22. Quale tipo di attributo ha un tipo semplice, come numeri interi o stringhe? A) Multiplo. B) Composto. C) Opzionale. D) Semplice. Show Answer Correct Answer: D) Semplice. 23. A field in a database table whose values are the same as the primary key of another table is called ..... A) An alternate key. B) A foreign key. C) A primary key. D) Metadata. Show Answer Correct Answer: B) A foreign key. 24. In the relational table, which of the following can also be represented by the term 'attribute'? A) Entity. B) Row. C) Column. D) Both A and C. Show Answer Correct Answer: C) Column. 25. The select operation ..... A) Combines relational tables to provide the user with more information than is otherwise available. B) Creates a subset consisting of rows in a table that meet stated criteria. C) Identifies the table from which the columns will be selected. D) Creates a subset consisting of all records in a file. Show Answer Correct Answer: B) Creates a subset consisting of rows in a table that meet stated criteria. 26. What is one to one relationship means? A) Each record in the first table is related to only one record in the second table, but not vice versa. B) Each record in the first table is related to only one record in the second table, and vice versa. C) Each record in the first table is not related to any record in the second table. D) Each record in the first table is related to multiple records in the second table. Show Answer Correct Answer: B) Each record in the first table is related to only one record in the second table, and vice versa. 27. What is the purpose of using a TRY ..... CATCH block within a stored procedure that contains a transaction? A) To improve the performance of the COMMIT command. B) To define the OUTPUT parameters of the procedure. C) To handle unexpected system errors and ensure a ROLLBACK is issued. D) To bypass the SERIALIZABLE isolation level. Show Answer Correct Answer: C) To handle unexpected system errors and ensure a ROLLBACK is issued. 28. Which SQL keyword is used to return specific columns? A) RETURN. B) SHOW. C) SELECT. D) OUTPUT. Show Answer Correct Answer: C) SELECT. 29. What is a column in a database? A) A single attribute of a record. B) A single image. C) A single folder. D) A single file. Show Answer Correct Answer: A) A single attribute of a record. 30. Information about NoSQL databases A) There are several problems with the operation of big data, which can be effectively solved with a relational database. B) Graph-oriented databases use graph theory to store, display, and query relationships. C) OLTP is another type of database that can quickly process requests and maintain data integrity in multiple available environments. D) This type of DBMS uses parent-generation relationships to store data. E) None. Show Answer Correct Answer: A) There are several problems with the operation of big data, which can be effectively solved with a relational database. 31. Which high-level language was developed in 1995 and is widely used for web applications? A) C++. B) Java. C) BASIC. D) FORTRAN. Show Answer Correct Answer: B) Java. 32. Who are the typical users and administrators of a database system? A) System administrators, network engineers, project managers. B) Marketing specialists, graphic designers, content creators. C) Sales representatives, customer support agents, IT technicians. D) End-users, data analysts, developers, and database administrators (DBAs). Show Answer Correct Answer: D) End-users, data analysts, developers, and database administrators (DBAs). 33. Which command is used to rename a collection? A) Db.collection.renameCollection(). B) Db.renameCollection(). C) Db.collection.rename(). D) Db.collection.renameTo(). Show Answer Correct Answer: D) Db.collection.renameTo(). 34. Which of the following is an example of an input mask? A) Allowing only numbers in a phone number field. B) Sorting data in alphabetical order. C) Formatting reports for printing. D) Storing text in a lookup field. Show Answer Correct Answer: A) Allowing only numbers in a phone number field. 35. What does middleware do in an information system? A) It enables communication between users and applications. B) It enables communication between applications or data bases. C) It enables communication between users. D) None of the above. Show Answer Correct Answer: B) It enables communication between applications or data bases. 36. What is the external level in a database architecture concerned with? A) End-user interaction. B) Data storage. C) Data modeling. D) Security enforcement. Show Answer Correct Answer: A) End-user interaction. 37. How can indexing improve database performance? A) Indexing enhances data retrieval speed and efficiency in databases. B) Indexing increases the amount of data stored in the database. C) Indexing slows down data retrieval processes. D) Indexing makes data updates more complex and time-consuming. Show Answer Correct Answer: A) Indexing enhances data retrieval speed and efficiency in databases. 38. Which is the earliest data model? A) ER. B) Hierarchical. C) Relational. D) Network. Show Answer Correct Answer: B) Hierarchical. 39. What is the primary purpose of data validation? A) To encrypt sensitive data. B) To ensure entered data meets predefined rules and constraints. C) To speed up database queries. D) To create backups of the database. Show Answer Correct Answer: B) To ensure entered data meets predefined rules and constraints. 40. What is the significance of primary keys in a database? A) Primary keys are used to store large amounts of data. B) Primary keys are optional for all database tables. C) Primary keys can be duplicated across records. D) Primary keys ensure uniqueness and integrity of records in a database. Show Answer Correct Answer: D) Primary keys ensure uniqueness and integrity of records in a database. 41. Which constraint prevents NULL values in a column? A) PRIMARY KEY. B) NOT NULL. C) CHECK. D) UNIQUE. Show Answer Correct Answer: B) NOT NULL. 42. What is a record? A) A complete set of related fields. B) A link between two tables. C) A column in a table. D) A table of multiple databases. Show Answer Correct Answer: A) A complete set of related fields. 43. Which view in MS Access displays data in a spreadsheet-like format? A) Form View. B) Datasheet View. C) Design View. D) Report View. Show Answer Correct Answer: B) Datasheet View. 44. Fields are made up of records. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 45. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator? A) Archetype entity. B) Subtype entity. C) Supertype entity. D) Instance entity. Show Answer Correct Answer: B) Subtype entity. 46. Which of the following is NOT an advantage of using a DBMS? A) Data integrity. B) Data complexity. C) Data backup and recovery. D) Data sharing. Show Answer Correct Answer: B) Data complexity. 47. Data redundancy occurs when: A) Data is stored efficiently. B) The same data is stored multiple times. C) No relationships exist between tables. D) Data is stored in one table only. Show Answer Correct Answer: B) The same data is stored multiple times. 48. What are the normal forms in database normalization? A) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. B) 1NF, 2NF, 3NF, 4NF, 8NF. C) 1NF, 2NF, 3NF, 5NF, 9NF. D) 1NF, 2NF, 3NF, 6NF, 7NF. Show Answer Correct Answer: A) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. 49. Which statement is used to assign a value to a variable in T-SQL? A) ASSIGN. B) SET. C) DEFINE. D) UPDATE. Show Answer Correct Answer: B) SET. 50. Which of the following is NOT a component of a database? A) Record. B) Formula. C) Table. D) Field. Show Answer Correct Answer: B) Formula. ← PreviousRelated QuizzesScience QuizzesClass 11 QuizzesClass 11 Computer Science Chapter 7 Database Concepts Quiz 1Class 11 Computer Science Chapter 7 Database Concepts Quiz 2Class 11 Computer Science Chapter 7 Database Concepts Quiz 3Class 11 Computer Science Chapter 7 Database Concepts Quiz 4Class 11 Computer Science Chapter 7 Database Concepts Quiz 5Class 11 Computer Science Chapter 7 Database Concepts Quiz 6Class 11 Computer Science Chapter 7 Database Concepts Quiz 7Class 11 Computer Science Chapter 7 Database Concepts Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books