Which type of index does this syntax create? CREATE INDEX hr.employees_last_name_idx ON hr.employees(last_name) PCTFREE 30 STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx;

Keep practicing — related questions

• Which type of index does the given syntax create? CREATE INDEX emp_last_name_idx ON emp(last_name) PCTFREE ...
• Which index will be beneficial to create on the column Gender of a table name employee which permits entry ...
• An index needs to be created on the EMP_ID column of the EMPLOYEE table which satisfies the following condi...
• You may use the CREATE INDEX statement to create an index on (choose all that apply):
• When creating an index using the CREATE INDEX statement,the UNIQUE and BITMAP keywords may be used together.
• You need to create an index on the PASSPORT_RECORDS table. It contains 10 million rows of data. The key col...
• Which is correct about index?
• What is the default index that is being created when a table is created in Sybase IQ?