DBMS

What is a database?

• Organized collection of information that cannot be accessed, updated, and managed

• Collection of data or information without organizing

• Organized collection of data or information that can be accessed, updated, and managed

• Organized collection of data that cannot be updated

What is DBMS?

• a) DBMS is a collection of queries

• b) DBMS is a high-level language

• c) DBMS is a programming language

• d) DBMS stores, modifies and retrieves data

Which type of data can be stored in the database?

• a) Image oriented data

• b) Text, files containing data

• c) Data in the form of audio or video

• d) All of the above

7. Which of the following is not a type of database?

• a) Hierarchical

• b) Network

• c) Distributed

• 
  d) Decentralized

Which of the following is not a feature of DBMS?

• a) Minimum Duplication and Redundancy of Data

• b) High Level of Security

• c) Single-user Access only

• d) Support ACID Property

Which of the following is a feature of the database?

• a) No-backup for the data stored

• b) User interface provided

• c) Lack of Authentication

• d) Store data in multiple locations

Which of the following is a component of the DBMS?

• a) Data

• b) Data Languages

• c) Data Manager

• d) All of the above

Which one of the following given statements possibly contains the error?

• select * from emp where empid = 10003;

• select empid from emp where empid = 10006;

• select empid from emp;

• select empid where empid = 1009 and Lastname = 'GELLER';

What do you mean by one to many relationships?

• One class may have many teachers

• One teacher can have many classes

• Many classes may have many teachers

• Many teachers may have many classes

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?

1. SELECT *  

2. FROM instructor  

3. ORDER BY salary ____, name ___;  

• Ascending, Descending

• Asc, Desc

• Desc, Asc

• All of the above