Database management system- BRIGHT 2

In the following Query, which of the following can be placed in the Query's blank portion to display the salary from highest to lowest amount, and sorting the employs name alphabetically?

SELECT * FROM instructor ORDER BY salary ____, name ___

• Ascending, descending

• Asc,Desc

• Desc,Asc

• All of the above

A Database Management System is a type of _________

• It is a type of system software

• It is a kind of application software

• It is a kind of general software

• Both A and B

To which of the following the term "DBA" referred?

• Database administrator

• Data bank administrator

• Data Administrator

• None of the above

Which of the following is a top-down approach in which the entity's higher level can be divided into two lower sub-entities?

• Aggregation

• Generalization

• Specialization

• All of the above

In which one of the following, the multiple lower entities are grouped (or combined) together to form a single higher-level entity

• Specialization

• Generalization

• Aggregation

• None of the above

The term "TCL" stands for_____.

• Ternary Control Language

• Transmission Control Language

• Transaction Central Language

• Transaction Control Language

Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?

• Delete

• Drop

• Remove

• All of the above

Which one of the following commands is used to restore the database to the last committed state

• Roll back

• Save point

• Committ

• Both A and B

The database management system can be considered as the collection of ______ that enables us to create and maintain the database.

• Translators

• Programs

• Keys

• Language

The Database Management Query language is generally designed for the _____

• Specifying the structure of the database

• Support end-users who use English like commands

• Support in the development of the complex applications software

• All of the above