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