Question 1

A related table is also called a ____________________ table.

Accepted Answer

The answer of A related table is also called a...

Question 2

A. ____________________ database stores information in a single table.

Accepted Answer

The answer of A. ____________________ database stores information in a...

Question 3

Each row in a database is called a record.

Accepted Answer

A) True 
 B)False

Question 4

The ____ keyword specifies the name of the table that needs to be modified when updating records.

Accepted Answer

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

Question 5

Most database management systems can import each other's file formats, and they can also read directly each other's files.

Accepted Answer

A) True 
 B)False

Question 6

____________________ are the individual categories of information stored in a record.

Accepted Answer

The answer of ____________________ are the individual categories of information...

Question 7

You create one-to-many relationships when you want to break information into multiple, logical sets.

Accepted Answer

A) True 
 B)False

Question 8

Breaking tables into multiple related tables to reduce redundant and duplicate information is called ____________________.

Accepted Answer

The answer of Breaking tables into multiple related tables to...

Question 9

MySQL is part of PHP.

Accepted Answer

A) True 
 B)False

Question 10

To keep your database from growing too large, you should choose the smallest data type possible for each field.

Accepted Answer

A) True 
 B)False

Question 11

A(n) _____________________ relationship exists in a relational database when one record in a primary table has many related records in a related table.

Accepted Answer

one-to-man

Question 12

The ____________________ application is an open source tool written in PHP to handle the administration of MySQL databases.

Accepted Answer

The answer of The ____________________ application is an open source...

Question 13

To delete a database, you must execute the ____ DATABASE command.

Accepted Answer

A)  DELETE 
B)  REMOVE 
C)  DROP 
D)  EXIT 
A)  DELETE 
B)  REMOVE 
C)  DROP 
D)  EXIT

Question 14

An application or collection of applications used to access and manage a database is called a ______________________________.

Accepted Answer

database m

Question 15

To modify the structure of a table, you use the ____ TABLE statement.

Accepted Answer

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

Question 16

SQL stands for sequential query language.

Accepted Answer

A) True 
 B)False

Question 17

A ____________________ is the structure of a database, including its tables, fields, and relationships.

Accepted Answer

The answer of A ____________________ is the structure of a...

Question 18

Primary and foreign keys are the only pieces of information in a relational database table that should be duplicated.

Accepted Answer

A) True 
 B)False

Question 19

One-to-one relationships allow you to make the information in one of the tables confidential and accessible only by certain individuals.

Accepted Answer

A) True 
 B)False

Question 20

When inserting a new record in a table, you must specify the keyword(s) ____ for any fields in which you do not have a value.

Accepted Answer

A)  NULL 
B)  BLANK 
C)  VOID 
D)  NO VALUE 
A)  NULL 
B)  BLANK 
C)  VOID 
D)  NO VALUE

A related table is also called a ____________________ table.

A. ____________________ database stores information in a single table.

Each row in a database is called a record.

The ____ keyword specifies the name of the table that needs to be modified when updating records.

Most database management systems can import each other's file formats, and they can also read directly each other's files.

____________________ are the individual categories of information stored in a record.

You create one-to-many relationships when you want to break information into multiple, logical sets.

Breaking tables into multiple related tables to reduce redundant and duplicate information is called ____________________.

MySQL is part of PHP.

To keep your database from growing too large, you should choose the smallest data type possible for each field.

A(n) _____________________ relationship exists in a relational database when one record in a primary table has many related records in a related table.

The ____________________ application is an open source tool written in PHP to handle the administration of MySQL databases.

To delete a database, you must execute the ____ DATABASE command.

An application or collection of applications used to access and manage a database is called a ______________________________.

To modify the structure of a table, you use the ____ TABLE statement.

SQL stands for sequential query language.

A ____________________ is the structure of a database, including its tables, fields, and relationships.

Primary and foreign keys are the only pieces of information in a relational database table that should be duplicated.

One-to-one relationships allow you to make the information in one of the tables confidential and accessible only by certain individuals.

When inserting a new record in a table, you must specify the keyword(s) ____ for any fields in which you do not have a value.

Getting Started With Php

Functions and Control Structures

Manipulating Strings

Handling User Input

Working With Files and Directories

Manipulating Arrays

Manipulating Mysql Databases With Php

Managing State Information

Developing Object-Oriented Php

Filters

Exam 7: Working With Databases and Mysql

A related table is also called a ____________________ table.

A. ____________________ database stores information in a single table.

Each row in a database is called a record.

The ____ keyword specifies the name of the table that needs to be modified when updating records.

Most database management systems can import each other's file formats, and they can also read directly each other's files.

____________________ are the individual categories of information stored in a record.

You create one-to-many relationships when you want to break information into multiple, logical sets.

Breaking tables into multiple related tables to reduce redundant and duplicate information is called ____________________.

MySQL is part of PHP.

To keep your database from growing too large, you should choose the smallest data type possible for each field.

A(n) _____________________ relationship exists in a relational database when one record in a primary table has many related records in a related table.

The ____________________ application is an open source tool written in PHP to handle the administration of MySQL databases.

To delete a database, you must execute the ____ DATABASE command.

An application or collection of applications used to access and manage a database is called a ______________________________.

To modify the structure of a table, you use the ____ TABLE statement.

SQL stands for sequential query language.

A ____________________ is the structure of a database, including its tables, fields, and relationships.

Primary and foreign keys are the only pieces of information in a relational database table that should be duplicated.

One-to-one relationships allow you to make the information in one of the tables confidential and accessible only by certain individuals.

When inserting a new record in a table, you must specify the keyword(s) ____ for any fields in which you do not have a value.

Getting Started With Php

Functions and Control Structures

Manipulating Strings

Handling User Input

Working With Files and Directories

Manipulating Arrays

Manipulating Mysql Databases With Php

Managing State Information

Developing Object-Oriented Php

Filters