DBMS Final Questions and Answers

DBMS Final Questions and Answers




1. When a user interacts with a database, they can use a to modify data
with commands.: Query Language
2. The SQL statement does not alter any database data: SELECT
3. When using a SQL statement to create a table, which data type is used to store a fractional
value?: DECIMAL
4. A database administrator uses which two SQL statements to view and then modify existing
customer balances with a late fee?: SELECT, UPDATE
5. A user creates a table by using a SQL statement. The data type VAR- CHAR(11) is part of the
statement. What does the value of (11) represent?: The number of characters allowed for the data
type
6. In the relational model, a column is : a name and a data type

7. What does SQL stand for?: Structured Query Language
8. What is the correct statement for creating a database called reserva- tionDB?:
CREATE DATABASE reservationDB
9. A database system has a database called onlineShop. What is the result of a CREATE
statement that tries to create onlineShop a second time?: The statement produces an error that
indicates the database already exists
10.What is the correct statement for deleting a database?: DROP DATABASE DatabaseName
11.What should be added to the SQL statements to produce the below: result table
onlineShop, TABLES



12.In a table, columns are and rows are : Ordered, not or-
dered
13.How many columns are created by the SQL statement below?

1/
11

, DBMS Final Questions and Answers
CREATE TABLE Supplier ( SupplierId INT,
CompanyName VARCHAR(40), ContactName
VARCHAR(50),
City VARCHAR(40),
Country VARCHAR(40),
Phone VARCHAR(30)
);: 6
14.Which SQL statement deletes the table Supplier?: DROP TABLE Supplier
15.Which SQL Statement adds a new column Fax to the Supplier table?: AL- TER TABLE
Supplier ADD Fax VARCHAR(30)
16.Which SQL statement deletes the City column from the Supplier table?: -
ALTER TABLE Supplier DROP City




2/
11