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

Question 1

MySQL functions on the ________ platform.

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

Answer 1

D

Question 2

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.

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

Answer 2

A

Question 3

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

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

Answer 3

A

Question 4

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

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

Question 5

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

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 ________.

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

Question 7

The following SQL query:
SELECT lastName FROM Authors
WHERE lastName LIKE '%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 8

A relational database table consists of rows and ________.

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

Question 9

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

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

Question 10

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

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

Question 11

SQL is a ________.

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

Question 12

The following SQL query:
SELECT * FROM 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.