1. Consider the following SQL statement: CREATE TABLE tab1 ( COL1 SERIAL, COL2 C

Question

1. Consider the following SQL statement:

CREATE TABLE tab1 (
COL1 SERIAL,
COL2 CHAR(20) )
FRAGMENT BY ROUND ROBIN
IN dbspace1, dbspace2, dbspace3
EXTENT SIZE 9000
NEXT SIZE 3000;
Which of the following statements describe the actions implemented by this SQL statement? (Choose all that apply) *This question is required.
a. Rows in the table will be randomly distributed among the three dbspaces
b. Rows in the table will be evenly distributed among the three dbspaces
c. One extent of 9000 pages will be reserved in each of the three dbspaces
d. One extent of 3000 pages will be reserved in each of the three dbspaces
3. Consider the following SQL statement:

CREATE INDEX cust_idx   
ON customer(zipcode)
IN cust_idx_dbs;

The index cust_idx is described as what type of index? (Choose all that apply) *This question is required.
a. An attached index
b. A detached index
c. A fragmented index
d. A descending index
4. The following view has been created on the CUSTOMER table:

CREATE VIEW palo_alto AS
SELECT * FROM customer
WHERE city = ’Palo Alto’;
Which of the following statements are TRUE concerning this view? (Choose all that apply) *This question is required.
a. You could insert a row with city = 'Los Alamos' into the customer table using the view
b. You could insert a row with city = 'Palo Alto' into the customer table using the view
c. You could update a row in the customer table to change city from 'Palo Alto' to 'Los Alamos' using the view
d. You could update a row in the customer table to change city from 'Los Alamos' to 'Palo Alto' using the view
6. A database was created as follows:

CREATE DATABASE db1 IN db_dbs1;
What gets written to the logical log for this database? *This question is required.
a. Nothing
b. UPDATE, INSERT, and DELETE statements
c. DDL statements
d. UPDATE, INSERT, and DELETE statements and DDL statements

Explanation / Answer

1.c. One extent of 9000 pages will be reserved in each of the three dbspaces

3.a. An attached index

4. You could update a row in the customer table to change city from 'Palo Alto' to 'Los Alamos' using the view

5.UPDATE, INSERT, and DELETE statements and DDL statements

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.