Get premium membership and access questions with answers, video lessons as well as revision papers.
- Discuss some of the main reasons for selecting a column as a potential candidate for indexing. Give examples to illustrate your answer.(Solved)
Discuss some of the main reasons for selecting a column as a potential candidate for indexing. Give examples to illustrate your answer.
Date posted: July 4, 2018.
- When would you not add any indexes to a table?(Solved)
When would you not add any indexes to a table?
Date posted: July 4, 2018.
- Having identified a column as a potential candidate, under what circumstances would you decide against indexing it? (Solved)
Having identified a column as a potential candidate, under what circumstances would you decide against indexing it?
Date posted: July 4, 2018.
- Describe the access control facilities of SQL.(Solved)
Describe the access control facilities of SQL.
Date posted: July 4, 2018.
- Discuss the difference between system security and data security(Solved)
Discuss the difference between system security and data security
Date posted: July 4, 2018.
- Explain the meaning of denormalization.(Solved)
Explain the meaning of denormalization.
Date posted: July 4, 2018.
- Describe the two main approaches to partitioning and discuss when each may be an appropriate way to improve performance. Give examples to illustrate your answer(Solved)
Describe the two main approaches to partitioning and discuss when each may be an appropriate way to improve performance. Give examples to illustrate your answer
Date posted: July 4, 2018.
- What factors can be used to measure efficiency?(Solved)
What factors can be used to measure efficiency?
Date posted: July 4, 2018.
- State and discuss how the four basic hardware components interact and affect system performance(Solved)
State and discuss how the four basic hardware components interact and affect system performance
Date posted: July 4, 2018.
- How should you distribute data across disks?(Solved)
How should you distribute data across disks?
Date posted: July 4, 2018.
- Compare and contrast a DDBMS with distributed processing. Under what circumstances would you choose a DDBMS over distributed processing?(Solved)
Compare and contrast a DDBMS with distributed processing. Under what circumstances would you choose a DDBMS over distributed processing?
Date posted: July 4, 2018.
- Discuss the advantages of a DDBMS(Solved)
Discuss the advantages of a DDBMS
Date posted: July 4, 2018.
- Discuss the disadvantages of DDBMS(Solved)
Discuss the disadvantages of DDBMS
Date posted: July 4, 2018.
- Describe the expected functionality of a replication server.(Solved)
Describe the expected functionality of a replication server.
Date posted: July 4, 2018.
- Discuss the Update-anywhere (symmetric replication) ownership in replication(Solved)
Discuss the Update-anywhere (symmetric replication) ownership in replication
Date posted: July 4, 2018.
- Discuss the workflow ownership as portrayed in replication(Solved)
Discuss the workflow ownership as portrayed in replication.
Date posted: July 4, 2018.
- Discuss the master/slave type of ownership model in replication(Solved)
Discuss the master/slave type of ownership model in replication
Date posted: July 4, 2018.
- Give a definition of an OODBMS.(Solved)
Give a definition of an OODBMS.
Date posted: July 4, 2018.
- Give a definition of a data warehouse. Discuss the benefits of implementing a data warehouse(Solved)
Give a definition of a data warehouse. Discuss the benefits of implementing a data warehouse
Date posted: July 4, 2018.
- Describe the characteristics of the data held in a data warehouse.(Solved)
Describe the characteristics of the data held in a data warehouse.
Date posted: July 4, 2018.
- Describe what relationships represent in an ER model and provide examples of unary, binary, and ternary relationships(Solved)
Describe what relationships represent in an ER model and provide examples of unary, binary, and ternary relationships
Date posted: July 4, 2018.
- Describe what entities represent in an ER model and provide examples of entities with a physical or conceptual existence.(Solved)
Describe what entities represent in an ER model and provide examples of entities with a physical or conceptual existence.
Date posted: July 4, 2018.
- How do the contents of a users’ requirements specification differ from a systems specification?(Solved)
How do the contents of a users’ requirements specification differ from a systems specification?
Date posted: July 4, 2018.
- What is the purpose of the systems definition stage?(Solved)
What is the purpose of the systems definition stage?
Date posted: July 4, 2018.
- Describe how fact-finding is used throughout the stages of the database system development lifecycle(Solved)
Describe how fact-finding is used throughout the stages of the database system development lifecycle
Date posted: July 4, 2018.
- Briefly describe what the process of fact-finding attempts to achieve for a database developer. (Solved)
Briefly describe what the process of fact-finding attempts to achieve for a database developer.
Date posted: July 4, 2018.
- Discuss Redundant Array of Independent Disks (RAID)(Solved)
Discuss Redundant Array of Independent Disks (RAID)
Date posted: July 4, 2018.
- Explain the purpose and scope of database security.(Solved)
Explain the purpose and scope of database security.
Date posted: July 4, 2018.
- Discuss the process of testing the database system and its purpose(Solved)
Discuss the process of testing the database system and its purpose
Date posted: July 4, 2018.
- What are the main activities associated with operational maintenance stage.(Solved)
What are the main activities associated with operational maintenance stage.
Date posted: July 4, 2018.