Question 1

SQL Server is an open-source DBMS package that is free for most database applications.

Accepted Answer

A) True 
 B)False

Question 2

________ consists of forms, reports, queries, and application programs.

Accepted Answer

A)   A database application
B)   A DBMS program
C)   A Visual Basic application
D)   A database
E)   A Windows application

Question 3

A database is a self-describing collection of integrated records.

Accepted Answer

A) True 
 B)False

Question 4

Explain the difference between a primary key and a foreign key.

Accepted Answer

A primary key is a column or g...

Question 5

SQL stands for "Standard Query Language."

Accepted Answer

A) True 
 B)False

Question 6

SQL is a

Accepted Answer

A)   query language.
B)   database system.
C)   3GL.
D)   2GL.
E)   programming language.

Question 7

A database is a collection of tables, metadata, and ________.

Accepted Answer

The answer of A database is a collection of tables,...

Question 8

________ describe(s)  the structure of a database.

Accepted Answer

A)   Logic
B)   Metadata
C)   Models
D)   Protocols
E)   Content

Question 9

In the early days of corporate websites, employees were allowed to add content directly to the sites. Today this practice is not acceptable because

Accepted Answer

A)   of the lack of consistency in both look and accuracy of the website.
B)   employees lack the skills to add content to web sites due to the greater sophistication of the software used today for corporate web sites.
C)   companies with web sites now have copy editors to prepare web site content.
D)   most companies use content management systems today.
E)   most web sites are driven by database management systems.

Question 10

A group of similar rows or records is called a

Accepted Answer

A)   database.
B)   table.
C)   instance.
D)   attribute.
E)   column.

Question 11

What does CMS stand for?

Accepted Answer

A)   Content management system
B)   Copy management system
C)   Customer management system
D)   Customer manipulation system
E)   Content manipulation system

Question 12

What is meant by a relational database? What are the advantages of relational database technology?

Accepted Answer

Relational databases store data in table...

Question 13

Setting up the database security is a part of database ________.

Accepted Answer

The answer of Setting up the database security is a...

Question 14

A DBMS is a collection of tables, relationships, and metadata.

Accepted Answer

A) True 
 B)False

Question 15

One example of a DBMS is

Accepted Answer

A)   SQL Server.
B)   .NET.
C)   Java.
D)   OEM.
E)   Excel.

Question 16

A database form translates inputted changes into a SQL query in order for the database to process them.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is an international standard language for processing a database?

Accepted Answer

A)   VBA
B)   C++
C)   Visual Basic
D)   Standard Query Language
E)   Structured Query Language

Question 18

Discuss the challenges for a multiuser database application.

Accepted Answer

Multiple users may try to update the sam...

Question 19

A database can have one and only one application.

Accepted Answer

A) True 
 B)False

Question 20

MySQL is an open-source DBMS product.

Accepted Answer

A) True 
 B)False

Exam 7: Database and Content Management

Explain the difference between a primary key and a foreign key.

Correct AnswerverifiedA primary key is a column or g...View AnswerShow Answer

SQL stands for "Standard Query Language."

Correct AnswerverifiedShow Answer

What is meant by a relational database? What are the advantages of relational database technology?

Correct AnswerverifiedRelational databases store data in table...View AnswerShow Answer

SQL Server is an open-source DBMS package that is free for most database applications.

Correct AnswerverifiedShow Answer

Discuss the challenges for a multiuser database application.

Correct AnswerverifiedMultiple users may try to update the sam...View AnswerShow Answer

A database is a collection of tables, metadata, and ________.

Correct AnswerverifiedShow Answer

One example of a DBMS is

Correct AnswerverifiedShow Answer

A database is a self-describing collection of integrated records.

Correct AnswerverifiedShow Answer

What does CMS stand for?

Correct AnswerverifiedShow Answer

Which of the following is an international standard language for processing a database?

Correct AnswerverifiedShow Answer

A database can have one and only one application.

Correct AnswerverifiedShow Answer

A database form translates inputted changes into a SQL query in order for the database to process them.

Correct AnswerverifiedShow Answer

In the early days of corporate websites, employees were allowed to add content directly to the sites. Today this practice is not acceptable because

Correct AnswerverifiedShow Answer

SQL is a

Correct AnswerverifiedShow Answer

________ describe(s) the structure of a database.

Correct AnswerverifiedShow Answer

A DBMS is a collection of tables, relationships, and metadata.

Correct AnswerverifiedShow Answer

MySQL is an open-source DBMS product.

Correct AnswerverifiedShow Answer

A group of similar rows or records is called a

Correct AnswerverifiedShow Answer

Setting up the database security is a part of database ________.

Correct AnswerverifiedShow Answer

________ consists of forms, reports, queries, and application programs.

Correct AnswerverifiedShow Answer

Correct Answer
verified
A primary key is a column or g...
View Answer

Correct Answer
verified

Correct Answer
verified
Relational databases store data in table...
View Answer

Correct Answer
verified

Correct Answer
verified
Multiple users may try to update the sam...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified