ISM 4212 FSU Final Exam
ALTER command - ANS-Add one or more than one columns after developing a table
Example: ALTER TABLE supplier ADD (supplier_name char(50), city_char(forty five));
AND and OR Statements - ANS-Used to clear out based totally on more than one circumstance
Example:
SELECT * FROM Customers WHERE Country='Germany' AND City='Berlin'
Authorization rules - ANS-controls that are integrated into the data control device; authorization
guidelines supply get right of entry to, specifying which actions and constraints govern the user
(or consumer organizations) access.
Authorization Rules Restrict - ANS-- Access to records (what consumer can see)
- Actions that human beings can take on information (can the consumer SELECT, INSERT,
UPDATE, DELETE)
Backup - ANS-Provide periodic backup of the entire database or subset of the database
(backup as soon as according to day)
checkpoint - ANS-Checkpoint facilities allow DBMS to periodically suspend all processing and
synchronizing its files and journals to establish a restoration factor.
COUNT Statement - ANS-Use the COUNT feature to find totals
Example:
SELECT COUNT(*) FROM order WHERE orderID = 1004
statistics administration - ANS-A high-stage characteristic that is answerable for the overall
management of facts sources in an organisation, together with keeping corporate-extensive
definitions and standards; more managerial
Data Control Language (DCL) - ANS-Commands that control a database, which includes
administering privileges and committing records
Data Definition Language (DDL) - ANS-Commands used to define a database, including
creating, altering, and losing tables and establishing constraints
ALTER command - ANS-Add one or more than one columns after developing a table
Example: ALTER TABLE supplier ADD (supplier_name char(50), city_char(forty five));
AND and OR Statements - ANS-Used to clear out based totally on more than one circumstance
Example:
SELECT * FROM Customers WHERE Country='Germany' AND City='Berlin'
Authorization rules - ANS-controls that are integrated into the data control device; authorization
guidelines supply get right of entry to, specifying which actions and constraints govern the user
(or consumer organizations) access.
Authorization Rules Restrict - ANS-- Access to records (what consumer can see)
- Actions that human beings can take on information (can the consumer SELECT, INSERT,
UPDATE, DELETE)
Backup - ANS-Provide periodic backup of the entire database or subset of the database
(backup as soon as according to day)
checkpoint - ANS-Checkpoint facilities allow DBMS to periodically suspend all processing and
synchronizing its files and journals to establish a restoration factor.
COUNT Statement - ANS-Use the COUNT feature to find totals
Example:
SELECT COUNT(*) FROM order WHERE orderID = 1004
statistics administration - ANS-A high-stage characteristic that is answerable for the overall
management of facts sources in an organisation, together with keeping corporate-extensive
definitions and standards; more managerial
Data Control Language (DCL) - ANS-Commands that control a database, which includes
administering privileges and committing records
Data Definition Language (DDL) - ANS-Commands used to define a database, including
creating, altering, and losing tables and establishing constraints
