Database Management Questions & Answers: part11



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
Trust because you are willing to accept the risk, not because it’s safe or certain