Discussion
Home ‣ Technical Questions ‣ Database See What Others Are Saying!
- 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. ON UPDATE CASCADE ensures which of the following?
Options- A. Normalization
- B. Data Integrity
- C. Materialized Views
- D. All of the above. Discuss
- 2. 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
- 3. A goal of data mining includes which of the following?
Options- A. To explain some observed event or condition
- B. To analyze data for expected relationships
- C. To confirm that data exists
- D. To create a new data warehouse Discuss
- 4. ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
Options- A. MySQL
- B. JSP/SQL
- C. JDBC/SQL
- D. Sun ACCESS Discuss
- 5. Which of the following is the original purpose of SQL?
Options- A. To specify the syntax and semantics of SQL data definition language
- B. To specify the syntax and semantics of SQL manipulation language
- C. To define the data structures
- D. All of the above. Discuss
- 6. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
Options- A. First normal form
- B. Second normal form
- C. Third normal form
- D. Fourth normal form Discuss
- 7. For what purposes are views used?
Options- A. To hide rows only
- B. To hide columns only
- C. To hide complicated SQL statements only
- D. All of the above are uses for SQL views. Discuss
- 8. What are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms?
Options- A. Polish
- B. Reverse Polish
- C. Both A and B
- D. None of the above Discuss
- 9. The different classes of relations created by the technique for preventing modification anomalies are called:
Options- A. normal forms.
- B. functional dependencies.
- C. referential integrity constraints.
- D. None of the above is correct. Discuss
- 10. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Options- A. Equi-join
- B. Natural join
- C. Outer join
- D. Cartesian join Discuss
More questions
Correct Answer: Data Integrity
Correct Answer: Microsoft's Access
Correct Answer: To explain some observed event or condition
Correct Answer: MySQL
Correct Answer: All of the above.
Explanation:
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
Purpose of SQL are ::
* To define the data structures
* To specify the syntax and semantics of SQL manipulation language
* To specify the syntax and semantics of SQL data definition language
Correct Answer: Second normal form
Correct Answer: All of the above are uses for SQL views.
Correct Answer: Both A and B
Explanation:
Polish and Reverse Polish are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms
Correct Answer: normal forms.
Correct Answer: Cartesian join
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.