The database management system can be considered as the collection of ______ that enables us to create and maintain the database.
Programs
Well Done. Your Answer is Correct Keep it Up!
Translators
Keys
Language activity
Tag: Databases MCQs
Which one of the following commands is used to restore the database to the last committed state?
Which one of the following commands is used to restore the database to the last committed state?
Rollback
Well Done. Your Answer is Correct Keep it Up!
Savepoint
Commit
None of the options are correct
Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
Drop
Well Done. Your Answer is Correct Keep it Up!
Delete
Remove
All options are correct
Which one of the following command is used to delete the existing row in a table?
Which one of the following command is used to delete the existing row in a table?
Delete
Well Done. Your Answer is Correct Keep it Up!
Update
Insert
All options are correct
Which of the following commands is used to save any transaction permanently into the database?
Which of the following commands is used to save any transaction permanently into the database?
Commit
Well Done. Your Answer is Correct Keep it Up!
Rollback
Savepoint
None of the options are correct
Which of the following is used in the application programs to request data from the database management system?
Which of the following is used in the application programs to request data from the database management system?
Data Manipulation language
Well Done. Your Answer is Correct Keep it Up!
Data Definition Language
Data Control Language
All options are correct
Which of the following refers to the number of attributes in a relation?
Which of the following refers to the number of attributes in a relation?
Degree
Well Done. Your Answer is Correct Keep it Up!
Row
Column
All options are correct
The term “TCL” stands for_____.
The term “TCL” stands for_____.
Transaction Control Language
Well Done. Your Answer is Correct Keep it Up!
Transaction Central Language
Transmission Control Language
Ternary Control Language
In the relational table, which of the following can also be represented by the term “attribute”?
In the relational table, which of the following can also be represented by the term “attribute”?
Column
Well Done. Your Answer is Correct Keep it Up!
Row
Entity
All options are correct
In a relation database, every tuples divided into the fields are known as the______.
In a relation database, every tuples divided into the fields are known as the______.
Domains
Well Done. Your Answer is Correct Keep it Up!
Queries
Relations
All options are correct