Database Management Quiz

What does RDBMS mean?

• Required Database Management Setup

• Relational Database Management System

• Rational Design By Multiple Steps

• None of the above

What does SQL stand for?

• Structured Question Language

• Strong Query Language

• Structure Query Language

• Simple Query Language

Which of these are Database Types?

• Relational

• Object Oriented

• NoSQL

• Hierarchical

What is a set of data for one entity called?

• Field

• Row

• Entity

• Record

A single person, place or thing about which data can be stored?

• Field

• Attribute

• Record

• Entity

A diagram showing the interrelationships between different entities and their attributes?

• Data flow diagram

• Entity Relationship diagram

• Database Relationship diagram

• Relational Schema

One or more attributes that uniquely identify each record in a table

• Primary key

• Foreign Key

• Database Key

• Composite Key

An association between entities

• Relationships

• Links

• Joins

• Connections

Which SQL statement is used to extract data from a database?

• SELECT

• INSERT

• UPDATE

• DELETE

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

• EXTRACT FirstName from Persons

• SELECT Persons.FirstName

• SELECT FirstName FROM Persons

• SELECT * FROM Persons