Discussion
Home ‣ Database ‣ Introduction to SQL See What Others Are Saying!
- Question
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Options- A. all columns of the table are to be returned.
- B. all records meeting the full criteria are to be returned.
- C. all records with even partial criteria met are to be returned.
- D. None of the above is correct.
- Correct Answer
- all columns of the table are to be returned.
- 1. Which of the following is true concerning open-source DBMS?
Options- A. Is free or nearly free database software whose source code is publicly available
- B. Is free or nearly free database software whose source code is not publicly available
- C. Is not competitive against PC-oriented packages and is fully SQL compliant
- D. Is competitive against PC-oriented packages and is not fully SQL compliant Discuss
- 2. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Options- A. GROUP BY.
- B. WHERE.
- C. ORDER BY.
- D. FROM. Discuss
- 3. A server cannot serve on which of the following levels?
Options- A. Client Layer
- B. Business Layer
- C. Database Layer
- D. All of the above. Discuss
- 4. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
Options- A. Disjoint with total specialization
- B. Disjoint with partial specialization
- C. Overlap with total specialization
- D. Overlap with partial specialization Discuss
- 5. Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
- 6. The wildcard in a WHERE clause is useful when?
Options- A. An exact match is necessary in a SELECT statement.
- B. An exact match is not possible in a SELECT statement.
- C. An exact match is necessary in a CREATE statement.
- D. An exact match is not possible in a CREATE statement. Discuss
- 7. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Options- A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- C. Three rows have the values Brown, NULL, and Blue in the same column.
- D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. Discuss
- 8. Entities can be associated with one another in which of the following?
Options- A. Entities
- B. Attributes
- C. Identifiers
- D. Relationships Discuss
- 9. The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Options- A. True
- B. False Discuss
- 10. An action assertion is a statement that expresses some aspect of the static structure of the organization.
Options- A. True
- B. False Discuss
More questions
Correct Answer: Is free or nearly free database software whose source code is publicly available
Correct Answer: ORDER BY.
Correct Answer: Client Layer
Correct Answer: Overlap with total specialization
Correct Answer: Dirty read
Correct Answer: An exact match is not possible in a SELECT statement.
Correct Answer: One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Correct Answer: Relationships
Correct Answer: True
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.