-
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?
Date posted:
July 4, 2018
-
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.
Date posted:
July 4, 2018
-
Discuss the difference between system security and data security
Date posted:
July 4, 2018
-
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
Date posted:
July 4, 2018
-
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
Date posted:
July 4, 2018
-
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?
Date posted:
July 4, 2018
-
Discuss the advantages of a DDBMS
Date posted:
July 4, 2018
-
Discuss the disadvantages of DDBMS
Date posted:
July 4, 2018
-
Describe the expected functionality of a replication server.
Date posted:
July 4, 2018
-
Discuss the Update-anywhere (symmetric replication) ownership in replication
Date posted:
July 4, 2018
-
Discuss the workflow ownership as portrayed in replication.
Date posted:
July 4, 2018
-
Discuss the master/slave type of ownership model in replication
Date posted:
July 4, 2018
-
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
Date posted:
July 4, 2018
-
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
Date posted:
July 4, 2018
-
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?
Date posted:
July 4, 2018
-
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
Date posted:
July 4, 2018
-
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)
Date posted:
July 4, 2018
-
Explain the purpose and scope of database security.
Date posted:
July 4, 2018
-
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.
Date posted:
July 4, 2018