Tag: databases

Questions Related to databases

sgsgsgsgsgasgteegsgsg
technology databases

  1. fgg

  2. sb

  3. gsgsg

  4. sgsgs

Show answer
Correct Option: C

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

  1. DROP ANY INDEX

  2. DROP ALL INDEX

  3. REMOVE ANY INDEX

  4. REMOVE ALL INDEX

Show answer
Correct Option: A

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

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

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

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

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

Show answer
Correct Option: C

A function-based index is an index based on expressions
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the below statement is worth creating an index
technology databases

  1. The table is small

  2. The columns are often used as a condition in the query

  3. Most queries are expected to retrieve more than 2 to 4 percent of the rows in the table

  4. The table is updated frequently

Show answer
Correct Option: B

More indexes on a table is always better for faster queries
technology databases

  1. True

  2. False

Show answer
Correct Option: B

What does SQL stand for?
technology databases

  1. Structured Question Language

  2. Strong Question Language

  3. Structured Query Language

  4. Structured Query Limited

Show answer
Correct Option: C

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

  1. FETCH

  2. GET

  3. SELECT

  4. EXTRACT

Show answer
Correct Option: C

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

  1. UPDATE

  2. MODIFY

  3. SAVE AS

  4. SAVE

Show answer
Correct Option: A

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

  1. REMOVE

  2. COLLAPSE

  3. DELETE

  4. REMOVE ALL

Show answer
Correct Option: C