Global MCQ Practice

🌐 Total MCQ
🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

Class 11 Computer Science Chapter 7 Database Concepts Quiz 18 (60 MCQs)

Quiz Instructions

Select an option to see the correct answer instantly.

1. What is the role of a data warehouse in business intelligence?
2. Which of the following SQL queries is used to retrieve records having open ..... bal between 15000 to 20000 by selecting the right command:
3. What is a key benefit of using offline databases?
4. What are the advantages of using views in a database?
5. A row in a database.
6. Which of the following is NOT a feature of a relational database?
7. Apa kepanjangan dari ERD?
8. What can Select Queries do with data?
9. What does a record (or row) in a database table represent?
10. Which data type is appropriate for storing long paragraphs of text?
11. What does the 'I' in ACID properties stand for?
12. Which of the following is a feature of NoSQL databases?
13. Which SQL operator compares a value with all values in a subquery?
14. How are "Fields" defined in a Microsoft Excel flat file database?
15. What is the benefit of using an ER model before creating a physical database?
16. A relation is in 1NF if it doesn't contain any ..... ?
17. ..... is a container of database objects in Microsoft Access.
18. Select * from ..... ;
19. Which of the following is a characteristic of unstructured data?
20. With reference to SQL, identify the invalid data type.
21. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). Which of the following best defines a field?
22. What is the primary key in a table?
23. Which of the following is a real-world example of a database in a library?
24. Dalam diagram use case, aktor biasanya digambarkan dengan:
25. ..... ensures users can access data at the same time.
26. A database relationship is established by:
27. Which property ensures "all or nothing" execution?
28. Perintah berikut ada dalam Bahasa Data Defintion Language, kecuali .....
29. Which of the following is a common DBMS?
30. In a hospital database, which table would contain information about patients?
31. Which type of data model is simpler and easier to read?
32. A database is a ..... collection of related data.
33. Related fields in a database are grouped to form a
34. How does a foreign key function in a database?
35. ER models are useful for designing the structure of relational databases.
36. Which SQL command would you use to add a new row to a table?
37. An entity is represented by what in a database?
38. What is an attribute in a database?
39. Why is it important to choose the correct data type for a field in a database?
40. What are the common data types used in database tables?
41. Which SQL command is used to create a new table?
42. Which of the following is an advantage of a flat file database?
43. The ..... operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple
44. Database Management System (DBMS)
45. What are the key components of a database?
46. A subquery inside another query that references outer query columns is called:
47. What can queries perform on data besides extracting it?
48. Entities can be associated with one another in which of the following?
49. Which of the following technologies would you use to analyze the social media data collected by a major online retailer?
50. The SQL used by front-end application programs to request data from the DBMS is called .....
51. In a one-to-one relationship, how many records in one table can be associated with records in another table?
52. Which type of relationship is the most common in databases?
53. Which data type can store up to 1 gigabyte of data?
54. An attribute in a database refers to:
55. The command to update multiple documents is:
56. Perintah SQL yang benar untuk membuat database baru bernama 'siswa' adalah .....
57. Entity in a database
58. Which of the following is a characteristic of a digital database?
59. What is a "primary key" in a database table?
60. Which of the following is a characteristic of object-oriented database structures?
🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books