A _____ is the unique identifier for a record. a. Common record. b. Turn Key c.

Question

A _____ is the unique identifier for a record. a. Common record. b. Turn Key c. Primary Key d. Foreign Key For the purpose of this class (and most real-world applications), we want our data to be normalized to this level on our ER Models? a. 3NF b. INF c. 2NF d. Un normalized data Which of the following commands is required in a SELECT statement? a. WHERE b. ORDER BY c. FROM d. GROUP BY Which of the following symbols would display all of the columns from a table? a. % b. & c. + d. # Which of the following represents exactly one character in a pattern search? a. ESCAPE b. _ c. ? d. % Which of the following causes is used to display query results in a sorted order? a. SELECT b. FROM c. WHERE d. ORDER BY e. None of the above Which of the following commands can be used to join 2 SELECT statements? a. JOIN b. CONCACTENATE c. UNION d. None of the above A ______ is a type of join that uses a common column between the two tables. a. Self Join b. Cartesian Join c. Outside Join d. Natural Join

Explanation / Answer

16. Primary key is used for unique identification of a record ( option c)

A primary key should not contains a null values

There should only one primary key for a table

17. 3NF ( option 1)

The data that is to be normalised in the real world is third normal form

18. The statement required for select command is from ( option c)

19. The symbol used to display all the columns from a table is *

( option c)

20. The symbol used for exactly one character pattern search is %

( option d)

21. The clause used to display the query in sorted order is order by clause ( option d)

22. Join is a command used to join 2 select statements (option a)

23. The type of join that uses a common column between the two tables is natural join ( option d)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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