SQL and Differrent type of SQL statements
What is a database ?
A database is an organized collection of logically related data and information .
Schema
A logical grouping of tables , indexes , triggers and other data objects under one qualifying name
Data Dictionary
A read - only set of tables that provides information about the database
------- is a collection of related fields . A ) Column B ) Row C ) Table D ) All of the above
Answer : B
A database is an organized collection of related data . A ) physically B ) logically C ) None of the above D ) Both of the above
Answer : B
INSERT INTO is an example of ———- code . A ) DDL B ) DML C ) DCL D ) TCL
Answer : B
——— is a set of commands used to update a database . A ) DDL B ) DML C ) DCL D ) TCL
Answer : B
------------- withdraws access privileges given with the GRANT GRANT command . A ) Rollback B ) Revise C ) Revoke D ) All of the above
Answer : C
How to make changes permanent after manipulating a table ? A ) Rollback B ) Update C ) Commit D ) Drop
Answer : C
————is a set of commands used to control a database , including security . A ) DML B ) DDL C ) DCL D ) TCL
Answer : C
Any create command may be reversed by using a ( n ) ———command . A ) undo B ) delete C ) rollback D ) drop
Answer : D
The CREATE SCHEMA , the DDL command is used to create a table
Answer : FALSE CREATE TABLE
The DELETE TABLE , DDL command is used to remove a table from the database .
Answer : FALSE DROP
A database is maintained and queried using the data mapping language ( DML ) .
Answer : FALSE data manipulation language
A database is a central repository of shared data .
Answer : TRUE
A database table is defined using the data definition language ( DDL )
Answer : TRUE
RDBMS is the basis for SQL , and for all modern database systems
Answer : TRUE
SQL is a standard language for database access .
Answer : TRUE
The SQL command used to populate tables with data is the INSERT command
Answer : TRUE
) After performing a DELETE operation you need to ----........ to undo it . A ) Redo B ) Rollback C ) Commit D ) Diallo all of the above
Answer Answer : : B
What is a database table
Answer Table is database object that contains all the data in a database . A table has records rows and fields ( columns . It is a collection of related records .
----------- add comments to the data dictionary
COMMENT
After performing a DELETE operation you need to ---- or ————the transaction to make the change permanent or to undo it .
COMMIT / ROLLBACK
What are the different kinds of SQL statements ? ( Just Name and Abbreviations
Data Query Language ( DQL ) Data Definition Language ( DDL Data Manipulation Language ( DML ) Data Control Language ( DCL ) Transaction Control Language ( TCL )
A field is a single piece of information .
FALSE DATA
GRANT
Gives user's access privileges to database
FLASHBACK TABLE
Restore an earlier state of a table in the event of human or application error .
ROLLBACK
Restore database to original since the last COMMIT
SQL stands for ---------------- What is SQL ?
Structured Query Language SQL is English like commands and is used to communicate with database
----- removes all rows from a table and cannot be rolled back .
TRUNCATE
A ——————is an optional part of a SELECT , DELETE , or UPDATE statements
WHERE clause
REVOKE
Withdraw access privileges given with the GRANT command
DCL is used to update the database with new records
used to FALSE DML
