Database Management Systems Concepts
48 Questions
15 Views

Database Management Systems Concepts

Created by
@DistinguishedWetland

Podcast Beta

Play an AI-generated podcast conversation about this lesson

Questions and Answers

set of computer programs use in DBMS

  • creation, maintenance, use of db (correct)
  • controls organization, storage, management, & retrieval of data in db
  • creation, storage, control, maintainance,

    • combines two tables with common column which is primary key.

  • left outer join
  • cross join
  • inner join (correct)

    • divided into logical units called table composed of rows and columns of data

  • Attribute
  • Relational Database (correct)
  • Domain

    • bridge bet machine components and human components

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

    returns all the rows of table on the right side of join and matching rows for the table on the left side of join.

    <p>RIGHT JOIN</p> Signup and view all the answers

    attribute or field serves as unique identifier for particular record within a relation.

    <p>PRIMARY KEY</p> Signup and view all the answers

    Other term for row in Relational Database

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

    contain particular characteristic of real-world entity being describes by row in Relational database

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

    set of valid atomic values for given attribute

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

    SQL can't do

    <p>control operation</p> Signup and view all the answers

    high-level conceptual data modeling approach to db

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

    support the basic data manipulation

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

    column cant have a NULL

    <p>NOT NULL</p> Signup and view all the answers

    creates the result-set by combining result of both LEFT JOIN and RIGHT JOIN

    <p>FULL JOIN</p> Signup and view all the answers

    to specify multiple values in a WHERE clause

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

    returns all possible combinations of rows from two tables. called a cross product.

    <p>CROSS JOIN</p> Signup and view all the answers

    to select data from a database

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

    describe and name the entities, attributes, and relationships required

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

    Facilities DBMS doesn't provide

    <p>Users manipulate data through DDL</p> Signup and view all the answers

    people whose tasks require access to the db

    <p>End User</p> Signup and view all the answers

    db involves specifying data types, structures, and constraints of data to be stored in the db.

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

    controls organization, storage, management, & retrieval of data in db

    <p>set of software programs</p> Signup and view all the answers

    db includes functions; querying the db to retrieve specific data.

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

    returns all the rows of the table on left side and matching rows for table on the right side of join. rows no matching row on right, will contain null

    <p>LEFT JOIN</p> Signup and view all the answers

    Ensures that all values in a column satisfies a specific condition

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

    returns the smallest value of the selected column

    <p>MIN()</p> Signup and view all the answers

    displays a record if either is true

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

    used in a WHERE to search for a specified pattern in a column.

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

    to substitute for any other character(s) in a string

    <p>Wildcard character</p> Signup and view all the answers

    SQL Command: extracts data from a database

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

    SQL means

    <p>Structured Query Language</p> Signup and view all the answers

    over-all design of a db

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

    support the basic data manipulation

    <p>data manipulation language</p> Signup and view all the answers

    deletes a table

    <p>DROP TABLE</p> Signup and view all the answers

    interface layer bet. users and physical db.

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

    collection of logically related data

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

    instruction and rules govern the design and use of db

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

    SQL Command: deletes data from a database

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

    who publish ERM

    <p>Peter Chen</p> Signup and view all the answers

    SQL Commands: inserts new data into a database Choices

    <p>INSERT INTO</p> Signup and view all the answers

    Sets a default value for a column when no value is specified

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

    returns the total sum of a numeric column

    <p>SUM()</p> Signup and view all the answers

    returns the largest value of the selected column.

    <p>MAX()</p> Signup and view all the answers

    to filter records

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

    to return only distinct (different) values

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

    Uniquely identifies a row/record in another table

    <p>FOREIGN KEY</p> Signup and view all the answers

    collection of data from multiple tables. combines two or more tables to retrieve data from multiple tables.

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

    automated system enables users define, create, maintain and control access db

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

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser