Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

sgsgsgsgsgasgteegsgsg

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

To drop an index, we must be the owner of the index or have the ______ privilege.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

If a table is dropped, which of the following statement is true.

indexes and sequences are automatically dropped, but views and constraints remain
views and indexes are automatically dropped, but constraints and sequences remain
indexes and constraints are automatically dropped, but views and sequences remain
views and sequences are automatically dropped, but indexes and constraints remain

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

A function-based index is an index based on expressions

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the below statement is worth creating an index

The table is small
The columns are often used as a condition in the query
Most queries are expected to retrieve more than 2 to 4 percent of the rows in the table
The table is updated frequently

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

More indexes on a table is always better for faster queries

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What does SQL stand for?

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which SQL statement is used to extract data from a database?

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which SQL statement is used to update data in a database?

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which SQL statement is used to delete data from a database?

Reveal answer Fill a bubble to check yourself

Tag: databases