40 Short Questions DBMS- 8 Marks - SEE COMPUTER SCIENCE 2080

 

40 Short Questions DBMS- 8  Marks - SEE COMPUTER SCIENCE 2080

1.          Define RDBMS.

2.          Define MS Access.

3.          What is primary key?

4.          What is foreign key?

5.          What is data sorting?

6.          Define filtering.

7.          What is data processing.

8.          What are field properties?

9.          What is table in Access?

10.          What is form in Access?

11.          What is query in Access?

12.          What is report in Access?

13.          What is select query?

14.          What is action query?

15.          Why caption field property is used in MS-Access?

16.          What are validation text and validation rule?

17.          Write any four importance of table.

18.          Mention any four uses of form.

19.          Mention any four uses of report.

20.      List any four advantages of query.

21.      List any two major differences between forms and reports.

22.      What type of work is done in MS-Access using form and query object.

23.      Differentiate between select query and update query.

24.      Differentiate between Select query and Action query.

25.      Write the difference between data and information.

26.      Differentiate between Primary key and Foreign key with example.

27.      Differentiate between fields and records with an examples.

28.      Differentiate between text and memo data type.

29.      Mention the functions of any four data types of MS-Access.

30.      Write any four advantages of DBMS [Computerized Database]

31.      Write any four advantages of MS-Access.

32.      List any three advantages of primary key.

33.      List any two advantages of sorting.

34.      Why is it important to specify primary key in database?

35.      What do you understand by Data Redundancy? How can it reduced in data redundancy.

36.      Why table is called the building block of database?

37.      What is the purpose of database?

38.      List out the data type used for the following data in MS Access

Student' Name, Students' Roll Number, Address, Fee paid

39.      Identify a record, field and value from the following table structure.

Symbol No.	Name	Marks
00100202S	Aarambha Gharti	85
00100203T	Subash Rayamajhi	91

 

40.      While designing table structure which data types are suitable to store information about teacher’s name, address, salary and date of birth

Write a similarity and a difference between Number field type and Currency filed type.

80 Short Questions Fundamentals - 10 Marks - SEE COMPUTER SCIENCE 2080

80 Short Questions Fundamentals  - 10 Marks - SEE COMPUTER SCIENCE 2080

 1.    Differentiate between bounded media and unbounded media.

2.    What is data communication? Write the basic elements of data communication.

3.    Distinguish between STP and UTP

4.    Define mode of communication

5.    Explain transmission media with its types.

6.    Define e-mail with some advantages

7.    What is computer network? Enlist any two advantages of it.[8]

8.    Write any two disadvantages of computer network.

9.    "Computer network reduces the operation cost". Justify the statement

10.          What is network topology? List any two types of network topology.

11.          Differentiate between peer to peer and client-server network with figure.

12.          Differentiate between LAN and WAN.

13.          What is the difference between Switch and Router?

14.          Define Network Architecture. List out its types.

15.          Define two major uses of internet.

16.          Write down the advantages of internet.

17.          What is star topology? Write its merits and demerits.

18.          Give any two advantage of E-mail over traditional mail

19.          Write advantages and disadvantages of bus topology

20.          Classify computer network on the basis of geographical location and explain it.

21.          Explain about star topology with the help of diagram

22.          What is firewall? Write its any two uses.

23.          What is e-commerce. Write any two benefits of e-commerce.

24.          Write any two disadvantages of e-commerce

25.          Give two differences between E-Commerce and Traditional Commerce

26.          List any two E- commerce companies/sites in Nepal.

27.          Share your thoughts about cyberbullying.

28.          What is Online Payment? Write any four forms of e-payment in Nepal.

29.          What are security threats? Write down any four possible threats to computer security

30.          What is cyber law? Why is cyber law needed?

31.          Write two examples of cybercrime

32.          List any two objectives of formulating cyber law in Nepal.

33.          What is biometric verification

34.          What is cyber-crime? Explain any one of them

35.          What is computer ethics? Write any two of them.

36.          Write any four commandments of computer ethics

37.          Write any two advantages and disadvantages of social media.

38.          Write opportunities and threats in social media

39.          What is digital citizenship? List out the major themes of digital citizenship

40.          What is digital footprint? Write any two tips to maintain digital reputation

41.          What is the importance of ICT in this digital society? Explain.

42.          Why is ethics important in information technology

43.          What is Biometric? Write any four areas where it is used

44.          List the types of E-governance. Describe any one of them

45.          List some points about how we can protect our data.

46.          What is software security? Write any two measures of software security.

47.          What is computer security?

48.          Give some examples of computer security

49.          What is hardware security ? Write any two hardware security measures

50.          Write any two measures to protect hardware and explain

51.          Write the role of Ups in hardware security

52.          What is antivirus software? Name any two popular antivirus software.

53.          How antivirus helps to secure computer software

54.          What is firewall in computer. Write its type.

55.          Write ant two symptoms of computer virus

56.          What is computer virus? Give some examples

57.          What is password? Write any two importance of password protection.

58.          What is password Policy? Write any two important criteria for creating strong password

59.          What is power protection device? Write its role in computer security

60.          What is Cryptography? How encryption helps in data protection

61.          What is m-commerce? Write any two important services.

62.          How password policy protects computer software and data? Explain

63.          Write any four examples of M-Commerce.

64.          What is e-banking? Write any two uses of it.

65.          How can public get benefited from the e-governance services?

66.          Define online payment with example

67.          Write some different modes of electronic payment.

68.          What is IoT? Write any two importance of it.

69.          How does IOT help in our daily life? Explain.

70.          What is an online payment (electronic payment)? Make a list most common payment platforms used in Nepal.

71.          What is E-Learning? Write some examples of it

72.          Write some challenges of IoT.

73.          What is virtual reality? Write any two areas where virtual reality are used

74.          Define artificial intelligence (AI). Write any two uses of AI.

75.          "Al is for the aid of people not their against. Explain.

76.          Artificial Intelligence is threat to humans". Give your opinion

77.          What are the advantages of cloud computing?

78.          Define cloud computing? Name any two services of it.

79.          What is e-governance? Write any two advantages of e- governance.

80.          List the types of E-governance. Describe any one of them