INFO 201 # Ch3

Works with users to decide the content of the database

• DBA

• SAAS

• SQL

• DML

Responsible for defining and implementing consistent principles for a variety of data issues

• none

• Database administrator

• Data administrator

• administrator

choose the definition of SQL from the options

• Can be part of the database or a separate schema file

• Commands that manipulate the data in a database

• Eliminates rows according to certain criteria

• the standard query language for relational databases

what is the mean of SQL ?

• NONE

• Study Qrequency Language

• Structured Query Language

Popular Database Management Systems

choose all the correct answer

• DBMS

• Database as a Service

• Data administrator

• DBMSs for end users

Selecting

• Eliminates columns in a table

• Eliminates rows according to certain criteria

• Combines two or more tables

Manipulating two or more tables that share at least one common data attribute

• Manipulating Data

• Joining

• Projecting

• Linking

Projecting can Eliminates rows in a table

• false

• true

Joining can Combines more than two tables

• false

• true

what is a primary key ?

• none

• Field or set of fields that uniquely identifies the record

• Field or set of fields in a record that is used to identify the record

• Collection of related data fields