How would you extract DDL of a table without using a GUI tool?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between catalog & nocatalog?
now one user in online.now i want drop him..how do u drop him?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Give two examples of referential integrity constraints.
Explain materialized views and how they are used.
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
Explain the use of table functions.
how does an oracle clusterware manage crs resources?
Oracle (3253)
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)