NTS Past Papers Test (Computer Science) 2019

PAPER PREPARATION 2019 FOR NTS 2019

1. Which of the Keys does not hold uniqueness property?

ANS: Foreign Key

Database development process involve mapping of conceptual data model into?

ANS: Implementation Model

2. An Entity related to itself in an ERD model refers to?

ANS: Recursive relationship

3. In ERD model, the relationship between two entities is represented by a?

ANS: Diamond symbol

4. In hybrid distribution which kind of fragments are stored at only one site?

ANS: Non-critical fragments

5. Customers, cars and parts are examples?

ANS: Entities

6. In an E-R diagram, a rectangle represents a?

ANS: Entity

7. A Person’s name, birthday and social security number are examples of?

ANS: Attributes

8. A technique for physically arranging the records of a file on secondary storage devices is called?

ANS: File Organization

9. A Factor to consider when choosing a file Organization is?

ANS: Fast data retrieval, Security, Efficient storage

10. A Primary key that consists of more than one attribute is called a?

ANS: Composite Key

11. An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a?

ANS: Foreign Key

12. Which field listed below is the most appropriate primary key?

ANS: A person’s Social Security Number

13. An attribute (Or attributes) that uniquely identifies each row in a relation is called?

ANS: Primary key

14. Organizing the database in computer disk storage is done in?

ANS: Physical design

15. In 3NF which form of dependency is removed?

ANS: Transitive

16. The goal of normalization is to?

ANS: Get simple and stable data structure

17. The attribute on the left-hand side of the arrow in a functional dependency is?

ANS: Determinant

NTS Computer Science

18. A rule that states that each foreign key value must match a primary key value in the other relation is called?

ANS: Referential Integrity constraint

19. Different attributes in two different tables having same name referred to as?

ANS: Homonym

20. The Goal of Normalization is to?

ANS: Gen simple and stable data structure

21. A relation is in third normal form if it is in second normal form and?

ANS: Has no transitive dependencies

22. A functional dependency between two or more non-key attributes is called?

ANS: Transitive dependency

23. Microsoft access saves the database with the extension?

ANS: MDB

24. A collection of data that consists of name, address and email of a person is called?

ANS: Record

25. Which of the following view in MS-Access is used to define the structure of table?

ANS: Design view

26. How many table views are available in Microsoft Access?

ANS: Two

27. Which of the following is NOT suitable for an input mask?

ANS: Street address

28. What command is required to actually execute a filter on a table?

ANS: Apply Filter

29. Find and Replace Command is found in?

ANS: Edit Menu

30. Which format property displays test in uppercase?

ANS: Greater than sign

31. Which field type can by indexed?

ANS: Number

32. Why are validation rules used in a database?

ANS: To make sure there is no incorrect data entered & to avoid typographical errors

33. A Program whose job is to store and retrieve user data in the database is called?

ANS: Database Management System

34. The description of structure and organization of data in a database is contained in?

ANS: Data Dictionary

35. Information including a table’s name, field names and data types is stored in?

ANS: Data Dictionary

36. A request for information from a database in database terminology is called?

ANS: Query

37. A printed or onscreen display of data or information in the database is called a?

ANS: Report

38. The name for software to build reports that summarize data form 3 database is?

ANS: Report Generator

39. A collection of data that includes name address, phone number etc. of a person is?

ANS: Record

40. SQL is used for?

ANS: Data definition and manipulation

41. Create command is used to create?

ANS: Table

42. The foreign key is found in?

ANS: Dependent table

43. A two-dimensional table of data is called a?

ANS: Relation

44. Insert Command is used to insert?

ANS: New Record

45. A Collection of Raw facts and figure is called?

ANS: Data

46. The processed data is called?

ANS: Information

47. Which of the following is an example of a database?

ANS: Phone Book, Library catalog and Student records

48. Which of the following data model is more flexible?

ANS: Indexed Sequential File

49. SQL is a?

ANS: Structured Language

50. Which of the following may be a temporary file?

ANS: Transaction File

nts,nts jobs, nts papers, nts past papers

NTS Papers Preparation

51. The Type of files from usage point of view include?

ANS: Master file, Transaction file and Backup file

52. A database in an organized collection of ______ related data?

ANS: Logically

53. The most commonly used database model in current database development is?

ANS: Relational

54. Which of the following data model has general shape of an organization chart?

ANS: Hierarchical Data Model

55. Texts are entered in?

ANS: Cells

56. Shortcuts for select entire worksheet is?

ANS: Ctrl + A

57. Shortcut Key for format Cell is?

ANS: Ctrl + 1

58. To move to the next worksheet in a workbook press?

ANS: Ctrl + page down

59. To Move to the previous worksheet in a workbook press

ANS: Ctrl + page up

60. Web Page option exist in?

ANS: File Manu

61. The function that is used to get date and time simultaneously?

ANS: Now ()

62. To move to the next worksheet in a workbook press?

ANS: Ctrl + Page down

63. To combine two or more cells into one is called?

ANS: Merge

64. The Function that is used to count the number of entries in the given range is Called?

ANS: Count

65. Shortcut key to open old workbook is?

ANS: Ctrl + F6

66. A Computer can be linked to the Internet through?

ANS: DSL, A Phone Line Modem, Cable Modem

67. Which of the following is used to find information on World Wide Web?

ANS: Search Engine

68. The length of IP Address is?

ANS: 32 Bits

69. The four numbers in an IP Address are called?

ANS: Octets

70. Junk mail is called?

ANS: Spam

71. Text are entered in?

ANS: Cells

72. Which is an Email client?

ANS: Outlook Express

73. Which of the protocol is used to access Web Pages on World Wide Web?

ANS: HTTP

MY STEEMIT BLOG LINK BELOW

https://steemit.com/@sidhar

Milan Tomic

Hi. I’m Designer of Blog Magic. I’m CEO/Founder of ThemeXpose. I’m Creative Art Director, Web Designer, UI/UX Designer, Interaction Designer, Industrial Designer, Web Developer, Business Enthusiast, StartUp Enthusiast, Speaker, Writer and Photographer. Inspired to make things looks better.