When creating a user, what permissions must you grant to
allow them to connect to the database?
Post New Answer View All Answers
How to start SQL Server in minimal configuration mode?
how can you record information about current session?
What are the operating modes in which database mirroring runs? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what are the performance views in an oracle rac environment?
How can you control the amount of free space in your index pages? : sql server DBA
how can a session indicate its interest in receiving alerts?
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.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what do you understand by flashback feature of oracle?
How do you trace the traffic hitting a sql server? : sql server DBA