Estimate the I/O cost of retrieving records from Parts table that contains price less than or equal 1000 rupees. Assume that 15% of tuples satisfy the selection criteria.?
Estimate the I/O cost of retrieving records from Parts table that contains price less than or equal 1000 rupees. Assume that 15% of tuples satisfy the selection criteria. There are 3300 pages in the Parts table, with 50 records each page. The clustered B+ tree index on price attribute is the only index available in the Parts table. This index takes up 1/3 of the table's space.
- 1595 दृश्य
- 0 उत्तर
0 उत्तर
- What are the two main types of databases?
- What are the four major types of DBMS?
- Every person have based knowledge of Database Management System?
- What Legal Advice Should I Seek?
- What is DBMS and Rdbms with example?
- What are the advantages of DBMS?
- which book is good to study DATABASE MANAGEMENT SYSTEM?
- What is an example of a database? Explain your answer
- What is the syllabus and exam pattern for Database Management System
- How can I practice the questions of Database Management System? Where to find study material?
मॉक परीक्षण अभ्यास के लिए
database management system