Discussion
Home ‣ Database ‣ Distributed Databases See What Others Are Saying!
- Question
Replication should be used when which of the following exist?
Options- A. When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
- B. When using many nodes with different operating systems and DBMSs and database designs.
- C. The application's data can be somewhat out-of-date.
- D. All of the above.
- Correct Answer
- The application's data can be somewhat out-of-date.
- 1. Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
Options- A. advantage
- B. disadvantage
- C. either an advantage or disadvantage
- D. neither an advantage nor disadvantage Discuss
- 2. The NOT EXISTS keyword will be true if:
Options- A. any row in the subquery meets the condition.
- B. all rows in the subquery fail the condition.
- C. both of these two conditions are met.
- D. neither of these two conditions is met. Discuss
- 3. The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
Options- A. True
- B. False Discuss
- 4. A rectangle represents which of the following in an EER?
Options- A. Attribute
- B. Entity
- C. Optional One
- D. Relationship Discuss
- 5. What standard, protocol or language was generalized to become a standard protocol for sending messages of any type, using any protocol?
Options- A. SOAP
- B. SGML
- C. SQL
- D. ADO Discuss
- 6. The semicolon terminates a SQL statement (and executes it).
Options- A. True
- B. False Discuss
- 7. The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.
Options- A. True
- B. False Discuss
- 8. Stored procedures have which of the following advantages?
Options- A. It takes a longer time to write them as compared to writing Visual Basic.
- B. Network traffic increases
- C. Data integrity improves as multiple applications access the same stored procedure.
- D. Result in thicker client and thinner database server. Discuss
- 9. Which prefixes are available to Oracle triggers?
Options- A. :new only
- B. :old only
- C. Both :new and :old
- D. Neither :new nor :old Discuss
- 10. Business Intelligence (BI) reporting analyses can be performed using ________ .
Options- A. standard SQL only
- B. extensions to SQL only
- C. OLAP only
- D. both standard SQL and extensions to SQL Discuss
More questions
Correct Answer: neither an advantage nor disadvantage
Correct Answer: all rows in the subquery fail the condition.
Correct Answer: False
Correct Answer: Entity
Correct Answer: SOAP
Correct Answer: True
Correct Answer: False
Correct Answer: Data integrity improves as multiple applications access the same stored procedure.
Correct Answer: Both :new and :old
Correct Answer: standard SQL only
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.