SQL Database Fundamentals

Which of the following is used to modify the structure of a table?

Alter Table

ANSI stands for which of the following?

American National Standards Institute

The acronym ACID stands for

Atomicity, Consistency, Isolation, and Durability

Which of the following SQL statements adds a Primary Key constraint for column ClientID when used within a CREATE TABLE statement?

CONSTRAINT PK_Client PRIMARY KEY (ClientID)

______ is an example of DDL?

CREATE

Which of the following SQL commands is used to add a SQL database?

CREATE DATABASE

Which of the following SQL statements is used to generate an index for a table?

CREATE INDEX

Which of the following SQL statements is used to end your current transaction and make permanent changes performed in the transaction?

Commit

The acronym CAP stands for

Consistency, Availability, and Partition Tolerance

A _____ SQL statement is used to generate a SQL table?

Create Table

The acronym CRUD stands for

Create, Read, Update, and Delete

Which of the following SQL statements removes the table called Products?

DROP TABLE Products;

The acronym DML stands for

Data Manipulation Language

The acronym DDL stands for

Database Definition Language

Which SQL statement is used to remove rows from a database table?

Delete

______ ensures each record in a table is uniquely identified.

Entity integrity

ETL stands for

Extract, Transform, Load

A Primary Key may contain only one column?

False

Most major RDMS providers do not implement ACID principles?

False

A ______ enforces that all of a column's values must match existing values from the column it references.

Foreign Key Constraint

Which of the following joins selects records with matching values in both tables?

Inner Join

Which SQL statement is used to add rows into a database table?

Insert

Which range of values defines an int?

Integer Data From -2,147,483,648 to 2,147,483,648

______ requires concurrent transactions must leave the database in a status as if they were executed sequentially.

Isolation

Which of the following is not true for a Primary Key?

It can contain NULL values

Which of the following joins selects all records from the left table and the matched records from the right table?

Left Join

In SQL Server, which SQL command is used to limit the number of records returned by a query result set to a specified number of rows?

Limit

Which of the following database systems is not a RDBMS?

MariaDB

Which of the below SQL keywords is used to sort a result set in ascending or descending order?

Order By

A ______ is often used to enforce entity integrity within a table.

Primary key

R.D.M.S. stands for

Relational Database Management System

Which of the following SQL statements is used to erase all data changes made from the start of the current transaction?

Rollback

How do you retrieve all the rows and columns from a table named Cities?

SELECT * FROM Cities;

Which of the following SQL statements will return the FirstName and LastName columns

SELECT FirstName, LastName FROM Customers;

Which SQL statement is used to retrieve data from a database?

Select

The acronym SQL stands for

Structured Query Language

A ______ is a unique identifier not derived from application data and that has no business meaning. For example, the first five values might be 1, 2, 3, 4, 5.

Surrogate key

A ______ is a data structure that organizes information into rows and columns.

Table

The acronym 3NF stands for

Third Normal Form

Which of the following is a set of programming extensions from Sybase and Microsoft that adds features to the SQL available in SQL Server?

Transact-SQL

A table column is also considered to be an attribute.

True

Postgres, SQL Server, and MySQL each have a DATE datatype?

True

The DELETE statement may be used in conjunction with the WHERE statement?

True

______ is an example of DML?

UPDATE

Which SQL statement is used to modify existing rows in a database table?

Update

A ______ is a virtual table with contents based on the result-set of a SQL statement.

View

Which SQL statement filters rows from a table named Cities to just rows whose CityName starts with B?

WHERE CityName LIKE 'B';

Which of the below SQL statements will filter down to FirstName starting with B and containing only 2 total characters?

WHERE FirstName LIKE 'B_'

Which of the below SQL statements will filter to records with FruitName values containing Orange, Apple, or Pineapple

WHERE FruitName IN ('Orange', 'Apple', 'Pineapple')

RANK is an example of a ______ function

Window