The data dictionary tells the DBMS
Answer
All of the above
Question
Sort/report generators
Answer
require more disk space than index/report generators
Question
Periodically adding, changing and deleting file records is called file
Answer
Updating
Question
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
Answer
commit
Question
item characteristics that are important in data management include
Answer
width
Question
What is the language used by most of the DBMSs for helping their users to access data?
Answer
Query language
Question
After you _____ a record, many data management the environments require you to issue a command to save the changes you made
Answer
Update
Question
DCL is used to
Answer
Give or remove access rights to both a database and the structures within
Question
With SQL, how do you select all the columns from a table named "Persons"?
Answer
SELECT * FROM Persons
Question
The single element is called the _______ Element
Answer
Root
Question
Which SQL statement is used to insert new data in a database?
Answer
INSERT INTO
Question
Which SQL statement is used to delete data from a database?
Answer
delete
Question
Which SQL statement is used to update data in a database?
Answer
UPDATE
Question
RDBMS stands for _________
Answer
Relational Database Management System
Question
Which SQL statement is used to extract data from a database?
Answer
SELECT
Question
SQL comprises
Answer
DML and DDL
Question
We use _________ to do Projection, selection and joining
Answer
SELECT statement
Question
Expert system does not permit _________
Answer
What-if analysis
Question
_________ Technologically implemented medium for recording, storing, and disseminating information
Answer
information system
Question
_________are distinct from regular information systems in that they are used to analyze other information systems applied in operational activities in the organization
Answer
MIS
Comments