Database Introduction MCQ Quiz in मल्याळम - Objective Question with Answer for Database Introduction - സൗജന്യ PDF ഡൗൺലോഡ് ചെയ്യുക

​CRM database programs can be used as standalone software, incorporated with existing databases, such as Outlook or Excel, or a combination of the two.

• CRM, short for Customer Relationship Management, is software that helps businesses foster strong customer relationships and improve sales and retention by having quality conversations with prospects and customers.
• CRM, or customer relationship management, employs databases that are used to automatically collect, store, and analyze all the information that a company collects about its customers, whether it’s a post on a social media account, a purchase made at an online store, a help desk call, or participation in a webinar. '
• The CRM database then makes all of this information available in one customizable dashboard.
•  With CRM, all of the data created about customers across disparate tools, accounts, and systems are automatically stored in the database and easily accessible to everyone on the team.

• List of Examples of CRM
  • Inbound CRM: HubSpot CRM.
  • General CRM: Salesforce CRM.
  • Fully Integrated CRM: Freshworks CRM.
  • Operational CRM: NetSuite CRM.
  • Sales CRM: Pipedrive.

Key Points

• Degree : The Number of Attributes (Column) in a relation (Table)
• Cardinality: The number of tuples (rows) in a relation (table)
• Domain or Range: It is a pool of values from which actual value is present in a given We can say that  The values that can be assigned to attributes. For example, a student's name cannot be a numeric value. It has to be alphabetic

Example: Let's suppose we have a relation name Student

• Degree : 3 (Because 3 columns in the table)
• Cardinality: 4 (Because 4 rows in the table)
• Domain or Range: In the age attribute cannot have a negative number. So the Domain of the Age attribute is a Positive integer only.

Statement 1: Correct

Any relation with two attributes will always in BCNF

Example:

Relation R = {x, y} non trivial FD’s of this relation is x - > y and y - > x and these both FD’s are in BCNF so this statement is true.

Statement 2: Incorrect

 It is not always possible to decompose a table in BCNF and preserve FD’s and lossless decomposition will always be possible in BCNF.

Example:

XY - > Z and Z - > Y cannot be decomposed in BCNF

Statement 3: Correct

Lossless, dependency - preserving decomposition into 3NF is always possible this statement is true.

Statement 4: correct

BCNF is stricter form of normalization than 3NF because it eliminates the second condition of 3NF.

The correct answer is option 3.

Concept:

Statement 1: Each attribute in relation has a unique name.

True, Attributes in relational databases are the defining characteristics or properties that describe all entries belonging to a specific category and are applied to all cells in a column. Each attribute or column in relation has a unique name. The rows, on the other hand, are referred to as tuples, and they contain data sets that have been applied to a single entity in order to uniquely identify each item.

Statement 2:  No attribute can have many data values in one tuple.

True, No attribute can have many data values in one tuple because if an attribute can store multiple values then that database can not fails normalization. For example, A student relation has some attributes like student id, student name, student phone number and etc. An attribute student phone number can not store more than one contact number. 

Hence the correct answer is Both statement 1 and statement 2.

Therefore, a customer database is an organized collection of detailed information about individual customers or prospects that is accessible, actionable and current for marketing purposes such as lead generation and others.

The correct answer is Queries.

Key Points

• To retrieve specific financial information from a complex database, the user has to set the Queries. 
• ​​Queries can perform many different functions in a database.
  • Their most common function is to retrieve specific data from the tables.
  • The data is usually spread across several tables, and queries allow us to view it in a single datasheet.
  • Certain queries are "updateable," meaning we can edit the data in the underlying tables via the query datasheet.
• Queries come in two basic varieties-
  • select queries
  • action queries
• A select query simply retrieves the data and makes it available for use.
  • The results of the query can be viewed on the screen, can be printed, or copied to the clipboard.
  • The output of the query can be used as the record source for a form or report.
• An action query, as the name implies, performs a task with the data.
  • Action queries can be used to create new tables, add data to existing tables, update data, or delete data.

The correct answer is option 3.

Concept:

Data Base Management:

A database is a grouping of information that is logically related and is set up such that it is simple to access, administer, and change. A database management system often controls how databases are accessed electronically from a computer system (DBMS).

Explanation:

The person in charge of administering databases, including database security, access control, backup, and disaster recovery, is known as a database administrator (DBA).

The information technician in charge of planning, carrying out, and overseeing all operations involved in successfully maintaining a database environment is known as a database administrator (DBA). A DBA ensures that a company's databases and related applications run effectively and functionally.

Hence the correct answer is Data base administrator.

The correct answer is option 3.

Concept:

Statement 1: Raw data is data that has not been processed for use. It is in the form of numbers / Text / Images.

True, Raw data, also known as primary data, is data collected from a source. Raw data is data that has not been processed for use. It is in the form of numbers / Text / Images.

Statement 2: Information is processed, organized, and structured data. It is in the form of a table or chart or text.

True, Information that has been processed, organized and structured. It puts facts into perspective and facilitates decision-making.  It is in the form of a table or chart or text.

Example:

A single customer’s sale at a restaurant is data – this becomes information when the business is able to identify the most popular or least popular dish.

Hence the correct answer is Both statement 1 and statement 2 are true.

The correct option is (3)

Concept:-

A Web Page can also be treated as a file. All the information on the internet is presented to the user as a document or more popularly known as a Web Page. All these Web Pages are linked to each other or even to sections within a Web Page and these links are known as Hyper Links.

Key Points​

• Downloading a web page as a file is the simplest built-in way for Chrome users on the desktop to save a web page for offline reading.
• Text content, code, stylesheets, and media assets are among the files that make up a website.
• A web page is a simple document displayed by a browser. HTML is the programming language that these documents are written in.
• A web page is regularly used to provide information to readers, often using images or videos to help highlight key points.

Additional InformationMemory:- A memory-mapped file, as opposed to one that is written to memory and subsequently flushed to a disc, is one that is partially or totally mapped in memory (RAM).

Disk:- Unless it is write-protected or locked, a disc is a magnetic medium that is rewritable by default.

Web Browser:- With a web browser, you can go anywhere on the internet. It's also known as a "browser," which is software that enables users to find, access, display, and view websites.

The correct answer is option 3.

Concept:

Data Storage:

Data storage is the process of storing data on storage devices so that data can be retrieved later. Large amounts of data are being created at an alarming rate these days. As a result, storing data has become a difficult undertaking. However, as the cost of digital storage devices has decreased, this work has become easier.

There are numerous digital storage devices available in the market like,

• Hard Disk Drive (HDD),
• Solid State Drive (SSD),
• CD/DVD,
• Tape Drive,
• Pen Drive,
• Memory Card, etc.

Hence the correct answer is Paper.