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? Show
Sets found in the same folderRecommended textbook solutions
Fundamentals of Database Systems7th EditionRamez Elmasri, Shamkant B. Navathe 687 solutions
Service Management: Operations, Strategy, and Information Technology7th EditionJames Fitzsimmons, Mona Fitzsimmons 103 solutions
Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 720 solutions Operating System Concepts9th 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
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 disparity. -data irregularity. -data inconsistency. data inconsistency Which of the following
is a TRUE statement when considering using databases instead of lists? -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? -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? -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 -foreign key. -master field. -logical key. primary key Which best describes a data warehouse? -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? -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 mining. -clustering. -online analytical processing. data mining A system that is designed to help keep track of everyday business activities is a(n) -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? -decision support system -expert system -business intelligence system business intelligence system When
is it sufficient to use a list to organize data? -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-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 -integration. -data staging. -normalization. normalization Which of the following is NOT
considered metadata? -database name -field size -data type database name Data captured as users navigate through a website is called -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? -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? -filter -relationship -query filter Which of the following data-mining techniques is used to determine which data goes together? -classification -affinity grouping -visualization affinity grouping Unnecessary duplication of data in a database is referred to as -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? -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 -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. -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 ________. -integrity -normalization -redundancy redundancy Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data. -unstructured -multidimensional -structured unstructured ________ databases are the most
commonly used electronic databases. -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. -completeness -range -consistency range In
a database, the term ________ is synonymous with a category of data -record -table -row field You can set a ________, which is automatically displayed in a field unless the user enters something different. -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. -real-time -batch -immediate real-time ________ is the branch of computer science that attempts to create computers that think like humans. -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. -Record integrity -Database consistency -Referential integrity referential integrity A
________ is a collection of related data that can be stored, sorted, organized, and queried. -macro -document -database database ________ is used to ensure that data is organized most efficiently in a database -Consistency checking -Range checking -Validation normalization In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field. -long text -object -text long text Data ________ helps to ensure data integrity by maintaining information in only one place. -flexibility -centralization -mapping centralization Data in a multidimensional database is organized in a ________ format. -linear -cube -cellular cube Which of the following is a likely primary key in a student information record? -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. -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. -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. -field constraint -query -validation rule query Sets with similar termsChapter 1145 terms nicodico12 MGMT CH 1140 terms stephaniek0155 Intro To Computers Ch 1153 terms M_Shelton Chapter 11 (notes 1)54 terms novelhellsing Sets found in the same folderChapter 5: End of Chapter Quiz15 terms saraya2012 Chapter 1315 terms Jacob_Holcombe Chapter 7: End of Chapter Quiz15 terms mack_harris Chapter 1010 terms taylerht Other sets by this creatorETS BUSINESS EXAM171 terms sophia_lozinski ETS Business Exam Study Guide203 terms sophia_lozinski Chapter 1031 terms sophia_lozinski Chapter 931 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 Value5th EditionJack T. Marchewka 346 solutions Information Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions Computer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions Information Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions Other Quizlet setsVocabulary Quiz 1324 terms TaishoJapan Genetics Exam 3 (chapter 19 key terms: Molecular G…45 terms pmoneyyy history final ch 1-19119 terms raeganbuchananPLUS SCI 190 TEST 435 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 Which type of database is best for handling unstructured types of data such as audio and video files?As noted earlier, unstructured data can be textual or non-textual (such as audio, video, and images), and generated by people or by machines. Non-relational databases such as MongoDB are the preferred choice for storing many kinds of unstructured data.
Can NoSQL handle unstructured data?Flexibility: NoSQL databases generally provide flexible schemas that enable faster and more iterative development. The flexible data model makes NoSQL databases ideal for semi-structured and unstructured data.
What is the most commonly used type of database?Relational Databases. A relational database is the most common type of database. It uses schema, which is a template used to dictate the data structure stored within the database.
What type of database is a collection of data that is organized in tables from which the data can be accessed and organized in many different ways?A collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.
|