What is a database?, A single piece of information about a person., A printed book containing information., A collection of organized data stored on a computer., A specialized calculator for math problems., What is a 'record' in a database?, The title of the database file., A specific category of information like 'Surname' or ' Gender '., One single item or person and all the information linked to them., The software used to open the file., Which of the following best describes a 'field'?, A row containing all details about one object., A type of animal in the zoo database., The entire collection of data., A part of the information in a record, such as 'Date of Birth'., What does DBMS stand for?, Database Management System, Data Basic Management Source, Data Backup Main Server, Digital Base Model System, Which of these is a disadvantage of keeping hard copy (paper) data?, It is too expensive to buy paper., It requires electricity to read., It cannot be read by humans., It can be easily lost or damaged., What is the term for a request for information from a database?, Query, Cell, Record, Field, What does a 'filter' do in a database table?, It permanently deletes incorrect data., It changes the font color of all text., It sorts the data from A to Z as Ascending and Z to A as Descending., It shows only the parts of the table you selected and hides the rest., If you want to organize a list of names alphabetically from A to Z, which function should you use?, Filter, Query, Sort, Collate, Which data type would be best for storing a 'Date of birth'?, Text, Date, Alphanumeric, Number, What is an 'alphanumeric' data type?, A field containing only images., A mix of letters and numbers., A field containing only numbers., A field containing only symbols., Why is it important to 'Format as Table' in spreadsheet software?, It allows you to use sort and filter functions correctly., It prevents anyone else from opening the file., It creates a backup of your file., It automatically corrects spelling mistakes., What does it mean to 'collate' data?, To combine information onto a new sheet to show all data at once., To separate confusion from an old blanket to hide some dust at home., To delete old records., To add color to the table headers., In a spreadsheet table, what indicates that a filter has been applied to a column?, A symbol that looks like a star disappears from the menu button panel., The column disappears., A symbol that looks like a filter (funnel) appears on the menu button., The cell becomes bold., What is a 'complex filter'?, A filter that sets two or more criteria., A filter that uses only one criterion., A filter that deletes data., A filter that requires a password., Which of the following is an example of a 'Number' data type field?, First Name, Student ID, Date of Birth, Bus Number (e.g., 18A), Why are spreadsheets often NOT the best choice for storing large school databases?, They are normally accessed by many users and include permission controls., They cannot calculate numbers., They do not have rows and columns., They are normally accessed by one user and lack specific permission levels., What is 'conditional filtering'?, Deleting rows that are empty., Using operators to show results that meet a certain criteria., Ignoring operators to hide results that do not match any criteria., Filtering that happens automatically every hour., In the animal database example, 'Lives in large groups' would be an example of a:, Database, Record, Query, Field, What happens if you sort a table without activating the table function properly?, The data stays organized because all columns sort together correctly., The font size changes to size 12., The data becomes mixed up because only one column sorts., The file becomes read-only., Which of these is a database permission level?, Print-always, Write-often, See-never, Read-only, In the school database example, who would likely have access to ALL data?, A student in Year 6., A teacher/ parent in Year 6., The school office staff / Administrator., A parent of a Year 1 student., If you want to find all female students in 'Juno' house who take the number 7 bus, what are you performing?, A complex query, A deletion, A simple sort, A format change, Which software is mentioned as an example of a spreadsheet program?, Microsoft Word, PowerPoint, Microsoft Excel, Adobe Photoshop, What is the main reason permissions are used in a school database?, To stop students from playing games., To allow access and prevent restrictions on viewing or editing information., To ensure only authorized people can see or change specific data., To make the computer run faster., Which of these is an example of a 'text' data type?, Surname (e.g., Chung), 109877, 01/10/2014, 18A

Unit-1 Databases

さんの投稿です
印刷
埋め込み

リーダーボード

表示スタイル

オプション

テンプレートを切り替える

自動保存: を復元しますか?