QUESTION 1

1. Common database oriented professions might not include:

   	A.	Database Administrator.
   	B.	Database Programmer.
   	C.	Database Server Technician.
   	D.	Database Architects and Designers.

5 points

QUESTION 2

1. Referential integrity of a relational database is ensuring that there is not a single record in a table that is a(n):

   	A.	Independent record.
   	B.	Non-unique record.
   	C.	Unrelated record.
   	D.	Orphan record.

5 points

QUESTION 3

1. A database is a collection of related information that is organized so that they can be entered, stored, accessed, managed and updated.

   	A.	True
   	B.	False

5 points

QUESTION 4

1. SQL is often used to deal with complex data formatting, extractions and calculations in a real-time mode.

   	A.	True
   	B.	False

5 points

QUESTION 5

1. NoSQL has something to do with not using SQL as a data storage or an extraction engine.

   	A.	True
   	B.	False

5 points

QUESTION 6

1. Originally, data was stored as ___ files in a pure sequential format.

   	A.	Relational
   	B.	Text
   	C.	Flat
   	D.	Linier

5 points

QUESTION 7

1. We use SQL or Structured Query Language to extract data from a database.

   	A.	True
   	B.	False

5 points

QUESTION 8

1. ISAM (Indexed Sequential Access Method) is a file management system developed at _____ that allows records to be accessed either sequentially (in the order they were entered) or randomly (with an index).

   	A.	Microsoft
   	B.	Oracle
   	C.	MySQL
   	D.	IBM

5 points

QUESTION 9

1. We dedicate fast, powerful and architecturally different types of computers just to host the database systems called _______.

   	A.	Data Servers
   	B.	File Servers
   	C.	Database Servers
   	D.	SQL-Servers

5 points

QUESTION 10

1. In recent year databases have started to play one of the most important roles in storing, preserving and arraying data to business systems.

   	A.	True
   	B.	False

5 points

QUESTION 11

1. Removing repeating groups of data from one table and breaking down into two tables is an attempt to ensure ______.

   	A.	1NF
   	B.	2NF
   	C.	3NF
   	D.	4NF

5 points

QUESTION 12

1. Which of the following statements is not one of major outcomes of Normalization?

   	A.	Normalized DB helps in creating an efficient data structure with related tables.
   	B.	Normalized DB decreases the propensity of inconsistent and orphan data.
   	C.	Normalized DB ensures security and privacy of information.
   	D.	Normalized DB influences the seek time to be faster because the processor is searching smaller tables.

5 points

QUESTION 13

1. NoSQL databases do not use any SQL type language or methods.

   	A.	True
   	B.	False

5 points

QUESTION 14

1. A standard DBMS has embedded Data Definition Language (DDL), Data Manipulation Language (DML) and Sequential Query Language (SQL).

   	A.	True
   	B.	False

5 points

QUESTION 15

1. Big-Data only deals with large-scale unstructured data.

   	A.	True
   	B.	False

5 points

QUESTION 16

1. When all fields in all tables are fully dependent on the primary key and not any other field is an attempt to ensure ______.

   	A.	1NF
   	B.	2NF
   	C.	3NF
   	D.	4NF

5 points

QUESTION 17

1. The most frequently used model is the Relational form or RDBMS.

   	A.	True
   	B.	False

5 points

QUESTION 18

1. Just in the U.S. alone, over ______ have been breached, violated or stolen over the past two years.

   	A.	900 million to a billion records
   	B.	250 to 300 million records
   	C.	150 to 200 million records
   	D.	100 to 150 million records

5 points

QUESTION 19

1. A popular Database Technology to deal with massive scale data is _____.

   	A.	SQL
   	B.	RDBMS
   	C.	Big-Data
   	D.	MongoDB

5 points

QUESTION 20

1. In generic terms, Data-type may not include which of the following?

   	A.	Bibliographic
   	B.	Text
   	C.	Hyperlinks
   	D.	Numeric
   	E.	Geographic