DBMS110 (M05-M07)

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

advanced social psychology exam 2

View Set

Art History: Early Medieval Art [Quiz]

View Set

BAS 282: Overview of Marketing: SmartBook

View Set

Medical Office (front) continued

View Set

CH. 4 Learning and Transfer of Training

View Set