How does a query language like sql work

Assignment Help Database Management System

Reference no: EM131112023

Assessment Questions

Question 1

Which term refers to a collection of data fields?

Flat file
Field
Relationship
Record

Question 2

Which of these access controls tracks what a user does?

Accountability
Authorization
Identification and authentication
Verification

Question 3

When discussing data management tools, which tool is the most versatile for managing simple flat files that involve calculations?

Dedicated software
Word processing software
Spreadsheet software
database software

Question 4

In which order is data in a typical database stored?

Ascending
Descending
No particular order
Hierarchical

Question 5

Which of the following is an analytical process that allows decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status?

Data mining analytics
Online analytical processing (OLAP)
Data warehousing
Predictive analytics

Question 6

In database jargon, cardinality refers to the number of associations that can exist between two record types. Identify the three types of relationships that deal with cardinality and explain each one.

Question 7

How does a query language like SQL work? Give brief descriptions of commands, parameters, and record searches.

Question 8

What kinds of databases track relationships? Give a brief description and the advantages of at least three.

Reference no: EM131112023

Questions Cloud

How many numbers of collision and broadcast domains : How many numbers of collision and broadcast domains does the network have? When station A sends a packet to station C, whose Ethernet address does station A use for the destination address?

Justification for decision : What sort of argument is Anne using as justification for her decision?

What is likelihood that eight or fewer installations took : The Maumee branch installed 50 mufflers last month. If the corporate report is correct: How many of the installations at the Maumee branch would you expect to take more than 30 minutes?

Determining the kind of argument : Females are currently responsible for 85% of all consumer purchases. So, I'll bet it was a woman that bought the size 16 shoes I just sold on EBay. Putting this argument into standard form for its type would be putting it into the form of what kin..

How does a query language like sql work : What kinds of databases track relationships? Give a brief description and the advantages of at least three. How does a query language like SQL work? Give brief descriptions of commands, parameters, and record searches.

Illustrate outcomes graphically : To what extent have increases in U.S. real GDP resulted from more labor inputs? From higher labor productivity?

Is it spying or just good management : If a hardware or software maker finds a vulnerability in one of its products, how should it respond? Does it have a legal responsibility to warn its users? Does it have an ethical responsibility to do so? Why or Why not?

Dust storms in oklahoma : Imagine an argument for the conclusion that the dust storms in Oklahoma in the 1930s were caused by over-plowing. If that argument were based on the authority of statements made by documentarian Ken Burns (and you were going to put the argument i..

How many sculptures can he display : Brian is helping to set up 20 small tables for an exhibit of Eskimo sculpture at the museum. Each table can have one sculpture on each side. If he pushes all the tables together to make one long table, how many sculptures can he display?

User Account

All Pages