Dovetail Phase 2 (All Topics)

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By MishraAkshay
M
MishraAkshay
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,294
Questions: 221 | Attempts: 1,294

SettingsSettingsSettings
Computer Software Quizzes & Trivia

Questions and Answers
  • 1. 

    Block indexes for multiple columns produces

    • A.

      Blocks

    • B.

      Clusters

    • C.

      Multidimensional Clusters

    • D.

      None

    Correct Answer
    C. Multidimensional Clusters
    Explanation
    Block indexes for multiple columns produce Multidimensional Clusters. Multidimensional Clusters are used to optimize queries that involve multiple columns by organizing the data in a way that allows for efficient retrieval based on different combinations of column values. This type of index is particularly useful for queries that involve range queries or queries that have multiple filter conditions. By using multidimensional clustering, the database can quickly locate and retrieve the required data, improving query performance.

    Rate this question:

  • 2. 

    Database partition is known as

    • A.

      Leaf

    • B.

      Node

    • C.

      Root

    Correct Answer
    B. Node
    Explanation
    In a database, partitioning refers to the process of dividing a large database into smaller, more manageable parts called partitions. Each partition is then stored on a separate storage device or server. In this context, a "node" refers to a unit or component in a distributed database system that stores and manages a partition of the database. Therefore, the correct answer is "Node" because it represents a partition in a database.

    Rate this question:

  • 3. 

    Block indexes are preferable for high cardinality columns.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Block indexes are not preferable for high cardinality columns. Block indexes are most effective for low cardinality columns, where there are a limited number of distinct values. High cardinality columns, on the other hand, have a large number of distinct values, making block indexes less efficient. In such cases, other types of indexes, such as B-tree indexes, are more suitable for optimizing query performance.

    Rate this question:

  • 4. 

    What does page cleaner do?

    • A.

      Data from the buffer pool is written to the disk

    • B.

      No Buffer

    • C.

      Data from the buffer pool is written to the page

    Correct Answer
    A. Data from the buffer pool is written to the disk
    Explanation
    The page cleaner is responsible for writing data from the buffer pool to the disk. The buffer pool is a cache that holds frequently accessed data, and the page cleaner ensures that any changes made to this data are persisted to the disk. This process helps to prevent data loss in the event of a system failure or shutdown. By regularly writing the buffered data to the disk, the page cleaner helps to maintain data integrity and ensure that the most up-to-date information is stored persistently.

    Rate this question:

  • 5. 

    What is meant by pre-fetching?           

    • A.

      Fetching data from hard disk to buffer pool

    • B.

      Fetching data from page to buffer pool

    • C.

      None

    Correct Answer
    A. Fetching data from hard disk to buffer pool
    Explanation
    Pre-fetching refers to the process of retrieving data from the hard disk and storing it in the buffer pool before it is actually needed. This is done in order to improve performance by reducing the time it takes to access the data when it is required. By pre-fetching data from the hard disk to the buffer pool, the system can anticipate future data needs and have it readily available, minimizing the delay in retrieving it from the slower hard disk.

    Rate this question:

  • 6. 

    Statistics update is done 

    • A.

      Once a week

    • B.

      Depending on frequency of table updates.

    • C.

      Once a Month

    Correct Answer(s)
    A. Once a week
    B. Depending on frequency of table updates.
    Explanation
    The statistics update is done once a week, but the frequency may vary depending on how often the table is updated. This means that if the table is updated more frequently, the statistics will also be updated more often to ensure accurate and up-to-date information.

    Rate this question:

  • 7. 

    A database partition is not given complete control of Hardware resource  

    • A.

      In Logical Partition

    • B.

      In Primary Partition

    • C.

      In Secondary Partition

    Correct Answer
    A. In Logical Partition
    Explanation
    A database partition is not given complete control of hardware resources in a logical partition. In a logical partition, the hardware resources are shared among multiple partitions, including the database partition. This means that the database partition does not have exclusive control over the hardware resources and may have to compete with other partitions for their usage. This can impact the performance and efficiency of the database partition as it may not be able to utilize the hardware resources to their full potential.

    Rate this question:

  • 8. 

    Which is true?

    • A.

      Database partition consists its own data, index, config files and transaction logs

    • B.

      Database partition consists its own data, index, config files except transaction logs

    • C.

      Database partition consists its own data, index and transaction logs except config files

    Correct Answer
    A. Database partition consists its own data, index, config files and transaction logs
    Explanation
    A database partition is a division of a database into separate parts for the purpose of improving performance, scalability, and availability. Each partition contains its own data, index, config files, and transaction logs. This allows for better organization and management of the database, as well as faster access to the data.

    Rate this question:

  • 9. 

    MPP –

    • A.

      Massively Parallel Processing

    • B.

      Maximum Parallel Processing

    • C.

      Minimum Parallel Processing

    • D.

      Marginal Parallel Processing

    Correct Answer
    A. Massively Parallel Processing
    Explanation
    Massively Parallel Processing (MPP) refers to a computing architecture that uses multiple processors to perform tasks simultaneously. It allows for the efficient processing of large amounts of data by dividing the workload into smaller tasks that can be executed in parallel. This approach significantly speeds up data processing and analysis, making it suitable for applications that require high-performance computing and handling big data. Therefore, the given answer, Massively Parallel Processing, accurately describes the concept and its significance in computing.

    Rate this question:

  • 10. 

    Large updates and transactions are not suitable for

    • A.

      Block index

    • B.

      B+ tree index

    • C.

      Clustered index

    Correct Answer(s)
    A. Block index
    C. Clustered index
    Explanation
    Large updates and transactions are not suitable for block index and clustered index.

    Block index is a data structure used in databases to organize and efficiently access blocks of data. It is not ideal for large updates and transactions because it requires a lot of disk I/O operations to update the index, which can be time-consuming and inefficient.

    Clustered index is a type of index that determines the physical order of data in a table. It is not suitable for large updates and transactions because it requires rearranging the data on disk to maintain the physical order, which can be costly in terms of time and resources.

    Therefore, both block index and clustered index are not recommended for handling large updates and transactions.

    Rate this question:

  • 11. 

    The No. of CPUs used in DB2 Enterprise edition

    • A.

      2

    • B.

      4

    • C.

      No restriction

    Correct Answer
    C. No restriction
    Explanation
    The DB2 Enterprise edition does not have any restriction on the number of CPUs that can be used. This means that there is no limit or maximum number of CPUs specified for this edition. Users can utilize as many CPUs as they require for their specific needs and workload without any limitations.

    Rate this question:

  • 12. 

    Tablespace span across containers and tables can span across tablespaces

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    This statement is true because tablespaces in a database can span across multiple containers, which are physical storage units. This allows for better organization and allocation of storage space. Additionally, tables within a database can also span across multiple tablespaces, providing flexibility in managing and distributing data within the database.

    Rate this question:

  • 13. 

    Different table spaces have different page sizes

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In a database, a tablespace is a logical storage unit that contains tables, indexes, and other database objects. Each tablespace can have its own page size, which determines the size of the data blocks used to store data within the tablespace. This allows for flexibility in managing different types of data and optimizing storage efficiency. Therefore, it is true that different table spaces can have different page sizes.

    Rate this question:

  • 14. 

    If Num_oicleaners is 0,then _____ are started

    • A.

      No page cleaners

    • B.

      Page Cleaners

    • C.

      None

    Correct Answer
    A. No page cleaners
    Explanation
    If the variable Num_oicleaners is equal to 0, it means that there are no page cleaners available. Therefore, no page cleaners will be started.

    Rate this question:

  • 15. 

    Effects of locking –    

    • A.

      Improves concurrency

    • B.

      Degrades performance

    • C.

      Degrades concurrency

    • D.

      Improves performance

    Correct Answer(s)
    A. Improves concurrency
    B. Degrades performance
    Explanation
    Locking is a mechanism used to control access to shared resources in a concurrent environment. When multiple threads or processes try to access the same resource simultaneously, locking ensures that only one thread or process can access it at a time, preventing data corruption or inconsistency. This improves concurrency by allowing multiple threads to execute concurrently without interfering with each other. However, the process of acquiring and releasing locks introduces overhead, which can degrade performance. Therefore, while locking improves concurrency, it can also have a negative impact on performance.

    Rate this question:

  • 16. 

    What is ASLheapsz?

    • A.

      It is the Communication buffer between the local application and its associated Agent.

    • B.

      Error Agent

    • C.

      Local Error Handler

    Correct Answer
    A. It is the Communication buffer between the local application and its associated Agent.
    Explanation
    ASLheapsz refers to the communication buffer that facilitates the exchange of information between a local application and its associated Agent. This buffer allows for seamless communication, enabling the local application to send and receive data to and from the Agent. It plays a crucial role in ensuring smooth and efficient communication between the two entities.

    Rate this question:

  • 17. 

    True for Chngpgs_thresh:

    • A.

      For heavy update transactions, decrease this value below default.

    • B.

      Percentage of changed pages in Buffer pool at which the asynchronous page cleaners will be started, if they are not currently active.

    • C.

      For heavy update transactions, increase this value below default.

    Correct Answer(s)
    A. For heavy update transactions, decrease this value below default.
    B. Percentage of changed pages in Buffer pool at which the asynchronous page cleaners will be started, if they are not currently active.
    Explanation
    This answer is correct because it accurately explains that for heavy update transactions, the value of Chngpgs_thresh should be decreased below the default value. This is because heavy update transactions tend to result in a higher percentage of changed pages in the buffer pool. By decreasing the Chngpgs_thresh value, the asynchronous page cleaners will be started at a lower threshold, ensuring that the buffer pool is cleaned more frequently and efficiently.

    Rate this question:

  • 18. 

    Multi Dimensional Clusters are  Beneficial For

    • A.

      OLAP

    • B.

      MOLAP

    • C.

      ROLAP

    • D.

      None

    Correct Answer
    A. OLAP
    Explanation
    Multi Dimensional Clusters are beneficial for OLAP (Online Analytical Processing). OLAP involves analyzing large volumes of data from multiple dimensions, such as time, geography, and product. Multi-dimensional clusters help in organizing and structuring this data in a way that allows for efficient and fast retrieval of information. By grouping similar data points together based on their attributes, multi-dimensional clusters enable OLAP systems to perform complex queries and aggregations more quickly, improving the overall performance and responsiveness of the analytical process.

    Rate this question:

  • 19. 

    SMS-

    • A.

      Allocates space on demand

    • B.

      The File Manager of operating system allocates and manages space

    • C.

      System Managed Space

    Correct Answer(s)
    A. Allocates space on demand
    C. System Managed Space
    Explanation
    The given correct answer suggests that SMS (System Managed Space) is responsible for allocating space on demand. It implies that the File Manager of the operating system is in charge of managing and allocating space as needed. This system manages the space efficiently, ensuring that it is allocated and utilized optimally.

    Rate this question:

  • 20. 

    A container is not a

    • A.

      Raw device

    • B.

      Directory

    • C.

      File

    • D.

      Memory

    Correct Answer
    D. Memory
    Explanation
    A container is not considered a memory. Memory refers to the physical or virtual storage space where data and instructions are stored for processing by a computer system. A container, on the other hand, is a software unit that encapsulates and isolates applications and their dependencies, providing a consistent and portable environment for running them. While containers may utilize memory resources, they are not synonymous with memory itself.

    Rate this question:

  • 21. 

    Locklist 

    • A.

      Increase this value if there is a problem with lock escalation.

    • B.

      Memory that holds information about locks held by all applications concurrently connected to the database

    • C.

      Decrease this value if there is a problem with lock escalation.

    Correct Answer(s)
    A. Increase this value if there is a problem with lock escalation.
    B. Memory that holds information about locks held by all applications concurrently connected to the database
    Explanation
    The locklist is the memory that holds information about locks held by all applications concurrently connected to the database. If there is a problem with lock escalation, increasing the locklist value can help address the issue. This allows for more locks to be held in memory, reducing the need for lock escalation. On the other hand, decreasing the locklist value can exacerbate lock escalation problems as there may not be enough memory to hold all the necessary lock information.

    Rate this question:

  • 22. 

    Default page size in DB2?

    • A.

      32 KB

    • B.

      16 KB

    • C.

      8 KB

    • D.

      4 KB

    Correct Answer
    D. 4 KB
    Explanation
    The default page size in DB2 is 4 KB. This means that the database system allocates storage in units of 4 KB for storing data and indexes. This page size is commonly used because it strikes a balance between efficient storage and performance. Larger page sizes can reduce the overhead of managing storage, but they may also result in wasted space if the data being stored is smaller than the page size. Smaller page sizes can be more efficient for small amounts of data, but they may also increase the overhead of managing storage.

    Rate this question:

  • 23. 

    Not a DB2 licence method

    • A.

      CPU

    • B.

      User

    • C.

      Memory

    Correct Answer
    C. Memory
    Explanation
    The given options CPU and User are not related to licensing methods in DB2. Memory, on the other hand, can be a relevant factor when it comes to licensing as it determines the amount of data that can be stored and processed in the database. Therefore, Memory is not a DB2 license method.

    Rate this question:

  • 24. 

    If the user wants particular attribute to be displayed in the report o/p, include the attribute in

    • A.

      None

    • B.

      Browse form

    • C.

      Report display form

    • D.

      Report layout form

    Correct Answer
    C. Report display form
    Explanation
    The attribute that the user wants to be displayed in the report output should be included in the Report display form. This form is specifically designed to display the attributes that will be included in the report output. By including the attribute in this form, the user ensures that it will be visible in the final report.

    Rate this question:

  • 25. 

    True about Drill across? 

    • A.

      A hierarchy can be used as a drill path

    • B.

      The destination is shown as part of the other.

    • C.

      A hierarchy cannot be used as a drill path

    • D.

      The Source is shown as part of the other.

    Correct Answer(s)
    A. A hierarchy can be used as a drill path
    B. The destination is shown as part of the other.
    Explanation
    Drill across refers to the ability to navigate from one level of detail to another within a hierarchy. This means that a hierarchy can indeed be used as a drill path. Additionally, when drilling across, the destination is shown as part of the other. Therefore, the answer "A hierarchy can be used as a drill path, The destination is shown as part of the other" is correct.

    Rate this question:

  • 26. 

    Row level math calculation and virtual attributes is possible with 

    • A.

      Consolidation

    • B.

      Constraint

    • C.

      None

    Correct Answer
    A. Consolidation
    Explanation
    Consolidation allows for row level math calculations and virtual attributes. It is a process of combining data from multiple sources into a single, unified view. This means that calculations can be performed on individual rows of data and virtual attributes can be created to represent derived values. Consolidation is commonly used in financial reporting and analysis, where data from different departments or subsidiaries needs to be aggregated and analyzed together.

    Rate this question:

  • 27. 

    If you want to filter on more than one attribute you will use

    • A.

      Joint element list

    • B.

      Element list

    • C.

      Joint filter

    Correct Answer
    A. Joint element list
    Explanation
    The correct answer is "Joint element list" because when you want to filter on more than one attribute, you need to combine or join the elements from multiple lists into a single list. This joint element list will contain all the elements that satisfy the filtering conditions for each attribute.

    Rate this question:

  • 28. 

    Report view mode

    • A.

      Grid

    • B.

      Graph

    • C.

      SQL

    • D.

      Grid graph mode

    Correct Answer(s)
    A. Grid
    B. GrapH
    C. SQL
    D. Grid grapH mode
    Explanation
    The given correct answer lists the different view modes available in a report. These modes include Grid, Graph, SQL, and Grid graph mode. Grid mode displays the data in a tabular format, Graph mode represents the data visually using charts and graphs, SQL mode allows users to write custom SQL queries, and Grid graph mode combines both the tabular and visual representations of the data.

    Rate this question:

  • 29. 

    Derives metrics can be used in other reports 

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Derives metrics cannot be used in other reports. These metrics are calculated based on other metrics and are specific to the report they are generated for. They cannot be transferred or used in other reports as they are not standalone metrics. Therefore, the given answer "False" is correct.

    Rate this question:

  • 30. 

    Level prompt –

    • A.

      Dimensionality of a metrics

    • B.

      dimensionality of a Columns

    • C.

      None

    Correct Answer
    A. Dimensionality of a metrics
    Explanation
    The dimensionality of a metrics refers to the number of dimensions or variables that are used to measure or analyze a particular metric. It indicates the complexity or richness of the metric. A higher dimensionality means that more variables are considered, resulting in a more comprehensive analysis. On the other hand, a lower dimensionality implies a simpler analysis with fewer variables. The dimensionality of a metrics is important in determining the accuracy and reliability of the analysis conducted using that metric.

    Rate this question:

  • 31. 

    More than one ID column 

    • A.

      Compound attribute

    • B.

      Multiple attribute

    • C.

      Common Attribute

    Correct Answer
    A. Compound attribute
    Explanation
    A compound attribute refers to a single attribute that consists of multiple sub-attributes. In this case, the attribute being referred to is an ID column, and it is stated that there is more than one ID column. This suggests that the ID column is composed of multiple sub-attributes, making it a compound attribute.

    Rate this question:

  • 32. 

    Default level of metrics –

    • A.

      Report Level

    • B.

      Visual Level

    • C.

      Page Level

    Correct Answer
    A. Report Level
    Explanation
    The default level of metrics is set at the Report Level. This means that when you create a report, the metrics included in that report will be displayed at the report level by default. This allows you to view and analyze the metrics in the context of the entire report.

    Rate this question:

  • 33. 

    Types of actions in hierarchy display

    • A.

      Locked

    • B.

      Limited

    • C.

      Entry point

    • D.

      Filtered

    Correct Answer(s)
    A. Locked
    B. Limited
    C. Entry point
    D. Filtered
    Explanation
    The given answer lists the types of actions in a hierarchy display. "Locked" refers to actions that are completely restricted and cannot be accessed or modified. "Limited" indicates actions that have some restrictions or limitations in terms of usage or availability. "Entry point" refers to actions that serve as the starting point or gateway to access other actions or features. "Filtered" implies that certain actions are displayed or made available based on specific filters or criteria.

    Rate this question:

  • 34. 

    Schema updation can be done by

    • A.

      Stop and start microstatergy intelligence server

    • B.

      Disconnect and reconnect to the project source

    • C.

      All

    • D.

      Manually update the schema

    Correct Answer
    C. All
    Explanation
    The correct answer is "All". This means that schema updation can be done by any of the mentioned methods, including stopping and starting the microstrategy intelligence server, disconnecting and reconnecting to the project source, and manually updating the schema.

    Rate this question:

  • 35. 

    Formula automatically got updated fact column by which metrics

    • A.

      Nested

    • B.

      Smart

    • C.

      Derived

    • D.

      Compound

    Correct Answer
    B. Smart
    Explanation
    The correct answer is "Smart" because the term "Smart" is commonly used to describe formulas or functions that automatically update or recalculate values based on changes in other cells or data. In this context, the formula is likely designed to update the fact column with metrics based on certain conditions or calculations. The other options (Nested, Derived, and Compound) do not specifically imply this automatic updating behavior.

    Rate this question:

  • 36. 

    Which of the following is responsible for MOLAP functionality of microstatergy – 

    • A.

      Analytical engine

    • B.

      DB Engine

    • C.

      DataMart

    Correct Answer
    A. Analytical engine
    Explanation
    The analytical engine is responsible for the MOLAP (Multidimensional Online Analytical Processing) functionality of MicroStrategy. MOLAP is a type of database technology that enables fast and efficient analysis of large amounts of data. The analytical engine within MicroStrategy processes and organizes data in a multidimensional format, allowing users to easily navigate and analyze data from different perspectives. This engine performs calculations, aggregations, and other operations necessary for generating reports and visualizations in MOLAP cubes. It plays a crucial role in providing users with a powerful and interactive analytical experience within the MicroStrategy platform.

    Rate this question:

  • 37. 

    Which mapping stores the project information – 

    • A.

      Metadata mapping

    • B.

      Data mapping

    • C.

      Transaction Mapping

    Correct Answer
    A. Metadata mapping
    Explanation
    Metadata mapping is the mapping that stores project information. Metadata refers to the data that provides information about other data, in this case, it includes information about the project. This mapping is responsible for organizing and managing the metadata of the project, such as project name, description, version, and other relevant details. By using metadata mapping, project information can be easily accessed and utilized for various purposes, such as project management, documentation, and analysis.

    Rate this question:

  • 38. 

    Metric level – group set to NONE is not applicable for 

    • A.

      Transformation.

    • B.

      Transaction

    • C.

      Duplication

    Correct Answer
    A. Transformation.
    Explanation
    The given question states that the metric level with the group set to NONE is not applicable for Transformation. This suggests that the metric level and group set to NONE can be applicable for Transaction and Duplication. Therefore, the correct answer is Transformation.

    Rate this question:

  • 39. 

    OLAP services

    • A.

      Report objects

    • B.

      Derived metrics

    • C.

      View filters

    • D.

      None

    Correct Answer(s)
    A. Report objects
    B. Derived metrics
    C. View filters
    Explanation
    The correct answer includes three options: report objects, derived metrics, and view filters. These are all components or features commonly found in OLAP services. Report objects refer to the various elements that can be included in a report, such as tables, charts, and graphs. Derived metrics are calculated measures that are derived from existing data in the OLAP cube. View filters allow users to apply specific filters to the data being viewed in order to focus on specific subsets of information. Therefore, all three options are relevant to OLAP services.

    Rate this question:

  • 40. 

    Default drill path –

    • A.

      System Hierarchy

    • B.

      Data Hierarchy

    Correct Answer
    A. System Hierarchy
    Explanation
    The correct answer is System Hierarchy because the term "default drill path" refers to the predefined path or sequence followed when navigating through a system or data hierarchy. In this context, the System Hierarchy refers to the hierarchical structure of the system, which is the default path followed when drilling down or navigating through different levels of the system. It is the primary hierarchy that determines the organization and relationship between different components or levels within the system.

    Rate this question:

  • 41. 

    Grouping of attributes which can be displayed, ordered, unordered –

    • A.

      Hierarchy

    • B.

      Drillers

    • C.

      Sequential

    Correct Answer
    A. Hierarchy
  • 42. 

    OLAP services

    • A.

      Report objects

    • B.

      View filters

    • C.

      Derived metrics

    • D.

      All

    Correct Answer
    D. All
    Explanation
    The correct answer is "All" because all of the mentioned options (report objects, view filters, derived metrics) are part of OLAP services. OLAP services are used for analyzing multidimensional data and these components are essential for performing various operations and calculations on the data. Therefore, selecting "All" implies that all of these components are included in OLAP services.

    Rate this question:

  • 43. 

    Types of prompts 

    • A.

      Level prompt

    • B.

      Object prompt

    • C.

      Value prompt

    • D.

      Filter definition prompt

    Correct Answer(s)
    A. Level prompt
    B. Object prompt
    C. Value prompt
    D. Filter definition prompt
    Explanation
    The given answer lists the different types of prompts. A level prompt is used to select a level or hierarchy in a system. An object prompt allows the selection of specific objects or entities. A value prompt allows the input of a specific value or range. A filter definition prompt is used to define filters or conditions for data retrieval.

    Rate this question:

  • 44. 

    Output of hash file - 

    • A.

      Not sorted.

    • B.

      Sorted

    Correct Answer
    A. Not sorted.
    Explanation
    The output of the hash file is "Not sorted" because it does not follow any specific order or arrangement. A hash file is typically used for quick data retrieval and does not guarantee any particular order of the stored data. Therefore, the output is not sorted and can be accessed randomly.

    Rate this question:

  • 45. 

    Implicit facts or attributes are 

    • A.

      Virtual facts or attributes.

    • B.

      Constant facts or attributes.

    • C.

      None

    Correct Answer(s)
    A. Virtual facts or attributes.
    B. Constant facts or attributes.
    Explanation
    Implicit facts or attributes are facts or attributes that are not explicitly stated but can be inferred or assumed based on other information. They are not directly mentioned but can be understood or deduced from the context or other explicit facts. Therefore, implicit facts or attributes can be considered as virtual or constant, as they exist but are not explicitly mentioned or stated.

    Rate this question:

  • 46. 

    Updating the schema is nessary when there is a change in 

    • A.

      Fact

    • B.

      Attributes

    • C.

      Both the facts and attributes

    • D.

      None

    Correct Answer
    C. Both the facts and attributes
    Explanation
    When there is a change in both the facts and attributes of a schema, updating the schema becomes necessary. A schema is a blueprint or structure that defines the organization and relationships of data in a database. Facts are the actual data stored in the database, while attributes are the characteristics or properties of the data. If either the facts or attributes change, the schema needs to be updated to reflect these changes and ensure the integrity and consistency of the data.

    Rate this question:

  • 47. 

    Schema objects are  

    • A.

      Facts, Attributes

    • B.

      Hierarchies

    • C.

      Transformation

    • D.

      Partition mapping

    • E.

      All

    Correct Answer
    E. All
    Explanation
    The correct answer is "All". This means that schema objects include all of the options listed: facts, attributes, hierarchies, transformation, and partition mapping. In database management, a schema is a logical container for organizing and grouping related database objects. These objects can include tables, views, indexes, procedures, and more. So, all of these options are valid examples of schema objects.

    Rate this question:

  • 48. 

    In which type of filter the SQL is not changed?

    • A.

      View filter

    • B.

      True Filter

    • C.

      All Types

    Correct Answer
    A. View filter
    Explanation
    A view filter in SQL is a filter applied to a view, which is a virtual table created from the result of a query. When a view filter is applied, the SQL query itself remains unchanged. Instead, the filter is applied to the result set of the query, allowing for selective retrieval of data from the view. Therefore, in a view filter, the SQL is not changed.

    Rate this question:

  • 49. 

    In two tier architecture, how many ODBC connections are there?

    • A.

      2

    • B.

      4

    • C.

      3

    • D.

      1

    Correct Answer
    A. 2
    Explanation
    In a two-tier architecture, there are two ODBC connections. This architecture consists of a client and a server, where the client directly communicates with the server. The first ODBC connection is established between the client application and the database server, allowing the client to send queries and retrieve data. The second ODBC connection is between the database server and the database itself, enabling the server to execute the queries and retrieve the requested data. Therefore, there are two ODBC connections in a two-tier architecture.

    Rate this question:

  • 50. 

    Types of partition mapping?

    • A.

      Server Level Partitioning

    • B.

      Application Level Partitioning

    • C.

      Both

    Correct Answer
    C. Both
    Explanation
    The correct answer is "Both" because there are two types of partition mapping: server level partitioning and application level partitioning. Server level partitioning involves dividing data across multiple servers or nodes, while application level partitioning involves dividing data within a single server or node. Therefore, both types of partition mapping are valid and can be used depending on the specific requirements and architecture of the system.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 29, 2016
    Quiz Created by
    MishraAkshay
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.