Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part11 : 11 to 15

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

11.What is the logical description of the entire database showing all the data elements and relationships among them called?

Data definition language

Data dictionary

Physical schema

Conceptual schema

Subschema.

12.Consider the following Employee table. #159.Consider the following Employee table. Which of the following statements give the list of departments having average salary greater than 20000 from employee table?

SELECT Dept_No,AVG(Salary) FROM Employee ORDER BY Dept_No HAVING AVG(Salary)>20000

SELECT Dept_No,AVG(Salary) FROM Employee HAVING AVG(Salary)>20000

SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No HAVING AVG(Salary)>20000

SELECT Dept_No,AVG(Salary) FROM Employee WHERE AVG(Salary)>20000

SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No WHERE AVG(Salary)>20000.

13.What is SQL?

A first-generation language

The standard data manipulation language for relational DBMS

The query language used for networked databases

Never used for reports

A natural language approach to gathering information from databases.

14.Select the correct statement from among the following on proper naming of schema constructs:

Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type

In the narrative description of the database requirements, verbs tend to indicate the names of relationship types

The nouns arising from a database requirement description can be considered as names of attributes

Additional nouns which are appearing in the narrative description of the database requirements represent the weak entity type names

Adjectives written in the database requirement description help to identify the partial relationships among entities.

More Database Management QUESTIONS AND ANSWERS available in next pages

Health is the greatest gift, contentment is the greatest wealth -Buddha

Opportunity is missed by most people because it is dressed in overalls and looks like work.- Thomas Edison

Related Online Test

Bank General Knowledge - Online Test 1
Bank General Knowledge - Online Test 3
Bank General Knowledge - Online Test 4
Bank General Knowledge - Online Test 5
Bank General Knowledge - Online Test 6
Bank Model question Paper - Online Test 1
Bank Numerical Ability - Online Test 1

Database Management Questions & Answers: part11

Database Management Questions and Answers

Related Online Test