DBMS110 (M05-M07)
What is Infrastructure as a Service (IaaS)?
A cloud server model that allows an enterprise to rent computing facilities.
What is Platform as a Service (PaaS)?
A cloud server model that not only provides computing infrastructure but also deploys and manages platform
What is Software as a Service (SaaS)?
A cloud server model that provides the application software as a services
Data Sources can be:
Historical data Operational databases Market research companies Internet
Null value indicates:
An absent value that may exist but unknown or doesn't exist at all
Null values indicates: --------------------------------------------- (END OF M06)
An absent value that may exist but unknown or doesn't exist at all
In a transaction Server Architecture there are server database processes.. Select all the applies:
Checkpoint process Log writer process Database writer process Server process Lock manager
A create table command:
Creates a new table in the schema
Which language has commands that specify integrity constraints?
DDL
Which language has commands to define views?
DDL
Insert, update, delete and select are commands in:
DML
Components of BI includes:
Data Sources Data Warehouse and data marts Portals, Scorecards, and Dashboards OLAP
Parallel database systems were developed: --------------------------------------------- (END OF M05)
Late 1980s
What was the initial source of Big Data?
Logs from web server software
Other sources of Big Data include:
Metadata from communication networks Data Sensors Mobile phones Transaction data from retain enterprises
Which language has commands to specify the beginning and end of a transaction?
Neither
Key-Value stores are also called:
NoSQL system
A number of system for Big Data storage have been developed including which of the following:
Parallel and Distributed Systems Distributed File Systems Sharding across multiple databases Key Value Storage System
The main difference between parallel databases and distributed are:
Distributed database have sites that are geographically separated. Nodes in a distributed database tend to vary more in size and function. Parallel database system address the problems of node failure only. Distributed databases may be separately administered, with each side retaining some degree of autonomy of operation.
Data warehouse is used:
Generate OLAP reports To store vast amount of data indefinitely
DDL and DML are features included in:
SQL
A data mart is a collection of subject areas organized for decision support based on the needs of a given department.
T
A distributed file system stores files across a large collection of machines while giving a single file system view to clients.
T
A float data type represents a floating number with precision of at least n digits.
T
A from clause specifies which entity the data is being retrieved from.
T
A not null constraint on an attribute specifies that the null value is not allowed for that attribute.
T
A where clause allows us to select only those rows from the entities listed in the from clause, that satisfies a specified predicate.
T
Business Intelligence is a broad category of applications and technologies used for gathering, providing access to, an analyzing data for the purpose of helping enterprise users make better business decision.
T
Data definition language provides commands for defining relation schemas, deleting relations, and modify relations.
T
Distributed Database system stores databases on nodes located at geographically separated sites.
T
ETL is the process of extracting, transforming and loading data into a data warehouse.
T
Parallel databases are databases that run on multiple machines and are designed to store data across multiple machines and to process large queries using multiple machines. --------------------------------------------- (END OF M07)
T
Sharding refers to the partitioning of data across multiple databases or machines.
T
The cloud computing model allows applications of an enterprise to be executed on an infrastructure that is managed by another company.
T
The following command creates an entity called employee. CREATE TABLE employee ( Emp_id varchar(20), Emp_firstname varchar(20), Emp_lastname varchar(20), Emp_age numeric(2), Primary key (emp_id) )
T
There are two ways in which computers are used: single user system and multiuser system
T
What phenomenon is responsible for the innovation of Big Data?
The growth of the World Wide Web resulted in the need to store and query data with volumes that exceeded relational databases.
DDL allows specification for:
For each relation in a schema Types of values associated with each attributes Set of indices to be maintained Integrity constraints
SQL Data Definition Language is used:
To create database objects such as tables Alter database objects
A single-user system has:
Typically only one processor One or two disks A single user
When did Big Data start to emerge?
2000
A centralized database is:
A database that runs on a single computer system
Widely used parallel key-value stores includes:
Apache HBase BigTable from Google MongoDB
Replication is key to ensuring the:
Availability of data
Select the two types of server architecture.
Data server Transaction server
Semi structure data can be defined as:
Data that is stored in an organized format such as JSON and XML but not in the traditional tabular format
Unstructured data can be defined as:
Data that is stored in no structure format such as video, audio, text messages
A drop table command:
Deletes that table from the schema
The distinct keyword used in a select statement:
Eliminates duplication in results returned in a select statement
A char data type represents a variable length character string.
F
A key value storage system is a system that provides a way to store semi structure data in an organized schema.
F
Data manipulation language provides the ability to query information directly from the datafiles and alter the structure of the datafiles.
F
Is the following statement correct? SELECT * FROM HR.EMPLOYEE WHERE LastName = Jones;
F
Cloud Service Modules includes:
Infrastructure as a service Software as a service Platform as a service
SQL Data Manipulation Language is used:
Retrieve and modify data in a table
An SQL query is used for:
Retrieving data from a database
The internet of things refers to:
The number of devices connected to the internet
Big Data can only store data that is:
Unstructured Structured Semi Structured >> All of the above
What are the three characteristic of Big Data?
Variety format Size Speed
How does Big Data differs from traditional relational database?
Volume Variety Velocity
The basic structure of an SQL query consist of which clauses:
WHERE FROM SELECT