Database Management Systems Chapter 8 & 9
39 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What does DBMS stand for?

  • Data Broad Management System
  • Data Basic Management System
  • Digital Basic Management System
  • Database Management System (correct)

    • An example of a DBMS is MS-Excel.

    False

    What is the role of DBMS in data management?

    It serves as an interface between databases and users, allowing for the creation, manipulation, and management of data.

    A collection of data that gives information about other data is called ______.

    <p>metadata</p> Signup and view all the answers

    What does the 'R' in RDBMS stand for?

    <p>Relational</p> Signup and view all the answers

    DBMS enhances redundancy of data in the database.

    <p>False</p> Signup and view all the answers

    HTML is a scripting language used to create structured documents.

    <p>False</p> Signup and view all the answers

    Match the following terms related to databases:

    <p>Data = Raw facts and figures Files = Collection of related records Record = A set of related fields Tables = A file in the database in the form of rows and columns Ribbon = Component of Access window which consists of basic commands</p> Signup and view all the answers

    Which tag is used to display text as superscript?

    <p>sup</p> Signup and view all the answers

    A ______ is a column in the table that contains only one type of information.

    <p>field</p> Signup and view all the answers

    The ALT attribute specifies an alternate text for the ______.

    <p>image</p> Signup and view all the answers

    Match the following attributes to their descriptions:

    <p>BgColor = Defines the background colour of the web page Face = Changes the type of font of the text Noshade = Specifies that the horizontal rule should render in one solid line Src = Specifies the URL of the image Behaviour = Sets how the text will be scrolled within the marquee</p> Signup and view all the answers

    Which attribute is used to specify the URL of the image?

    <p>Src</p> Signup and view all the answers

    Which among the following is not a type of marker in the unordered list?

    <p>Rectangle</p> Signup and view all the answers

    The align attribute can have the value of 'Bottom'.

    <p>False</p> Signup and view all the answers

    An ordered list can only be numerical.

    <p>False</p> Signup and view all the answers

    What is the filename extension of HTML documents?

    <p>.html / .htm</p> Signup and view all the answers

    The HREF attribute of the ______ tag indicates the destination of the link.

    <p>a</p> Signup and view all the answers

    The content of the data cell is known as ______.

    <p>table data</p> Signup and view all the answers

    Match the following attributes with their descriptions:

    <p>BgColor = Defines the background colour of rows and columns Cellpadding = Sets space between cell border and cell contents Rowspan = Extends the cells vertically Valign = Defines the vertical alignment of cell contents</p> Signup and view all the answers

    Which attribute is responsible for adding more space inside each cell?

    <p>Cellpadding</p> Signup and view all the answers

    What does the OLE acronym stand for?

    <p>Object Linking and Embedding</p> Signup and view all the answers

    Design view is the default view of MS-Access.

    <p>False</p> Signup and view all the answers

    HTML tags are displayed in the web pages.

    <p>False</p> Signup and view all the answers

    What key do you press to add a new column after typing in the last field of a record?

    <p>Tab</p> Signup and view all the answers

    A value of zero indicates that there is ______.

    <p>no border</p> Signup and view all the answers

    The keyboard shortcut to save the table is _____.

    <p>Ctrl + S</p> Signup and view all the answers

    Match the following data types with their storage requirements:

    <p>OLE Objects = Up to about 2 GB Currency = 8 bytes Yes/No = 1 byte AutoNumber = 4 bytes Hyperlinks = Up to 8,192</p> Signup and view all the answers

    Which data type generates a unique number for each new record?

    <p>AutoNumber</p> Signup and view all the answers

    Which tab is used to set a relationship among the tables?

    <p>Database Tools</p> Signup and view all the answers

    A primary key of one table is known as a foreign key in another table.

    <p>True</p> Signup and view all the answers

    A primary key ensures that there is no data redundancy inside a table.

    <p>True</p> Signup and view all the answers

    What view of the form is used to change its layout?

    <p>Layout View</p> Signup and view all the answers

    What numeric value is stored for False in the Yes/No data type?

    <p>0</p> Signup and view all the answers

    To create a form, access the ________ tab.

    <p>Create</p> Signup and view all the answers

    Which of the following is primarily used for printing?

    <p>Reports</p> Signup and view all the answers

    We cannot edit the tables once a relationship is set between them.

    <p>False</p> Signup and view all the answers

    Match the following elements with their descriptions:

    <p>Fields = A row which displays the selected fields from the table Show = A row which displays the check marks Table = A row which displays the names of the tables from which the fields are selected Criteria = A row which holds the conditions on the basis of which the records will be sorted Sort = A row which is used to sort the data in ascending/descending order</p> Signup and view all the answers

    The __________ pane of the Query Design View displays the design grid.

    <p>Bottom</p> Signup and view all the answers

    Study Notes

    Chapter 8: Database Management Systems (DBMS)

    • DBMS is an acronym for Database Management System
    • DBMS serves as an interface between users and databases
    • It provides programs for creating, extracting, editing, and updating databases
    • DBMS does not form part of Microsoft Office Suite
    • MS-Excel is not a DBMS
    • R in RDBMS stands for Relational
    • DBMS controls data redundancy by ensuring data is stored in only one location
    • DBMS ensures data consistency across the database
    • DBMS provides data independence
    • A database is a systematically organized collection of data and information
    • Metadata describes other data
    • DBMS is application software for creating and managing databases
    • Fields within a table contain only one type of information
    • Modules are software programs used to access databases

    Chapter 9: Data Types and OLE

    • Currency data type stores 4 digits to the right of the decimal point
    • AutoNumber data type generates unique numbers for each new record
    • OLE stands for Object Linking and Embedding
    • A 'Yes/No' data type stores 0 for False and 1 for True
    • Tab key is used to add a new column in a record
    • Data Types are used to define the fields of a table
    • "Memo" is a legacy data type for long text
    • Primary key is a feature of a Relational Database Management System
    • Keyboard shortcut for saving a table is Ctrl + S
      • Short text fields do not require calculations
      • Design view is the default view in MS Access
      • OLE objects are used to store graphical elements from other applications
      • Primary Key ensures no data redundancy within a table
    • Users cannot delete the Primary Key from fields

    Chapter 10: Relationships and Queries

    • Database Tools tab is used to set relationships among tables
    • Primary Key in one table acts as a foreign key in another
    • Query Design option is available under the Create tab
    • Layout View is used for changing the form's look, whereas Form View is used for data entry
    • Reports are used for printing
    • Relationships between tables are indicated by linking lines
    • Crosstab queries aggregate data across rows and columns
    • Format and Arrange tabs appear in the MS Access Ribbon after creating a form
    • The bottom pane of the Query Design View displays the grid of data in the database
    • The top pane of the Query Design View shows the tables used in the Query.

    Chapter 11: HTML Tags and Structure

    • The <BODY> tag contains all content within a structured document
    • GIF stands for Graphics Interchange Format
    • Square and Circle are types of unordered list markers
    • The <DD> tag defines the definition of a term defined in the <DT> tag
    • The <A> tag is an Anchor tag

    Chapter 12: Tables and Attributes

    • BgColor attribute defines the background color of rows and columns
    • The <TD> tag defines a table column
    • Cellpadding adds space inside cells
    • Rowspan extends cells vertically; while Colspan extends them horizontally
    • Align attribute is used to horizontally align cell contents and can be set to Left, Right, or Center

    Matching Tables (Chapters 8, 9, 10, 11, and 12)

    • Matching tables are provided for various attributes related to data types, database design, tables, querying, and more.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    Class VII Computer 3rd UT PDF

    Description

    Explore the fundamental concepts of Database Management Systems in this quiz covering Chapters 8 and 9. Learn about the role of DBMS, data types, and their importance in managing and accessing databases. Test your knowledge on how DBMS ensures data consistency and independence, as well as various data types and their functionalities.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser