1. At which of the following levels is the actual data stored in a database? A. Physical
2. Consider the first step involved in acquisition of data for warehouse:
“Extract data from multiple and heterogeneous sources.”
Which of the following steps will be the second step involved in acquisition of data for warehouse? A. Format data for consistency within a warehouse
3. Consider the following example:
“The salary of an employee should not exceed the salary of the employee’s supervisor.”
Which of the following constraints is suitable for the given example? A. Transition
4. Consider the following options for mapping specialization or generalization:
Option 1: Multiple relations—superclass and subclasses
Option 2: Multiple relations—subclass relations only
Option 3: Single relation with one type attribute
Option 4: Single relation with multiple type attributes
Which of the following options works for any constraints on the specialization, i.e., disjoint or overlapping, total or partial? A. Option 1
5. Consider the following skills of a surgical technician:
The skills of a surgical technician are an example of which type of attribute? A. Multivalued attribute
6. Consider the following statement:
“If the validation phase is successful, the transaction updates are applied to the database; otherwise, the updates are discarded and the transaction is restarted.”
In which of the following phases of concurrency control protocol does this happen? A. Write
7. Due to which of the following actions does a checkpoint record in the log also include additional information, and this can facilitate undoing transaction operations in the event that a transaction must be rolled back? A. Force-write all main memory buffers that have been modified to disk.
8. During which of the following steps do the database designers interview prospective database users to understand and document their data necessities? A. Requirements collection and analysis
9. During which of the following steps do the database designers interview prospective database users to understand and document their data necessities? A. Requirements collection and analysis
10. In which of the following categories do the physical design decisions for indexing fall?
Each correct answer represents a complete solution. Choose all that apply. A. ABDE
11. What are the NOSQL characteristics related to distributed databases and distributed systems? A. BCDE
12. What challenges are faced by big data technologies when they are used for analytics applications? A. Inconsistent and incomplete information, Privacy and confidentiality, Heterogeneity of information
13. What problems occur due to the redundancy in storing the same data multiple times?
Each correct answer represents a complete solution. Choose all that apply. A. ABC
14. What term is used for intermediate form of databases before they are cleansed, aggregated, and transformed into a data warehouse? A. ODS
15. Which abstraction concept is needed to distinguish among database objects and classes, and to identify database objects? A. Identification
16. Which of the following are steps of ER-to-relational mapping algorithm?
Each correct answer represents a complete solution. Choose all that apply. A. ABCD
17. Which of the following associations is represented as a line connecting the participating classes, and may optionally have a name? A. Binary
18. Which of the following clauses assigns a variable to range over each of the individual elements in a sequence? A. FOR
19. Which of the following constraints are possible constraints on a specialization?
Each correct answer represents a complete solution. Choose all that apply. A. ACD
20. Which of the following constraints are possible constraints on a specialization? A. ACD
21. Which of the following constraints can be directly expressed in the schemas of the data model? A. BCD
22. Which of the following functional dependencies occurs only in a relation that contains three or more attributes and an attribute is indirectly dependent on another attribute that is not part of the primary key? A. Transitive
23. Which of the following functions does SQL allow to be blocked from public use, and an EXECUTE privilege is needed to have access to these functions? A. Mutator, Constructor , Observer
24. Which of the following indexes requires that the ordering field of the data file has a distinct value for each record as well as records are of fixed length with two fields? A. Primary
25. Which of the following interpretations are true of NULLs?
Each correct answer represents a complete solution. Choose all that apply. A. ACD
26. Which of the following is described in the given statement? A. Confinement
27. Which of the following methods are used for collision resolution?
Each correct answer represents a complete solution. Choose all that apply. A. Multiple hashing, Chaining, Open addressing
28. Which of the following multiset operations do not eliminate duplicates?
Each correct answer represents a complete solution. Choose all that apply. A. BCD
29. Which of the following operations takes the results of two queries and returns only those rows that appear in both result sets without eliminating duplicates? A. INTERSECT ALL
30. Which of the following properties is enforced by the concurrency control subsystem of the DBMS? A. Isolation
31. Which of the following rules states that a set of attributes always determines itself or any of its subsets? A. Reflexive
32. Which of the following strategies updates a view as soon as the base tables are changed? A. Immediate update
33. Which of the following techniques to make accessing data more efficient on HDDs deals with the incompatibility of speeds between a CPU and the electromechanical device? A. Buffering of data
34. Which of the following types of actions are used to control discretionary database authorization?
Each correct answer represents a complete solution. Choose all that apply. A. AD
35. Which of the following updates recomputes a view only upon demand? A. Lazy
36. Which of the following violations will occur when a transaction may read a set of rows from a table, based on some condition specified in the SQL WHERE-clause? A. Phantom
37. Which operation is used for inserting new data or new versions of existing data items? A. Put
38. Which spatial operator provides a more specific description of the object’s geometry and measures some global properties of single objects? A. Metric
39. Which statistical model provides a framework in which term weighting, ranking of retrieved documents, and determining the relevance of feedback are possible? A. Vector space
40. Which type of end user tries to learn most of the DBMS facilities to achieve their complex requirements?
This task contains the radio buttons and checkboxes for options. A. Sophisticated
41. Which type of XML document is formatted as XML document in order to exchange it over the Web? A. Data-centric
42. Who communicates with all prospective database users to understand their requirements and to create a design that meets those requirements? A. Database designer
Other Links:
See other websites for quiz:
Check on QUIZLET