Skip to content
Past paper

Sonali and Janata Bank — Assistant Database Administrator — Exam: 25.09.2021 (AUST)প্রশ্ন ও সমাধান

Set by
Sonali & Janata Bank
Post
Assistant Database Administrator
Exam date
25 Sep 2021
Conducted by
AUST
Questions
94 (94 MCQ, 0 written)
Exam guide
Bank IT jobs · ব্যাংকের আইটি চাকরি
  • Database · ডেটাবেজ 41
  • Bangla · বাংলা 10
  • English · ইংরেজি 9
  • General Knowledge · সাধারণ জ্ঞান 9
  • Mathematics · গণিত 9
  • Computer Architecture · কম্পিউটার আর্কিটেকচার 4
  • Software Engineering · সফটওয়্যার ইঞ্জিনিয়ারিং 3
  • Cyber Security · সাইবার নিরাপত্তা 2
  • Networking · নেটওয়ার্কিং 2
  • Web Technology · ওয়েব টেকনোলজি 2
  • Cloud & Emerging Tech · ক্লাউড ও উদীয়মান প্রযুক্তি 1
  • Operating Systems · অপারেটিং সিস্টেম 1
  • Programming · প্রোগ্রামিং 1
Question 1Cyber Security

A database can be hacked by-

  • a)Exploiting weak passwords
  • b)SQL Injection
  • c)Delivering a Trojan
  • d)All of the above (correct answer)
Answer and explanation

Correct answer: (d) All of the above

Each of the three listed methods can lead to a database compromise, so "All of the above" is the only complete answer.

  • Weak or default passwords on database or application accounts can be guessed or brute-forced; OWASP lists permitting weak or well-known passwords as a common authentication failure.
  • SQL injection inserts SQL code through an application's input; OWASP notes that a successful exploit can read and modify database data and even run administrative operations.
  • A Trojan planted on a database server or an administrator's PC runs hidden malicious code that can steal credentials or copy data out.

Why the other options are wrong

  • (a) Exploiting weak passwords: a real route, but choosing it alone ignores (b) and (c).
  • (b) SQL Injection: the best-known database attack, but not the only one listed.
  • (c) Delivering a Trojan: also a real route, but again only one of three correct choices.

Tip: When every listed option is a genuine attack route, pick "All of the above".

Source: A07:2021 – Identification and Authentication Failures - OWASP Top 10:2021; SQL Injection | OWASP Foundation; Trojan horse - Glossary | CSRC

Question 2Database

Which of the following is not a DDL command?

  • a)Create
  • b)Drop
  • c)Alter
  • d)Update

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 3Database

Business Intelligence (BI) reporting analyses can be performed using ________.

  • a)standard SQL only
  • b)extensions to SQL only
  • c)OLAP only
  • d)Both standard SQL and extensions to SQL

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 4Database

The SQL statement

SELECT ROUND (45.926, -1) FROM DUAL;
  • a)is illegal
  • b)prints garbage
  • c)prints 045.926
  • d)prints 50

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 5Operating Systems

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 OS environment?

  • a)lsps -a
  • b)swapinfo -m
  • c)swapon -s (correct answer)
  • d)swap -l and swap -s
Answer and explanation

Correct answer: (c) swapon -s

On Linux, swapon -s (long form --summary) prints a summary of every active swap area, one line per device or swap file, with its type, size, how much is used and its priority. The output is the same as cat /proc/swaps. Red Hat lists both commands as the way to check swap on RHEL systems. free -m also shows the swap total and the amount used.

Why the other options are wrong

  • (a) lsps -a: the IBM AIX command for listing paging spaces; it is not part of Linux.
  • (b) swapinfo -m: the HP-UX swap report command; it does not exist on Linux.
  • (d) swap -l and swap -s: Solaris commands. swap -l lists the swap areas and swap -s summarises swap allocation, but they only exist on Solaris.

Tip: Linux = swapon -s (or cat /proc/swaps, free -m); Solaris = swap -l/swap -s; AIX = lsps -a; HP-UX = swapinfo. Linux commands are lowercase and case-sensitive.

Sources: How do I check for information about the swap on my Red Hat Enterprise Linux system? — Red Hat; Monitoring swap resources (swap -l, swap -s) — Oracle Solaris documentation

Question 6Database

In Oracle, to change the DB_BLOCK_SIZE parameter, you need to-

  • a)Re-create the database
  • b)Alter the database
  • c)Move database to temporary
  • d)Update the table types of the database

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 7Software Engineering

Which of the following controls the execution of application program and UI in two tier client/server architecture?

  • a)Modulation side
  • b)Server side
  • c)Host side
  • d)None of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 8Database

Which one of the following is a failure to a system?

  • a)Boot crash
  • b)Read failure
  • c)Transaction failure
  • d)All of the mentioned

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 9Database

Referential integrity in a DBMS is a form of-

  • a)Foreign key
  • b)Primary key
  • c)Assertion
  • d)Referential constraint

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 10Database

How can you roll back a committed transaction in any DBMS?

  • a)Using SQL rollback commands
  • b)Restoring the data from backups
  • c)Run the transaction again in reverse order
  • d)All of the Above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 11Database

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 of the following functional dependencies is not implied by the above set?

  • a)CD=>AC
  • b)BD=>CD
  • c)BC=>CD
  • d)AC=>BC

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 12Database

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, where R1 is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model?

  • a)2
  • b)3
  • c)4
  • d)5

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 13Database

LGWR process writes information into-

  • a)Database files
  • b)Control Files
  • c)Redo Log Files
  • d)All of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 14Software Engineering

Which of the following is an appropriate category of system maintenance performed for the purpose of modifying the system to cope with changes in the software environment?

  • a)Preventive maintenance
  • b)Corrective maintenance
  • c)Adaptive maintenance
  • d)Perfective maintenance

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 15Database

What are the different events in Triggers?

  • a)Define, Create
  • b)Drop, Comment
  • c)Insert, Update, Delete
  • d)Select, Commit

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 16Web Technology

XSLT processors evaluate each statement in the context of the match that has been made. That is, XSLT processors are:

  • a)Context oriented
  • b)Procedural oriented
  • c)Object oriented
  • d)Relational oriented

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 17Database

The packaged procedure that makes data in a form permanent in the Database is-

  • a)Post
  • b)Post form
  • c)Commit form
  • d)None of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 18Database

When three or more AND & OR conditions are combined, it is easier to use the SQL keyword(s):

  • a)LIKE only
  • b)IN only
  • c)NOT IN only
  • d)Both IN and NOT IN

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 19Database

How to select all data from the student table where the name starts with the letter 'r'?

  • a)SELECT * FROM student WHERE name LIKE 'r%';
  • b)SELECT * FROM student WHERE name LIKE '%r%';
  • c)SELECT * FROM student WHERE name LIKE '%r';
  • d)SELECT * FROM student WHERE name LIKE '_r%';

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 20Database

Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.

  • a)advantage
  • b)disadvantage
  • c)either an advantage or disadvantage
  • d)neither an advantage nor disadvantage

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 21Database

Data integrity problems in a DBMS are caused by-

  • a)Missing Data
  • b)Data inconsistency
  • c)Data Redundancy
  • d)Security constraints

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 22Database

A collection of conceptual tools for describing data, data relationships, data semantics, and consistency constraints, is known as-

  • a)Data organization
  • b)Data Binding
  • c)Data schemas
  • d)Data models

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 23Computer Architecture

The fastest read/write time and most efficient data storage of any disk array type is:

  • a)RAID-0
  • b)RAID-1
  • c)RAID-2
  • d)RAID-3

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 24Database

Which of the following is an appropriate description of the mapping between the relational model and relational databases as its implementations?

  • a)A domain is mapped to a character type or a character string type.
  • b)A relation is mapped to a table
  • c)Attributes and columns are ordered from left to right
  • d)Neither tuples nor rows have duplicates

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 25Database

How can you generate debugging output from PL/SQL?

  • a)DBMS_SQL
  • b)DBMS_OUTPUT
  • c)DBMS_PIPE
  • d)DBMS_LOB

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 26Database

What is GET_BLOCK_PROPERTY?

  • a)Restricted procedure
  • b)Unrestricted procedure
  • c)Library function
  • d)None of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 27Cloud & Emerging Tech

Which of these is not a common reason businesses choose to go with a data center colocation service for disaster recovery instead of building a new data center?

  • a)Full control of hardware
  • b)Security and location
  • c)Granular climate control
  • d)Cost of building data centers

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 28Database

Which of the following are the five built-in functions provided by SQL?

  • a)COUNT, SUM, AVG, MAX, MIN
  • b)SUM, AVG, MIN, MAX, MULT
  • c)SUM, AVG, MULT, DIV, MIN
  • d)SUM, AVG, MIN, MAX, NAME

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 29Programming

Which of the following is a technique for hiding the internal implementation details of an object?

  • a)Encapsulation (correct answer)
  • b)Polymorphism
  • c)Inheritance
  • d)All of the above
Answer and explanation

Correct answer: (a) Encapsulation

Encapsulation hides an object's internals: fields are made private, and outside code may use only the public methods. Because callers interact only with those methods, the internal implementation stays hidden and can change without breaking them. This is called information hiding.

Why the other options are wrong

  • (b) Polymorphism: lets one call behave differently for different objects. It is about varying behaviour, not hiding internals.
  • (c) Inheritance: lets a subclass reuse a parent's members. It actually makes inherited public and protected members visible to the subclass, so it is not a hiding technique.
  • (d) All of the above: only encapsulation is a hiding technique, so "all" is wrong.

Tip: private data + public methods = encapsulation = information hiding. (Abstraction, which shows only the essentials, is a close cousin but is not offered here.)

Source: What Is an Object? (The Java Tutorials, Oracle)

Question 30Database

ROLLBACK command is used to undo the changes made by-

  • a)DDL commands
  • b)TCL commands
  • c)DML Commands
  • d)Commit command

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 31Database

Embedded SQL is which of the following?

  • a)Hard-coded SQL statements in a programming language such as Java.
  • b)The process of making an application capable of generating specific SQL code on the fly
  • c)Hard-coded SQL statements in a procedure.
  • d)Hard-coded SQL statements in a trigger.

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 32Networking

In a comparatively small organization, if you want data forwarding among departments based on IP address, which one of the following will be a better bet for networking?

  • a)Using Layer-3 routers
  • b)Using Layer-3 switches
  • c)Using Unmanaged switches
  • d)Combining a and b

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 33Database

A star schema has what type of relationship between a dimension and a fact table?

  • a)Many-to-many
  • b)One-to-one
  • c)One-to-many
  • d)All of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 34Database

What does this query do?

SELECT employee_number, name FROM
employees AS Parent WHERE salary> (SELECT AVG (salary)
FROM employees WHERE department= Parent.department);
  • a)Finds the name and ID of employees who get more than average
  • b)Finds the employee's name and ID of those who get more than average salaries of all the departments' salaries.
  • c)Finds the name and ID of employees who get more than average salaries of his own department.
  • d)None

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 35Web Technology

What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?

  • a)A Java application
  • b)A Java applet
  • c)A Java servlet (correct answer)
  • d)None of the above is correct
Answer and explanation

Correct answer: (c) A Java servlet

A Java servlet is a server-side Java component that runs inside the web server's servlet container (e.g. Tomcat). When a browser sends an HTTP request to a URL mapped to the servlet, the container invokes it (for example its doGet() or doPost() method); the servlet runs its logic and writes the HTTP response, usually an HTML page or JSON, back to the browser.

Why the other options are wrong

  • (a) A Java application: a standalone program started through its main() method on the JVM; it is not invoked by the web server for each HTTP request.
  • (b) A Java applet: embedded in a web page, downloaded and run on the client inside the browser, not on the server.
  • (d) None of the above is correct: wrong, because (c) exactly describes the server-side component.

Tip: Servlet = server side (invoked by HTTP requests); Applet = client side (ran in the browser).

Sources: Servlet (Java EE 7 Specification APIs); Applet (Java Platform SE 8)

Question 36Computer Architecture

How does RAID provide data protection?

  • a)Using either data mirroring or parity (correct answer)
  • b)Using either data mirroring or striping
  • c)Using high quality disk drives
  • d)Using dedicated data protection hardware
Answer and explanation

Correct answer: (a) Using either data mirroring or parity

RAID protects data through redundancy, in one of two forms:

  • Mirroring (RAID 1): every block is written to two disks, so a full copy survives if one disk fails.
  • Parity (RAID 3, 4, 5, 6): extra parity blocks, computed by XOR across the data in a stripe, let the contents of a failed disk be rebuilt from the surviving disks.

Either way, the array keeps working after a disk failure.

Why the other options are wrong

  • (b) Using either data mirroring or striping: striping on its own (RAID 0) only spreads data for speed and has zero redundancy, so it protects nothing.
  • (c) Using high quality disk drives: RAID was designed around inexpensive disks; protection comes from redundant data, not from better drives.
  • (d) Using dedicated data protection hardware: RAID can run in software as well; a RAID controller only computes the mirroring or parity, and the protection still comes from that redundancy.

Tip: Protection = mirroring or parity; striping = speed only.

Source: RAID — Wellesley College CS 304 notes

Question 37Networking

A DNS client is called a_________

  • a)DNS updater
  • b)DNS resolver (correct answer)
  • c)DNS handler
  • d)DNS host
Answer and explanation

Correct answer: (b) DNS resolver

DNS is a client-server system. The server side is the name server; the client side is the resolver. RFC 1034 describes resolvers as the programs that sit between user programs and domain name servers: an application asks the resolver for a name, and the resolver sends the queries to name servers, follows referrals if needed, caches the results and returns the IP address. In a PC this is the stub resolver in the operating system; an ISP's recursive resolver plays the same client role toward authoritative servers.

Why the other options are wrong

  • (a) DNS updater: Dynamic DNS update is a separate message type for changing zone records; it is not the name of the DNS client.
  • (c) DNS handler: Not a DNS term.
  • (d) DNS host: Any computer is a host; the word does not name the DNS client component.

Tip: DNS client = resolver; DNS server = name server.

Source: RFC 1034: Domain Names - Concepts and Facilities

Question 38Database

Which of the following is correct for the Create index command?

  • a)Insert index index_name on table_name
  • b)Insert index index_name on database_name;
  • c)Create index index_name on database_name;
  • d)Create index index_name on table_name;

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 39Database

Third normal form is based on the concept of ______.

  • a)Normal Dependency
  • b)Closure Dependency
  • c)Functional Dependency
  • d)Transitive Dependency

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 40Database

Which one of the following is true for a tuple in a database?

  • a)A tuple in a database represents a column
  • b)A tuple in a database represents database schema.
  • c)A tuple in a database represents a Record
  • d)A tuple in a database represents a Database topology

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 41Computer Architecture

Which of the following is not a nonvolatile storage device?

  • a)Memory Stick
  • b)Hard Disk
  • c)Random Access Memory
  • d)NVRAM

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 42Cyber Security

In an asymmetric key encryption process, the key used to encrypt the data is known as a-

  • a)Private key
  • b)Encryption key
  • c)Public key
  • d)Modulation key

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 43Database

Why is SET TRANSACTION used in an Oracle DBMS?

  • a)For placing a name on a transaction
  • b)For committing a transaction
  • c)For locking a transaction
  • d)To set up transaction user parameters.

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 44Database

Which is the Oracle component that contains the memory structures and background processes?

  • a)Instance
  • b)Server
  • c)SGA
  • d)Database files

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 45Software Engineering

The three different application logic components are which of the following?

  • a)Presentation, Client, and Storage
  • b)Presentation, Client, and Processing
  • c)Presentation, Processing, and Storage (correct answer)
  • d)Presentation, Processing, and Network
Answer and explanation

Correct answer: (c) Presentation, Processing, and Storage

In client/server design every application is described by three logic components:

  • Presentation logic: input and output with the user (screens, forms, reports), i.e. the user interface.
  • Processing logic: the application or business rules that process the data, validate input and handle requests.
  • Storage logic: storing and retrieving data, i.e. the DBMS and its data.

Client/server architectures differ only in where these components run: a fat client runs presentation and processing on the client, a thin client runs only presentation, and a three-tier design places each component on its own tier.

Why the other options are wrong

  • (a) Presentation, Client, and Storage: "client" is a machine or role in the architecture, not a logic component; processing logic is missing.
  • (b) Presentation, Client, and Processing: again lists "client" as if it were logic and leaves out storage logic.
  • (d) Presentation, Processing, and Network: the network connects the tiers; it is infrastructure, not one of the application logic components, and storage is missing.

Tip: Application logic = Presentation + Processing + Storage; tiers decide where each one runs.

Source: What Is Three-Tier Architecture? | IBM

Question 46Database

Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

  • a)Lock level
  • b)Transaction isolation level
  • c)Cursor concurrency setting
  • d)Locking hints

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 47Database

In a DBMS, when multiple transaction programs update the same database simultaneously, which of the following is a technology that is used to prevent logical contradictions?

  • a)Exclusive Control
  • b)Integrity constraint
  • c)Normalization
  • d)Reorganization

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 48Database

The Application program interface in a two-tier architecture DBMS is provided by-

  • a)Close module connectivity
  • b)Open module connectivity
  • c)Open database connectivity
  • d)Close database connectivity

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 49Database

Which of the below is responsible for controlling the interaction among simultaneous transactions?

  • a)Serializable controller
  • b)Concurrency Control Manager
  • c)Transportation management system
  • d)Multiple Access Protocol

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 50Database

Which is not a UTL_FILE function-

  • a)FOPEN()
  • b)File_Close()
  • c)FCOPY
  • d)FFLUSH()

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 51Database

In the strict two-phase locking protocol-

  • a)All exclusive mode locks taken by a transaction be held until the transaction commits
  • b)All exclusive mode locks taken by a transaction can be released before the transaction commits
  • c)All locks can be released before the transaction commits
  • d)None of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 52Database

The maximum number of super keys for the relation schema R (E, F, G, H) with E as the key is-

  • a)5
  • b)6
  • c)7
  • d)8

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 53Database

Oracle materialized views or SNAPSHOTS are used for-

  • a)Hiding data from users
  • b)Dynamic data replication
  • c)Table Space Reduction
  • d)Data Abstraction

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 54Database

A distributed database has which of the following advantages over a centralized database?

  • a)Software cost
  • b)Software complexity
  • c)Slow Response
  • d)Modular growth

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 55Database

Database index speeds up-

  • a)Select queries
  • b)Where clauses
  • c)Update query
  • d)Both a and b (correct answer)
Answer and explanation

Correct answer: (d) Both a and b

An index speeds up finding rows. Whenever a query has a search condition on an indexed column, as in the WHERE clause of a SELECT, the DBMS can follow the index to the matching rows instead of scanning the table. In a SQLite test on a 1,000-row table, SELECT * FROM emp WHERE name = 'n500' changed from SCAN emp to SEARCH emp USING INDEX emp_name_idx (name=?) once the index existed. So both (a) and (b) describe what an index speeds up.

Why the other options are wrong

  • (a) Select queries: True but incomplete; the index works through the search condition, so (d) is the fuller answer.
  • (b) Where clauses: True but incomplete for the same reason.
  • (c) Update query: Every UPDATE, INSERT and DELETE must also change the index entries, so indexes add write overhead; that is the usual exam point. An UPDATE with a selective WHERE does use the index to find its rows (SQLite planned it as SEARCH emp USING INDEX), but the write itself becomes more expensive, so speeding up updates is not what an index is for.

Tip: Index → faster searches and reads, slower writes.

Source: PostgreSQL Documentation: Indexes - Introduction

Exam note: An index can also help an UPDATE or DELETE locate its rows, but the paper as printed expects the read-side answer. If the question reappears unchanged, choose (d).

Question 56Database

Which of the following indexes is automatically created by the database server when an object is created?

  • a)Implicit
  • b)Single column
  • c)Unique
  • d)Composite

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 57English

We are waiting for the bus. The underlined part is _______.

  • a)A noun phrase
  • b)An infinitive phrase
  • c)A prepositional phrase
  • d)A verb phrase

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 58English

Fill in the blank with correct preposition. He is devoid ______ Commonsense.

  • a)Of
  • b)From
  • c)Introduction
  • d)At

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 59English

Complete the following sentence 'Had I known you were waiting outside, I ______.

  • a)Had invited you to come in
  • b)Would invite you to come in
  • c)Would be inviting you to come in
  • d)Would have invited you to come in

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 60English

What is the meaning of "White Elephant"?

  • a)An elephant of white color
  • b)A hoarder
  • c)A black Marketer.
  • d)A very costly or troublesome possession

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 61English

Choose the appropriate meaning of the idiom 'swan song'

  • a)First Work
  • b)Last Work
  • c)Middle Work
  • d)Early Work

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 62Mathematics

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 speed for the whole trip was 120 km/h.

  • a)120 km/h
  • b)125 km/h
  • c)130 km/h
  • d)150 km/h

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 63Mathematics

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 be the new retail price of the lamp?

  • a)$21.00
  • b)$28.00
  • c)$31.50
  • d)$32.20

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 64Mathematics

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 taking out a book for d days, where d is greater than 7?

  • a)C+f(d-7)
  • b)C+fd
  • c)cd
  • d)Cd+f

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 65Mathematics

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 distance. What is the speed of the stream?

  • a)2.5 km/hr
  • b)1.5 km/hr
  • c)1 km/hr
  • d)0.5 km / hr

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 66English

Which one of the following words is masculine?

  • a)Mare
  • b)Lad
  • c)pillow
  • d)Pony

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 67English

Love for the whole world is called _________.

  • a)Philanthropy
  • b)Misogyny
  • c)Benevolence
  • d)Misanthropy

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 68English

Who did write first English dictionary?

  • a)Boswell
  • b)Ben Jonson
  • c)Samuel Johnson
  • d)Milton

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 69English

Misanthropist means-

  • a)One who flirts with ladies
  • b)A person of narrow views
  • c)A hater of mankind
  • d)One who believe that God is in everything

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 70Mathematics

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 C costs 1000 and sells for 110. On which product, he has maximum percentage of profit?

  • a)B only
  • b)A and B both
  • c)A only
  • d)C only

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 71Mathematics

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 highest number have?

  • a)23
  • b)37
  • c)45
  • d)57

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 72Mathematics

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 Spanish?

  • a)1/5
  • b)4/15
  • c)1/3
  • d)7/15

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 73Mathematics

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. How many small glass tumblers can be filled with one large glass tumbler?

  • a)11/5
  • b)7/5
  • c)5/3
  • d)7/3

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 74Mathematics

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 equal to 40 mm³. What will be the lengths of the sides a and b of the triangle?

  • a)2mm and 3mm
  • b)1 mm and 4 mm
  • c)2 mm and 2 mm
  • d)2 mm and 4 mm

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 75Bangla

তুমি আসবে বলে হে স্বাধীনতা সখীনা বিবি কপাল ভাঙল। — এটি কোন বাক্য?

  • a)সরল
  • b)মিশ্র বা জটিল
  • c)যৌগিক
  • d)সংযুক্ত

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 76Bangla

সমাসবদ্ধ শব্দ আনত কোন সমাসের উদাহরণ?

  • a)বহুব্রীহি
  • b)কর্মধারয়
  • c)অব্যয়ীভাব
  • d)সবগুলো

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 77Bangla

বৈষ্ণব পদাবলির সঙ্গে কোন তথ্য সম্পর্কিত?

  • a)সন্ধ্যাভাষা
  • b)অধিভাষা
  • c)ব্রজবুলি
  • d)সংস্কৃত ভাষা

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 78Bangla

সাহচর্য শব্দের শুদ্ধ গঠন কোনটি?

  • a)সম+চর+র্য
  • b)সহচর+ঌ ফলা
  • c)সহচর+য
  • d)কোনটি নয়

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 79Bangla

চৌ-হদ্দি শব্দটি কোন কোন ভাষার শব্দ মিলে হয়েছে?

  • a)বাংলা + ফারসি
  • b)সংস্কৃত + ফারসি
  • c)ফারসি + আরবি
  • d)সংস্কৃত + আরবি

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 80General Knowledge

বাংলাদেশে প্রথম জাতীয় সংসদের নির্বাচন কখন হয়?

  • a)৭ ফেব্রুয়ারী ১৯৭৩
  • b)৭ জানুয়ারি ১৯৭৩
  • c)৭ মার্চ ১৯৭৩
  • d)৭ এপ্রিল ১৯৭৩

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 81General Knowledge

টেস্ট ক্রিকেটে বাংলাদেশের পক্ষে কে প্রথম ডাবল সেঞ্চুরি করেন?

  • a)মুশফিক
  • b)তামিম
  • c)সাব্বির
  • d)লিটন দাস

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 82General Knowledge

স্টিফেন হকিং একজন-

  • a)দার্শনিক
  • b)পদার্থবিদ
  • c)কবি
  • d)রসায়নবিদ

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 83General Knowledge

চীনের জিনজিয়াং প্রদেশে বসবাসকারী প্রধান মুসলিম সম্প্রদায়ের নাম কি?

  • a)তুর্কমেন
  • b)উইঘুর
  • c)কাজখ
  • d)তাজিক

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 84Computer Architecture

EDSAC কম্পিউটারে ডাটা সংরক্ষণের জন্য কী ধরনের মেমরি ব্যবহার হতো?

  • a)RAM
  • b)ROM
  • c)Mercury Delay
  • d)Registers Lines

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 85Bangla

শিব রাত্রির সলতে- বাগধারাটির অর্থ কী?

  • a)শিবরাত্রির আলো
  • b)একমাত্র সঞ্চয়
  • c)একমাত্র সন্তান
  • d)শিবরাত্রির গুরুত্ব

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 86Bangla

'কোন পাছ ক্ষান্ত হও হেরি দীর্ঘ পথ'- কার লেখা?

  • a)কৃষ্ণচন্দ্র মজুমদার
  • b)ঈশ্বরচন্দ্র গুপ্ত
  • c)কামিনী রায়
  • d)যতীন্দ্রমোহন বাগচী

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 87Bangla

বাংলা গদ্যের জনক কে?

  • a)ঈশ্বরচন্দ্র বিদ্যাসাগর
  • b)বঙ্কিমচন্দ্র চট্টোপাধ্যায়
  • c)উইলিয়াম কেরী
  • d)রবীন্দ্রনাথ ঠাকুর

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 88Bangla

বাংলা ভাষার আদি নিদর্শন চর্যাপদ আবিষ্কৃত হয় কত সালে?

  • a)২০০৭
  • b)১৯০৭
  • c)১৯০৯
  • d)১৯১৬

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 89Bangla

বাংলা কথ্য ভাষার আদি গ্রন্থ কোনটি?

  • a)প্রভু বিত্তর বাণী
  • b)কৃপার শাস্ত্রের অর্থভেদ
  • c)ফুলমণি ও করুণার
  • d)শিনারি জীবন বিবরণ

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 90General Knowledge

কত সালে আওয়ামী লীগের ৬দফা পেশ করা হয়েছিল?

  • a)১৯৬৬ সালে
  • b)১৯৬৭ সালে
  • c)১৯৯৮ সালে
  • d)১৯৬৯ সালে

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 91General Knowledge

নির্বাহী বিভাগ থেকে বিচার বিভাগ পৃথক করার বিষয়টি সংবিধানের কোন অনুচ্ছেদে উল্লেখ রয়েছে?

  • a)অনুচ্ছেদ ২৩
  • b)অনুচ্ছেদ ২৪
  • c)অনুচ্ছেদ ২১
  • d)অনুচ্ছেদ ২২

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 92General Knowledge

১৯৫৪ সালে পূর্ব পাকিস্তান প্রাদেশিক পরিষদ নির্বাচনে যুক্তফ্রন্টের কি প্রতীক ছিল?

  • a)ধানের শীষ
  • b)নৌকা
  • c)লাঙল
  • d)বাইসাইকেল

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 93General Knowledge

সলোমন দ্বীপপুঞ্জ কোন মহাসাগরে অবস্থিত?

  • a)ভারত মহাসাগর
  • b)প্রশান্ত মহাসাগর
  • c)অ্যাটলান্টিক মহাসাগর
  • d)আর্কটিক মহাসাগর

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 94General Knowledge

বিশ্বব্যাংক সংশ্লিষ্ট কোন সংস্থাটি স্বল্প আয়ের উন্নয়নশীল দেশে বেসরকারি খাতে আর্থিক সহায়তা ও উপদেশ দিয়ে থাকে?

  • a)IBRD
  • b)MIGA
  • c)IFC
  • d)ICSID

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question text is from the public recruitment exam; answers and explanations are written by ARBS Academy. All past papers · Bank IT jobs guide