GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

Chapter 8

Costin Andrei 9 Fragen

Quiz starten

Fragen in diesem Quiz (9)

  1. 11.)Clusters have:
    1. AAdvantages for retrieving
    2. BAdvantages for updating
    3. CDisadvantages for indexing
    4. DDisadvantages for retrieving
    5. EDisadvantages for updating
  2. 22.)Optimized request can be obtained by:
    1. AUsing indexes
    2. BUsing partitions
    3. CUsing the DBMS optimizier
    4. DUsing clusters
    5. EUsing views
  3. 33.)Optimizing the storing can be made by:
    1. AReusing data
    2. BReallocating the data
    3. CCompaction of data
    4. DDynamic allocation of space
    5. ELocking the accounts
  4. 44.) Clusters are created for tables that:
    1. AAre very big
    2. BAre very small
    3. CAre subjected to repeated requests and are rarely updated
    4. DAre frequently queried together
    5. EParticipate in joins in multiple queries
  5. 55.)The decision for using clusters is made considering:
    1. AThe frequency of updates
    2. BThe frequency of common queries on the clusters' indexes
    3. CThe DBA's experience
    4. DThe amount of data in tables
    5. EThe number of indexes
  6. 66.)Clustering can be applied on:
    1. ARetail DB
    2. BTelco DB
    3. CDocumentary DB
    4. DMedical DB
    5. EAirport DB
  7. 77.The steps for creating a cluster index are:Bild zu Frage 7
    1. AI , V
    2. BIII, II
    3. CV, I, II, III
    4. DIII, IV
    5. EI, II, III, IV, V
  8. 88.)CREATE INDEX idx_1 ON CLUSTER cluster_3;
    1. AIs wrong because an index cannot be created on clusters
    2. BIs wrong because the cluster has to have a table specified
    3. CIs the command for creating a cluster index
    4. DIs the command for creating a cluster table
    5. EAssumes the cluster is already created
  9. 99.)ALL_CLUSTERS:
    1. AIs a view that contains all clusters from the DB
    2. BIs a view that contains all clusters that are accessible to the current user
    3. CIs a view that contains clusters in user's schema
    4. DIs a view that can be queried
    5. EIs a cluster that can be queried

Informationen

Beschreibung
Quiz am Chapter 8, erstellt von Costin Andrei am 07/02/2017.
Sprache
English
Aufrufe
20
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck