Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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.
- Correct Answer
- normal forms.
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. ________ 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
- 6. 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
- 7. 88%of 370 +24% of 210-x =118 find x Discuss
- 8. 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
- 9. The benefits of object-oriented modeling are which of the following?
Options- A. The ability to tackle more challenging problems
- B. Reusability of analysis, design, and programming results
- C. Improved communication between users, analysts, etc.
- D. All of the above. Discuss
- 10. A collection of interrelated records is called a
Options- A. Datasheet
- B. Spreadsheet
- C. Database
- D. Utility File Discuss
Database problems
Search Results
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: All of the above are uses for SQL views.
Correct Answer: Second normal form
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: MySQL
Correct Answer: Cartesian join
Correct Answer: From the given equation, 88x370/100 + 24x210/100 - 118 = x => x = 3256 + 504 - 118 x = 258
Correct Answer: To provide security against unauthorized users
Correct Answer: All of the above.
Correct Answer: Database
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.