Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

DATABASE| 2026 MUST KNOW QUESTIONS, Exams of Nursing

Texas State UniversityNursing

DATABASE| 2026 MUST KNOW QUESTIONS DATABASE| 2026 MUST KNOW QUESTIONS

Typology: Exams

2025/2026

Available from 06/21/2026

christine-boyle
christine-boyle 🇺🇸

3.6

(7)

3.9K documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
DATABASE| 2026 MUST KNOW
QUESTIONS
What is a database? - ANSWER-A database is a structured set of data held in a
computer, especially one that is accessible in various ways.
What is a field? - ANSWER-A field in a record that holds unique data which identifies
that record from all the other records in the file or database.
What is a record? - ANSWER-A complete row of information about a person or thing.
What is a flat file? - ANSWER-A database that holds all the information in one file.
What is a relational database? - ANSWER-A database comprised of linked tables.
A relational database allows you to save space.
[True] / [False] - ANSWER-True.
A relational database causes data redundancy by making you repeat data entries.
[True] / [False] - ANSWER-False.
A relational database helps you avoid making data entry mistakes.
[True] / [False] - ANSWER-True.
Database - ANSWER-Contains information in fields and columns
Filing Cabinet - ANSWER-Is an old database
Data Field - ANSWER-Information about one specific thing. Example 'Artist' or
'Surname'
Record - ANSWER-A ______________________ is a collection of fields, possibly of
different data types.
What is a FLAT FILE? - ANSWER-A file having no internal structure. No other file is
more important than the other.
Relational Database - ANSWER-A database structured to recognize relations between
stored items of information.
A database allows you to save space? TRUE or FALSE? - ANSWER-True
To make a search better. - ANSWER-Add more information about the person you are
looking for.
pf3
pf4
pf5

Partial preview of the text

Download DATABASE| 2026 MUST KNOW QUESTIONS and more Exams Nursing in PDF only on Docsity!

DATABASE| 2026 MUST KNOW

QUESTIONS

What is a database? - ANSWER-A database is a structured set of data held in a computer, especially one that is accessible in various ways. What is a field? - ANSWER-A field in a record that holds unique data which identifies that record from all the other records in the file or database. What is a record? - ANSWER-A complete row of information about a person or thing. What is a flat file? - ANSWER-A database that holds all the information in one file. What is a relational database? - ANSWER-A database comprised of linked tables. A relational database allows you to save space. [True] / [False] - ANSWER-True. A relational database causes data redundancy by making you repeat data entries. [True] / [False] - ANSWER-False. A relational database helps you avoid making data entry mistakes. [True] / [False] - ANSWER-True. Database - ANSWER-Contains information in fields and columns Filing Cabinet - ANSWER-Is an old database Data Field - ANSWER-Information about one specific thing. Example 'Artist' or 'Surname' Record - ANSWER-A ______________________ is a collection of fields, possibly of different data types. What is a FLAT FILE? - ANSWER-A file having no internal structure. No other file is more important than the other. Relational Database - ANSWER-A database structured to recognize relations between stored items of information. A database allows you to save space? TRUE or FALSE? - ANSWER-True To make a search better. - ANSWER-Add more information about the person you are looking for.

Goal - ANSWER-Old English word meaning Jail File - ANSWER-Something containing data stored on a computer. DBMS - ANSWER-Database management system A Record Row - ANSWER-Goes across a database An example of a database - ANSWER-iTunes An example of a non-digital database - ANSWER-The Yellow pages Database - ANSWER-maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Database management system (DBMS) - ANSWER-creates, reads, updates, and deletes data in a database while controlling access and security Relational database model - ANSWER-a type of database that stores its information in the form of logically-related two-dimensional tables process model - ANSWER-formal way of representing how a business operates by looking at the system itself versus users. Ultimately, guides what code must do Data model - ANSWER-The logical data structure that details the relationships among data elements using graphics or pictures Entity Relationship (ER) diagram - ANSWER-consists of entities, attributes and relationships Entity - ANSWER-Also called a Table (in MSAccess), stores information about a person, place, thing, transaction, or event Instance - ANSWER-the representation of a particular entity, i.e. STUDENT(John Smith, 123-45-6789) Entity Examples - ANSWER-Wine Club Member, employee, wine, customer, product Attributes - ANSWER-data elements associated with an entity ( Customer - name, address, number... Item - item number, price, genre) There are several types of attributes including - ANSWER-Stored versus derived (DOB- 12-Jan-1987 vs. current age), Null-valued (no home phone number), Simple versus composite, single-valued versus multi-valued

possible. Several types of outer joins exist. In a left outer join, a binary operation, rows from the first relation that do not have matching values in the shared column of the second relation are included in the result relation. Right outer joins keep every unmatched row in the second relation in the result relation. In regard to serializability, which of the following is true? - ANSWER-When determining serializability, you must consider the following: If concurrent transactions only read data, no conflict exists and the order of execution is not significant. If concurrent transactions read or write entirely different data structures, no conflict exists and the order of execution is not significant. If concurrent transactions read or write the same data structures, the order of execution is significant. Inner Join - ANSWER-An inner join only returns those records that have "matches" in both tables. So for every record returned in T1 - you will also get the record linked by the foreign key in T2. In programming logic - think in terms of AND. Outer Join - ANSWER-An outer join is the inverse of the inner join. It only returns those records not in T1 and T2. "Give me the records that DON'T have a match." In programming logic - think in terms of NOT AND. Left Join - ANSWER-A left join returns all the records in the "left" table (T1) whether they have a match in the right table or not. If, however, they do have a match in the right table - give me the "matching" data from the right table as well. If not - fill in the holes with null. LEFT OUTER JOIN - ANSWER-A left outer join combines the ideas behind a left join and an outer join. Basically - if you use a left outer join you will get the records in the left table that DO NOT have a match in the right table. Theta JOIN - ANSWER-A theta join is the Cartesian product of the 2 tables and not normally what people are looking for - but what they sometimes get by mistake. How many of us have written a join similar to this only to get way more then we were ever expecting. Entity - ANSWER- Field - ANSWER-Data and information of someone or something. Record - ANSWER-All information of someone or something in a line. Flat File - ANSWER-A data that contains information without structures. Relational Database - ANSWER-Data that are organised formally for many ways.

Advantage of Relational Database - ANSWER-Data is only stored once so that storage are easily efficient, if the user wants to delete then it is easy and links are easy. Primary Key - ANSWER-Unique number that helps to tell each record apart. Data Type of a Primary Key - ANSWER-Auto Number- so the computer automatically generates the number. Data Types - ANSWER-1. Text- Letters, numbers, punctuation.

  1. Number- Numbers only. 3.Date/Time- Dates or times. Validation Check - ANSWER-The way the computer checks if the data that is entered is sensible and reasonable. Presence Check - ANSWER-See if data has been properly entered. For example are letters and numbers. Length Check - ANSWER-Check the data if it has the same number open. This are like passwords. Range Check - ANSWER-Check that the value entered is determined. Type Check - ANSWER-Make sure the data is correct. Check Digit - ANSWER-Allows a number to be checked. For example is a calculator. Format Check - ANSWER-Make sure a data is in correct format. This is like postcodes. Lookup Check - ANSWER-This compares a data like an address. Verification - ANSWER-Checks for human error so that it makes sure the user did not get a typo. For example: passwords and captcha.