Question
QUESTION 1 Common database oriented professions might not include: A. Database Administrator. B. Database Programmer. C. Database Server Technician. D. Database Architects and Designers. 5
QUESTION 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
-
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
-
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
-
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
-
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
-
Originally, data was stored as ___ files in a pure sequential format.
A. Relational
B. Text
C. Flat
D. Linier
5 points
QUESTION 7
-
We use SQL or Structured Query Language to extract data from a database.
A. True
B. False
5 points
QUESTION 8
-
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
-
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
-
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
-
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
-
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
-
NoSQL databases do not use any SQL type language or methods.
A. True
B. False
5 points
QUESTION 14
-
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
-
Big-Data only deals with large-scale unstructured data.
A. True
B. False
5 points
QUESTION 16
-
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
-
The most frequently used model is the Relational form or RDBMS.
A. True
B. False
5 points
QUESTION 18
-
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
-
A popular Database Technology to deal with massive scale data is _____.
A. SQL
B. RDBMS
C. Big-Data
D. MongoDB
5 points
QUESTION 20
-
In generic terms, Data-type may not include which of the following?
A. Bibliographic
B. Text
C. Hyperlinks
D. Numeric
E. Geographic
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started