Discussion
Home ‣ Technical Questions ‣ Database See What Others Are Saying!
- Question
The capacity to change the conceptual schema without having to change external schemas or application programs is called
Options- A. Physical Data Independence
- B. Logical Data Independence
- C. Both A and B
- D. None
- Correct Answer
- Logical Data Independence
ExplanationLDI is the capacity to change the conceptual schema without having to change external schemas or application programs.
- 1. What is the type of the algorithm used in solving the 8 Queens problem ?
Options- A. Dynamic Programming
- B. BackTracking
- C. Branch and Bound
- D. None Discuss
- 2. The SQL statements that take care of security and authorization are
Options- A. DDL
- B. DML
- C. DCL
- D. None Discuss
- 3. ON UPDATE CASCADE ensures which of the following?
Options- A. Normalization
- B. Data Integrity
- C. Materialized Views
- D. All of the above. Discuss
- 4. 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
- 5. 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
- 6. ________ 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
More questions
Correct Answer: BackTracking
Explanation:
BackTracking is used for solving N-Queens problem
Correct Answer: DCL
Explanation:
Data Control Language takes caare of security and authorization
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
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.