QUESTION 1 Select the correctly written query. SELECT ALL FROM CUSTOMERS WHERE 1

Question

QUESTION 1

Select the correctly written query.

SELECT ALL FROM CUSTOMERS WHERE 10243 IS CUSTOMERID

PULL * FROM CUSTOMERS WHERE CUSTOMERID = 10243

SELECT * FROM CUSTOMERS WHERE CUSTOMERID = 10243

GET LIST FROM CUSTOMERS

2 points   

QUESTION 2

Which one is NOT a type of JOIN?

INNER JOIN

LEFT JOIN

RIGHT JOIN

OUTSIDE JOIN

2 points   

QUESTION 3

Match the following terms with their definitions.

Primary Key

Secondary Key

Foreign Key

Candidate Key

An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null.

An attribute or combination of attributes used strictly for data retrieval purposes.

A minimal ( irreducible) superkey; a superkey that does not contain a subset of attributes that is itself a superkey.

A candidate key selected to uniquely identify all other attribute values in any given row; cannot contain null entries.

2 points   

QUESTION 4

Normalization works through a series of stages called normal forms.

True

False

2 points   

QUESTION 5

Storing data in a permanent, denormalized table is a recommended solution.

True

False

2 points   

QUESTION 6

If a table has multiple candidate keys and one of them is a composite key, the table can have partial dependencies based on this composite candidate key, even when the primary key chosen is a single attribute.

True

False

2 points   

QUESTION 7

A Primary Key can be used to uniquely identify a column or row within a table?

True

False

2 points   

QUESTION 8

When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be ____?

join-compatible

domain-compatible

shared-compatible

union-compatable

2 points   

QUESTION 9

Each table must have a two Primary keys.

True

False

2 points   

QUESTION 10

The ER Model should be validated against expected processes. The 3 expected processes are inserts, updates, and _____.

queries

extracts

distributes

deletes

SELECT ALL FROM CUSTOMERS WHERE 10243 IS CUSTOMERID

PULL * FROM CUSTOMERS WHERE CUSTOMERID = 10243

SELECT * FROM CUSTOMERS WHERE CUSTOMERID = 10243

GET LIST FROM CUSTOMERS

Explanation / Answer

QUESTION 1

Ans->SELECT * FROM CUSTOMERS WHERE CUSTOMERID = 10243

All others are incorrect syntactically

QUESTION 2

Ans->OUTSIDE JOIN

LEFT JOIN returns all records from the left table , and the matched records from the right table.

RIGHT JOIN keyword returns all records from the right table, and the matched records from the left table.

INNER JOIN selects all rows from both participating tables as long as there is a match between the columns.

QUESTION 3

Ans->  Primary Key -> A candidate key selected to uniquely identify all other attribute values in any given row; cannot contain null entries.

Secondary Key -> An attribute or combination of attributes used strictly for data retrieval purposes.

Foreign Key -> An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null.

Candidate Key -> A minimal ( irreducible) superkey; a superkey that does not contain a subset of attributes that is itself a superkey.

QUESTION 4

Normalization works through a series of stages called normal forms.

Ans-> True, There is first normal form, second normal form, third normal form, boyce codd normal form and forth normal form.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.