A data warehouse administrator is concerned with which of the following?
Options: The time to make a decision but not the typical roles of a database administrator, The time to make a decision and the typical roles of a database administrator, The typical roles of a data administrator and redesigning existing applications, The typical roles of a database administrator and redesigning existing applications
Options: Tables group on the Insert ribbon and click the Split Table button
B. Split group on the Layout ribbon and click the Split Table button
C. Merge group on the Layout ribbon and click the Split Table button
D. Split group on the Table ribbon and click the Split Table button
. What is the use of Cascade Delete Option in MS Access?
Options: a. It makes sure that all the records from the parent table and child table is deleted from selected database
b. It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
c. It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted
d. None of above
Options: (A)are very common in current operating systems (B) are very efficient in memory utilization (C) are very inefficient in memory utilization (D) are most used on large mainframe operating systems 28
Options: is a hardware memory device which denotes the location of the current instruction being executed., is a group of electrical circuits (hardware), that performs the intent of instructions fetched from memory., contains the address of the memory location that is to be read from or stored into., contains a copy of the designated memory location specified by the MAR after a "read" or the new contents of the memory prior to a "write".
Options: (A)Extent to which all the parts of a software system or component are present and each of its parts is fully specified and developed. (B) Testing of individual hardware/software components (C) An Entity-relation (E-R) diagram show how entities in the system are composed of other entities. (D) It consists of wide range of different types of computer programs, which be used to support software process activities such as a requirement analysis, system modeling, debugging and testing. 15