Database Management System DBMS

4 followers study24x7

23 Oct 2024 10:21 AM study24x7

You observe that a specific query is not using an available index, leading to poor performance.
See more

A

Rebuild the index

B

Update the database statistics

C

Increase the query timeout

D

Change the query's isolation level

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

23 Oct 2024 10:20 AM study24x7

After adding a new index to a table, certain update operations on the table have become slower.
See more

A

The new index requires additional storage space

B

The update operations do not use the index

C

Updating the table now requires updating the index as well

D

The index has caused a lock on the table

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

23 Oct 2024 10:13 AM study24x7

A query that used to run quickly is now running slowly, even though no changes were made to the query itself.
See more

A

The database has been indexed incorrectly

B

The underlying data has significantly increased in size

C

A network issue is causing delayed responses

D

The query optimizer is malfunctioning

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

22 Oct 2024 11:12 AM study24x7

How do you enforce uniqueness on a composite index in SQL Server for columns "FirstName" and "LastName" in the "Employees" table?

A

CREATE UNIQUE INDEX ux_name ON Employees(FirstName, LastName)

B

UNIQUE INDEX CREATE Employees(FirstName, LastName)

C

CREATE INDEX UNIQUE Employees ON (FirstName, LastName)

D

INDEX CREATE UNIQUE ON Employees(FirstName, LastName)

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

22 Oct 2024 11:12 AM study24x7

In PostgreSQL, how do you add a GIN index to an array column named "tags" in a table named "Posts"?

A

CREATE INDEX gin_tags ON Posts USING GIN(tags)

B

GIN INDEX CREATE ON Posts(tags)

C

CREATE GIN INDEX ON Posts(tags)

D

INDEX GIN CREATE ON Posts USING (tags)

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

22 Oct 2024 11:11 AM study24x7

Which SQL statement is used to create a full-text index in MySQL?

A

CREATE FULLTEXT INDEX ft_index ON Articles(content)

B

FULLTEXT INDEX CREATE ON Articles(content)

C

INDEX FULLTEXT CREATE Articles(content)

D

CREATE INDEX FULLTEXT ON Articles(content)

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

21 Oct 2024 11:25 AM study24x7

How can we create a non-clustered index on the "email" column of the "Users" table in SQL?

A

CREATE NONCLUSTERED INDEX idx_email ON Users(email)

B

CREATE INDEX idx_email ON Users(email) NONCLUSTERED

C

INDEX CREATE ON Users(email) NONCLUSTERED

D

CREATE INDEX idx_email ON Users USING NONCLUSTERED(email)

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

21 Oct 2024 11:24 AM study24x7

What is a B-tree index suitable for?

A

Only equality searches

B

Only range searches

C

Both equality and range searches

D

Neither equality nor range searches

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

21 Oct 2024 11:24 AM study24x7

In a relational database, what does a composite index refer to?

A

An index that combines multiple tables

B

An index built on a single column

C

An index that includes multiple columns from a single table

D

An index used exclusively for joins

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

18 Oct 2024 11:04 AM study24x7

What is a full-text search primarily used for?

A

Searching for numeric data

B

Searching for exact matches in textual data columns

C

Performing complex searches within textual data columns

D

Indexing foreign keys

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

18 Oct 2024 11:03 AM study24x7

Which type of database index is optimized for equality searches?

A

Clustered index

B

Non-clustered index

C

Full-text index

D

Bitmap index

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

18 Oct 2024 11:02 AM study24x7

What is the primary purpose of indexing in a database?

A

To increase transaction speeds

B

To decrease database storage requirements

C

To speed up the retrieval of records based on attribute values

D

To secure the database

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

17 Oct 2024 10:22 AM study24x7

You notice that a particular query within a transaction is causing lock contention.
See more

A

Re-writing the query to access fewer rows

B

Increasing the database's hardware resources

C

Switching to table-level locks

D

Disabling locks for the transaction

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

17 Oct 2024 10:21 AM study24x7

After implementing row-level locking, the system experiences deadlocks.
See more

A

Using table-level locks instead

B

Applying a consistent locking order

C

Reducing the transaction isolation level

D

Implementing lock escalation

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

17 Oct 2024 10:20 AM study24x7

A transaction frequently fails due to lock timeouts.
See more

A

Decrease the transaction isolation level

B

Increase the lock timeout duration

C

Split the transaction into smaller parts

D

All of the above

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

16 Oct 2024 11:36 AM study24x7

How do you enable automatic detection and resolution of update conflicts in Oracle when using optimistic concurrency control?

A

ENABLE AUTOMATIC CONFLICT RESOLUTION

B

SET TRANSACTION RESOLVE CONFLICTS AUTOMATICALLY

C

DBMS_LOCK.RESOLVE

D

DBMS_CONFLICT.RESOLVE_AUTOMATICALLY

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

16 Oct 2024 11:36 AM study24x7

Which command is used in MySQL to start a transaction with a consistent snapshot, providing repeatable reads for the duration of the transaction?

A

START TRANSACTION WITH CONSISTENT SNAPSHOT

B

BEGIN WORK WITH CONSISTENT SNAPSHOT

C

CREATE TRANSACTION WITH SNAPSHOT

D

BEGIN TRANSACTION CONSISTENT SNAPSHOT

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

16 Oct 2024 11:35 AM study24x7

In PostgreSQL, how can you acquire an exclusive lock on a table to prevent other transactions from reading or writing to it?

A

LOCK TABLE table_name IN EXCLUSIVE MODE

B

EXCLUSIVE LOCK ON table_name

C

SET LOCK table_name EXCLUSIVE

D

LOCK table_name EXCLUSIVE

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

15 Oct 2024 11:26 AM study24x7

To set the transaction isolation level to Serializable in SQL Server, which command should be used?

A

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

B

SET ISOLATION LEVEL SERIALIZABLE

C

TRANSACTION SET ISOLATION LEVEL SERIALIZABLE

D

SET TRANSACTION LEVEL AS SERIALIZABLE

Databases

Write a comment

Database Management System DBMS

4 followers study24x7

15 Oct 2024 11:22 AM study24x7

In database systems, the phenomenon where a transaction re-reads data it has previously read and finds that another transaction has modified it is called:

A

Dirty read

B

Non-repeatable read

C

Phantom read

D

Serialization anomaly

Databases

Write a comment

Interests

About

Gallery

Ratings

About

Ratings

Related Pages