Question 1

Explain why it is important to learn SQL.

Accepted Answer

Most modern DBMS products support SQL as

Question 2

SQL is a data sublanguage,not a complete programming language.

Accepted Answer

A) True 
 B)False

Question 3

What are SQL Built-in Functions?

Accepted Answer

SQL Built-in Functions are functions tha

Question 4

Using standard SQL,unmatched rows will not appear in the result of a join.

Accepted Answer

A) True 
 B)False

Question 5

Microsoft Access SQL commands are run within the SQL View of a Query window.

Accepted Answer

A) True 
 B)False

Question 6

Explain the essential format of the CREATE TABLE statement.

Accepted Answer

The essential format for the CREATE TABL

Question 7

To open a new Microsoft Access Query window,click the Query Design button on the Create command tab.

Accepted Answer

A) True 
 B)False

Question 8

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to add new student data to the STUDENT table?

Accepted Answer

A)  INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith'; 
B)  INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith'); 
C)  INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith'); 
D)  INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith'; 
E)  INPUT INTO STUDENT (123, 'Jones', 'Smith'); 
A)  INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith'; 
B)  INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith'); 
C)  INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith'); 
D)  INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith'; 
E)  INPUT INTO STUDENT (123, 'Jones', 'Smith');

Question 9

For a column to be defined as the primary key using table constraints,the column must have been given the property NULL.

Accepted Answer

A) True 
 B)False

Question 10

The result for SELECT statements in SQL is a relation unless the result is a single number.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Accepted Answer

A)  text(10) 
B)  char(10) 
C)  varchar(10) 
D)  fixed(10) 
E)  length(10) 
A)  text(10) 
B)  char(10) 
C)  varchar(10) 
D)  fixed(10) 
E)  length(10)

Question 12

Explain how to run an SQL query in Microsoft Access.

Accepted Answer

To run an SQL query in Microsoft Access,

Question 13

Explain two methods for defining a primary key using SQL.

Accepted Answer

A primary key may be defined by either t

Question 14

Discuss SQL data types.

Accepted Answer

Common examples of standard SQL data typ

Question 15

Using SQL commands,multiple tables can be queried so that all the values from one table appear in the results,regardless of whether they have one or more corresponding values in the other table,by using the SQL ________ command.

Accepted Answer

The answer of Using SQL commands,multiple tables can be queried...

Question 16

Compare and contrast subqueries and joins.

Accepted Answer

Subqueries and joins are both used to pr

Question 17

Microsoft Access can run QBE queries,but not SQL queries.

Accepted Answer

A) True 
 B)False

Explain why it is important to learn SQL.

SQL is a data sublanguage,not a complete programming language.

What are SQL Built-in Functions?

Using standard SQL,unmatched rows will not appear in the result of a join.

Microsoft Access SQL commands are run within the SQL View of a Query window.

Explain the essential format of the CREATE TABLE statement.

To open a new Microsoft Access Query window,click the Query Design button on the Create command tab.

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to add new student data to the STUDENT table?

For a column to be defined as the primary key using table constraints,the column must have been given the property NULL.

The result for SELECT statements in SQL is a relation unless the result is a single number.

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Explain how to run an SQL query in Microsoft Access.

Explain two methods for defining a primary key using SQL.

Discuss SQL data types.

Using SQL commands,multiple tables can be queried so that all the values from one table appear in the results,regardless of whether they have one or more corresponding values in the other table,by using the SQL ________ command.

Compare and contrast subqueries and joins.

Microsoft Access can run QBE queries,but not SQL queries.

Getting Started

The Relational Model

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 3: Structured Query Language

Explain why it is important to learn SQL.

SQL is a data sublanguage,not a complete programming language.

What are SQL Built-in Functions?

Using standard SQL,unmatched rows will not appear in the result of a join.

Microsoft Access SQL commands are run within the SQL View of a Query window.

Explain the essential format of the CREATE TABLE statement.

To open a new Microsoft Access Query window,click the Query Design button on the Create command tab.

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to add new student data to the STUDENT table?

For a column to be defined as the primary key using table constraints,the column must have been given the property NULL.

The result for SELECT statements in SQL is a relation unless the result is a single number.

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Explain how to run an SQL query in Microsoft Access.

Explain two methods for defining a primary key using SQL.

Discuss SQL data types.

Using SQL commands,multiple tables can be queried so that all the values from one table appear in the results,regardless of whether they have one or more corresponding values in the other table,by using the SQL ________ command.

Compare and contrast subqueries and joins.

Microsoft Access can run QBE queries,but not SQL queries.

Getting Started

The Relational Model

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters