Discussion
Home ‣ Database ‣ Database Redesign See What Others Are Saying!
- Question
What SQL command can be used to add columns to a table?
Options- A. MODIFY TABLE TableName ADD COLUMN ColumnName
- B. MODIFY TABLE TableName ADD ColumnName
- C. ALTER TABLE TableName ADD COLUMN ColumnName
- D. ALTER TABLE TableName ADD ColumnName
- Correct Answer
- ALTER TABLE TableName ADD ColumnName
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. The data model that is produced from reverse engineering is:
Options- A. a conceptual model.
- B. an internal model.
- C. a logical model.
- D. None of the above is correct. Discuss
- 6. The process of reading a database schema and producing a data model from that schema is known as:
Options- A. data modeling.
- B. database design.
- C. reverse engineering.
- D. None of the above is correct. Discuss
- 7. What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Options- A. ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
- B. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
- C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
- D. None of the above is correct. Discuss
- 8. Before any changes to database structure are attempted one should first:
Options- A. clearly understand the current structure and contents of the database only.
- B. test any changes on a test database only.
- C. create a complete backup of the operational database only.
- D. All of the above should be done. Discuss
- 9. Which of the following is not true of SQL views?
Options- A. Oracle views cannot use the ORDER BY clause in view definitions.
- B. Oracle views are created using the standard SQL-92 CREATE VIEW command.
- C. Oracle views can by queried.
- D. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Discuss
- 10. In OLE DB, which of the following represents characteristics of the recordset abstraction?
Options- A. Properties
- B. Collections
- C. Methods
- D. Abstractions Discuss
More questions
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.
Correct Answer: None of the above is correct.
Correct Answer: reverse engineering.
Correct Answer: ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
Correct Answer: All of the above should be done.
Correct Answer: Oracle views cannot use the ORDER BY clause in view definitions.
Correct Answer: Properties
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.