MCQ Test: Database Management System - 2 - JKSSB Patwari MCQ

In the above-given Query, the "%" (like) operator will be used, which is generally used while searching for a certain pattern in the strings. It represents the single and multiple characters. In this case, it used with "Where "louse to select the "dept_name" that contains the Computer Since as its ending string. To understand it more clearly, consider the following syntax:

Syntax

SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;

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.

In order to define the overall design of the database, generally, the schema is used. Therefore the correct answer is C.

The "COUNT" keyword is used to find the total number of values inside a column. So whenever a user wants to find the total values in a column, he can use the keyword "COUNT".

A computer security protocol for logging-in can be considered as the procedure component of an information system. Therefore the correct answer is C.

In the relation model, the relations are also referred to as the tables because the relations are considered as the technical name of the table. So the correct answer is D.

The term "ODBC" refers to the Open Database Connectivity that is a SQL based programming interface introduced by Microsoft.

In database management systems, relation calculus is a type of non-procedural query language that describes what data needs to be retrieved. However, it does not explain how to retrieve the data.

The collection of data (or information) stored in a database at a particular moment is known as the instance of the database. Therefore the correct answer is B.

The Mata Data refers to the type of data that describes the other data or information.

A general file or document is nothing more than a sequence of bytes that contains information like file name, file size, and date & time when the document was created or modified.

To understand it in more details, consider the following example:

For a common music file, the metadata may include the singer's name, the year it was released, and the lyrics, etc.

The hierarchical model organizes data in a tree-like structure, where each record has a single parent but can have multiple children. It represents a one-to-many relationship and was widely used in early database systems.

The third normal form (3NF) ensures that every non-key attribute in a table is fully functionally dependent on the primary key and eliminates transitive dependencies. It is an important step in database normalization.

A foreign key is a column in a table that establishes a relationship with the primary key of another table. It ensures referential integrity and enforces data consistency and integrity across related tables.

The INSERT command in SQL is used to add new rows or records to an existing table. It allows you to specify the values for each column or insert data from another table.

Cassandra is an example of a NoSQL database management system. It is designed to handle large amounts of data across multiple commodity servers and provides high availability and scalability.

The INNER JOIN operation in SQL combines rows from two tables based on a matching condition and returns only the matching rows. Rows that do not have a match in the other table are excluded from the result.

Locking is a concurrency control technique used to ensure that transactions do not interfere with each other. It involves acquiring and releasing locks on database objects to enforce mutual exclusion and preserve data integrity.

Database indexes are data structures that improve the performance of data retrieval operations. They allow for faster access to specific data by creating a separate structure that references the indexed data.

MongoDB is a NoSQL database management system that is designed to handle large amounts of structured and unstructured data. It provides flexibility and scalability for storing and retrieving data.

A full outer join combines the result sets of both the left and right tables and returns all rows from both tables. It fills in any missing values with NULL where there is no match.