Discussion
Home ‣ Database ‣ SQL for Database Construction Comments
- Question
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Options- A. True
- B. False
- Correct Answer
- True
- 1. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
Options- A. True
- B. False Discuss
- 2. The SQL statement used to create a view is CREATE VIEW.
Options- A. True
- B. False Discuss
- 3. A updatable view has its own data.
Options- A. True
- B. False Discuss
- 4. Three types of triggers are: BEFORE, AFTER and EXCEPTION.
Options- A. True
- B. False Discuss
- 5. The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
Options- A. True
- B. False Discuss
- 6. The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
Options- A. True
- B. False Discuss
- 7. A SQL view is a virtual table that is constructed from other tables or views.
Options- A. True
- B. False Discuss
- 8. SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
Options- A. True
- B. False Discuss
- 9. A benefit of using a stored procedure is that it can be distributed to client computers.
Options- A. True
- B. False Discuss
- 10. Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.
Options- A. True
- B. False Discuss
SQL for Database Construction problems
Search Results
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.