Database Questions: will give thumbs up if both questions are answered Q1: Q2:
Posted: Sat May 14, 2022 2:53 pm
Database Questions: will give thumbs up if both questions are
answered
Q1:
Q2:
Which of the following is FALSE regarding a Disk-Oriented DBMS architecture? In order to operate on the data the DBMS needs to bring the data into memory. The DBMS has a buffer pool that manages the movement back and forth between disk and memory. The DBMS has an execution engine that will execute queries. The buffer pool will ask the execution engine for a specific page, and the execution engine will take care of bringing that page into memory. The database is all on disk, and the data in the database files is organized into pages, and the first page is the directory page.
Which of the following is FALSE regarding Slotted Pages in page layout? The slot array keeps track of the location of the start of each tuple. The header keeps track of the number of used slots. To add a tuple, the data of the tuples will grow from the beginning to the end, and the slot array will grow from end to the beginning. The header keeps track of the offset of the starting location of the last slot used.
answered
Q1:
- Database Questions Will Give Thumbs Up If Both Questions Are Answered Q1 Q2 1 (34.34 KiB) Viewed 48 times
- Database Questions Will Give Thumbs Up If Both Questions Are Answered Q1 Q2 2 (24.57 KiB) Viewed 48 times
Which of the following is FALSE regarding Slotted Pages in page layout? The slot array keeps track of the location of the start of each tuple. The header keeps track of the number of used slots. To add a tuple, the data of the tuples will grow from the beginning to the end, and the slot array will grow from end to the beginning. The header keeps track of the offset of the starting location of the last slot used.