Discussion
Home ‣ Technical Questions ‣ Operating Systems See What Others Are Saying!
- Question
Describe the Buddy system of memory allocation.
- Correct Answer
- Free memory is maintained in linked lists, each of equal sized blocks Any such block is of size 2^k When some memory is required by a process, the block size of next higher order is chosen, and broken into two Note that the two such pieces differ in address only in their kth bit Such pieces are called buddies When any used block is freed, the OS checks to see if its buddy is also free If so, it is rejoined, and put into the original free-block linked-list
- 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.