Question 1

In SQL,the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.

Accepted Answer

A) True 
 B)False

Question 2

The ________ statement removes all data from a table while leaving the table structure,and also resets any surrogate primary key values back to the starting point.

Accepted Answer

The answer of The ________ statement removes all data from...

Question 3

Distinguish between the HAVING clause and the WHERE clause.

Accepted Answer

The HAVING clause and the WHERE clause d

Question 4

Which type of join,although not included in standard SQL,was created to allow unmatched rows to appear in the result of a join operation?

Accepted Answer

A)  ODD JOIN 
B)  OPEN JOIN 
C)  OUTER JOIN 
D)  INNER JOIN 
E)  COMBINE JOIN 
A)  ODD JOIN 
B)  OPEN JOIN 
C)  OUTER JOIN 
D)  INNER JOIN 
E)  COMBINE JOIN

Question 5

The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.

Accepted Answer

The answer of The SQL keyword(s)________ mean(s)that a value must...

Question 6

Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

Accepted Answer

A) True 
 B)False

Question 7

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

Accepted Answer

A)  WHERE 
B)  HAVING 
C)  LIKE 
D)  SORT 
E)  DISTINCT 
A)  WHERE 
B)  HAVING 
C)  LIKE 
D)  SORT 
E)  DISTINCT

Question 8

A complete table,including both the table structure and any data in the table,can be removed from the database by using the SQL ________ command.

Accepted Answer

The answer of A complete table,including both the table structure...

Question 9

In SQL,the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.

Accepted Answer

A) True 
 B)False

Question 10

When using SQL to create a table,specifying the NULL property for a column indicates that only null values may be stored in that column.

Accepted Answer

A) True 
 B)False

Question 11

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

Accepted Answer

A)  UPDATE STUDENT SET Advisor = 'Smith'; 
B)  MODIFY STUDENT SET Advisor = 'Smith'; 
C)  MODIFY Advisor SET STUDENT = 'Smith'; 
D)  UPDATE Advisor = 'Smith'; 
E)  SET STUDENT Advisor = 'Smith'; 
A)  UPDATE STUDENT SET Advisor = 'Smith'; 
B)  MODIFY STUDENT SET Advisor = 'Smith'; 
C)  MODIFY Advisor SET STUDENT = 'Smith'; 
D)  UPDATE Advisor = 'Smith'; 
E)  SET STUDENT Advisor = 'Smith';

Question 12

The basic idea of a join is to combine the contents of two or more relations into a new relation.

Accepted Answer

A) True 
 B)False

Question 13

In SQL,the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.

Accepted Answer

A) True 
 B)False

Question 14

In SQL,the IS NULL keyword can be used to select on records containing NULL values in a particular column.

Accepted Answer

A) True 
 B)False

Question 15

In Microsoft Access,tables are added to a Query window by ________.

Accepted Answer

A)  selecting the tables from the Use Table dialog box 
B)  selecting the tables from the Show Table dialog box 
C)  selecting the tables from the Tables section of the Navigation Pane 
D)  selecting the tables from the Queries section of the Navigation Pane 
E)  selecting the tables from the Relationships window 
A)  selecting the tables from the Use Table dialog box 
B)  selecting the tables from the Show Table dialog box 
C)  selecting the tables from the Tables section of the Navigation Pane 
D)  selecting the tables from the Queries section of the Navigation Pane 
E)  selecting the tables from the Relationships window

Question 16

Data is added to a table using the SQL INSERT command.

Accepted Answer

A) True 
 B)False

Question 17

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

Accepted Answer

A)  percent sign % 
B)  exclamation mark ! 
C)  underscore  _ 
D)   question mark ? 
E)  semi-colon ; 
A)  percent sign % 
B)  exclamation mark ! 
C)  underscore  _ 
D)   question mark ? 
E)  semi-colon ;

Question 18

In SQL,the LIKE keyword can be used to select on partial values.

Accepted Answer

A) True 
 B)False

Question 19

Distinguish between Char and VarChar data types.

Accepted Answer

Char data type is fixed length,so that n

Question 20

The order of the columns returned by an SQL SELECT statement is determined by the ________.

Accepted Answer

A)  ORDER BY clause 
B)  SORT BY clause 
C)  order they are listed in following SELECT 
D)  order they are listed in following WHERE 
E)  order they are listed in following FROM 
A)  ORDER BY clause 
B)  SORT BY clause 
C)  order they are listed in following SELECT 
D)  order they are listed in following WHERE 
E)  order they are listed in following FROM

In SQL,the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.

The ________ statement removes all data from a table while leaving the table structure,and also resets any surrogate primary key values back to the starting point.

Distinguish between the HAVING clause and the WHERE clause.

Which type of join,although not included in standard SQL,was created to allow unmatched rows to appear in the result of a join operation?

The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.

Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

A complete table,including both the table structure and any data in the table,can be removed from the database by using the SQL ________ command.

In SQL,the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.

When using SQL to create a table,specifying the NULL property for a column indicates that only null values may be stored in that column.

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

The basic idea of a join is to combine the contents of two or more relations into a new relation.

In SQL,the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.

In SQL,the IS NULL keyword can be used to select on records containing NULL values in a particular column.

In Microsoft Access,tables are added to a Query window by ________.

Data is added to a table using the SQL INSERT command.

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

In SQL,the LIKE keyword can be used to select on partial values.

Distinguish between Char and VarChar data types.

The order of the columns returned by an SQL SELECT statement is determined by the ________.

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

In SQL,the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.

The ________ statement removes all data from a table while leaving the table structure,and also resets any surrogate primary key values back to the starting point.

Distinguish between the HAVING clause and the WHERE clause.

Which type of join,although not included in standard SQL,was created to allow unmatched rows to appear in the result of a join operation?

The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.

Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

A complete table,including both the table structure and any data in the table,can be removed from the database by using the SQL ________ command.

In SQL,the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.

When using SQL to create a table,specifying the NULL property for a column indicates that only null values may be stored in that column.

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

The basic idea of a join is to combine the contents of two or more relations into a new relation.

In SQL,the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.

In SQL,the IS NULL keyword can be used to select on records containing NULL values in a particular column.

In Microsoft Access,tables are added to a Query window by ________.

Data is added to a table using the SQL INSERT command.

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

In SQL,the LIKE keyword can be used to select on partial values.

Distinguish between Char and VarChar data types.

The order of the columns returned by an SQL SELECT statement is determined by the ________.

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