What are the steps involved in Database Shutdown ?
Answer / guest
Close the Database, Dismount the Database and Shutdown the
Instance.
| Is This Answer Correct ? | 1 Yes | 1 No |
What are the main functions of a database management system?
Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
How do you start a database?
What is db driver?
What is system r? How many of its two major subsystems?
Define denormalization.
What is the difference between SQL and NoSQL databases
Mention few case manipulation functions in sql
What do you mean by Correlated subquery in database?
How to pump the data from one database to another?
When does checkpoint occur?
Can you explain insert, update and delete query?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)