Sonali & Janata Bank Assistant Database Administrator September 2021 – Preliminary (AUST) question & solution

MCQ (93)

1. A database can be hacked by-
   1. a) Exploiting weak passwords
   2. b) SQL Injection
   3. c) Delivering a Trojan
   4. d) All of the above
2. Which of the following is not a DDL command?
   1. a) Create
   2. b) Drop
   3. c) Alter
   4. d) Update
3. Business Intelligence (BI) reporting analyses can be performed using ________.
   1. a) standard SQL only
   2. b) extensions to SQL only
   3. c) OLAP only
   4. d) Both standard SQL and extensions to SQL
4. The SQL statement SELECT ROUND (45.926, -1) FROM DUAL;
   1. a) is illegal
   2. b) prints garbage
   3. c) prints 045.926
   4. d) prints 50
5. Assume that you want to improve database performance and are willing to see the amount of swap space. Which command can you use in a LINUX…
   1. a) lsps -a
   2. b) swapinfo -m
   3. c) swapon -s
   4. d) swap -l and swap -s
6. In Oracle, to change the DB_BLOCK_SIZE parameter, you need to-
   1. a) Re-create the database
   2. b) Alter the database
   3. c) Move database to temporary
   4. d) Update the table types of the database
7. Which of the following controls the execution of application program and UI in two tier client/server architecture?
   1. a) Modulation side
   2. b) Server side
   3. c) Host side
   4. d) None of the above
8. Which one of the following is a failure to a system?
   1. a) Boot crash
   2. b) Read failure
   3. c) Transaction failure
   4. d) All of the mentioned
9. Referential integrity in a DBMS is a form of-
   1. a) Foreign key
   2. b) Primary key
   3. c) Assertion
   4. d) Referential constraint
10. How can you roll back a committed transaction in any DBMS?
    1. a) Using SQL rollback commands
    2. b) Restoring the data from backups
    3. c) Run the transaction again in reverse order
    4. d) All of the Above
11. In a schema with attributes A, B, C, D and F the following set of functional dependencies is given A => B, A=>C, CD=> E, B=>D, E=>A. Which…
    1. a) CD=>AC
    2. b) BD=>CD
    3. c) BC=>CD
    4. d) AC=>BC
12. Let E1 and E2 be two entities in an E/R diagram with simple single-valued attributes. R1 and R2 are two relationships between E1 and E2…
    1. a) 2
    2. b) 3
    3. c) 4
    4. d) 5
13. LGWR process writes information into-
    1. a) Database files
    2. b) Control Files
    3. c) Redo Log Files
    4. d) All of the above
14. Which of the following is an appropriate category of system maintenance performed for the purpose of modifying the system to cope with…
    1. a) Preventive maintenance
    2. b) Corrective maintenance
    3. c) Adaptive maintenance
    4. d) Perfective maintenance
15. What are the different events in Triggers?
    1. a) Define, Create
    2. b) Drop, Comment
    3. c) Insert, Update, Delete
    4. d) Select, Commit
16. XSLT processors evaluate each statement in the context of the match that has been made. That is, XSLT processors are:
    1. a) Context oriented
    2. b) Procedural oriented
    3. c) Object oriented
    4. d) Relational oriented
17. The packaged procedure that makes data in a form permanent in the Database is-
    1. a) Post
    2. b) Post form
    3. c) Commit form
    4. d) None of the above
18. When three or more AND & OR conditions are combined, it is easier to use the SQL keyword(s):
    1. a) LIKE only
    2. b) IN only
    3. c) NOT IN only
    4. d) Both IN and NOT IN
19. How to select all data from the student table where the name starts with the letter 'r'?
    1. a) SELECT * FROM student WHERE name LIKE 'r%';
    2. b) SELECT * FROM student WHERE name LIKE '%r%';
    3. c) SELECT * FROM student WHERE name LIKE '%r';
    4. d) SELECT * FROM student WHERE name LIKE '_r%';
20. Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
    1. a) advantage
    2. b) disadvantage
    3. c) either an advantage or disadvantage
    4. d) neither an advantage nor disadvantage
21. Data integrity problems in a DBMS are caused by-
    1. a) Missing Data
    2. b) Data inconsistency
    3. c) Data Redundancy
    4. d) Security constraints
22. A collection of conceptual tools for describing data, data relationships, data semantics, and consistency constraints, is known as-
    1. a) Data organization
    2. b) Data Binding
    3. c) Data schemas
    4. d) Data models
23. The fastest read/write time and most efficient data storage of any disk array type is:
    1. a) RAID-0
    2. b) RAID-1
    3. c) RAID-2
    4. d) RAID-3
24. Which of the following is an appropriate description of the mapping between the relational model and relational databases as its…
    1. a) A domain is mapped to a character type or a character string type.
    2. b) A relation is mapped to a table
    3. c) Attributes and columns are ordered from left to right
    4. d) Neither tuples nor rows have duplicates
25. How can you generate debugging output from PL/SQL?
    1. a) DBMS_SQL
    2. b) DBMS_OUTPUT
    3. c) DBMS_PIPE
    4. d) DBMS_LOB
26. What is GET_BLOCK_PROPERTY?
    1. a) Restricted procedure
    2. b) Unrestricted procedure
    3. c) Library function
    4. d) None of the above
27. Which of these is not a common reason businesses choose to go with a data center colocation service for disaster recovery instead of…
    1. a) Full control of hardware
    2. b) Security and location
    3. c) Granular climate control
    4. d) Cost of building data centers
28. Which of the following are the five built-in functions provided by SQL?
    1. a) COUNT, SUM, AVG, MAX, MIN
    2. b) SUM, AVG, MIN, MAX, MULT
    3. c) SUM, AVG, MULT, DIV, MIN
    4. d) SUM, AVG, MIN, MAX, NAME
29. Which of the following is a technique for hiding the internal implementation details of an object?
    1. a) Encapsulation
    2. b) Polymorphism
    3. c) Inheritance
    4. d) All of the above
30. ROLLBACK command is used to undo the changes made by-
    1. a) DDL commands
    2. b) TCL commands
    3. c) DML Commands
    4. d) Commit command
31. Embedded SQL is which of the following?
    1. a) Hard-coded SQL statements in a programming language such as Java.
    2. b) The process of making an application capable of generating specific SQL code on the fly
    3. c) Hard-coded SQL statements in a procedure.
    4. d) Hard-coded SQL statements in a trigger.
32. In a comparatively small organization, if you want data forwarding among departments based on IP address, which one of the following will…
    1. a) Using Layer-3 routers
    2. b) Using Layer-3 switches
    3. c) Using Unmanaged switches
    4. d) Combining a and b
33. A star schema has what type of relationship between a dimension and a fact table?
    1. a) Many-to-many
    2. b) One-to-one
    3. c) One-to-many
    4. d) All of the above
34. What does this query do? SELECT employee_number, name FROM employees AS Parent WHERE salary> (SELECT AVG (salary) FROM employees WHERE…
    1. a) Finds the name and ID of employees who get more than average
    2. b) Finds the employee's name and ID of those who get more than average salaries of all the departments' salaries.
    3. c) Finds the name and ID of employees who get more than average salaries of his own department.
    4. d) None
35. What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
    1. a) A Java application
    2. b) A Java applet
    3. c) A Java servlet
    4. d) None of the above is correct
36. How does RAID provide data protection?
    1. a) Using either data mirroring or parity
    2. b) Using either data mirroring or striping
    3. c) Using high quality disk drives
    4. d) Using dedicated data protection hardware
37. A DNS client is called a_________
    1. a) DNS updater
    2. b) DNS resolver
    3. c) DNS handler
    4. d) DNS host
38. Which of the following is correct for the Create index command?
    1. a) Insert index index_name on table_name
    2. b) Insert index index_name on database_name;
    3. c) Create index index_name on database_name;
    4. d) Create index index_name on table_name;
39. Third normal form is based on the concept of ______.
    1. a) Normal Dependency
    2. b) Closure Dependency
    3. c) Functional Dependency
    4. d) Transitive Dependency
40. Which one of the following is true for a tuple in a database?
    1. a) A tuple in a database represents a column
    2. b) A tuple in a database represents database schema.
    3. c) A tuple in a database represents a Record
    4. d) A tuple in a database represents a Database topology
41. Which of the following is not a nonvolatile storage device?
    1. a) Memory Stick
    2. b) Hard Disk
    3. c) Random Access Memory
    4. d) NVRAM
42. In an asymmetric key encryption process, the key used to encrypt the data is known as a-
    1. a) Private key
    2. b) Encryption key
    3. c) Public key
    4. d) Modulation key
43. Why is SET TRANSACTION used in an Oracle DBMS?
    1. a) For placing a name on a transaction
    2. b) For committing a transaction
    3. c) For locking a transaction
    4. d) To set up transaction user parameters.
44. Which is the Oracle component that contains the memory structures and background processes?
    1. a) Instance
    2. b) Server
    3. c) SGA
    4. d) Database files
45. The three different application logic components are which of the following?
    1. a) Presentation, Client, and Storage
    2. b) Presentation, Client, and Processing
    3. c) Presentation, Processing, and Storage
    4. d) Presentation, Processing, and Network
46. In a DBMS, when multiple transaction programs update the same database simultaneously, which of the following is a technology that is used…
    1. a) Exclusive Control
    2. b) Integrity constraint
    3. c) Normalization
    4. d) Reorganization
47. The Application program interface in a two-tier architecture DBMS is provided by-
    1. a) Close module connectivity
    2. b) Open module connectivity
    3. c) Open database connectivity
    4. d) Close database connectivity
48. Which of the below is responsible for controlling the interaction among simultaneous transactions?
    1. a) Serializable controller
    2. b) Concurrency Control Manager
    3. c) Transportation management system
    4. d) Multiple Access Protocol
49. Which is not a UTL_FILE function-
    1. a) FOPEN()
    2. b) File_Close()
    3. c) FCOPY
    4. d) FFLUSH()
50. In the strict two-phase locking protocol-
    1. a) All exclusive mode locks taken by a transaction be held until the transaction commits
    2. b) All exclusive mode locks taken by a transaction can be released before the transaction commits
    3. c) All locks can be released before the transaction commits
    4. d) None of these
51. The maximum number of super keys for the relation schema R (E, F, G, H) with E as the key is-
    1. a) 5
    2. b) 6
    3. c) 7
    4. d) 8
52. Oracle materialized views or SNAPSHOTS are used for-
    1. a) Hiding data from users
    2. b) Dynamic data replication
    3. c) Table Space Reduction
    4. d) Data Abstraction
53. A distributed database has which of the following advantages over a centralized database?
    1. a) Software cost
    2. b) Software complexity
    3. c) Slow Response
    4. d) Modular growth
54. Database index speeds up-
    1. a) Select queries
    2. b) Where clauses
    3. c) Update query
    4. d) Both a and b
55. Which of the following indexes is automatically created by the database server when an object is created?
    1. a) Implicit
    2. b) Single column
    3. c) Unique
    4. d) Composite
56. We are waiting for the bus. The underlined part is _______.
    1. a) A noun phrase
    2. b) An infinitive phrase
    3. c) A prepositional phrase
    4. d) A verb phrase
57. Fill in the blank with correct preposition. He is devoid ______ Commonsense.
    1. a) Of
    2. b) From
    3. c) Introduction
    4. d) At
58. Complete the following sentence 'Had I known you were waiting outside, I ______.
    1. a) Had invited you to come in
    2. b) Would invite you to come in
    3. c) Would be inviting you to come in
    4. d) Would have invited you to come in
59. What is the meaning of "White Elephant"?
    1. a) An elephant of white color
    2. b) A hoarder
    3. c) A black Marketer.
    4. d) A very costly or troublesome possession
60. Choose the appropriate meaning of the idiom 'swan song'
    1. a) First Work
    2. b) Last Work
    3. c) Middle Work
    4. d) Early Work
61. A train went 300 km from city X to city Y at an average speed of 100 km/h. At what speed did it travel on the way back if its average…
    1. a) 120 km/h
    2. b) 125 km/h
    3. c) 130 km/h
    4. d) 150 km/h
62. A lamp is manufactured to sell for $35.00, which yields a profit of 25% of cost. If the profit is to be reduced to 15% of cost, what will…
    1. a) $21.00
    2. b) $28.00
    3. c) $31.50
    4. d) $32.20
63. A leading library charges c cents for the first week that a book is loaned and f cents for each day over one week. What is the cost for…
    1. a) C+f(d-7)
    2. b) C+fd
    3. c) cd
    4. d) Cd+f
64. A boat sailing against a stream of river takes 6 hours to travel 24 kms, while sailing with the stream it takes 4 hours to travel the same…
    1. a) 2.5 km/hr
    2. b) 1.5 km/hr
    3. c) 1 km/hr
    4. d) 0.5 km / hr
65. Which one of the following words is masculine?
    1. a) Mare
    2. b) Lad
    3. c) pillow
    4. d) Pony
66. Love for the whole world is called _________.
    1. a) Philanthropy
    2. b) Misogyny
    3. c) Benevolence
    4. d) Misanthropy
67. Who did write first English dictionary?
    1. a) Boswell
    2. b) Ben Jonson
    3. c) Samuel Johnson
    4. d) Milton
68. Misanthropist means-
    1. a) One who flirts with ladies
    2. b) A person of narrow views
    3. c) A hater of mankind
    4. d) One who believe that God is in everything
69. A manufacturer sells three products i.e. A, B and C Product A costs 200 and sells for 250. Product B costs 150 and sells for 180, product…
    1. a) B only
    2. b) A and B both
    3. c) A only
    4. d) C only
70. Three boys have marbles in the ration of 19:5:3. If the boy with the least number has 9 marbles, how many marbles does the boy with the…
    1. a) 23
    2. b) 37
    3. c) 45
    4. d) 57
71. In a Group of 15, 7 can speak Spanish, 8 can speak French and 3 can speak neither. What fraction of the group can speak both French and…
    1. a) 1/5
    2. b) 4/15
    3. c) 1/3
    4. d) 7/15
72. In distributing milk at a summer camp, it is found that a quart of milk will fill wither 3 large glass tumblers or 5 small glass tumblers…
    1. a) 11/5
    2. b) 7/5
    3. c) 5/3
    4. d) 7/3
73. The triangular base of a prism is a right triangle of sides a and b =2a. The height h of the prism is equal to 10mm and its volume is…
    1. a) 2mm and 3mm
    2. b) 1 mm and 4 mm
    3. c) 2 mm and 2 mm
    4. d) 2 mm and 4 mm
74. তুমি আসবে বলে হে স্বাধীনতা সখীনা বিবি কপাল ভাঙল। — এটি কোন বাক্য?
    1. a) সরল
    2. b) মিশ্র বা জটিল
    3. c) যৌগিক
    4. d) সংযুক্ত
75. সমাসবদ্ধ শব্দ আনত কোন সমাসের উদাহরণ?
    1. a) বহুব্রীহি
    2. b) কর্মধারয়
    3. c) অব্যয়ীভাব
    4. d) সবগুলো
76. বৈষ্ণব পদাবলির সঙ্গে কোন তথ্য সম্পর্কিত?
    1. a) সন্ধ্যাভাষা
    2. b) অধিভাষা
    3. c) ব্রজবুলি
    4. d) সংস্কৃত ভাষা
77. সাহচর্য শব্দের শুদ্ধ গঠন কোনটি?
    1. a) সম+চর+র্য
    2. b) সহচর+ঌ ফলা
    3. c) সহচর+য
    4. d) কোনটি নয়
78. চৌ-হদ্দি শব্দটি কোন কোন ভাষার শব্দ মিলে হয়েছে?
    1. a) বাংলা + ফারসি
    2. b) সংস্কৃত + ফারসি
    3. c) ফারসি + আরবি
    4. d) সংস্কৃত + আরবি
79. বাংলাদেশে প্রথম জাতীয় সংসদের নির্বাচন কখন হয়?
    1. a) ৭ ফেব্রুয়ারী ১৯৭৩
    2. b) ৭ জানুয়ারি ১৯৭৩
    3. c) ৭ মার্চ ১৯৭৩
    4. d) ৭ এপ্রিল ১৯৭৩
80. টেস্ট ক্রিকেটে বাংলাদেশের পক্ষে কে প্রথম ডাবল সেঞ্চুরি করেন?
    1. a) মুশফিক
    2. b) তামিম
    3. c) সাব্বির
    4. d) লিটন দাস
81. স্টিফেন হকিং একজন-
    1. a) দার্শনিক
    2. b) পদার্থবিদ
    3. c) কবি
    4. d) রসায়নবিদ
82. চীনের জিনজিয়াং প্রদেশে বসবাসকারী প্রধান মুসলিম সম্প্রদায়ের নাম কি?
    1. a) তুর্কমেন
    2. b) উইঘুর
    3. c) কাজখ
    4. d) তাজিক
83. EDSAC কম্পিউটারে ডাটা সংরক্ষণের জন্য কী ধরনের মেমরি ব্যবহার হতো?
    1. a) RAM
    2. b) ROM
    3. c) Mercury Delay
    4. d) Registers Lines
84. শিব রাত্রির সলতে- বাগধারাটির অর্থ কী?
    1. a) শিবরাত্রির আলো
    2. b) একমাত্র সঞ্চয়
    3. c) একমাত্র সন্তান
    4. d) শিবরাত্রির গুরুত্ব
85. 'কেন পান্থ ক্ষান্ত হও হেরি দীর্ঘ পথ'- কার লেখা?
    1. a) কৃষ্ণচন্দ্র মজুমদার
    2. b) ঈশ্বরচন্দ্র গুপ্ত
    3. c) কামিনী রায়
    4. d) যতীন্দ্রমোহন বাগচী
86. বাংলা গদ্যের জনক কে?
    1. a) ঈশ্বরচন্দ্র বিদ্যাসাগর
    2. b) বঙ্কিমচন্দ্র চট্টোপাধ্যায়
    3. c) উইলিয়াম কেরী
    4. d) রবীন্দ্রনাথ ঠাকুর
87. বাংলা ভাষার আদি নিদর্শন চর্যাপদ আবিষ্কৃত হয় কত সালে?
    1. a) ২০০৭
    2. b) ১৯০৭
    3. c) ১৯০৯
    4. d) ১৯১৬
88. বাংলা কথ্য ভাষার আদি গ্রন্থ কোনটি?
    1. a) প্রভু যিশুর বাণী
    2. b) কৃপার শাস্ত্রের অর্থভেদ
    3. c) ফুলমণি ও করুণার বিবরণ
    4. d) মিশনারি জীবন
89. কত সালে আওয়ামী লীগের ৬দফা পেশ করা হয়েছিল?
    1. a) ১৯৬৬ সালে
    2. b) ১৯৬৭ সালে
    3. c) ১৯৯৮ সালে
    4. d) ১৯৬৯ সালে
90. নির্বাহী বিভাগ থেকে বিচার বিভাগ পৃথক করার বিষয়টি সংবিধানের কোন অনুচ্ছেদে উল্লেখ রয়েছে?
    1. a) অনুচ্ছেদ ২৩
    2. b) অনুচ্ছেদ ২৪
    3. c) অনুচ্ছেদ ২১
    4. d) অনুচ্ছেদ ২২
91. ১৯৫৪ সালে পূর্ব পাকিস্তান প্রাদেশিক পরিষদ নির্বাচনে যুক্তফ্রন্টের কি প্রতীক ছিল?
    1. a) ধানের শীষ
    2. b) নৌকা
    3. c) লাঙল
    4. d) বাইসাইকেল
92. সলোমন দ্বীপপুঞ্জ কোন মহাসাগরে অবস্থিত?
    1. a) ভারত মহাসাগর
    2. b) প্রশান্ত মহাসাগর
    3. c) অ্যাটলান্টিক মহাসাগর
    4. d) আর্কটিক মহাসাগর
93. বিশ্বব্যাংক সংশ্লিষ্ট কোন সংস্থাটি স্বল্প আয়ের উন্নয়নশীল দেশে বেসরকারি খাতে আর্থিক সহায়তা ও উপদেশ দিয়ে থাকে?
    1. a) IBRD
    2. b) MIGA
    3. c) IFC
    4. d) ICSID

Other papers for this post

• 2022 – Written