Databases - Upwork

Question: The applications of Data Mining would not include:
A
Discovering buying-patterns for cross selling

B
Financial market prediction

C
Discovering errors made during data entry

D
Discovering which customer is most profitable

E
Credit assessment

Note: Not available
1. Report
Question: A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision-making process". The data within the warehouse is integrated in such a way that:
A
Users from all departments help to create the database

B
It contains the data of the enterprise in its entirety

C
The final product is a fusion of various legacy system information into a cohesive set of information

D
Every user has access to the data in the warehouse

Note: Not available
1. Report
Question: The simplest query must include at least________ and _________.
A
A select clause

B
A where clause

C
A from clause

D
A group by clause

E
A having clause

F
An order by clause

Note: Not available
1. Report
Question: Which of the following are aggregate functions in SQL?
A
Avg

B
Select

C
Order By

D
Sum

E
Union

F
Group by

G
Having

Note: Not available
1. Report
Question: Which logical operator can reverse the result?
A
AND

B
OR

C
NOT

D
ANY

Note: Not available
1. Report
Question: What are the programs that execute automatically whenever DML operations are performed on tables called?
A
Triggers

B
Procedures

C
Functions

D
None of the above

Note: Not available
1. Report
Question: The primary key index does not allow ________ data in a field.
A
Numeric

B
Characte

C
Date

D
Null

E
Duplicate

F
All of the above

Note: Not available
1. Report
Question: Which character function should be used to return a specified portion of a character string?
A
CONCAT

B
LENGTH

C
SUBSTR

D
INITCAP

Note: Not available
1. Report
Question: Which one of the following correctly selects rows from the table myTable that have null in column column1?
A
SELECT * FROM myTable WHERE column1 is null

B
SELECT * FROM myTable WHERE column1 = null

C
SELECT * FROM myTable WHERE column1 EQUALS null

D
SELECT * FROM myTable WHERE column1 NOT null

E
SELECT * FROM myTable WHERE column1 CONTAINS null

Note: Not available
1. Report
Question: What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount*1.10What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount*1.10
A
Increases OrderDiscount of first row by 10%

B
Increases OrderDiscount of all rows by 10%

C
Does nothing without where clause

D
Gives an error due to lack of where clause

Note: Not available
1. Report

First Prev 22 23 24 25 26 Next Last

Question: The applications of Data Mining would not include:

Question: A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision-making process". The data within the warehouse is integrated in such a way that:

Question: The simplest query must include at least and _.

Question: Which of the following are aggregate functions in SQL?

Question: Which logical operator can reverse the result?

Question: What are the programs that execute automatically whenever DML operations are performed on tables called?

Question: The primary key index does not allow ________ data in a field.

Question: Which character function should be used to return a specified portion of a character string?

Question: Which one of the following correctly selects rows from the table myTable that have null in column column1?

Question: What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount1.10What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount1.10

Question: The applications of Data Mining would not include:

Question: A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision-making process". The data within the warehouse is integrated in such a way that:

Question: The simplest query must include at least________ and _________.

Question: Which of the following are aggregate functions in SQL?

Question: Which logical operator can reverse the result?

Question: What are the programs that execute automatically whenever DML operations are performed on tables called?

Question: The primary key index does not allow ________ data in a field.

Question: Which character function should be used to return a specified portion of a character string?

Question: Which one of the following correctly selects rows from the table myTable that have null in column column1?

Question: What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount*1.10What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount*1.10

Question: The simplest query must include at least and _.

Question: What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount1.10What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount1.10