Discussion
Home ‣ Database ‣ SQL for Database Construction See What Others Are Saying!
- Question
Views can be used to show the results of computed columns.
Options- A. True
- B. False
- Correct Answer
- True
- 1. Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Options- A. always
- B. commonly
- C. seldom
- D. never Discuss
- 2. Which of the following is true concerning a procedure?
Options- A. You do not create them with SQL.
- B. They do not need to have a unique name.
- C. They include procedural and SQL statements.
- D. They are the same thing as a function. Discuss
- 3. An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
Options- A. COBOL.
- B. VB.NET.
- C. TRANSACT SQL.
- D. Visual Basic. Discuss
- 4. An attribute name should be which of the following?
Options- A. Singular verb or verb phrase
- B. Follow a standard format
- C. Use a alias
- D. All of the above. Discuss
- 5. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Options- A. READ_ONLY
- B. SCROLL_LOCK
- C. OPTIMISTIC
- D. PESSIMISTIC Discuss
- 6. Which of the following is one of the basic approaches for joining tables?
Options- A. Subqueries
- B. Union Join
- C. Natural join
- D. All of the above Discuss
- 7. Database redesign is especially difficult if the database has no data.
Options- A. True
- B. False Discuss
- 8. The most popular way to materialize XML documents is to use XSLT.
Options- A. True
- B. False Discuss
- 9. The presentation logic component is responsible for formatting and presenting data on the user's screen or other output device, and for managing user input from a keyboard or other input device.
Options- A. True
- B. False Discuss
- 10. ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
Options- A. True
- B. False Discuss
More questions
Correct Answer: commonly
Correct Answer: They include procedural and SQL statements.
Correct Answer: TRANSACT SQL.
Correct Answer: Follow a standard format
Correct Answer: OPTIMISTIC
Correct Answer: All of the above
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.