Question 1

DDL is typically used during which phase of the development process?

Accepted Answer

A)  Implementation 
B)  Physical design 
C)  Analysis 
D)  Evaluation 
A)  Implementation 
B)  Physical design 
C)  Analysis 
D)  Evaluation

Question 2

Indexes generally slow down access speed in most RDMS.

Accepted Answer

A) True 
 B)False

Question 3

In databases, null values are equivalent to zero.

Accepted Answer

A) True 
 B)False

Question 4

A single value returned from an SQL query that includes an aggregate function is called a(n):

Accepted Answer

A)  agate. 
B)  scalar aggregate. 
C)  vector aggregate. 
D)  summation. 
A)  agate. 
B)  scalar aggregate. 
C)  vector aggregate. 
D)  summation.

Question 5

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

Accepted Answer

A) True 
 B)False

DDL is typically used during which phase of the development process?

Indexes generally slow down access speed in most RDMS.

In databases, null values are equivalent to zero.

A single value returned from an SQL query that includes an aggregate function is called a(n):

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 6: Introduction to SQL

DDL is typically used during which phase of the development process?

Indexes generally slow down access speed in most RDMS.

In databases, null values are equivalent to zero.

A single value returned from an SQL query that includes an aggregate function is called a(n):

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters