ICT Midterm (1).docx

**[MidTerm ICT]** [\...\...\...\...\....] offer services pertaining to processing transactions, documentation, presentations, inventory management and gathering product information. **e-commerce** Choose right variant. [\...\...\...\...\...\...] as a set of enterprises and organizations engaged in...

**[MidTerm ICT]** [\...\...\...\...\....] offer services pertaining to processing transactions, documentation, presentations, inventory management and gathering product information. **e-commerce** Choose right variant. [\...\...\...\...\...\...] as a set of enterprises and organizations engaged in economic activities related to the design, production and trade of software, computing, communications equipment, consumer electronics and its components, as well as system integration, with the provision of telecommunication and information technology services. **ICT in industry** Choose right variant. [\...\...\...\...\....] are regarded as modern methods and means of communication of people in a normal and professional activities with the help of information technologies for the search, collection, storage, processing and dissemination of information. **ICT** Fill in a gap. [\...\...\...\...\...\...\...] of the discipline is to teach students to gain information and communication competencies that will enable the use of modern information technologies in various areas of professional activity. **Purpose** Choose right variant. Today a lot of business transactions happen through internet and hence called [\...\...\...\...] **e-commerce** Choose right variant. The practical purpose of the ICT course **All answers are correct** Is it true or false? Books and newspapers have made industry wide changes that have had drastic effects **false** Is it true or false? ICT is only about computers. **False** Choose right variant. [\...\...\...\....] used for the formation of an ideology in the field of information and modern information culture, i.e. the ability to interact with information, professional use for receiving, processing, transmitting and storing it. **Discipline "ICT"** Choose right variant. Every service a traditional bank provides is available these days through [\...\...\...\.....] **online service** A definition or format that has been approved by a recognized standards organization or is accepted as a de facto standard by the industry. **Standard** Choose right variant. How many ways that a standard can be developed? **4** Choose right variant. A single vendor controls a large enough share of the market to make its product the market standard. An example of this type would be Microsoft. **De Facto Standard** This statement true or false? Government is the use of electronic communications devices, computers and the Internet to provide public services to citizens and other persons in a country or region. **False** This statement true or false? Software standards are controlled by private and by open, public, or non-profit organizations. **True** Fill in a gap. [\...\...\.....]is a model which would replicate (simulate) the functions of a real system. **computer model** Choose right variant. Purpose of an Open Standard: **All answers are correct** IEEE stand for **Institute of Electrical and Electronic Engineers** Fill in a gap. Purpose of [\...\...\...\...\...\...] the use of the -- single user, instructional use, lab work, will the hardware be reused or is it disposable, who are the users (tech savvy or novice), are there infection control issues if used for patient care, etc. **Hardware** Fill in a gap. [\...\...\....] a group of interested people and organizations agree on a standard specification. It is informal and are mutually agreed on by the participating groups. **Ad hoc method** Fill in a gap: A **computer** is an electronic machine that performs input, processing, storing, and output operations according to programmed instructions to carry out specific tasks. Is it true or false?\ A desktop is intended to be used in a twice location and are widely popular for daily use in workplace and home. **False** Is it true or false?\ Workstation: A powerful, single-user computer. A workstation is like a personal computer, but it has a more powerful microprocessor and, in general, a higher-quality monitor. **True** Is it true or false?\ Personal Computer Assistants (PCAs): It is a handheld computer and popularly known as a palmtop. It has a touch screen and a memory card for storage of data. **False** Is it true or false?\ Specialist application software performs a non-single very specific type of task. **False** Fill in a gap: Specialist application software performs a **single** very specific type of task. Fill in a gap: There are two main types of computer software: **system software** and **application software**. Is it true or false?\ Hardware - the instructions that tell a computer how to carry out a task are referred to as a computer program **False** What are main software categories? **System software and application software** Which of the following DOES NOT belong to the GUI? **Command line** BIOS stand for **Basic Input/Output System** What are type of system software designed to help you monitor and configure settings or your computer system equipment, the operating system, or application software? **Utility** What are small pictures used to represent commands, files or windows? **Icons** What Does not an Operating System Do? **Translates text from one language to other** Which type of software is to manage memory, decide which task to run next, and handle the various types of interrupts that can occur? **Kernel** Try to find right order. **Turn on computer** **Loading BIOS** **Loading the OS kernel into memory** **The operating system itself starts** Match the appropriate file's extension to types **.com** **Executable command MS-DOS** **.txt** **Text file** **.xls** **Microsoft Excel table** **.wav** **Audio file** Select the appropriate type of software with an example **LINUX** **Operating System** **MS Word** **Application** **DOS** **Operating System** **Macros** **User-Written Scripts** Which software refers to system software? **Microsoft Windows** Which software refers to system software? **Mac OS** What type of software does store data in cells formed by the intersection of rows and columns? **Spreadsheets** Is it true or false? One advantage of a software suite is that each application tends to have a similar user interface and it is usually easy to transport data from one application to another. **True** Which software refers to application software? **Adobe Acrobat Reader** What is a type of software that can perform many different related tasks? **Generic software package** Which software refers to application software? **Macromedia Dreamweaver** Which software refers to application software? **Microsoft Word** What type of application is MS PowerPoint? **Generic software package** What type of software does allow a user to take sections of video recordings called clips and trim, splice, cut or arrange them across a timeline? **Video-editing software** Which software refers to application software? **Unix** Which software refers to Integrated Packages? **Microsoft Office** List the levels of computer systems from bottom to up **hardware system, operating system software, application software, and users** What is a sign of copyright protection? **©** Is it true or false? Public domain software is not copyrighted, making it available for use without restriction, except that you cannot apply for a copyright on it. **True** What type of license is priced per user and allows the allocated number of people to use the software at any time? **Multi-user license** Fill in a gap: A Keyboard or a mouse is used to **input data** Fill in a gap: Computer being a versatile machine can process different types of data, so to work with these data types we need different type of devices which can help us to enter such data types in the computer and to receive their outputs like keyboard, mouse, joystick, light pen, printer, speaker, and etc. They are called **peripheral devices.** Fill in a gap: **input devices** are used to give data and instructions to the computer. Try to find the right answers. **Peripheral devices** **are connected to the core computer** **systems via motherboard** **via different connection protocols** **and types** Try to find the right answers: **VGA** **is an old-style graphic display connection type which is the previous version of HDMI and used by monitors, displays, and projections.** **HDMI** **is a popular next-generation connection where monitors, displays, and projections are connections.** **SATA** **is generally used by internet peripheral devices like storage devices, hard disk devices.** Try to find the right answer. **Laser printers are often** **preferred for their quick and** **quiet production and** **and high-quality printouts** The knowledge model embedded in the computer memory is called \... **knowledge base** The logical model of knowledge in a certain subject area is represented by a knowledge base composed of \... **facts** Can a 6-year-old child be a payment card holder? **yes, if the card is issued as additional to the account of the parents (adoptive parents, guardians)** Artificial Intelligence (AI) is \... **branch of computer science, the subject of which is human thinking** Studying goods in a retail store in order to then buy them at a cheaper price in an online store is \... **pricing.** Product by design \... **answers the question of what the buyer actually gets.** AI aims to: **independently build a program of their actions, based on the condition of the problem** Why is a microprocessor (chip) placed on payment cards? **to improve the security of payments** The marketing mix is \... **combined and coordinated use of various marketing tools** The main areas of AI include: **Adaptive learning systems** Choose right variant. What is connect with Human:\ 1) a person who tries to accomplish a goal;\ 2) the end-user;\ 3) the member of an organization **1,2,3** Choose right variant.\ What is connect with Interface:\ 1) A point where two objects meet;\ 2) A point where human can tell the computer what to do;\ 3) A point where the computer displays the requested information **1,2,3** Choose correct answer.\ What is the totality of the effect or effects felt by a user because of interaction with, and the usage context of, a system, device, or product **User experience** Choose right variant. Develop usable products will be **all answers are correct** Is it true or false? Sketching - often used with scenarios, bringing more detail, and a chance to role play **True** Choose right variant.\ What is the development of interaction between people (users) and computers? **HCI** Choose right variant. Why excellence in HCI is important? **All answers are correct** Choose right variant. Find example of ergonomics. **All answers are correct** Is it true or false?\ Good design involves understanding how users interact with computers, and enabling them to do so effectively **true** Is it true or false?\ A prototype is an early sample, model, or release of a product built to test a concept or process. **True** Choose right variant. What is the component of the UX to which system functionally gives the ability to use the system or product to accomplish the goals of work (or play) ? **Usefulness** Is it true or false? Usefulness - the pragmatic component of user experience, including effectiveness, efficiency, productivity, ease-of-use, learnability, retainability, and the pragmatic aspects of user satisfaction. **False** Choose right variant. The user has a list of items to choose from, and can make selections by highlighting one. **Menu Driven Interface** Choose right answer. Is it true or false? The human-computer interface is a communications channel between the user and the computer. **True** Is it true or false? UI is a program interface that takes advantage of the computer\'s graphics capabilities to make the program easier to use. **False** Choose right variant. What is an iterative design process in which designers focus on the users and their needs in each phase of the design process? **User-centered design** Choose right variant. How many types of Interfaces? **4** Choose right variant. Main stages of the user interface design: 1. User Research; 2) Design; 3) Prototyping; 4) Evaluation **1,2,3,4** Choose right variant. What is describes a hardware device or software interface that is easy to use? **User-friendly interface** Is it true or false? Usability inspection is a technique used in user-centered interaction design to evaluate a product by testing it on users. **True** Good and preferred type of saving books and documents? **.pdf** File type for slides? **.pptx**.html file type is used for? **Web pages** Microsoft Excel file type? **.xls** Is it true or false?\ 3D hologram is invisible from all sides, which means the observer can walk around the hologram, enabling an absolutely realistic-looking image to form. **False** Is it true or false?\ Computer-assisted translation (CAT) is the use of software to assist a human translator in the translation process. **False** Is it true or false?\ Robotics is an interdisciplinary research area at the interface of computer science and engineering. **True** Best audio codec for best quality? **.flac** New format of Microsoft Word? **.docx** Sample of video codec file type? **Car.avi** Try to find right answers. **Augmented reality (AR)** **is an interactive experience of a real-world environment** **Artificial intelligence (AI)** **is intelligence demonstrated by machines, unlike the natural intelligence displayed by humans and animals.** **Biometrics** **are body measurements and calculations related to human characteristics.** **Robotics** **is an interdisciplinary research area at the interface of computer science and engineering.** Quantum cryptography is the science of exploiting unquantum mechanical properties to perform cryptographic tasks. **False** Animated file format is **.gif** File type based on flash? **Small Web Format** Course(course*id,sec*id,semester)\ Here the course*id,sec*id and semester are \...\..... and course is a \...\...\..... **Attributes, Relation** A in a table represents a relationship among a set of values. **Row** For each attribute of a relation, there is a set of permitted values, called the of that attribute. **Domain** The term \_ is used to refer to a row. **Tuple** The tuples of the relations can be of \...\...\... order. **Any** The term attribute refers to a \...\...\.... of a table. **Column** A domain is atomic if elements of the domain are considered to be units. **Indivisbile** A relational database consists of a collection of **Tables** Database which is the logical design of the database, and the database \_ which is a snapshot of the data in the database at a given instant in time. **Schema, Instance** Department (dept name, building, budget) and Employee (employee\_id, name, dept name, salary)\ Here the dept name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating \...\..... relations. **Tuple of distinct** The most commonly used operation in relational algebra for projecting a set of tuple from a relation is **Select** Using which language can a user request information from a database? **Query** The \...\...\...\... operator takes the results of two queries and returns only rows that appear in both result sets. **Intersect** The \...\..... operation performs a set union of two "similarly structured" tables **Union** Which one of the following is a procedural language? **Relational algebra** The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match. **Cartesian product** A \...\...\.... is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys**. Schema diagram** The \...\...\.... provides a set of operations that take one or more relations as input and return a relation as an output. **Relational algebra** Student(ID, name, dept name, tot\_cred)\ In this query which attributes form the primary key? **ID** The is the one in which the primary key of one relation is used as a normal attribute in another relation. **Referenced relation** Which one of the following cannot be taken as a primary key? **Street** The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called **Referencing relation** Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record? **Super key** The subset of a super key is a candidate key under what condition? **No proper subset is a super key** A \...\...\.... is a property of the entire relation, rather than of the individual tuples in which each tuple is unique. **Key** A \...\...\... integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation. **Referential** Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key? **ID** Which one of the following attribute can be taken as a primary key? **Id** An attribute in a relation is a foreign key if the \...\...\.... key from one relation is used as an attribute in that relation. **Primary** The basic data type char(n) is a \...\.... length character string and varchar(n) is \...\...\... length character. **Fixed, variable** SELECT \* FROM employee\ What type of statement is this? **DML** Updates that violate \...\...\... are disallowed. **Integrity constraints** An attribute A of datatype varchar(20) has the value "Avi". The attribute B of datatype char(20) has value "Reed". Here attribute A has \...\...\.....spaces and attribute B has \...\...\...spaces. **3, 20** Which one of the following is used to define the structure of the relation, deleting relations and relating schemas? **DDL(Data Definition Langauge)** CREATE TABLE employee (name VARCHAR, id INTEGER)\ What type of statement is this? **DDL** To remove a relation from an SQL database, we use the \...\...\... command. **Drop table** Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database? **DML(Data Manipulation Langauge)** DELETE FROM r; //r - relation\ This command performs which of the following action? **Clear relation entries** INSERT INTO instructor VALUES (10211, 'Samatov', 'Math', 66000);\ What type of statement is this? **DML** SELECT \* FROM employee WHERE salary\>10000 AND dept\_id=101;\ Which of the following fields are displayed as output? **All the field of employee relation** The query given below will not give an error. Which one of the following has to be replaced to get the desired output?\ SELECT ID, name, dept name, salary \* 1.1\ WHERE instructor; **Where** This Query can be replaced by which one of the following?\ SELECT name, course*id\ FROM instructor, teaches\ WHERE instructor*ID= teaches\_ID; **Select name, course\_id from instructor natural join teaches;** In the given query which of the keyword has to be inserted? INSERT INTO employee \...\...\... (1002,Joey,2000); **Values** Here which of the following displays the unique values of the column?\ SELECT \...\.... dept\_name\ FROM instructor; **Distinct** The \...\...\....clause allows us to select only those rows in the result relation of the \...\...\.....clause that satisfy a specified predicate. **Where, from** https://iitu.okudemia.kz/static/realms/iitu/courses/x7Sa/6.5.2.jpg\ This is Employee table.\ Which of the following employee*id will be displayed for the given query?\ SELECT \* FROM employee WHERE employee*id\>1009; **1018** Which of the following statements contains an error? **Select empid where empid = 1009 and lastname = 'GELLER';** The \...\.... clause is used to list the attributes desired in the result of a query. **Select** What type of chart is useful for comparing values over categories? **Column Chart** What is the intersection of a column and a row on a worksheet called? **Cell** Which functionin Excel tells how many numeric entries are there? **COUNT** Statistical calculations and preparation of tables and graphs can be done using **Excel** A features that displays only the data in column (s) according to specified criteria **Filtering** In Excel, Columns are labelled as \_ **A, B, C, etc** Which one is not a Function in MS Excel? **AVG.** Which functionin Excel checks whether a condition is true or not? **IF** Functions in MS Excel must begin with \_ **An Equal Sign** What type of chart will you use to compare performance of two employees? **Line Chart** What type of chart is useful for comparing parts of a whole? **Pie Chart** What type of chart is useful for showing trends or changes over time? **Line Chart** The Greater Than sign (\>) is an example of \...\..... operator. **Logical** The process of arrenging the items of a column in some sequence or order is known as: **Sorting** The \...\.... feature of MS Excel quickly completes a series of data **Auto Fill** What type of chart is good for single series of data? **Pie Chart** What do you use to create a chart? **Chart Wizard** In Excel, Rows are labelled as **1,2,3 etc** How will you graphically represent expenditure in different departments? **Pie Chart** The basic unit of a worksheet into which you enter data in Excel is called a **cell** In Excel, which one denoted a range from B1 through E5 **B1:E5** It is a collection of data that is stored electronically as a series of records in a table. **Database** How many sheets are there, by default, when we create a new Excel file? **3** An Excel file is generally called a / an: **Workbook** What type of chart will you use to compare performance of sales of two products? **Column Chart** **\ **