Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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.
- Correct Answer
- ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
- 1. To drop a column that is used as a foreign key, first:
Options- A. drop the primary key.
- B. drop the table containing the foreign key..
- C. drop the foreign key constraint.
- D. All of the above must be done. Discuss
- 2. 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
- 3. In a 1:N relationship, the foreign key is placed in:
Options- A. the parent table.
- B. the child table.
- C. either table without specifying parent and child tables.
- D. either the parent table or the child table. Discuss
- 4. Using OQL, you may do which of the following?
Options- A. Return an entire collection of elements including duplicates.
- B. Return a collection of elements without duplicates.
- C. Return a specific subset of elements using a given criteria.
- D. All of the above. Discuss
- 5. The object definition language (ODL) is which of the following?
Options- A. Used to develop logical schemas
- B. A data definition language for OODB
- C. A method to implement a logical schema
- D. All of the above. Discuss
- 6. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Options- A. Using the Oracle Database Configuration Assistant.
- B. Using the Oracle-supplied database creation procedures.
- C. Using the SQL CREATE DATABASE command.
- D. None of the above is correct. Discuss
- 7. An Oracle System Change Number (SCN):
Options- A. is a value that is incremented whenever a dirty read occurs.
- B. is incremented whenever a deadlock occurs.
- C. is a value that keeps track of explicit locks.
- D. is a value that is incremented whenever database changes are made. Discuss
- 8. The ODBC core API consists of which of the following functions?
Options- A. Commit or rollback transactions only
- B. Connect to data sources only
- C. Connect to data sources with driver-specific information only
- D. Both 1 and 2 above are in the OBDC core API. Discuss
- 9. ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
Options- A. ASP
- B. XML
- C. ODBC
- D. ADO Discuss
- 10. Which of the following are goals of OLE DB?
Options- A. Create object interfaces for DBMS functionality pieces only.
- B. Increase flexibility only.
- C. Object interface over any type of data only.
- D. All of the above as goals of OLE DB. Discuss
Database problems
Search Results
Correct Answer: drop the foreign key constraint.
Correct Answer: reverse engineering.
Correct Answer: the child table.
Correct Answer: All of the above.
Correct Answer: All of the above.
Correct Answer: Using the Oracle Database Configuration Assistant.
Correct Answer: is a value that is incremented whenever database changes are made.
Correct Answer: Both 1 and 2 above are in the OBDC core API.
Correct Answer: ADO
Correct Answer: All of the above as goals of OLE DB.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.