Sonali & Janata Bank , ADA, 2021 (MCQ)

Sonali & Janata Bank
Post: Assistant Database Administrator
Exam Date: 2021

A database can be hacked by:

Exploiting weak passwords,

SQL Injection,

Delivering a Trojan,

All of the above.

Which of the following is not a DDL command?

Create,

Drop,

Alter,

Update.

Business Intelligence (BI) reporting analyses can be performed using:

Standard SQL only,

Extensions to SQL only,

OLAP only,

Both standard SQL and extensions to SQL.

The SQL statement: SELECT ROUND (45.926, -1) FROM DUAL;

Illegal,

Prints garbage,

Prints 45.926,

Prints 50.

Assume that you want to improve database performance and willing to see the amount of swap space. Which command you can use in LINUX OS environment?

Lsps -a,

Swapon -s,

Swapinfo -m,

Swap -l and Swap -s

In oracle to change the DB_Block_size parameter, you need to-

Re-create the database,

Alter the database,

Move database to temporary,

Update the table types of the database

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

Modulation side,

Server side,

Host side,

None of the above

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

Boot crash,

Read failure,

Transaction failure,

All of the mentioned

Referential integrity in a DBMS is a form of-

Foreign key,

Primary key,

Assertion

Referential constraint

10.

How can you rollback a committed transaction in any DBMS?

Using SQL rollback commands,

Restoring the data from backups,

Run the transaction again in Reverse order,

All of the above

11.

LGWR process writes information into-

Database files,

Control Files,

Redo log files,

All of the above

12.

In a schema with attributes A, B, C, D and F following set of functional dependencies are given A => B, A => C, CD => E, B => D, E => A. Which of the following functional dependencies is not implied by the above set?

CD => AC,

BD => CD,

AC => CD

AC => BC

13.

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?

14.

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?

Preventive maintenance,

Corrective maintenance,

Adaptive maintenance,

Perfective maintenance

15.

What are the different events in Triggers?

Define, Create

Drop, Comment

Insert, Update, Delete

Select, Commit

16.

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

Context oriented

Procedural oriented

Object oriented

Relational oriented

17.

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

Post

Commit form

Post form

None of the above

18.

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

LIKE only

IN only

NOT IN only

Both IN and NOT IN

19.

How to select all data from student table starting the name from letter 'r'?

a) SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE 'r%';

20.

Needing to assess the validity of assumed referential integrity constraints on foreign keys is an ______ of normalization.

advantage

disadvantage

either an advantage or disadvantage

neither an advantage nor disadvantage

21.

Data integrity problems in a DBMS is caused due to-

Missing Data

Data inconsistency

Data Redundancy

Security constraints

22.

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

Data organization

Data Binding

Data schemas

Data models

23.

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

RAID-0

RAID-1

RAID-2

RAID-3

24.

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

a) A domain is mapped to a character type or a character string type

A relation is mapped to a table

Attributes and columns are ordered from left to right

Neither tuples nor rows have duplicates

25.

How can you generate debugging output from PL/SQL?

DBMS_SQL

DBMS_OUTPUT

DBMS_PIPE

DBMS_LOB

26.

What is GET_BLOCK property?

Restricted procedure

Unrestricted procedure

Library function

None of the above

27.

Which of the following 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?

Full control of hardware

Security and location

Granular climate control

Cost of building data centers

28.

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

COUNT, SUM, AVG, MAX, MIN

SUM, AVG, MIN, MAX, MULT

SUM, AVG, MULT, DIV, MIN

SUM, AVG, MIN, MAX, NAME

29.

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

Encapsulation

Polymorphism

Inheritance

All of the above

30.

Embedded SQL is which of the following?

a) Hard-coded SQL statements in a program language such as Java,

The process of making an application capable of generating specific SQL code on the fly

Hard-coded SQL statements in a procedure

Hard-coded SQL statements in a trigger

31.

ROLLBACK command is used to undo the changes made by-

DDL commands

TCL commands

DML Commands

Commit command

32.

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

Using Layer-3 switches

Using Unmanaged switches

Combining a and b

33.

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

Many-to-many

One-to-one

One-to-many

All of the above

34.

What does this query do?

 SELECT employee_number, name FROM employees AS Parent WHERE salary > (SELECT AVG(salary) FROM employee WHERE department= Parent department),

Finds the name and ID of employees who get more than average

Finds the employee’s name and ID of those who get more than average salaries of all the department’s salaries

Finds the name and ID of employees who get more than average salaries of his own department

d) None

35.

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

A Java application

A Java applet

A Java servlet

None of the above is correct

36.

How does RAID provide data protection?

Using either data mirroring or parity,

Using either data mirroring or striping,

Using high quality disk drives,

Using dedicated data protection hardware

37.

A DNS client is called a _______.

DNS updater

DNS resolver

DNS handler

DNS host

38.

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

Insert index index_name on table_name

Insert index index_name on database_name

Create index index_name on database_name

Create index index_name on table_name

39.

40.

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

A tuple in a database represents a column,

A tuple in a database represents database schema,

A tuple in a database represents a Record

A tuple in a database represents a Database topology

41.

Which of the following is not a non-volatile storage device?

Memory Stick

Hard Disk

Random Access Memory

NVRAM

42.

In an asymmetric key encryption process, the key used to encrypt the data is known as ______.

Modulation key

Public key,

Encryption key,

Private key,

43.

Why is set transaction used in an oracle DBMS?

For placing a name on a transaction,

For committing a transaction,

For locking a transaction,

To setup transaction user parameters

44.

Which is the oracle component that contains the memory structures and background process?

Instance,

Server,

SGA,

Database files

45.

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

Presentation, Client, and Storage,

Presentation, Client, and Processing,

Presentation, Processing, and Storage,

Presentation, Client, and Storage, Presentation, Client, and Processing, Presentation,

46.

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

Lock level,

Transaction isolation level,

Cursor concurrency setting,

Locking hints

47.

Question: 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?

Reorganization

Normalization,

Integrity constraint,

Exclusive Control,

48.

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

Close module connectivity,

Open module connectivity,

Open database connectivity,

Close database connectivity

49.

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

Serializable controller,

Transportation management system

Concurrency Control Manager

Multiple Access Protocol

50.

Of the functions provided by a DBMS, which of the following is a means for achieving protection for data confidentiality?

Checking referential constraints when the data is updated

Managing a transaction that combines a series of processes as a logical unit,

Managing the data access rights of users

Placing an exclusive lock on the data before it is updated

51.

In strict two-phase locking protocol-

All exclusive mode locks taken by transaction be held until transaction commit

All exclusive mode locks taken by transaction can be released before transaction commits

All locks can be released before transaction commits

None of these

52.

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

53.

Oracle materialized views or SNAPSHOTS is used-

Data Abstraction

Hiding data from users,

Dynamic data replication,

Table Space Reduction,

54.

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

Modular growth

Slow Response,

Software complexity,

Software cost,

55.

Question: Which is not the UTL_FILE function-

FCOPY,

FOPEN

File_Close()

FFLUSH

56.

Database index speeds up-

Select queries,

Where clauses

Update query,

Both a and b

57.

Question: Which of the following index is automatically created by the database server when an object is created?

Implicit,

Single column,

Unique,

Composite

Sonali & Janata Bank Post: Assistant Database Administrator Exam Date: 2021

Leave a Comment Cancel Reply

Sonali & Janata Bank
Post: Assistant Database Administrator
Exam Date: 2021