State Whether the following Statements are TRUE/FALSE:
[HDquiz quiz = 321]
‘Data redundancy means repetition or duplication of DATA
TRUE
SQL statement are case sensitive
FALSE
Select is DDL Data Defination Language
TRUE
‘collection of field is called a record
TRUE
Primary key does not allow null value in the column
TRUE
NULL value is same as a zero or blank space
FALSE
COMMIT is a transaction control statement
TRUE
Distinct clause is used to avoid the duplicate value in column
True
Drop table command eliminate a table from database
TRUE
The ORDER BY clause is used to sort the rows
TRUE
DBMS stands for Database Mangement System
True
Collection of Fields is called File
False
A traditional database stores data with no procedure
True
A view is not a subset of the database
False
DBMS is computer Software that manages database
False
Information is the processed data on which decision and action based
false
A table can have more than one Primary Key
False
Candidate Key that is not the primary key is called Alternate Key
TRUE
Foreign Key is used to represent the relationship between two tables
True
A Primary Key value can be NULL
False
Queries are created to put information into the database
False
A table in database may have multiple Primary Keys
False
SELECT command creates a new table
False
DML is used to Define the data
False
An aggregate function can be used in the WHERE clause
False
Column Name Alias can be defined for any Column
True
An underscore ( _ ) will match any number of characters from a column of a table
True
SQL statement are case sensitive
FALSE
SQL statement must be written in one line
FALSE
Column name in the table must be unique
True
Character values are not case sensitive in Where Clause
False
DATE values are format sensitive in Where Clause
True
In ORDER BY clause descending order in by Default
False
Group By Clause does not have to be in the SELECT clause
False
Queries can employ aggregate function to compute and answer
True