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
Tag: Databases MCQs
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
Which one of the following commands is used to modify a column inside a table?
Which one of the following commands is used to modify a column inside a table?
Alter
Well Done. Your Answer is Correct Keep it Up!
Update
Drop
Set
Which one of the following keyword is used to find out the number of values in a column?
Which one of the following keyword is used to find out the number of values in a column?
COUNT
Well Done. Your Answer is Correct Keep it Up!
TOTAL
SUM
ADD
A computer security protocol for logging-in can be considered as the example of the ______ component of an information system.
A computer security protocol for logging-in can be considered as the example of the ______ component of an information system.
Procedure
Well Done. Your Answer is Correct Keep it Up!
Software
Data
Hardware
Which of the following keys is generally used to represents the relationships between the tables?
Which of the following keys is generally used to represents the relationships between the tables?
Foreign key
Well Done. Your Answer is Correct Keep it Up!
Primary key
Secondary key
None of the options are correct
Which of the following levels is considered as the level closed to the end-users?
Which of the following levels is considered as the level closed to the end-users?
External Level
Well Done. Your Answer is Correct Keep it Up!
Conceptual Level
Internal Level
Physical Level