Home > Databases > Quizzes > DBMS Basics Practice Test: Database Systems Design and Implementation
DBMS Basics Practice Test: Database Systems Design and Implementation
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 72% • Most missed: “How can the values in the relation teaches be deleted?”
Quiz questions on E-R model, E-R design, constraints, atomic domains and querying databases like DDL and DML. Database implementation is the process of: installing database software, performing configuration and customization, running and testing the database, integrating it with applications, and training the users.  Some critical points to keep in mind for a good database design include: Maintaining data consistency and integrity, Low redundancy, Faster searching through indices, Security measures, and Storing data in fragmented bits of information.  The steps in database design... Show more
DBMS Basics Practice Test: Database Systems Design and Implementation
Time left 00:00
25 Questions

1. Which of the following is a single valued attribute
2. SELECT * FROM teaches WHERE Sec_id = 'CS-101';Which of the following Id is selected for the following query?
3. How can the values in the relation teaches be deleted?
4. In the section relation which of the following is used as a foreign key?
5. In the course relation, the title field should throw an error in case of any missing title. The command to be added in title is
6. Which of the following is another name for a weak entity?
7. SELECT Id, Course_id, Building FROM SECTION s AND teaches t WHERE t.year=2009;Which of the following Id are displayed?
8. A window into a portion of a database is
9. Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them.
10. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
11. In the above DDL command the foreign key entries are got by using the keyword
12. Given the basic ER and relational models, which of the following is INCORRECT?
13. Which of the following indicates the maximum number of entities that can be involved in a relationship?
14. To replace the relation section with some other relation the initial step to be carried out is
15. In order to include an attribute Name to the teaches relation which of the following command is used?
16. Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
17. The descriptive property possessed by each entity set is _________
18. Which one of the following uniquely identifies the elements in the relation?
19. Key to represent relationship between tables is called
20. In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.
21. Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________
22. The completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?
23. For a weak entity set to be meaningful, it must be associated with another entity set, called the
24. Which is the main relation which is used in the university database which is referenced by all other relation of the university?
25. Which of the following can be addressed by enforcing a referential integrity constraint?

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.