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
=>
Explain the use of setting GLOBAL_NAMES equal to TRUE.
View Answer
=>
What happens if a tablespace clause is left off of a primary key constraint clause?
View Answer
=>
How would you determine the time zone under which a database was operating?
View Answer
=>
What happens if the constraint name is left out of a constraint clause?
View Answer
=>
Explain the difference between and .
View Answer
=>
What are some of the Oracle provided packages that DBAs should be aware of?
View Answer
=>
How would you go about increasing the buffer cache hit ratio?
View Answer
=>
How would you go about generating an EXPLAIN plan?
View Answer
=>
You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
View Answer
=>
What is the purpose of the IMPORT option IGNORE? What is it's default setting?
View Answer
=>
What is a Sequence?
View Answer
=>
Give one method for transferring a table from one schema to another?
View Answer
=>
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
View Answer
=>
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
View Answer
=>
Give the two types of tables involved in producing a star schema and the type of data they hold?
View Answer
=>
Compare and contrast TRUNCATE and DELETE for a table.
View Answer
=>
Where would you look for errors from the database engine?
View Answer
=>
Where would you look for errors from the database engine?
View Answer
=>
What are the Referential actions supported by FOREIGN KEY integrity constraint?
View Answer
=>
Diffrence between a ?where? clause and a ?having? claus
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