Test: Data Models - 2 - Software Development MCQ
15 Questions MCQ Test Database Management System (DBMS) - Test: Data Models - 2
Which of the following data models is used to represent data in the form of a network of interconnected records?
Which of the following data models uses tables to represent data and relationships between them?
| 1 Crore+ students have signed up on EduRev. Have you? Download the App |
In the entity-relationship model, which of the following represents an entity?
In the relational data model, which of the following represents a table column?
Which of the following data models is used to represent data as objects that have properties and behaviors?
What will be the output of the following SQL query?
SELECT COUNT(*) FROM Customers;
Consider the following SQL query:
SELECT FirstName, LastName FROM Employees WHERE Salary > 5000;
What will be the result of the query?
What will be the output of the following code snippet in Python?
my_list = [1, 2, 3, 4, 5]
squared_list = [x * x for x in my_list]
print(squared_list)
Consider the following SQL query:
SELECT AVG(Age) FROM Students;
What does the query return?
What will be the output of the following code snippet in Python?
my_tuple = (1, 2, 3)
print(my_tuple[0])
Consider the following table structure:
Table: Employees
Columns: EmployeeID (INT), Name (VARCHAR), DepartmentID (INT)
Which of the following SQL queries will return the total number of employees in each department?
Consider the following SQL query:
SELECT COUNT(DISTINCT City) FROM Customers;
What does the query return?
What will be the output of the following code snippet in Python?
x = 10
y = 5
if x > y:
print("x is greater than y")
elif x == y:
print("x is equal to y")
else:
print("x is less than y")
Consider the following SQL query:
SELECT Name FROM Customers WHERE Country = 'USA' OR Country = 'Canada';
What will be the result of the query?
What will be the output of the following code snippet in Python?
my_dict = {'name': 'John', 'age': 25, 'city': 'New York'}
print(my_dict['gender'])
|
75 videos|44 docs
|
|
75 videos|44 docs
|
Top Courses for Software Development
Important Questions for Data Models - 2
Data Models - 2 MCQs with Answers
Online Tests for Data Models - 2 Database Management System (DBMS)
|
© EduRev
|
Education Revolution
|
|
