NEW
Font size
Worksheetsdata pirates quiz
Total questions: 70
Worksheet time: 12mins
Which of the following is the full form of DDL?
Data definition language
Data derivation language
Dynamic data language
Detailed data language
Which of the following is the property of transaction that protects data from system failure?
Atomicity
Isolation
Durability
Consistency
Which is the lowest level of abstraction that describes how the data are actually stored?
Physical
Abstract
View
User
Maximum children of a B-tree of order m?
m/2
m - 1
m
m + 1
Select the correct advantages of view.
Derived columns
Data security
Hiding of complex queries
All of the above
NATURAL JOIN can also be termed as
Combination of Union and cartesian product
Combination of Selection and cartesian product
Combination of Projection and cartesian product
None
To select some particular columns, which of the following command is used?
PROJECTION
SELECTION
JOIN
UNION
Primary key can be?
NULL
NOT NULL
Both NULL and NOT NULL
Depends on situation
Select the definition of the correct key which is used to represent relation between two tables?
Candidate key
Foreign key
Primary key
Super key
Total view of a database is known as?
Physical view
Internal view
Conceptual view
External view
Select the correct definition of Relational calculus?
It is a high level language
It is a procedural language
It is a non-procedural language
It is a data definition language
Which of the following is the full form of NTFS?
New Tree File System
New Technology File System
New Table File System
Both B and C
Which of the following can replace the below query?
SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;
Select name, course_id from instructor natural join teaches;
Select name,course_id from teaches,instructor where instructor_id=course_id;
Select name, course_id from instructor;
Select course_id from instructor join teaches;
Which of the following normal forms contains information about a single entity?
1NF
2NF
3NF
4NF
Which attribute is the COMPOSITE ATTRIBUTE?
Degree
Age
Salary
Address
Which of these would be the data type used for the field "PostCode"?
The DBMS acts as an interface between what two components of an enterprise-class database system?
Database application and SQL
Data and the database
The user and the database application
Database application and the database
DBMS should provide following features ___________.
All of these
Safety of the information stored
Authorized access
Protect the data from the system crash
Which one refers to File System?
collection of data organized in a manner that allows access, retrieval and use of that data.
used to store and manage data in which each department within an organization has its own set of files.
Which statement is TRUE about Database?
A collection of data organized in a manner that allows access, retrieval and use of that data.
A system used to store and manage data in which each department within an organization has its own set of files.
A software that allows you to create a computerized database.
A collection of unprocessed item, which can include text, numbers, images, audio and video.
Which statement is TRUE about Database Management System?
A collection of data organized in a manner that allows access, retrieval and use of that data.
A system used to store and manage data in which each department within an organization has its own set of files.
A software that allows you to create a computerized database.
A collection of unprocessed item, which can include text, numbers, images, audio and video.
An advantage of the database approach is the creation of maximum data redundancy.
True
False
The database approach requires additional costs and risks.
True
False
The most common source of database failures in an organization is the failure to implement a
strong database administration function.
True
False
The source of the data is sometimes called the system of record.
True
False
Which of the following DBMS types is not a classification based on a data model?
Relational Data Model
Hierarchical Data Model
Network Data Model
Cloud Data Model
Data Analysis is a process of?
inspecting data
cleaning data
transforming data
All of the above
Which of the following is not a major data analysis approaches?
Data Mining
Predictive Intelligence
Business Intelligence
Text Analytics
In descriptive statistics, data from the entire population or a sample is
summarized with ?
integer descriptors
floating descriptors
numerical descriptors
decimal descriptors
Data Analysis is defined by the statistician?
William S.
Hans Peter Luhn
Gregory Piatetsky-Shapiro
John Tukey
Which of the following is true about hypothesis testing?
answering yes/no questions about the data
estimating numerical characteristics of the data
describing associations within the data
modeling relationships within the data
The branch of statistics which deals with development of particular statistical
methods is classified as
industry statistics
economic statistics
applied statistics
applied statistics
Text Analytics, also referred to as Text Mining?
TRUE
FALSE
Can be true or false
Can not say
Amongst which of the following is / are the types of Linear Regression,
Simple Linear Regression
Multiple Linear Regression
Both A and B
None of the mentioned above
The process of quantifying data is referred to as ___.
A.
B.
C.
D.
Decoding
Structure
Enumeration
Coding
___ are used when we want to visually examine the relationship between
two quantitative variables.
Bar graph
Scatterplot
Line graph
Pie chart
Data Analysis is a process of,
Inspecting data
Data Cleaning
Transforming of data
All of the mentioned above
What is exploratory data analysis?
A rigid framework by which we analyze data
An initial way by which we can get a feel for data
A type of purely quantitative method of data analysis
A set of scientific principles for analyzing data in a categorical manner
Most often, EDA relies on _____.
visual techniques
assumptions
fixed models
testing for statistical significance
Which of the following is a principle of analytic graphics?
Don't plot more than two variables at at time
Only do what your tools allow you to do
Show box plots (univariate summaries)
Integrate multiple modes of evidence
Which of the following is true about the base plotting system?
The system is most useful for conditioning plots.
Plots are created and annotated with separate functions.
Plots are typically created with a single function call.
Margins and spacings are adjusted automatically depending on the type of plot and the data.
Which of the following functions is typically used to add elements to a plot in the base graphics system?
hist()
plot()
text()
boxplot()
With reference to the EDA boxplot shown, the median is represented by which feature?
Number 2
Number 3
Number 4
Number 5
A histogram is
Is a bar chart.
Is a graphic representation of the frequency distribution of a qualitative or categorical variable.
Is a graphic representation of the frequency distribution of a continuous variable.
Is an alternative to a pie chart.
Velocity is the speed at which the data is processed
True
False
___ refers to the ability to turn your data useful for business.
Value
Variety
Velocity
None of the mentioned above
Correlation is the relationship between two variables -
One
Two
Zero
All of the mentioned above
Logistic regression is used to find the probability of event = Success and
event = ____.
Failure
Success
Both A and B
None of the mentioned above
A good data analytics solution includes a viable self-service ___.
Data mining
Data wrangling
Data warehouse
None of the mentioned above
To glean insights from the data, many analysts and data scientists rely on
___.
Data mining
Data visualization
Data warehouse
All of the mentioned above
___ is the cyclical process of collecting and analyzing data during a
research study.
Extremis Analysis
Constant analysis
Interim Analysis
All of the mentioned above
An advantage of using computer programs for qualitative data is that they
___.
Can reduce time required to analyze data
Help in storing and organizing data
Make many procedures available that are rarely done by hand due to time
constraints
All of the mentioned above
The Process of describing the data that is huge and complex to store and
process is known as ___.
Analytics mining
Data cleaning
Big data
None of the mentioned above
A ______________ is a kind of graph. It uses line segments to show how data change over time.
Stem-and_Leaf Plot
Bar Graph
Dot Plot
Line Graph
What is a survey?
A series of questions related to a subject topic area
A quiz of questions to answer with correct and incorrect answers
A set of questions that cannot be reviewed after they have all been completed
When answering an open ended question...?
You write your answer in a dialogue box
You tick one of the boxes provided
You skip onto the net question
