CompTIA Databases
An INSERT statement is an example of what data language type?
Data Manipulation Language. These commands allow you to insert or update records and extract information from records for viewing
How is a relationship identified between two tables in an RDBMS?
Each table contains a primary key whose value is unique for each record in the table. A foreign table can use the value of a primary key as a relation, storing the value in a foreign key field.
What are the structural elements of a database?
Each table stores information about records in fields.
How does Microsoft SQL Server differ from Microsoft Excel when used to store a dataset?
Excel is an example of a flat file system, whereas SQL Server is relational database software that is better suited for larger volumes of information and more users.
You need a development environment with a library of database functions. What type of interface are you using?
Programmatic access. Most programming languages include libraries to provide default code for connecting to a database and executing queries.
What term is used to describe selecting and viewing information in a database?
Query
Which of the following is NOT an example of unstructured data?
Relational Databases. Unstructured data provides no rigid formatting of the data, which regional databases does do.
Give two examples of semi-structured data stores.
Semi-structured data lacks the structure of a formal database architecture but adds associated metadata to raw unstructured data. This helps identify the data. Two examples of semi-structured data are key/value pair databases and markup language documentation stores.
What language is usually used to request data from an RDBMS such as Oracle?
Structured Query Language (SQL) is used to query RDBMS-based database platforms.
How can a client-server application architecture be described if it could be re-developed to split the application and presentation layers?
This could be described as a two-tier application capable of becoming a tier-three application.
