Database Management Systems Concepts
48 Questions
13 Views
4.7 Stars

Database Management Systems Concepts

Test your knowledge of database management systems concepts including overall design, basic data manipulation, and SQL interface layer. Explore the collection of logically related data and understand the support between users and the physical database.

Created by
@DistinguishedWetland

Questions and Answers

set of computer programs use in DBMS

creation, maintenance, use of db

combines two tables with common column which is primary key.

inner join

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

Relational Database

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 Quizzes Like This

Use Quizgecko on...
Browser
Browser