Quiz
Chapter 8
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (9)
11.)Clusters have:
- AAdvantages for retrieving
- BAdvantages for updating
- CDisadvantages for indexing
- DDisadvantages for retrieving
- EDisadvantages for updating
22.)Optimized request can be obtained by:
- AUsing indexes
- BUsing partitions
- CUsing the DBMS optimizier
- DUsing clusters
- EUsing views
33.)Optimizing the storing can be made by:
- AReusing data
- BReallocating the data
- CCompaction of data
- DDynamic allocation of space
- ELocking the accounts
44.) Clusters are created for tables that:
- AAre very big
- BAre very small
- CAre subjected to repeated requests and are rarely updated
- DAre frequently queried together
- EParticipate in joins in multiple queries
55.)The decision for using clusters is made considering:
- AThe frequency of updates
- BThe frequency of common queries on the clusters' indexes
- CThe DBA's experience
- DThe amount of data in tables
- EThe number of indexes
66.)Clustering can be applied on:
- ARetail DB
- BTelco DB
- CDocumentary DB
- DMedical DB
- EAirport DB
77.The steps for creating a cluster index are:
- AI , V
- BIII, II
- CV, I, II, III
- DIII, IV
- EI, II, III, IV, V
88.)CREATE INDEX idx_1 ON CLUSTER cluster_3;
- AIs wrong because an index cannot be created on clusters
- BIs wrong because the cluster has to have a table specified
- CIs the command for creating a cluster index
- DIs the command for creating a cluster table
- EAssumes the cluster is already created
99.)ALL_CLUSTERS:
- AIs a view that contains all clusters from the DB
- BIs a view that contains all clusters that are accessible to the current user
- CIs a view that contains clusters in user's schema
- DIs a view that can be queried
- EIs a cluster that can be queried
Information
- Description
- Quiz on Chapter 8, created by Costin Andrei on 07/02/2017.
- Author
- Costin Andrei
- Language
- English
- Views
- 20
- Rating
- No ratings yet Rate this quiz