logo

CuriousTab

CuriousTab

Discussion

Home ‣ Technical Questions ‣ Database Comments
  • Question

  • Which of the following describes a relational database?


  • Options
  • A. It retrieves data related to its queries
  • B. It provides a relationship between floats
  • C. It provides a relationship between integers
  • D. It consists of separate tables or related data

  • Correct Answer
  • It consists of separate tables or related data 

    Explanation

    A relational database is a digital database based on the relational model of data, a database structured to recognize relations between stored items of information. A software system used to maintain relational databases is a relational database management system.

     

    Computer database in which all data is stored in Relations which (to the user) are tables with rows and columns. Each table is composed of records (called Tuples) and each record is identified by a field (attribute) containing a unique value. Every table shares at least one field with another table in 'one to one,' 'one to many,' or 'many to many' relationships. These relationships allow the database user to access the data in almost an unlimited number of ways, and to combine the tables as building blocks to create complex and very large databases.

    • Tags: Bank Exams, Analyst, Bank Clerk, Bank PO, Database Administrator, IT Trainer, Project Manager, Software Architect

    Database problems

    Search Results

    • 1. The command to eliminate a table from a database is

    • Options
    • A. REMOVE TABLE CUSTOMER;
    • B. UPDATE TABLE CUSTOMER;
    • C. DELETE TABLE CUSTOMER;
    • D. DROP TABLE CUSTOMER;
      • Discuss
    • 2. Legacy data is which of the following?

    • Options
    • A. Data contained in a newly-installed system
    • B. Data rejected during the installation of a new system
    • C. Data contained in a file system
    • D. Data contained by a system used prior to the installation of a new system
      • Discuss
    • 3. When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

    • Options
    • A. first step.
    • B. second step.
    • C. third step.
    • D. fourth step.
      • Discuss
    • 4. If a table has been normalized so that all determinants are candidate keys, then that table is in:

    • Options
    • A. 1NF
    • B. 2NF
    • C. 3NF
    • D. BCNF
      • Discuss
    • 5. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

    • Options
    • A. LIKE only.
    • B. IN only.
    • C. NOT IN only.
    • D. Both IN and NOT IN.
      • Discuss
    • 6. An entity is a thing in the real world with an independent existence.

    • Options
    • A. TRUE
    • B. FALSE
      • Discuss
    • 7. In the relational model, relationships between relations or tables are created by using:

    • Options
    • A. composite keys.
    • B. determinants.
    • C. candidate keys.
    • D. foreign keys.
      • Discuss
    • 8. A transaction for which all committed changes are permanent is called:

    • Options
    • A. atomic.
    • B. consistent.
    • C. isolated.
    • D. durable.
      • Discuss
    • 9. A benefit of the three-tier architecture is which of the following?

    • Options
    • A. New modules can be built to support specific business needs
    • B. Performance improves for compiled SQL statements
    • C. Results in a thinner client and database server
    • D. All of the above.
      • Discuss
    • 10. The load and index is which of the following?

    • Options
    • A. A process to reject data from the data warehouse and to create the necessary indexes
    • B. A process to load the data in the data warehouse and to create the necessary indexes
    • C. A process to upgrade the quality of data after it is moved into a data warehouse
    • D. A process to upgrade the quality of data before it is moved into a data warehouse
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.