Database/SQL

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

Which component of SQL architecture receives information from a SQL query and from a Parser + Optimizer?

Answer 2

Query Language Processor

Question 3

Which component of SQL architecture receives information from the Queary Language Processor and from a File Manager + Transaction Manager?

Answer 3

DBMS Engine

Question 4

Which component of SQL architecture receives information from the DBMS Engine?

Answer 4

Physical Database

Question 5

What is a field in a DB table that uniquely identifies each row/record?

Answer 5

Primary key

Question 6

Must primary keys contain unique values?

Answer 6

Yes

Question 7

Can primary key columns contain NULL values?

Answer 7

No

Question 8

Can a table have more than one primary key?

Answer 8

No

Question 9

What is the name for multiple fields in a primary key?

Answer 9

Composite key

Question 10

If a table has a primary key defined on on any field(s), can there be more than one record with the same value as the field(s)?

Answer 10

No

Question 11

Also called a referencing key, what is the name of a key that is used to link two tables together?

Answer 11

Foreign key

Question 12

A foreign key is a column or combination of columns whose values match a ____ in a different table.

Answer 12

Primary key

Question 13

What are the DDL (Data Definition Language) statements in SQL?

Answer 13

CREATE, ALTER, DROP

Question 14

What are the DML (Data Maipulation Language) statements in SQL?

Answer 14

SELECT, INSERT, UPDATE, DELETE

Question 15

What are the DCL (Data Control Language) statements in SQL?

Answer 15

GRANT, REVOKE

Question 16

What are the TCL (Transaction Control Language) statements in SQL?

Answer 16

SAVEPOINT, ROLLBACK, COMMIT

Question 17

What SQL statement is used to fetch data from a database and return this data in the form of a table?

Answer 17

SELECT

Question 18

What syntax is used to fetch all fields?

Answer 18

SELECT * FROM

Question 19

What SQL clause is used to specify a condition while fetching the data from a table or by joining multiple tables?

Answer 19

WHERE

Question 20

What other statements can WHERE be used in besides SELECT?

Answer 20

UPDATE, DELETE

Question 21

What SQL statement is used to add new rows of data to a table in the database?

Answer 21

INSERT INTO

Question 22

What clause is used to specify the values being added to their respective columns via INSERT INTO?

Answer 22

VALUES

Question 23

What clause is used to combine records from two or more tables in a DB?

Answer 23

JOIN

Question 24

What type of JOIN is used only to combine mutually inclusive data from both tables?

Answer 24

INNER JOIN

Question 25

What types of JOIN are used to combine only data from the left table or from the right table, respectively?

Answer 25

LEFT JOIN, RIGHT JOIN

Question 26

What type of JOIN is used to combine all data from both tables?

Answer 26

FULL JOIN