A database administrator wants to insert a record (row) into a database's Movies table. Which of the following is the SQL command that the administrator can use to insert the record?
Correct Answer:
INSERT INTO Movies (id, title, year, director) VALUES (166, "The Guardian", 1945, "Hal Manchin")
Correct Answer:
INSERT Movies VALUES (166, "The Guardian", 1945, "Hal Manchin") FIELDS (id, title, year,
director)
Correct Answer:
ALTER TABLE Movies (id, title, year, director) VALUES (166, "The Guardian", 1945, "Hal Manchin")
Correct Answer:
UPDATE TABLE Movies (id, title, year, director) VALUES (166, "The Guardian", 1945, "Hal Manchin")
Fundamentals of Database Systems
7th EditionRamez Elmasri, Shamkant B. Navathe
687 solutions
Service Management: Operations, Strategy, and Information Technology
7th EditionJames Fitzsimmons, Mona Fitzsimmons
103 solutions
Introduction to Algorithms
3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
720 solutions
Operating System Concepts
9th EditionAbraham Silberschatz, Greg Gagne, Peter B. Galvin
489 solutions
Email messages are a good example. While the actual content is unstructured, it does contain structured data such as name and email address of sender and recipient, time sent, etc.
Another example is a digital photograph. The image itself is unstructured, but if the photo was taken on a smart phone, for example, it would be date and time stamped, geo tagged, and would have a device ID. Once stored, the photo could also be given tags that would provide a structure, such as 'dog' or 'pet.'
Sets with similar termsUpgrade to remove ads
Only SGD 41.99/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set (45)
Two lists showing different values for the same data in different places of a database is an example of
-data redundancy.
-data disparity.
-data irregularity.
-data inconsistency.
data inconsistency
Which of the following
is a TRUE statement when considering using databases instead of lists?
-Data can be easily shared among users.
-Data-entry errors can be minimized with databases.
-Data integrity can be ensured with a database.
-all of the above
all of the above
Which type of relationship should be used to connect a Password table to a User Account table?
-one-to-one relationship
-many-to-many relationship
-one-to-none relationship
-one-to-many relationship
one-to-one relationship
Which type of database organizes data by measure and feature attributes?
-object-oriented database
-multidimensional database
-relational database
-all of the above
multidimensional database
The
field that has a unique entry for each record in a database table is called the
-primary key.
-foreign key.
-master field.
-logical key.
primary key
Which best describes a data warehouse?
-a software program that assists with file management
-a building that stores computer servers
-a collection of all the data from an organization's databases
-a database that organizes data from multiple organizations
a collection of all the data from an organizations databases
Extracting, transforming, and storing data are processes associated with which of the following?
-data staging
-online analytical processing
-transaction processing
-data scrubbing
data staging
The
process by which great amounts of data are analyzed and investigated is known as
-data staging.
-data mining.
-clustering.
-online analytical processing.
data mining
A system that is designed to help keep track of everyday business activities is a(n)
-decision support system.
-enterprise resource planning system.
-transaction-processing system.
-management information system.
transaction-processing system
Which type of information system is used mainly by executive managers and gathers data from data warehouses and data marts?
-voice management system
-decision support system
-expert system
-business intelligence system
business intelligence system
When
is it sufficient to use a list to organize data?
-when data needs to be organized into two or more tables
-when the data is simple and can be organized in one table
-when more than one person needs to access the data
-all of the above
when the data is simple and can be organized in one table
A customer information table linked to an orders table in a business database reflects which type
of relationship?
-one-to-one
-one-to-many
-many-to-many
-many-to-one
one-to-many
A process to ensure that data in a database is organized most efficiently is called
-centralization.
-integration.
-data staging.
-normalization.
normalization
Which of the following is NOT
considered metadata?
-field name
-database name
-field size
-data type
database name
Data captured as users navigate through a website is called
-staged data.
-time-variant data.
-web-user data.
-clickstream data.
clickstream data
The type of database that would be best to
store and organize video clips and pictures is which of the following?
-relational database
-multidimensional database
-object-oriented database
-all of the above
object-oriented database
Which of the following is used to create a temporary subset of data that matches certain criteria?
-request
-filter
-relationship
-query
filter
Which of the following data-mining techniques is used to determine which data goes together?
-clungtering
-classification
-affinity grouping
-visualization
affinity grouping
Unnecessary duplication of data in a database is referred to as
-normalized data.
-data inconsistency.
-validated data.
-data redundancy.
data redundancy
Which of the following is a method of inputting data into a transaction-processing system while the transaction is taking place?
-real-time processing
-batch processing
-input processing
-all of the above
real-time processing
A field labeled PHONE that accepts data such as (610) 555-1212 would use the Number data type.
false
A query is used to extract a subset of data from a database
true
A small slice of a data warehouse is called a data mine.
false
Data warehouses capture data only from one time period.
false
A multidimensional database uses two dimensions in which to organize data.
false
A ________ displays a subset of data from a table (or tables) based on the specified criteria
-select query
-join query
-table query
-criteria query
select query
Management information
systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system.
-detail
-summary
-exception
-expert
exception
If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.
-completeness
-integrity
-normalization
-redundancy
redundancy
Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data.
-enterprise
-unstructured
-multidimensional
-structured
unstructured
________ databases are the most
commonly used electronic databases.
-Relational
-Flat-file
-Object-oriented
-Multidimensional
relational
A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250.
-numeric
-completeness
-range
-consistency
range
In
a database, the term ________ is synonymous with a category of data
-field
-record
-table
-row
field
You can set a ________, which is automatically displayed in a field unless the user enters something different.
-relation
-field type
-numeric check
-default value
default value
In
a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing.
-direct
-real-time
-batch
-immediate
real-time
________ is the branch of computer science that attempts to create computers that think like humans.
-Expert systems
-Artificial intelligence
-Enterprise resource planning
-Natural language processing
artificial intelligence
________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.
-Normalization
-Record integrity
-Database consistency
-Referential integrity
referential integrity
A
________ is a collection of related data that can be stored, sorted, organized, and queried.
-memo
-macro
-document
-database
database
________ is used to ensure that data is organized most efficiently in a database
-Normalization
-Consistency checking
-Range checking
-Validation
normalization
In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.
-short text
-long text
-object
-text
long text
Data ________ helps to ensure data integrity by maintaining information in only one place.
-redundancy
-flexibility
-centralization
-mapping
centralization
Data in a multidimensional database is organized in a ________ format.
-modular
-linear
-cube
-cellular
cube
Which of the following is a likely primary key in a student information record?
-Student ID number
-Last name
-Date of birth
-First name
student id number
A ________ check compares the values of data in two or more fields to see whether those values are reasonable.
-range
-consistency
-correctness
-numeric
consistency
A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.
-one-to-one
-many-to-one
-many-to-many
-one-to-many
one-to-one
A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.
-enquiry
-field constraint
-query
-validation rule
query
Sets with similar termsChapter 11
45 terms
nicodico12
MGMT CH 11
40 terms
stephaniek0155
Intro To Computers Ch 11
53 terms
M_Shelton
Chapter 11 (notes 1)
54 terms
novelhellsing
Sets found in the same folderChapter 5: End of Chapter Quiz
15 terms
saraya2012
Chapter 13
15 terms
Jacob_Holcombe
Chapter 7: End of Chapter Quiz
15 terms
mack_harris
Chapter 10
10 terms
taylerht
Other sets by this creatorETS BUSINESS EXAM
171 terms
sophia_lozinski
ETS Business Exam Study Guide
203 terms
sophia_lozinski
Chapter 10
31 terms
sophia_lozinski
Chapter 9
31 terms
sophia_lozinski
Verified questions
COMPUTER SCIENCE
A binary search function is searching for a value that is stored in the middle element of an array. How many times will the function read an element in the array before finding the value?
Verified answer
COMPUTER SCIENCE
Discuss the hardware support required to support demand paging.
Verified answer
COMPUTER SCIENCE
A priming read is part of the pattern for a(n) a) interactive loop b) end-of-file loop c) sentinel loop d) infinite loop
Verified answer
COMPUTER SCIENCE
Suppose it is a reference to an object that implements the Iterator interface. Consider the following incomplete code segment. while (expression) { System.out.println(it.next()); } Which expression should go in the condition of the while loop so that the loop iterates through every element? (A) it.next(), (B) it.next() !=null, (C) it.next()==true, (D) it==true, (E) it.hasNext().
Verified answer
Recommended textbook solutionsInformation Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface
5th EditionDavid A. Patterson, John L. Hennessy
220 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Other Quizlet setsVocabulary Quiz 13
24 terms
TaishoJapan
Genetics Exam 3 (chapter 19 key terms: Molecular G…
45 terms
pmoneyyy
history final ch 1-19
119 terms
raeganbuchananPLUS
SCI 190 TEST 4
35 terms
aubrey_woolford
Related questionsQUESTION
Equal credit along the conversion touch points
2 answers
QUESTION
Two Types of Physical Storage of Databases
3 answers
QUESTION
An application programming interface (API) uses script files that perform specific functions based on the client's parameters that are passed to the web server.
13 answers
QUESTION
Validation Rules can contain a Formula or an expression that evaluates the data in one or more fields and returns a value of "True" or "False"
2 answers