Which of the following is not a valid aggregate function?
COMPUTE
Well Done. Your Answer is Correct Keep it Up!
COUNT
SUM
MAX
Category: Databases MCQs
Which datatype can store unstructured data in a column?
Which datatype can store unstructured data in a column?
RAW
Well Done. Your Answer is Correct Keep it Up!
CHAR
NUMERIC
VARCHAR
Which of the following is not Constraint in SQL?
Which of the following is not Constraint in SQL?
Union
Well Done. Your Answer is Correct Keep it Up!
Check
Not Null
Primary Key
How many Primary keys can have in a table?
How many Primary keys can have in a table?
Only 1
Well Done. Your Answer is Correct Keep it Up!
Only 2
Depends on no of Columns
Depends on DBA
SQL Views are also known as
SQL Views are also known as
Virtual tables
Well Done. Your Answer is Correct Keep it Up!
Simple tables
Complex tables
Actual Tables
Which of the following are TCL commands?
Which of the following are TCL commands?
COMMIT and ROLLBACK
Well Done. Your Answer is Correct Keep it Up!
UPDATE and TRUNCATE
SELECT and INSERT
GRANT and REVOKE
Which statement is used to delete all rows in a table without having the action logged?
Which statement is used to delete all rows in a table without having the action logged?
TRUNCATE
Well Done. Your Answer is Correct Keep it Up!
DROP
REMOVE
DELETE
Which of the following is not a DDL command?
Which of the following is not a DDL command?
UPDATE
Well Done. Your Answer is Correct Keep it Up!
CREATE
ALTER
TRUNCATE
Which of the following is not a valid SQL type?
Which of the following is not a valid SQL type?
DECIMAL
Well Done. Your Answer is Correct Keep it Up!
NUMERIC
FLOAT
CHARACTER
Which one of the following is commonly used to define the overall design of the database?
Which one of the following is commonly used to define the overall design of the database?
Schema
Well Done. Your Answer is Correct Keep it Up!
Data definition language
Application program
Source code