1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

When creating a user, what permissions must you grant to allow them to connect to the database?

 4 5807

How do you add a data file to a tablespace?

 1 2873

How do you resize a data file?

 2 4304

What view would you use to look at the size of a data file?

 1 3245

What view would you use to determine free space in a tablespace?

 1769

How would you determine who has added a row to a table?

 1785

How can you rebuild an index?

 1 4392

You have just compiled a PL/SQL package but got errors, how would you view the errors?

 1 4804

How can you gather statistics on a table?

 3 7248

How can you enable a trace for a session?

 2 5838

What is the difference between the SQL*Loader and IMPORT utilities?

 1 4490

Name two files used for network connection to a database.

 1 2503

What is NOCOPY?

DELL,

6 19861

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 6058

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 8621

Un-Answered Questions { Databases }

What are the 7 disadvantages to a manual system?

499

What is the difference between sql and postgresql?

429

Mention the uses of stored procedures.

563

What is the difference between mysql and pdo?

486

How to insert large data in mongodb?

1




What is a group function explain with an example?

514

How do you implement session management in SQL Server mode?

546

What is the difference between I and G in Oracle?

592

What is orm in mysql?

465

What is big data database?

481

What are the five functions of a database?

305

How rdbms is different from dbms?

479

Define model database?

566

How to load data through external tables?

573

What are the main features of ms access?

421

For More Un-Answered { Databases } Questions Click Here