How would you extract DDL of a table without using a GUI tool?
Query processing is slow(eg select query)how will u solve that
How can you control the amount of free space in your index pages? : sql server DBA
Explain how you would restore a database using RMAN to Point in Time?
How can we know the exact updation date of a particular database?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Name two files used for network connection to a database.
who owns the operating system files created by the utl_file package?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
From the database level, how can you tell under which time zone a database is operating?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How would you go about verifying the network name that the local_listener is currently using?
Give the two types of tables involved in producing a star schema and the type of data theyhold.