7 A table initially has 100 rows. Each row requires 100 bytes for the row and 4
ID: 3595326 • Letter: 7
Question
7 A table initially has 100 rows. Each row requires 100 bytes for the row and 4 bytes for the slot table entry. What is the minimum number of 2K pages that can be allocated for this table? *This question is required.
a. 4
b. 5
c. 6
d. 10
10. Which of the following statements are TRUE concerning extents? (Choose all that apply) *This question is required.
a. The minimum size for any extent is 2 pages
b. When a new extent allocated is contiguous to the previous extent, the two extents are concatenated
c. Each time the number of extents allocated for a particular tblspace reaches a multiple of 16, the database server doubles the size of each successive extent allocated
d. If the DBA detects that the initial extent-size specification for a table was inadequate and that many extents are being allocated, the size of existing extents can be increased by using the ALTER TABLE command
11. A user is accessing data in the CUSTOMER table using the CUST_IDX index. The DBA attempts to execute the following SQL statement:
DROP INDEX CUST_IDX ONLINE;
What will result? *This question is required.
a. The DBA will receive an error because the index is in use. The index will not be dropped
b. The existing user will receive an error and the index will be dropped
c. The existing user's query will be allowed to complete, but no additional users will be allowed to use the CUST_IDX index. After the existing user's query ends, the index will be dropped
d. The user's query will be allowed to complete, and additional users will be allowed to use the CUST_IDX index. After all users' queries end, the index will be dropped
12. Consider the following CREATE statement:
CREATE TABLE employee (
id INTEGER,
name CHAR(32))
FRAGMENT BY RANGE (id)
INTERVAL (200) STORE IN (dbs3, dbs4, dbs5)
PARTITION p0 VALUES IS NULL IN dbs0,
PARTITION p1 VALUES < 200 in dbs1,
PARTITION p2 VALUES < 400 in dbs2;
If a record with an employee id of 405 is entered into this table, what will happen? *This question is required.
a. The record will be stored in partition p0
b. The record will be stored in partition p2
c. A new fragment, which will hold records with id >= 400 and id < 600, will be created and the record will be stored there
d. The statement will fail because the value of id does not fall within one of the defined ranges
Explanation / Answer
7 A table initially has 100 rows. Each row requires 100 bytes for the row and 4 bytes for the slot table entry. What is the minimum number of 2K pages that can be allocated for this table? *This question is required.
a. 4
b. 5
c. 6
d. 10
Ans. 6
Total number of bytes required by table is 100* (100+4) = 10400 bytes. Each page size is 2K->2*2^10 ->2048. Number of pages required = 10400/2048 ~ 6 pages (taking ceiling of the division for extra bytes remained after 5th page)
10. Which of the following statements are TRUE concerning extents? (Choose all that apply) *This question is required.
a. The minimum size for any extent is 2 pages (False because minimum size is 4 pages)
b. When a new extent allocated is contiguous to the previous extent, the two extents are concatenated
c. Each time the number of extents allocated for a particular tblspace reaches a multiple of 16, the database server doubles the size of each successive extent allocated (False because extent sizes are in multiples of 16)
d. If the DBA detects that the initial extent-size specification for a table was inadequate and that many extents are being allocated, the size of existing extents can be increased by using the ALTER TABLE command
DROP INDEX CUST_IDX ONLINE;
What will result? *This question is required.
a. The DBA will receive an error because the index is in use. The index will not be dropped
b. The existing user will receive an error and the index will be dropped
c. The existing user's query will be allowed to complete, but no additional users will be allowed to use the CUST_IDX index. After the existing user's query ends, the index will be dropped
d. The user's query will be allowed to complete, and additional users will be allowed to use the CUST_IDX index. After all users' queries end, the index will be dropped
12. Consider the following CREATE statement:
CREATE TABLE employee (
id INTEGER,
name CHAR(32))
FRAGMENT BY RANGE (id)
INTERVAL (200) STORE IN (dbs3, dbs4, dbs5)
PARTITION p0 VALUES IS NULL IN dbs0,
PARTITION p1 VALUES < 200 in dbs1,
PARTITION p2 VALUES < 400 in dbs2;
If a record with an employee id of 405 is entered into this table, what will happen? *This question is required.
a. The record will be stored in partition p0
b. The record will be stored in partition p2
c. A new fragment, which will hold records with id >= 400 and id < 600, will be created and the record will be stored there
d. The statement will fail because the value of id does not fall within one of the defined ranges
If this helps please give a thumbs up. Happy Chegging!!
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.