Discussion
Home ‣ Database ‣ The Database Development Process See What Others Are Saying!
- Question
The longest step of database development is database maintenance.
Options- A. True
- B. False
- Correct Answer
- True
- 1. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
Options- A. Full backup
- B. Consistent backup
- C. Inconsistent backup
- D. Differential backup Discuss
- 2. Which of the following is not true about modifying table columns?
Options- A. You can drop a column at any time.
- B. You can add a column at any time as long as it is a NULL column.
- C. You can increase the number of characters in character columns or the number of digits in numeric columns
- D. You cannot increase or decrease the number of decimal places. Discuss
- 3. The ODBC Level 2 API contains which the following functions?
Options- A. Commit or rollback transactions only
- B. Connect to data sources with driver-specific information only
- C. Connect to data sources only
- D. All of the above are contained in the OBDC Level 2 API Discuss
- 4. In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Options- A. The line numbers reported match the line numbers you see in your text editor.
- B. SQL*Plus will automatically show the errors to you.
- C. To see the errors, enter SHOW ERRORS in SQL*Plus.
- D. If there are no syntax errors, you will receive the message "NO ERRORS." Discuss
- 5. A proxy server is used for which of the following?
Options- A. To provide security against unauthorized users
- B. To process client requests for Web pages
- C. To process client requests for database access
- D. To provide TCP/IP Discuss
- 6. A DBMS that combines a DBMS and an application generator is ________ .
Options- A. Microsoft's SQL Server
- B. Microsoft's Access
- C. IBM's DB2
- D. Oracle Corporation's Oracle Discuss
- 7. In OLE DB, a tabular data provider:
Options- A. does not own data.
- B. transforms data through ODE DB interfaces.
- C. is both a consumer and a provider of data.
- D. exposes data via rowsets. Discuss
- 8. A regular subquery can be processed:
Options- A. from the top down.
- B. from the bottom up.
- C. by nesting.
- D. None of the above is correct. Discuss
- 9. Which of the following situation requires the use of ID-dependent entities?
Options- A. Association relationships only
- B. Multivalued attributes only
- C. Archetype/instance relationships only
- D. All of the above use ID dependent entities Discuss
- 10. What is not an advantage of stored procedures?
Options- A. Greater security
- B. SQL can be optimized
- C. Code sharing
- D. Increased network traffic Discuss
More questions
Correct Answer: Consistent backup
Correct Answer: You cannot increase or decrease the number of decimal places.
Correct Answer: All of the above are contained in the OBDC Level 2 API
Correct Answer: To see the errors, enter SHOW ERRORS in SQL*Plus.
Correct Answer: To provide security against unauthorized users
Correct Answer: Microsoft's Access
Correct Answer: exposes data via rowsets.
Correct Answer: from the bottom up.
Correct Answer: All of the above use ID dependent entities
Correct Answer: Increased network traffic
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.