Database Concepts and DBMS Fundamentals quizzes
201 quizzes by 141 users · Page 1 of 6
This GoConqr page gathers over 170 community-made quizzes on database concepts and DBMS fundamentals, from data and foreign keys to query processing. They offer university students and professional candidates, school students, and teachers material for practicing database topics. The quizzes were made by over 110 users. Pick a quiz and see which topics you want to study further.
Select topic
- Data, Information and Uses of Databases10
- DBMS Features and Data Independence19
- Database Structure, Fields, Records and Data Types18
- Types of Databases57
- Database Architecture13
- Relational Databases and the Relational Model61
- Database Keys and Relationships35
- Database Design and Entity-Relationship Diagrams24
- Database Normalisation24
- SQL and Database Queries65
- Data Validation and Database Security25
- Transaction Management and Concurrency Control10
- Database Storage, Indexing and Query Processing13
- Data Warehousing and Emerging Database Technologies25
Quizzes
-
145 questionsSQL Server MTA 98-364 The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
-
75 questionsC175 Alternate Practice Test Database Foundations
-
49 questionsC175 - Practice Test What is a broad definition of data?
-
60 questionsCHAPTER 11: DATABASE PERFORMANCE TUNING AND QUERY OPTIMIZATION 1. One of the main functions of a database system is to provide timely answers to end users.
-
40 questionsChapter 16 (Multiple Choice) CIS 3365
-
40 questionsChapter 9 (Multiple Choice) CIS 3365
-
30 questionsChapter 10 (MC)
-
35 questionsMNSU CIS 440 Fall 2020 Quiz 4 Cursors are created using the DECLARE statement.
-
30 questionsChapter 1(Multiple Choice) CIS 3365
-
34 questionsMNSU CIS 440 Fall 2020 Quiz 1 If a foreign key contains either matching values or nulls, the tables that make use of such a foreign key a...
-
30 questionsChapter 9 (True/False) 1. Database designs that fail to recognize that the database is part of a larger information system are not...
-
17 questionsChapter 11 (MC) 1. On the client side, the objective is to generate a SQL query that returns the correct answer in the leas...
-
16 questionsDatabases Topic 1 Quiz What do the privileges associated with your role (the STUDENT role) allow you to do?
-
16 questionsSQL 1: Databases (Module 3) Every SQL server database installation should consist of at least 3 files. The primary, secondary, and a lo...
-
10 questionsQuery Processing Query Processing
-
15 questionsCET_TARDE - MTA Database - DIAGNOSTIC3 What do you call the elimination of redundant data?
-
20 questionsChapter 1 (True/False) CIS 3365 1. Data and information are essentially the same thing
-
10 questionsAccess 2 Which of the following contains a unique value for each record?
-
10 questionsOnline Test-Database Concepts Database is called "self-describing" because it contains a description of itself.
-
2 questionsDatabases 1 - 4A Which of the following are database objects? (Choose 4)
-
167 questionsDATABASE ++++++ + Data in a database is stored in:
-
25 questionsDatabase Design 1 Which SQL keyword is used to specify conditional search?
-
80 questionsOracle Database 19c Dataguard Which THREE statements are true about the states of a physical standby database that is open in real- time ...
-
180 questionskarl_dbdbdb Define a degree of a relation
-
180 questionsDatabaseInIS 1. Define a degree of a relation
-
200 questionsReading Exam Questions What is data governance?
-
200 questionsIS301 - Intro to Database Management Systems
-
160 questionsUntitled In a database system, whose responsibility is it to provide data consistency?
-
35 questionsSU 5.1 Of the following, the greatest advantage of a database (server) architecture is
-
89 questionsГОС по БД #1 Define a degree of a relation
-
38 questionsDatabase Fundamental Ch 1 - 3 High-school student Rajesh M. Patel works part-time in his dad’s cycle shop in Pune, India. Pune was the fi...
-
156 questionsIt For efficiency purposes, data analysis should be done on the production database.
-
141 questionsSDP 6 (2) edit
-
77 questionsDBIS Define a degree of a relation
-
87 questions98-364 PRACTICE EXAM v9.0 The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
-
158 questionsDatabase Design & Implementation Mid Term Study The purpose of a database is to help people keep track of things.
-
113 questionsSDP 6 (2) Quiz on SDP 6 (2), created by eldar khasen on 17/12/2017.
-
113 questions(2)
-
113 questionsSDP 6 (2) Quiz on SDP 6 (2), created by eldar khasen on 17/12/2017.
-
113 questionsSDP 6 (2)
More Database Concepts and DBMS Fundamentals resources
About database concepts and dbms fundamentals quizzes
GoConqr OriginalDatabase Concepts and DBMS Fundamentals quizzes
The quizzes on this page cover database structures, design and performance. C175 - Practice Test asks about data, unstructured data and flat files. Databases Topic 1 Quiz includes questions on roles and foreign keys, while Query Processing asks about indexes and the data cache.
Choosing a quiz
For a starting point, try C175 - Practice Test for its questions on basic data concepts. If you are preparing for MTA Database Fundamentals, SQL Server MTA 98-364 offers questions on indexes and database structures. You can also find quizzes on database security, relationships and distributed databases.
Study after a quiz
Note the questions you find difficult and group them by topic. Switch to a mind map on the unit page when you want an overview, or use flashcards to study terms before returning to a quiz. Choose a topic and give a quiz a try.
Frequently asked questions
Which quiz is a good place to start?
C175 - Practice Test is a useful starting point if you want questions on data concepts. It asks about definitions of data, unstructured data and flat files. If you want to focus on roles and foreign keys instead, Databases Topic 1 Quiz covers those topics.
Are the quizzes free to use?
Yes. Every quiz listed here is free to open and take without an account. A free account can also save your quiz scores and let you make your own quizzes, mind maps, flashcards and notes. The listed resources were made by GoConqr users.
Who can use these quizzes for practice?
University students and professional candidates can practice topics such as database design and query processing. School students can use the quizzes to go over database concepts, and teachers can find ready-made questions. SQL Server MTA 98-364 also offers practice on indexes and database structures.