QUESTIONS INTERVIEW.IN
Sign Up
|
Sign In
Post a Question
Asked Questions
Question Bank
Home
Interview Questions
-
Computer Language
-
Computer Database
-
Data Structure
-
Algorithm
-
SAP
-
Accounts
-
Arts
-
Banking
-
Bluetooth
-
Business
-
Call Center
-
Cashier
-
Certifications
-
Clarify CRM
-
Commerce
-
Computers
-
Cost Accounting
-
Common Interview Questions
-
Aerospace
Home
>>
Computer Database
>> Db
Question
View Answer
=>
What is a SNAPSHOT LOG?
View Answer
=>
What are the options available to refresh snapshots?
View Answer
=>
What is a database schema?
View Answer
=>
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
View Answer
=>
How can you determine if an index needs to be dropped and rebuilt?
View Answer
=>
A user selects from a sequence and gets back two values, his select is?
View Answer
=>
Describe what redo logs are.
View Answer
=>
If you have an example table, what is the best way to get sizing data for the production table implementation?
View Answer
=>
What is the effect of setting the value ?ALL_ROWS? for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
View Answer
=>
A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
View Answer
=>
What is difference between UNIQUE constraint and PRIMARY KEY constraint?
View Answer
=>
How can you tell if a database object is invalid?
View Answer
=>
What does a Control file Contain?
View Answer
=>
What causes the "snapshot too old" error? How can this be prevented or mitigated?
View Answer
=>
Explain materialized views and how they are used?
View Answer
=>
You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not?
View Answer
=>
Explain the use of table functions.
View Answer
=>
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
View Answer
=>
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
View Answer
=>
What is the proper method for disabling and re-enabling a primary key constraint?
View Answer
First
« Previous 20
Page:
1
2
3
4
5
6
7
8
Next 20 »
Last
Latest Db Interview video
Latest Topic
How to Import sqlserver data to mysql?
Uncaught TypeError: extract(): Argument #1 ($array) must be of type array, null given
Fatal error: Uncaught TypeError: extract(): Argument #1 ($array) must be of type array
HTTPS is invalid and might prevent it from being indexed
Deprecated: Required parameter $sql follows optional parameter $name in
Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null
Your account isn’t eligible for the Google Workspace Individual plan