Exam 10: Databases Database Basics

 SQL works behind the scenes as an intermediary between the database client software provided to users and the database itself.​ 

 The entire Internet contains about a zettabyte of data.​ 

 The acronym ____________ refers to software that manages data stored in a database.​​ 

 1024 Zettabytes = 1 _______.​

 A(n) _________ database is used to collect, modify, and maintain data on a daily basis.​ 

 There are three core elements in a relational database: fields, ________, and relationships.​

 Exploits that use malicious SQL statements to gain unauthorized access to a database are called SQL _____________.​

 _________-density data refers to large volumes of very detailed data in which many of the details are not important.​

 Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.​ 

 Computer programming languages designed for databases are called _________ languages because one of their main capabilities is to request data from a database​

 Most spreadsheet software also includes basic data management features.​ 

 Decision makers can access analytical databases using an executive __________.​

 __________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.​

 The underlying structure of a database is referred to as a database _________.​

 The SQL command word _________ removes a record from a table.​

 From a technical perspective, a data __________ specifies the way data is represented on physical storage media and in RAM.​

 A(n) __________ file consists of a single, two-dimensional table of data elements.​

 When joining two tables using SQL, the convention is to use ______ notation for field names.​

 Which of the following is not a SQL keyword?​ 

 The SQL query language provides a collection of special command words called SQL ______________.​