Question 1

In Microsoft Access,standard SQL table creation syntax items not supported by Access SQL can generally be implemented by:

Accepted Answer

A) setting the Data Types in Access table Design View. 
B) setting the field properties in Access table Design View. 
C) setting the relationship properties in the Edit Relationship dialog box. 
D) setting the referential integrity properties in the Edit Relationship dialog box. 
E) running an ALTER TABLE query in Access SQL. 
A) setting the Data Types in Access table Design View. 
B) setting the field properties in Access table Design View. 
C) setting the relationship properties in the Edit Relationship dialog box. 
D) setting the referential integrity properties in the Edit Relationship dialog box. 
E) running an ALTER TABLE query in Access SQL.

Question 2

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

Accepted Answer

The answer of Table and relationship properties not supported by...

Question 3

Which of the following cannot be done using the CONSTRAINT phrase?

Accepted Answer

A) Create a single attribute primary key. 
B) Define a foreign key. 
C) Establish a referential integrity constraint. 
D) All of the above can be done using the CONSTRAINT phrase. 
E) None of the above can be done using the CONSTRAINT phrase. 
A) Create a single attribute primary key. 
B) Define a foreign key. 
C) Establish a referential integrity constraint. 
D) All of the above can be done using the CONSTRAINT phrase. 
E) None of the above can be done using the CONSTRAINT phrase.

Question 4

Distinguish between Char and VarChar data types.

Accepted Answer

Char data type is fixed length,so that n

Question 5

An SQL data type of ________ means that values consist of seven decimal numbers with two numbers assumed to the right of the decimal point.

Accepted Answer

The answer of An SQL data type of ________ means...

Question 6

The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?

Accepted Answer

A) MODIFY TABLE 
B) CHANGE TABLE 
C) CREATE TABLE 
D) SET TABLE 
E) BUILD TABLE 
A) MODIFY TABLE 
B) CHANGE TABLE 
C) CREATE TABLE 
D) SET TABLE 
E) BUILD TABLE

Question 9

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

Accepted Answer

A) True 
 B)False

Question 10

The SQL command used to add new data to a table is ________.

Accepted Answer

The answer of The SQL command used to add new...

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

In SQL,the WHERE clause is used to specify which columns will be included in the result.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

SQL is not a complete programming language,but is rather a(n)________.

Accepted Answer

The answer of SQL is not a complete programming language,but...

In Microsoft Access,standard SQL table creation syntax items not supported by Access SQL can generally be implemented by:

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

Which of the following cannot be done using the CONSTRAINT phrase?

Distinguish between Char and VarChar data types.

An SQL data type of ________ means that values consist of seven decimal numbers with two numbers assumed to the right of the decimal point.

The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.

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

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

The SQL command used to add new data to a table is ________.

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?

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

In SQL,the WHERE clause is used to specify which columns will be included in the result.

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

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

SQL is not a complete programming language,but is rather a(n)________.

Getting Started

The Relational Model

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 3: Structured Query Language

In Microsoft Access,standard SQL table creation syntax items not supported by Access SQL can generally be implemented by:

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

Which of the following cannot be done using the CONSTRAINT phrase?

Distinguish between Char and VarChar data types.

An SQL data type of ________ means that values consist of seven decimal numbers with two numbers assumed to the right of the decimal point.

The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.

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

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

The SQL command used to add new data to a table is ________.

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?

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

In SQL,the WHERE clause is used to specify which columns will be included in the result.

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

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

SQL is not a complete programming language,but is rather a(n)________.

Getting Started

The Relational Model

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters