that’s great system to earn a free money online. thank @cyberian
now we can learn smartly wow!
Khuram Shahzad
Posts
-
How can I receive Reputation earning from Cyberian? 100% Discount on Fee -
CS614 Quiz No. 2 Solution and DiscussionQuiz Start Time: 04:09 PM Time Left 49
sec(s)Question # 1 of 10 ( Start time: 04:09:48 PM ) Total Marks: 1
In nested-loop join case, if there are ‘M’ rows in outer table and ‘N’ rows in inner table, time complexity is
Select correct option:O(MN) (Correct)
Quiz Start Time: 04:09 PM Time Left 35
sec(s)Question # 2 of 10 ( Start time: 04:11:20 PM ) Total Marks: 1
In context of data mining definition, the term “value” means:
Select correct option:importance of hidden perameters discovered (Correct)
Quiz Start Time: 04:09 PM Time Left 56
sec(s)Question # 3 of 10 ( Start time: 04:12:51 PM ) Total Marks: 1
Classification consists of examining the properties of a newly presented observation and assigning it to a predefined ____________.
Select correct option:Class (Correct)
Quiz Start Time: 04:09 PM Time Left 25
sec(s)Question # 4 of 10 ( Start time: 04:13:44 PM ) Total Marks: 1
The optimizer uses a hash join to join two tables if they are joined using an equijoin and
Select correct option:Large amount of data need to be joined (Correct)
A large amount of data needs to be joined.
A large portion of the table needs to be joined.Quiz Start Time: 04:09 PM Time Left 20
sec(s)Question # 5 of 10 ( Start time: 04:15:07 PM ) Total Marks: 1
In context of nested-loop join, actual number of matching rows returned as a result of the join would be ______ of the order of tables
Select correct option:Independent (Correct)
Quiz Start Time: 04:09 PM Time Left 13
sec(s)Question # 6 of 10 ( Start time: 04:16:36 PM ) Total Marks: 1
Normally the input data structure (a database table) for a data mining algorithm:
Select correct option:Quiz Start Time: 04:09 PM Time Left 12
sec(s)Question # 7 of 10 ( Start time: 04:18:07 PM ) Total Marks: 1
Mining multi dimensional databases allow users to:
Select correct option:Analyze Data (Correct)
Quiz Start Time: 04:09 PM Time Left 24
sec(s)Question # 8 of 10 ( Start time: 04:19:38 PM ) Total Marks: 1
________ refers to the overall process of discovering useful knowledge from data and data mining refers to a particular step in this process.
Select correct option:Knowledge discovery in database (Correct)
Quiz Start Time: 04:09 PM Time Left 17
sec(s)Question # 9 of 10 ( Start time: 04:21:01 PM ) Total Marks: 1
In case of nested-loop join, Inner table is accessed _____ for each qualifying row (or touple) in outer table
Select correct option:One Time (Correct)
Quiz Start Time: 04:09 PM Time Left 10
sec(s)Question # 10 of 10 ( Start time: 04:22:32 PM ) Total Marks: 1
In contrast to data mining, statistics is ______ driven.
knowledge (Correct)Quiz Start Time: 08:50 PM Time Left 55
sec(s)Question # 1 of 10 ( Start time: 08:50:34 PM ) Total Marks: 1
In context of data mining definition, the term “value” means:
Select correct option:The primary key of table
The index location of the record
Importance of hidden patterns discovered (Answer)
Numerical or string measure assigned to an attributeQuiz Start Time: 08:50 PM Time Left 22
sec(s)Question # 2 of 10 ( Start time: 08:51:23 PM ) Total Marks: 1
Data mining is all about:
Select correct option:Knowledge discovery in database
Finding hidden patterns in data
Finding relationships in data
All of the given options ( may be Answer)Quiz Start Time: 08:50 PM Time Left 19
sec(s)Question # 3 of 10 ( Start time: 08:52:41 PM ) Total Marks: 1
In contrast to statistics, data mining is ______ driven.
Select correct option:Assumption (Answer)
Knowledge
Human
DatabaseQuiz Start Time: 08:50 PM Time Left 55
sec(s)Question # 4 of 10 ( Start time: 08:53:56 PM ) Total Marks: 1
Mining multi dimensional databases allow users to:
Select correct option:Categorize the data
Analyze the data (Answer)
Summarize the data
All of the given optionsQuiz Start Time: 08:50 PM Time Left 18
sec(s)Question # 5 of 10 ( Start time: 08:54:40 PM ) Total Marks: 1
In context of data mining definition, the term “nontrivial” means:
Select correct option:Discovering information is a simple task
Discovering information is a complex task
We can not discover information
We simply find things rather than discovery (Answer)Quiz Start Time: 08:50 PM Time Left 1
sec(s)Question # 6 of 10 ( Start time: 08:55:56 PM ) Total Marks: 1
Identify the TRUE statement:
Select correct option:Clustering is unsupervised learning and classification is supervised learning
Clustering is supervised learning and classification is unsupervised learning
Both clustering and classification are unsupervised learning
Both clustering and classification are supervised learningQuiz Start Time: 08:50 PM Time Left 27
sec(s)Question # 7 of 10 ( Start time: 08:57:26 PM ) Total Marks: 1
In ________learning you don’t know the number of clusters and no idea about their attributes.
Select correct option:Supervised learning
Unsupervised learning (Answer)
Multi Dimension modeling
None of the given optionsQuiz Start Time: 08:50 PM Time Left 50
sec(s)Question # 8 of 10 ( Start time: 08:58:39 PM ) Total Marks: 1
In context of clustering, the term “distance” means:
Select correct option:Similarity/dissimilarly of records (Answer)
The difference between the primary keys of two records
The relation of a record with corresponding record in child table
None of the given optionsQuiz Start Time: 08:50 PM Time Left 15
sec(s)Question # 9 of 10 ( Start time: 08:59:22 PM ) Total Marks: 1
In data mining, initially you _____ what you are looking for.
Select correct option:Know
Don’t know (Answer)
May or may not know
None of the given optionsQuiz Start Time: 08:50 PM Time Left 52
sec(s)Question # 10 of 10 ( Start time: 09:00:41 PM ) Total Marks: 1
The optimizer uses a hash join to join two tables if they are joined using an equijoin and
Select correct option:Outer table has less number of rows
Inner table has less number of rows
Cardinality of tables is equal
Large amount of data needs to be joined (Answer) -
CS614 Quiz No. 2 Solution and DiscussionQuiz Start Time: 04:09 PM Time Left 49
sec(s)Question # 1 of 10 ( Start time: 04:09:48 PM ) Total Marks: 1
In nested-loop join case, if there are ‘M’ rows in outer table and ‘N’ rows in inner table, time complexity is
Select correct option:O(MN) (Correct)
Quiz Start Time: 04:09 PM Time Left 35
sec(s)Question # 2 of 10 ( Start time: 04:11:20 PM ) Total Marks: 1
In context of data mining definition, the term “value” means:
Select correct option:importance of hidden perameters discovered (Correct)
Quiz Start Time: 04:09 PM Time Left 56
sec(s)Question # 3 of 10 ( Start time: 04:12:51 PM ) Total Marks: 1
Classification consists of examining the properties of a newly presented observation and assigning it to a predefined ____________.
Select correct option:Class (Correct)
Quiz Start Time: 04:09 PM Time Left 25
sec(s)Question # 4 of 10 ( Start time: 04:13:44 PM ) Total Marks: 1
The optimizer uses a hash join to join two tables if they are joined using an equijoin and
Select correct option:Large amount of data need to be joined (Correct)
A large amount of data needs to be joined.
A large portion of the table needs to be joined.Quiz Start Time: 04:09 PM Time Left 20
sec(s)Question # 5 of 10 ( Start time: 04:15:07 PM ) Total Marks: 1
In context of nested-loop join, actual number of matching rows returned as a result of the join would be ______ of the order of tables
Select correct option:Independent (Correct)
Quiz Start Time: 04:09 PM Time Left 13
sec(s)Question # 6 of 10 ( Start time: 04:16:36 PM ) Total Marks: 1
Normally the input data structure (a database table) for a data mining algorithm:
Select correct option:Quiz Start Time: 04:09 PM Time Left 12
sec(s)Question # 7 of 10 ( Start time: 04:18:07 PM ) Total Marks: 1
Mining multi dimensional databases allow users to:
Select correct option:Analyze Data (Correct)
Quiz Start Time: 04:09 PM Time Left 24
sec(s)Question # 8 of 10 ( Start time: 04:19:38 PM ) Total Marks: 1
________ refers to the overall process of discovering useful knowledge from data and data mining refers to a particular step in this process.
Select correct option:Knowledge discovery in database (Correct)
Quiz Start Time: 04:09 PM Time Left 17
sec(s)Question # 9 of 10 ( Start time: 04:21:01 PM ) Total Marks: 1
In case of nested-loop join, Inner table is accessed _____ for each qualifying row (or touple) in outer table
Select correct option:One Time (Correct)
Quiz Start Time: 04:09 PM Time Left 10
sec(s)Question # 10 of 10 ( Start time: 04:22:32 PM ) Total Marks: 1
In contrast to data mining, statistics is ______ driven.
knowledge (Correct)Quiz Start Time: 08:50 PM Time Left 55
sec(s)Question # 1 of 10 ( Start time: 08:50:34 PM ) Total Marks: 1
In context of data mining definition, the term “value” means:
Select correct option:The primary key of table
The index location of the record
Importance of hidden patterns discovered (Answer)
Numerical or string measure assigned to an attributeQuiz Start Time: 08:50 PM Time Left 22
sec(s)Question # 2 of 10 ( Start time: 08:51:23 PM ) Total Marks: 1
Data mining is all about:
Select correct option:Knowledge discovery in database
Finding hidden patterns in data
Finding relationships in data
All of the given options ( may be Answer)Quiz Start Time: 08:50 PM Time Left 19
sec(s)Question # 3 of 10 ( Start time: 08:52:41 PM ) Total Marks: 1
In contrast to statistics, data mining is ______ driven.
Select correct option:Assumption (Answer)
Knowledge
Human
DatabaseQuiz Start Time: 08:50 PM Time Left 55
sec(s)Question # 4 of 10 ( Start time: 08:53:56 PM ) Total Marks: 1
Mining multi dimensional databases allow users to:
Select correct option:Categorize the data
Analyze the data (Answer)
Summarize the data
All of the given optionsQuiz Start Time: 08:50 PM Time Left 18
sec(s)Question # 5 of 10 ( Start time: 08:54:40 PM ) Total Marks: 1
In context of data mining definition, the term “nontrivial” means:
Select correct option:Discovering information is a simple task
Discovering information is a complex task
We can not discover information
We simply find things rather than discovery (Answer)Quiz Start Time: 08:50 PM Time Left 1
sec(s)Question # 6 of 10 ( Start time: 08:55:56 PM ) Total Marks: 1
Identify the TRUE statement:
Select correct option:Clustering is unsupervised learning and classification is supervised learning
Clustering is supervised learning and classification is unsupervised learning
Both clustering and classification are unsupervised learning
Both clustering and classification are supervised learningQuiz Start Time: 08:50 PM Time Left 27
sec(s)Question # 7 of 10 ( Start time: 08:57:26 PM ) Total Marks: 1
In ________learning you don’t know the number of clusters and no idea about their attributes.
Select correct option:Supervised learning
Unsupervised learning (Answer)
Multi Dimension modeling
None of the given optionsQuiz Start Time: 08:50 PM Time Left 50
sec(s)Question # 8 of 10 ( Start time: 08:58:39 PM ) Total Marks: 1
In context of clustering, the term “distance” means:
Select correct option:Similarity/dissimilarly of records (Answer)
The difference between the primary keys of two records
The relation of a record with corresponding record in child table
None of the given optionsQuiz Start Time: 08:50 PM Time Left 15
sec(s)Question # 9 of 10 ( Start time: 08:59:22 PM ) Total Marks: 1
In data mining, initially you _____ what you are looking for.
Select correct option:Know
Don’t know (Answer)
May or may not know
None of the given optionsQuiz Start Time: 08:50 PM Time Left 52
sec(s)Question # 10 of 10 ( Start time: 09:00:41 PM ) Total Marks: 1
The optimizer uses a hash join to join two tables if they are joined using an equijoin and
Select correct option:Outer table has less number of rows
Inner table has less number of rows
Cardinality of tables is equal
Large amount of data needs to be joined (Answer) -
CS403 GDB1 Solution and discussionRelational data model
As a database designer, I’ll choose relational data model for the database designing because the relational model represents the database as a collection of relations. A relation is nothing but a table of values. Every row in the table represents a collection of related data values. These rows in the table denote a real-world entity or relationship.
The table name and column names are helpful to interpret the meaning of values in each row. The data are represented as a set of relations. In the relational model, data are stored as tables. However, the physical storage of the data is independent of the way the data are logically organized.
Relational Integrity constraints are referred to conditions which must be present for a valid relation. These integrity constraints are derived from the rules in the mini-world that the database represents.
Four basic update operations performed on relational database model are
Insert, update, delete and select. The Relational database model represents the database as a collection of relations (tables)Attribute, Tables, Tuple, Relation Schema, Degree, Cardinality, Column, Relation instance, are some important components of Relational Model Relational Integrity constraints are referred to conditions which must be present for a valid relation. The relational database is only concerned with data and not with a structure which can improve the performance of the model -
CS403 GDB1 Solution and discussion