-
-
How can you find all the tables created by an user?
bapiora
- Jun 29th, 2009
As?a dba if you want such info. from your database side.You issue following command from server end.?? select owner,table_name,tablespace_name from dba_tables or if you need some specific user info. issue?? select owner, table_name ,tablespace_name from dba_tables where owner='< username>'
subha gunasekaran
- Jun 5th, 2008
select sum(bytes)/1024 from dba_segments where segment_name='TABLE_NAME' and owner=' 'As segment_name represents table_name,index_name..provide the table_name and index_name in the above query
-
Reading Oracle Control file content
Can we read Control file? If yes, then how?
lakshmi143.e
- Oct 14th, 2009
SQL> ALTER DATABASE BACKUP controlfile TO trace;
You can find the trace file which is backup of control file in udump directory.
narendra05
- Oct 2nd, 2009
Control file is the metadata of data and the information is stored in binary format. Some part of the control file can be seen by tracing it to trace (struncture of database can be seen by tracing th...
-
-
Do you need a commit after DDL statements?
Chintan
- May 29th, 2012
DDL is Auto Commited Statements.
cmanne
- Mar 25th, 2007
There is no need to issue commit command after executing DDL statements as the DDL statements are commited automatically
-
How to grant complete database access to an user as read only...?
mangeshchede
- Mar 21st, 2010
By using following SQL Command you can grant read only privillege to your user on whole database.SQL > grant select any table to user_name;and dont grant any other privilege to that user.
rajendra_thanekar
- Apr 9th, 2008
Hi,You can put the entire database in read only mode.startup mountalter database open read only;
-
How to recover the DB if we lost controlfile and we are not having backup also and the database is down...?
shekar2130
- Jul 15th, 2010
If we are loosing control file then we will take backup of control file from alertlog file.
rharijan
- Sep 2nd, 2009
If controlfile is lost we can go to the trace file in udump and there after we can create control file by copying the datafile and redologfile and paste in user managed backup by giving old location to a new new location and then try to recover the old one giving the reuse option.
-
How to use "ALTER DATABASE BEGIN BACKUP;" command in Oracle 9i.
sudhakar
- Sep 25th, 2011
1- When BEGIN BACKUP is issued: The hot backup flag in the datafile headers is set, so that the copy is identified to be a hot backup copy. This is to manage the backup consistency issue when the cop...
tykarthick
- Oct 6th, 2009
Sql>alter database begin backup;The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.Freeze means lock i.e during backup no data's wil...
-
ARCHIVELOG mode
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
-
How do you sort a table?
dineshctbm
- Jul 2nd, 2011
Order By is a keyword which is using for sort the table records either ascending or desending.For eg,for ascending,Select emp_name,emp_identity from emp order by emp_identity;Select emp_name...
nalinicisf
- May 19th, 2008
contents or data of the table can be sorted by using clause ORDER BY in SELECT statement.By default the table is in ASCENDING order.SYN: SELECT * from [table name] &...
-
Whenever a DBA creates a user in which datafile that will be get created ?
None
gbansal4
- Dec 17th, 2007
When the user is created without mentioning default tablespace, then it will be created in SYSTEM tablespace. If Temporary tablespace is also not mentioned then it will automatically take the default temporary tablespace mentioned by the DBA.
Sundar
- Oct 25th, 2007
In MS SQL Server it gets stored in master db.
-
What is Dedicated Server and Shared Server?
ianilreddy
- Aug 7th, 2010
Dedeicated server: For one user one server processsesShared server: Where multiple user and one server process. In shared server whenever user request, server hands over the request to dispatcher and...
sharmme
- Feb 17th, 2010
In a Dedicated server mode, listener spawns a dedicated server process for each user process where as in shared server mode, listener assigns a dispatcher to each user process from the available ...
-
What is the difference between a system crash and a media failure?
dbashashi
- May 20th, 2008
In simple terminology, combination of S/w(Operating system et all) and hardware(Disk Drives) on which these S/W(OS) are loaded, are vital for smooth runing of system. Failure of any of ...
stepwil
- Apr 16th, 2008
A system crash is when an operating system or an application fails corrupting or deleting database objects or the database itself. Media failure is when the hardware that houses the database fails ie: hard disk failure.
-
TNS-03505: Failed to resolve name
HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve namemy listerner.ora file isLISTENER=(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=IPC)(KEY=CHANDU)) (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))...
mb.appsdba
- Sep 2nd, 2010
The issue usually occurs when the tns entiries we provide has some unwanted characters or spaces etc.Please also check the tns entry(alias) is pointing to the correct database with sid,hostname etc.If...
maniswamy
- Oct 3rd, 2009
Just check your port number if two database are in one PC the port number is changed.
-
Database Connections
How will you determine the number of connections connected to your database?
Anupama Kanakam
- May 29th, 2011
We can also see these connections on Activity monitor. But you need permissions to see it.
jsavarin
- Nov 8th, 2010
We can determine the number of connections by using this - SELECT COUNT(*) FROM v$session;
-
How to provide much and more security to my users in the database?
rajendra_thanekar
- Apr 9th, 2008
Hi,create role in database with proper permission. then assign that role to the user. This is the simplest method to implement secuirty in database.
Yogesh
- Feb 6th, 2007
By providing proper Grants on tables such a (select ,update delete..) to different user a DBA can have a better control over his database and if he finds some problem he can Revoke the given rights of the specified user.
-
What happens if i kill a mandatory background processes?
krish_makkena
- Aug 4th, 2010
If we kill the mandatory background processes the db should be shutdown i.e, instance is terminated.
-
-
Different types of table join.
dhampack
- Nov 24th, 2008
In Sybase(T-SQL), there are 3 types of joins1) Equi Join2) Natural Join3) Outer Join (left & right)Joins based on equality (=) are called equijoins. Equijoins compare the values in the columns bei...
Bobby
- Sep 14th, 2006
There are 3 types of joins basis on Oracle 8i Simple join ?????1. Equi join : Equi join is one which contains comparision operator '=' in where clause. ?????2. Non Equi join: If the com...
-
If you have an open cursor on a table, modify the same tableand commit, what would happen?
AK
- Jul 3rd, 2007
Depends on when you commit the changes. If u are processing like above (in a for loop) you should commit post processing, after the cursor is closed. But that's often not useful on huge amount of data...
kishore_m_k
- Apr 19th, 2007
it updates the table without any problem.CREATE TABLE dept1 AS SELECT * FROM dept;declare r1 dept1%rowtype; cursor c1 is select * from dept1 for update of deptno;begin open c1; ...
Database Admin Interview Questions
Ans