CLIENT SERVER FINAL;

. Cookies are frequently used to keep track if the user is logged on to a site. A. True B. False

A. True

A single memory store can serve many applications. A. True B. False

A. True

Browser can be configured to reject cookies. A. True B. False

A. True

Common layout parts include headers and footers. A. True B. False

A. True

In node.js ecosystem, template is generic HTML file with some kind of parameters inside. A. True B. False

A. True

Session IDs are managed by the server A. True B. False

A. True

When storing session data in a memory cache, cookies are still used. A. True B. False

A. True

Documents within a collection cannot have different fields. A. false B. true

A. false

The term query is sometimes used as a synonym for running a ______ SQL statement. A. select B. retrieve C. get D. insert

A. select

Data Definition Language (DDL) is NOT used for A. selecting data from tables B. creating tables C. modifying the structure of a table D. deleting tables

A. selecting data from tables

11. REDIS can be used an in-memory data structure store A. true B. false

A. true

MongoDB stores the data in this format ____ A. SQL B. BSON C. XML D. JSON

B. BSON

Cookies can contain viruses. A. True B. False

B. False

Cookies can have the size of 32KB. A. True B. False

B. False

String session data in application memory is often used in production. A. True B. False

B. False

View templates can be used as the basis of static pages A. True B. False

B. False

Cookies are ___ A. a server-side approach to maintain state information. B. a client-side approach to maintain state information. C. both client and server-side approach to maintain state information. D. None of options above are correct.

B. a client-side approach to maintain state information.

MongoDB equivalent for tuple is ____ A. a row B. a document C. a field D. a database

B. a document

Database transaction refers to A. a successful database update B. a sequence of steps that are treated as a single unit C. a successful data retrieval

B. a sequence of steps that are treated as a single unit

Two of the most important advantages of using relational databases, as presented in the textbook, are A. data storage and data relevancy B. data integrity and data duplication reduction C. speed of data access and data control D. data flexibility and data integrity

B. data integrity and data duplication reduction

The view represents A. the data of the application. B. display aspects of the user interface. C. the "brains" of the application.

B. display aspects of the user interface.

MongoDB provides a simple JOIN command to merge documents A. true B. false

B. false

MongoDB requires the user to generate a unique ID for each document A. true B. false

B. false

A table in a SQL database is a two-dimensional container for data that consists of A. objects B. records C. joins D. views

B. records

Persistent cookies are also also known as ___ A. information cookies B. tracking cookies C. data cookies D. database cookies

B. tracking cookies

MongoDB documents have dynamic schema A. false B. true

B. true

REDIS as a key-value store that supports multiple fields that can be associated with one key A. false B. true

B. true

URL rewriting is A. converting a static URL into a dynamic one. B. converting a dynamic URL into a static one. C. adding query parameters to a static URL. D. None of options above are correct.

C. adding query parameters to a static URL.

When two tables are joined via an inner join, records are returned if there is matching data other in ____ A. the left table B. the right table C. both tables

C. both tables

MongoDB equivalent to a relational database table is called A. document B. folder C. collection D. directory

C. collection

A single MongoDB server typically has ____. A. a single database B. two databases - primary and failover. C. multiple databases D. does not have a concept of databases

C. multiple databases

4. One-to-one relationships in relational databases are typically used for A. data cohesion reasons B. data integity reasons C. performance reasons D. data access reasons

C. performance reasons

The special field that is used to uniquely identify each record in a table is called A. a record key B. a sequence key C. a foreign key D. a primary key

D. a primary key

Many-to-many relationships in relational databases are typically implemented using a(n) A. direct lookup table B. join table C. view table D. intermediate table

D. intermediate table

Database table index is used to A. ensure data integrity B. ensure data normalization C. eliminate data redundancy D. speed up the performance

D. speed up the performance