Pre-Assessment for DATA
MANAGEMENT - FOUNDATIONS
A manager asks an employee to listing attributes of the clients which are headquartered in
Los Angeles and which have a client quantity better than a thousand. Refer to the given SQL
declaration prepared by way of this employee.
SELECT CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY='Los Angeles'
Which line have to go at the cease of this statement? - ANSAND CUSTNUM>one thousand;
A product-advertising organisation publishes an Internet-based publication about their new
products to growth their client base.
What is an advantage that this employer will gain from investing in a relational database
management system so that it will save customer statistics? - ANSImproved query reaction
times
A shop clerk is authorized to sell 12 merchandise; a product may be offered by 10
salespersons.
Which sort of binary relationship is described in this situation? - ANSMany-to-many
During which step inside the extract, rework, load (ETL) technique are raw statistics units
aggregated? - ANSTransformation
How is prediction distinguished from estimation in statistics mining? - ANSPrediction
classifies objects in line with an predicted future behavior.
How had been facts retrieved earlier than database control systems? - ANSSequentially
from simple files
In which ways does a database control system surroundings increase effectiveness in
running with records?
Choose 2 solutions - ANSIt enables facts sharing.
It allows storage of large volumes of facts.
Refer to the given SQL announcement to reply the subsequent question:
SELECT *
, FROM PRODUCT;
What might this SQL declaration accomplish? - ANSList all entries in the PRODUCT desk.
Refer to the given SQL statement.
SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
WHERE SPNUM=22;
How ought to this announcement be altered to retrieve the whole record in preference to the
commission percentage and 12 months of rent? - ANSReplace COMMPERCT, YEARHIRE
with an asterisk
Refer to the given SQL declaration.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is an appropriate line to feature to the quit of this statement to locate salespersons with
a commission percent of 15? - ANSWHERE COMMPERCT=15;
Refer to the given desk.
Project Code Employee No. Employee Name Department No. Department Name Hourly
Rate
PC010 S10001 A. Smith L004 IT 22.00
PC010 S10030 L. Jones L023 Pensions 18.50
PC010 S21010 P. Lewis L004 IT 21.00
PC045 S10010 B. Jones L004 IT 21.Seventy five
PC045 S10001 A. Smith L004 IT 18.00
PC045 S31002 T. Gilbert L028 Database 25.50
PC045 S13210 W. Richards L008 Salary 17.00
PC064 S31002 T. Gilbert L028 Database 23.25
PC064 S21010 P. Lewis L004 IT 17.50
PC064 S10034 B. James L009 HR sixteen.50
In which kingdom are the attributes shown? - ANSFirst regular shape
Refer to the given table.
Students
IDSt LastName IDProf Prof Grade
1 Mueller three Schmid five
2 Meier 2 Borner 4
three Tobler 1 Bernasconi 6
Which component determines whether or not the desk is in first everyday form? - ANSThe
attributes are all unmarried valued.
MANAGEMENT - FOUNDATIONS
A manager asks an employee to listing attributes of the clients which are headquartered in
Los Angeles and which have a client quantity better than a thousand. Refer to the given SQL
declaration prepared by way of this employee.
SELECT CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY='Los Angeles'
Which line have to go at the cease of this statement? - ANSAND CUSTNUM>one thousand;
A product-advertising organisation publishes an Internet-based publication about their new
products to growth their client base.
What is an advantage that this employer will gain from investing in a relational database
management system so that it will save customer statistics? - ANSImproved query reaction
times
A shop clerk is authorized to sell 12 merchandise; a product may be offered by 10
salespersons.
Which sort of binary relationship is described in this situation? - ANSMany-to-many
During which step inside the extract, rework, load (ETL) technique are raw statistics units
aggregated? - ANSTransformation
How is prediction distinguished from estimation in statistics mining? - ANSPrediction
classifies objects in line with an predicted future behavior.
How had been facts retrieved earlier than database control systems? - ANSSequentially
from simple files
In which ways does a database control system surroundings increase effectiveness in
running with records?
Choose 2 solutions - ANSIt enables facts sharing.
It allows storage of large volumes of facts.
Refer to the given SQL announcement to reply the subsequent question:
SELECT *
, FROM PRODUCT;
What might this SQL declaration accomplish? - ANSList all entries in the PRODUCT desk.
Refer to the given SQL statement.
SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
WHERE SPNUM=22;
How ought to this announcement be altered to retrieve the whole record in preference to the
commission percentage and 12 months of rent? - ANSReplace COMMPERCT, YEARHIRE
with an asterisk
Refer to the given SQL declaration.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is an appropriate line to feature to the quit of this statement to locate salespersons with
a commission percent of 15? - ANSWHERE COMMPERCT=15;
Refer to the given desk.
Project Code Employee No. Employee Name Department No. Department Name Hourly
Rate
PC010 S10001 A. Smith L004 IT 22.00
PC010 S10030 L. Jones L023 Pensions 18.50
PC010 S21010 P. Lewis L004 IT 21.00
PC045 S10010 B. Jones L004 IT 21.Seventy five
PC045 S10001 A. Smith L004 IT 18.00
PC045 S31002 T. Gilbert L028 Database 25.50
PC045 S13210 W. Richards L008 Salary 17.00
PC064 S31002 T. Gilbert L028 Database 23.25
PC064 S21010 P. Lewis L004 IT 17.50
PC064 S10034 B. James L009 HR sixteen.50
In which kingdom are the attributes shown? - ANSFirst regular shape
Refer to the given table.
Students
IDSt LastName IDProf Prof Grade
1 Mueller three Schmid five
2 Meier 2 Borner 4
three Tobler 1 Bernasconi 6
Which component determines whether or not the desk is in first everyday form? - ANSThe
attributes are all unmarried valued.
