How to craeate the New Database Schema in Oracle and mysql?
Please tell me with Example?
No Answer is Posted For this Question
Be the First to Post Answer
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What command would you use to encrypt a PL/SQL application?
How would you force a log switch?
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.
when does an alert gets signaled?
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
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?
how will you see when the database was started using sql prompt?
How would you determine what sessions are connected and what resources they are waiting for?
Name a tablespace automatically created when you create a database.
what is ora 24313?what is the procedure to exclude that error?
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)