The command used to delete a particular column in a relation is ____________
ALTER , DROP
Explanation: None
UPDATE TABLE
TRUNCATE COLUMN
DELETE COLUMN
Category: Computer Science
The SQL used by front-end application programs to request data from the DBMS is called _______
The SQL used by front-end application programs to request data from the DBMS is called _______
DML
Explanation: None
DDL
VDL
SDL
A SQL query automatically eliminates duplicates (True / False) ?
A SQL query automatically eliminates duplicates (True / False) ?
FALSE
Explanation: None
TRUE
Sometimes
None of the Options are Correct
SQL permits attribute names to be repeated in the same relation. (True or False)
SQL permits attribute names to be repeated in the same relation. (True or False)
FALSE
Explanation: None
TRUE
Sometimes
None of Options are Correct
Which operator is used to compare a value to a specified list of values?
Which operator is used to compare a value to a specified list of values?
IN
Explanation: None
BETWEEN
ANY
ALL
Which data manipulation command is used to combines the records from one or more tables?
Which data manipulation command is used to combines the records from one or more tables?
JOIN
Explanation: None
SELECT
PROJECT
PRODUCT
Which of the following is not a valid SQL type?
Which of the following is not a valid SQL type?
DECIMAL
Explanation: None
FLOAT
NUMERIC
CHARACTER
Which of the following is not a database object?
which of the following is not a database object?
Relationships
Explanation: None
Tables
Queries
Reports
A data dictionary is a repository that manages _____
A data dictionary is a repository that manages _____
Metadata
Explanation: None
Data Validator
Memory
Spell Checker
The overall description of a database is called______.
The overall description of a database is called______.
Database schema
Explanation: None
Data integrity
Data manipulation
Data definition