COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Speed up the operation of a computer
|
|
|
Create a blank database table
|
|
|
Extract a data set from a number of tables
|
|
|
Produce reports that combine and summarise the data.
|
Detailed explanation-1: -The typical database administrative tasks that can be performed using a DBMS include: Configuring authentication and authorization. Easily configure user accounts, define access policies, modify restrictions, and access scopes.
Detailed explanation-2: -Database software is used to create, edit, and maintain database files and records, enabling easier file and record creation, data entry, data editing, updating, and reporting. The software also handles data storage, backup and reporting, multi-access control, and security.
Detailed explanation-3: -Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database.