SQL Essentials Exam Questions With
Correct Answers A+
SQL stands for ...
A. Structured Query Language
B. Sequential Query Language
C. Structured Question Language
D. Sequential Question Language - Answer✔A
Which of the following is described graphically using an E-R diagram?
A. Data flows between processes
B. Data source and destination
C. Entities and relationships between entities
D. Hierarchical data structure - Answer✔C
SQL query and modification commands make up a(n)
A. DDL
B. DML
C. HTML
D. XML - Answer✔B
A/an ... is a piece of information that in some way describes an entity. It is a property of the
entity and it quantifies, qualifies, classifies of specifies the entity.
A. ERD
1|Page
, ©Jason McConnel 2025 ALL RIGHTS RESERVED.
B. Process
C. Table
D. Attribute - Answer✔D
What is the purpose of a Unique Constraint?
A. To uniquely determine a table and columns within that table.
B. To identify a specific row within a table, using one or more columns and/or foreign key.
C. Create an entity that is unlike any other entity aside from itself.
D. To identify one unique instance of an entity, by using one or more attributes and/or
relationships. - Answer✔D
Which of the following entities most likely contains invalid attributes?
A. Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built
B. Entity: Pet. Attributes: Name, Birthdate, Owner
C. Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
D. Entity: Mother. Attributes: Name, Birthdate, Occupation, Salary - Answer✔C
In a 1:N relationship, the foreign key is placed in:
A. either table without specifying parent and child tables
B. the parent table
C. the child table
D. either the parent table or the child table - Answer✔C
You are building a new database for a company with 10 departments. Each department contains
multiples employees. In addition, each employee might work for several departments. How
should you logically model the relationship between the department entity?
A. Create a mandatory one-to-many relationship between department and employees.
B. Create a new entry, create a one-to-many relationship from employee to the new entry, and
create a one-to-many relationship from the department entry to the new entry.
C. Create a new entry, create a one-to-many relationship from the new entry to the employee
entry, and then create a one-to-many relationship from the new entry to the department entry.
2|Page
, ©Jason McConnel 2025 ALL RIGHTS RESERVED.
D. Create an optional one-to-many relationship between department and employee. - Answer✔B
In which of the following can many entity instances of one type be related to many entity
instances of another type?
A. One-to-One Relationship
B. One-to-Many Relationship
C. Many-to-Many Relationship
D. Composite Relationship - Answer✔C
In a 1:1 relationship, the foreign key is placed in:
A. either table without specifying parent and child tables
B. the parent table
C. the child table
D. either the parent table or the child table - Answer✔A
What is MS SQLServer?
A. Microsoft SQL Server is a database platform for online Transaction Processing (OLTP).
B. Microsoft SQL Server is a database platform for data warehousing, e-commerce applications.
C. Microsoft SQL Server is also a business intelligence platform for data integration, analysis,
and reporting solutions.
D. Microsoft SQL Server is a database platform for online Transaction Processing (OLTP), data
warehousing, e-commerce application. It is also a business intelligence platform for data
integration, analysis, and reporting solutions. - Answer✔D
What is components of MS SQL Server?
A. Database Engine, Intergration Services, Reporting Services, Analysis Services.
B. Service Broker, Intergration Services, Replication Services, Analysis Services.
C. Service Broker, Intergration Services, Replication, Reporting Services, Full-Text Search.
D. Replication, Full-Text Search. Database Engine, Reporting Services, Analysis Services. -
Answer✔A
What is databasse engine?
3|Page
, ©Jason McConnel 2025 ALL RIGHTS RESERVED.
A. Database Engine is an application programing interface (API)
B. Database Engine is a complete set of tools that you can use to create and manage reports.
C. Database Engine is the core service for storing, processing, and securing data.
D. Database Engine is supporting rapid analysis of business data. - Answer✔C
What is integration services (SSIS)?
A. Integration Services (SSIS) is support dor messaging and queuing applications.
B. Integration Services (SSIS) is a platform for building high performance data intergration
solutions, including extraction, transformation, and load packages for data warehousing.
C. Integration Services (SSIS) is synchronizing between databases to maintain consistency.
D. Integration Services (SSIS) is developing applications that generate and send notifications. -
Answer✔B
What data type is "Distance from home to school" should be?
A. Decimal
B. Int
C. Bigint
D. Text - Answer✔A
Which of the following is not an operator in categories of SQL Comparison Operators?
A. Not less than (!<)
B. Less than or equal to (<=)
C. Addition (+)
D. Not greater than (!>) - Answer✔C
What is the storage size of smallmoney data type?
A. 3 bytes
B. 2 bytes
C. 4 bytes
4|Page