Test: Data Models - 1 - Software Development MCQ

Portability is not a characteristic of a database. Other characteristics like redundancy control, consistency, and flexibility are commonly associated with databases.

A primary key is a column or a set of columns that uniquely identifies each row in a table. It ensures data integrity and provides a way to uniquely identify records.

The object-oriented data model represents data as a collection of objects that have attributes and methods. It is used in object-oriented programming languages like Java and C++.

The structural level is not a level of data abstraction in a DBMS. The three levels of data abstraction are physical level, logical level, and conceptual level.

The hierarchical data model offers simplicity and ease of understanding as it represents data in a tree-like structure with parent-child relationships. However, it lacks flexibility compared to the relational data model.

The code squares each number in the list 'numbers' using a list comprehension and stores the squared values in the list 'squared_numbers'. The output will be [1, 4, 9, 16, 25].

The code uses list slicing to extract elements from index 1 to 3 (excluding 3) from the list 'fruits'. The output will be ['banana', 'cherry'].

The code defines a function named 'greet' that takes a parameter 'name' and prints a greeting message. The function is then called with the argument 'Alice'. The output will be "Hello, Alice!".

The code uses a list comprehension to filter even numbers from the list 'numbers' and stores them in the list 'even_numbers'. The output will be [2, 4].

The code squares each even number in the list 'numbers' using a list comprehension and stores the squared values in the list 'squared_numbers'. The output will be [4, 16].

The 'map' function applies the lambda function to each element in the 'numbers' list, doubling each value. The 'list' function is used to convert the map object to a list. The output will be [2, 4, 6, 8, 10].

The function 'add_numbers' takes two arguments and returns their sum. The function is called with arguments 2 and 3, resulting in a sum of 5.

The function 'multiply_numbers' takes two arguments, 'a' and 'b', with 'b' having a default value of 2. When only one argument, 3, is passed to the function, 'a' is set to 3 and 'b' takes its default value. The result is 3 multiplied by 2, which is 6.

The function 'greet' takes two arguments, 'name' and 'greeting', with 'greeting' having a default value of "Hello". When the function is called with arguments "Alice" and "Hi", it overrides the default value. The output will be "Hi, Alice!".

The function 'calculate_sum' uses the '*numbers' syntax to accept any number of arguments and calculates their sum using the 'sum' function. The arguments 1, 2, 3, 4, and 5 are passed, resulting in a sum of 15.