Discussion
Home ‣ Database ‣ Advanced SQL See What Others Are Saying!
- Question
With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
Options- A. True
- B. False
- Correct Answer
- True
- 1. Which of the following is not one of the three ways to classify an action assertion?
Options- A. Condition
- B. Integrity Control
- C. Authorization
- D. Enabler Discuss
- 2. Every key used to join the fact table with a dimensional table should be a surrogate key.
Options- A. True
- B. False Discuss
- 3. Which of the following is true concerning a global transaction?
Options- A. The required data are at one local site and the distributed DBMS routes requests as necessary.
- B. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
- C. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
- D. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS. Discuss
- 4. An operational system is which of the following?
Options- A. A system that is used to run the business in real time and is based on historical data.
- B. A system that is used to run the business in real time and is based on current data.
- C. A system that is used to support decision making and is based on current data.
- D. A system that is used to support decision making and is based on historical data. Discuss
- 5. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
Options- A. parent
- B. child
- C. instance
- D. subtype Discuss
- 6. How can you find rows that do not match some specified condition?
Options- A. EXISTS
- B. Double use of NOT EXISTS
- C. NOT EXISTS
- D. None of the above is correct. Discuss
- 7. When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Options- A. Data source
- B. Driver
- C. Driver manager
- D. OLE DB Discuss
- 8. What servlet processor was developed by Apache Foundation and Sun?
Options- A. Apache Tomcat
- B. Apache Web server
- C. Sun servlet processor
- D. None of the above is correct. Discuss
- 9. What SQL command can be used to delete columns from a table?
Options- A. MODIFY TABLE TableName DROP COLUMN ColumnName
- B. MODIFY TABLE TableName DROP ColumnName
- C. ALTER TABLE TableName DROP COLUMN ColumnName
- D. ALTER TABLE TableName DROP ColumnName Discuss
- 10. The EXISTS keyword will be true if:
Options- A. any row in the subquery meets the condition only.
- B. all rows in the subquery fail the condition only.
- C. both of these two conditions are met.
- D. neither of these two conditions is met. Discuss
More questions
Correct Answer: Enabler
Correct Answer: True
Correct Answer: The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
Correct Answer: A system that is used to run the business in real time and is based on current data.
Correct Answer: child
Correct Answer: Double use of NOT EXISTS
Correct Answer: Driver manager
Correct Answer: Apache Tomcat
Correct Answer: ALTER TABLE TableName DROP COLUMN ColumnName
Correct Answer: any row in the subquery meets the condition only.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.