• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 4 fuera de 39 páginas
Examen

SQL Essentials Exam Questions With Correct Answers A+

Document preview thumbnail
Vista previa 4 fuera de 39 páginas

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 - AnswerA 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 - AnswerC SQL query and modification commands make up a(n) A. DDL B. DML C. HTML D. XML - AnswerB 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 ©Jason McConnel 2025 ALL RIGHTS RESERVED. 2 | P a g e B. Process C. Table D. Attribute - AnswerD 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. - AnswerD 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 - AnswerC 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 - AnswerC 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. ©Jason McConnel 2025 ALL RIGHTS RESERVED. 3 | P a g e D. Create an optional one-to-many relationship between department and employee. - AnswerB 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 - AnswerC 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 - AnswerA 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. - AnswerD 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. - AnswerA What is databasse engine?

Vista previa del contenido

©Jason McConnel 2025 ALL RIGHTS RESERVED.




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

Información del documento

Subido en
7 de enero de 2025
Número de páginas
39
Escrito en
2024/2025
Tipo
Examen
Contiene
Preguntas y respuestas
$10.99

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
StarGuide
3.8
(6)
Vendido
22
Seguidores
0
Artículos
2585
Última venta
1 mes hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes