Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Tests  >  Test: Database Management System - 2 - Computer Science Engineering (CSE) MCQ

Test: Database Management System - 2 - Computer Science Engineering (CSE) MCQ


Test Description

15 Questions MCQ Test - Test: Database Management System - 2

Test: Database Management System - 2 for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Test: Database Management System - 2 questions and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus.The Test: Database Management System - 2 MCQs are made for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for Test: Database Management System - 2 below.
Solutions of Test: Database Management System - 2 questions in English are available as part of our course for Computer Science Engineering (CSE) & Test: Database Management System - 2 solutions in Hindi for Computer Science Engineering (CSE) course. Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free. Attempt Test: Database Management System - 2 | 15 questions in 45 minutes | Mock test for Computer Science Engineering (CSE) preparation | Free important questions MCQ to study for Computer Science Engineering (CSE) Exam | Download free PDF with solutions
Test: Database Management System - 2 - Question 1

Which of the following set should be associated with weak entity set for weak entity to be meaningful?

Detailed Solution for Test: Database Management System - 2 - Question 1

Every weak entity must be linked to an identifying entity; in other words, the existence of the weak entity set is contingent on the presence of the identifying entity set. The weak entity set that the identifying entity set identifies is said to be owned by the identifying entity set. Owner entity set is another name for it.

Test: Database Management System - 2 - Question 2

Procedural language among the following is __________

Detailed Solution for Test: Database Management System - 2 - Question 2

Non-Procedural Languages are Domain relational calculus and Tuple relational calculus. Relational algebra is a procedural language that takes input in the form of relation and output generated is also a relation.

1 Crore+ students have signed up on EduRev. Have you? Download the App
Test: Database Management System - 2 - Question 3

Which forms have a relation that contains information about a single entity?

Detailed Solution for Test: Database Management System - 2 - Question 3

If and only if, for each of its non-trivial multivalued dependencies X \twoheadrightarrow Y, a table is in 4NF. X is a superkey—that is, X is either a candidate key or a superset thereof.

Test: Database Management System - 2 - Question 4

 _______ indicates the maximum number of entities that can be involved in a relationship.

Detailed Solution for Test: Database Management System - 2 - Question 4

The term cardinality refers to the uniqueness of data values included in a single column (attribute) of a table in SQL (Structured Query Language).

Test: Database Management System - 2 - Question 5

Why the following statement is erroneous?

SELECT dept_name, ID, avg (salary)
FROM instructor
GROUP BY dept_name;

Detailed Solution for Test: Database Management System - 2 - Question 5

Any property that does not occur in the group by clause must only appear in an aggregate function if it also appears in the select clause; otherwise, the query is considered incorrect.

Test: Database Management System - 2 - Question 6

After groups have been established, SQL applies predicates in the ___________ clause, allowing aggregate functions to be used.

Detailed Solution for Test: Database Management System - 2 - Question 6

The correct answer is:

4. Having

Explanation:

  • The 'HAVING' clause is used in SQL to apply conditions (predicates) to groups after they have been created with the 'GROUP BY' clause. Unlike the 'WHERE' clause, which filters rows before grouping, the 'HAVING' clause filters groups based on aggregate functions (such as 'SUM', 'COUNT', 'AVG', etc.).
Test: Database Management System - 2 - Question 7

What does a foreign key combined with a primary key create?

Detailed Solution for Test: Database Management System - 2 - Question 7

Using the two relationships mother and father gives us a record of a child’s mother, even if we don’t know who the father is; if the ternary connection parent is used, a null value is necessary. In this scenario, binary relationship sets are preferred.

Test: Database Management System - 2 - Question 8

Which of the following is correct according to the technology deployed by DBMS?

Detailed Solution for Test: Database Management System - 2 - Question 8

Pointers are used to access data with great speed and accuracy. Consistency is maintained using locks.

Test: Database Management System - 2 - Question 9

What is the function of the following command?

Delete from r where P;

Detailed Solution for Test: Database Management System - 2 - Question 9

In the command the P gives condition to delete a particular tuple.

Test: Database Management System - 2 - Question 10

Which of the following is the best way to represent the attributes in a large db?

Detailed Solution for Test: Database Management System - 2 - Question 10

Concatenation in DBMS is used to join two or more table fields of the same table or different tables. Example inst sec and student sec.

Test: Database Management System - 2 - Question 11

Which of the following is the subset of SQL commands used to manipulate Oracle Structures, including tables?

Detailed Solution for Test: Database Management System - 2 - Question 11

DDLs are used to define schema and table characters and consist of commands that help in modifying. DML performs the change in the values of the relation.

Test: Database Management System - 2 - Question 12

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

Detailed Solution for Test: Database Management System - 2 - Question 12

The term "DDL" stands for Data Definition Language, used to perform all other essential tasks such as deleting relation and related schemas in defining the structure relation.

Test: Database Management System - 2 - Question 13

The given Query can also be replaced with_______:
SELECT name, course_id  
FROM instructor, teaches  
WHERE instructor_ID= teaches_ID;  

Detailed Solution for Test: Database Management System - 2 - Question 13

Correct option is 2. SELECT name, course_id FROM instructor NATURAL JOIN teaches;

This query uses the NATURAL JOIN clause to join the "instructor" and "teaches" tables based on the common column "instructor_ID=teaches_ID".

Test: Database Management System - 2 - Question 14

What do you mean by one to many relationships?

Detailed Solution for Test: Database Management System - 2 - Question 14

We can understand the "one to many" relationship as a teacher who may have more than one class to attend.

Test: Database Management System - 2 - Question 15

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 ___;  

Detailed Solution for Test: Database Management System - 2 - Question 15

To sort the salary from highest to lowest amount and display the employee's name alphabetically, one can use the "Desc and Asc" in the above-given Query.

Information about Test: Database Management System - 2 Page
In this test you can find the Exam questions for Test: Database Management System - 2 solved & explained in the simplest way possible. Besides giving Questions and answers for Test: Database Management System - 2, EduRev gives you an ample number of Online tests for practice

Top Courses for Computer Science Engineering (CSE)

Download as PDF

Top Courses for Computer Science Engineering (CSE)