Question 1

________ provides mechanisms for storing and organizing data in a manner that facilitates sophisticated queries.

Accepted Answer

A)  database 
B)  database management system 
C)  Structured Query Language 
D) .NET 
A)  database 
B)  database management system 
C)  Structured Query Language 
D) .NET B

Question 2

Each table column in a relational detabase represents a different ________.

Accepted Answer

A)  data attribute 
B)  primary key 
C)  record 
D)  result set 
A)  data attribute 
B)  primary key 
C)  record 
D)  result set A

Question 3

A relational database table consists of rows and ________.

Accepted Answer

A)  rows 
B)  primary keys 
C)  columns 
D)  result sets 
A)  rows 
B)  primary keys 
C)  columns 
D)  result sets C

Question 4

The SQL keywords ASC and DESC are used when ________ rows.

Accepted Answer

A)  sorting 
B)  deleting 
C)  updating 
D)  creating 
A)  sorting 
B)  deleting 
C)  updating 
D)  creating

Question 5

There is a(n) ________ relationship between a primary key and its corresponding foreign key.

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  inverse 
A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  inverse

Question 6

Sun's branded version of Apache Derby, a pure Java database, is called ________.

Accepted Answer

A)  JSQL 
B)  JavaBase 
C)  DBJ 
D)  Java DB 
A)  JSQL 
B)  JavaBase 
C)  DBJ 
D)  Java DB

Question 7

The ________ SQL statement is used to change existing data in a table.

Accepted Answer

A)  EDIT 
B)  UPDATE 
C)  CHANGE 
D)  MODIFY 
A)  EDIT 
B)  UPDATE 
C)  CHANGE 
D)  MODIFY

Question 8

The ________ is a logical representation of the data that allows the relationships between the data to be considered without concerning oneself with the physical implementation of the data structures.

Accepted Answer

A)  relational database model 
B)  rational database model 
C)  SQL Server diagram 
D)  Common Gateway Interface 
A)  relational database model 
B)  rational database model 
C)  SQL Server diagram 
D)  Common Gateway Interface

Question 9

SQL is a ________.

Accepted Answer

A)  relational database 
B)  non-relational database 
C)  language for creating database queries and manipulating data 
D)  personal relational database 
A)  relational database 
B)  non-relational database 
C)  language for creating database queries and manipulating data 
D)  personal relational database

Question 10

The following SQL query:
SELECT lastName FROM Authors
WHERE lastName LIKE '%e_'

Accepted Answer

A)  selects from the table Authors the lastName fields which start with any single character followed by an 'e', then any number of additional characters. 
B)  selects from the table Authors the lastName fields which start with either the letter e followed by any number of additional characters. 
C)  selects from the table Authors the lastName fields which constist of any number of characters followed by an 'e' and any single character. 
D)  selects from the table Authors the lastName fields which end with the letter 'e'. 
A)  selects from the table Authors the lastName fields which start with any single character followed by an 'e', then any number of additional characters. 
B)  selects from the table Authors the lastName fields which start with either the letter e followed by any number of additional characters. 
C)  selects from the table Authors the lastName fields which constist of any number of characters followed by an 'e' and any single character. 
D)  selects from the table Authors the lastName fields which end with the letter 'e'.

Question 11

The following SQL query:
SELECT * FROM TableName

Accepted Answer

A)  generates an error. 
B)  selects all rows from the table TableName. 
C)  selects all columns from the table TableName. 
D)  selects all rows and columns from the table TableName. 
A)  generates an error. 
B)  selects all rows from the table TableName. 
C)  selects all columns from the table TableName. 
D)  selects all rows and columns from the table TableName.

Question 12

MySQL functions on the ________ platform.

Accepted Answer

A)  Windows 
B)  Linux 
C)  UNIX 
D)  All of the above 
A)  Windows 
B)  Linux 
C)  UNIX 
D)  All of the above

________ provides mechanisms for storing and organizing data in a manner that facilitates sophisticated queries.

Each table column in a relational detabase represents a different ________.

A relational database table consists of rows and ________.

The SQL keywords ASC and DESC are used when ________ rows.

There is a(n) ________ relationship between a primary key and its corresponding foreign key.

Sun's branded version of Apache Derby, a pure Java database, is called ________.

The ________ SQL statement is used to change existing data in a table.

The ________ is a logical representation of the data that allows the relationships between the data to be considered without concerning oneself with the physical implementation of the data structures.

SQL is a ________.

The following SQL query: SELECT lastName FROM Authors WHERE lastName LIKE '%e_'

The following SQL query: SELECT * FROM TableName

MySQL functions on the ________ platform.

Introduction to Computers and the Internet

Introduction to Html5: Part 1

Cascading Style Sheets Css

Introduction to Cascading Style Sheets

Javascript: Introduction to Scripting

Javascript: Control Statements I

Javascript: Control Statements II

Javascript: Functions

Javascript: Arrays

Javascript: Objects

Document Object Model Dom: Objects and Collections

Javascript: Event Handling

Html5: Introduction to Canvas

Xml

Ajax-Enabled Rich Internet Applications With Xml and Json

Web Servers Iis and Apache

Php

Web App Development With Aspnet in C#

Web App Development With Aspnet in C#: a Deeper Look

Windows Communication Foundation Wcf Web Services in C#

Web App Development With Aspnet in Visual Basic

Web App Development With Aspnet in Vb, a Deeper Look

Windows Communication Foundation Wcf Web Services in Vb

Javaserver Faces Web Apps: Part 1

Javaserver Faces Web Apps: Part 2

Web Services in Java

Filters

Exam 18: Database: Sql, Mysql, Linq and Javadb

________ provides mechanisms for storing and organizing data in a manner that facilitates sophisticated queries.

Each table column in a relational detabase represents a different ________.

A relational database table consists of rows and ________.

The SQL keywords ASC and DESC are used when ________ rows.

There is a(n) ________ relationship between a primary key and its corresponding foreign key.

Sun's branded version of Apache Derby, a pure Java database, is called ________.

The ________ SQL statement is used to change existing data in a table.

The ________ is a logical representation of the data that allows the relationships between the data to be considered without concerning oneself with the physical implementation of the data structures.

SQL is a ________.

The following SQL query: SELECT lastName FROM Authors WHERE lastName LIKE '%e_'

The following SQL query: SELECT * FROM TableName

MySQL functions on the ________ platform.

Introduction to Computers and the Internet

Introduction to Html5: Part 1

Cascading Style Sheets Css

Introduction to Cascading Style Sheets

Javascript: Introduction to Scripting

Javascript: Control Statements I

Javascript: Control Statements II

Javascript: Functions

Javascript: Arrays

Javascript: Objects

Document Object Model Dom: Objects and Collections

Javascript: Event Handling

Html5: Introduction to Canvas

Xml

Ajax-Enabled Rich Internet Applications With Xml and Json

Web Servers Iis and Apache

Php

Web App Development With Aspnet in C#

Web App Development With Aspnet in C#: a Deeper Look

Windows Communication Foundation Wcf Web Services in C#

Web App Development With Aspnet in Visual Basic

Web App Development With Aspnet in Vb, a Deeper Look

Windows Communication Foundation Wcf Web Services in Vb

Javaserver Faces Web Apps: Part 1

Javaserver Faces Web Apps: Part 2

Web Services in Java

Filters