Learn Database: Basic

Topics: All about Basic'

Browse all answers:

Explain the difference between a database administrator and a data administrator.
Explain the difference between an explicit and an implicit lock.
What is lock granularity?
In general, how should the boundaries of a transaction be defined?
 Explain the meaning of the expression ACID transaction.
Explain the necessity of defining processing rights and responsibilities. How are such responsibilities enforced?
What is normalization? what is the advantage of normalization (briefly)?
What is the difference between primary key, unique key, sorrougate key?
How the logs are escalated?
The DBMS acts as an interface between what two components of an enterprise-class database system?
An application where only one user accesses the database at a given time is an example of a(n) ________ .
The DBMS that is most difficult to use is ________ .
A DBMS that combines a DBMS and an application generator is ________ .
What type of join is needed when you wish to include rows that do not have matching values?
What is SQL? 
What is SELECT statement?
How can you compare a part of the name rather than the entire name?
What is the INSERT statement? 
How do you delete a record from a database?
What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
What are the Large object types suported by Oracle? 
Difference between a "where" clause and a "having" clause.
How might you display compile time warnings for PL/SQL code?
What is an overloaded procedure?
What's the command to see the current user name?
What is the command to change the SQL prompt name?
How do you switch to DOS prompt from SQL prompt?
How do I eliminate duplicate rows in an Oracle database?
How do I display row number with records?Use the row-num pseudocolumn with query, like
How do you display the records within a given range?
The NVL function only allows the same data type. But here's the task: if the commission field is null, then the text 'Not Applicable' should be displayed, instead of blank space. How do you write the query?
 How do you view version information in Oracle?
What are the components of physical database structure of Oracle database?
What are the components of logical database structure of Oracle database? 
What is a tablespace?
What is SYSTEM tablespace and when is it created? 
What is schema? 
What are Schema Objects? 
What is Oracle table? 
What is an Oracle view? 
What is Partial Backup ?
What is Full Backup ? 
What is the use of Control File ? 
What are the Referential actions supported by FOREIGN KEY integrity constraint ? 
What is Auditing ?
How can you avoid indexes ? 
What are actual and formal parameters ? 
What is a forward declaration ? What is its use ? 
What are the various types of queries ?? 
Is there a PL/SQL Engine in SQL*Plus? 
Is there a limit on the size of a PL/SQL block? 
Can one read/write files from PL/SQL? 
How can I protect my PL/SQL source code? 
Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ? 
What are the values of :new and :old in Insert/Delete/Update Triggers ?
What is the significance of the & and && operators in PL SQL ? 
What is Multi Threaded Server (MTA) ? 
Which are initial RDBMS, Hierarchical & N/w database ? 
Can one improve the performance of SQL*Loader? (for DBA)
How does one use SQL*Loader to load images, sound clips and documents? (for DBA)
What is the difference between the conventional and direct path loader? (for DBA)
What are the various types of Exceptions ? 
What is the difference between a procedure and a function ? 
What are the various types of database triggers ? 
Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA)
Difference between SUBSTR and INSTR ? 
What kind of jobs can one schedule with OEM? (for DBA)
What are the pre requisites ? 
How does one backout events and jobs during maintenance slots? (for DBA)
What are the types of SQL Statement ? 
What is the Oracle Intelligent Agent? (for DBA)
How does one start the Oracle Intelligent Agent? (for DBA)
Can one write scripts to send alert messages to the console?
Where can one get more information about TCL? (for DBA)
Are there any troubleshooting tips for OEM? (for DBA)
What is import/export and why does one need it? (for DBA)
How does one use the import/export utilities? (for DBA)
Can one monitor how fast a table is imported? (for DBA)
Can one import tables to a different tablespace? (for DBA)
How does one use the SQL*Loader utility? (for DBA) 
Is there a SQL*Unloader to download data to a flat file? (for DBA)
Can one load variable and fix length data records? (for DBA)
Can one modify data as it loads into the database? (for DBA)
What is the difference between boiler plat images and image items? 
What are the different objects that you cannot copy or reference in object groups? 
What is an OLE? 
WHY USE RMAN ? (for DBA)
What is STATSPACK and how does one use it? (for DBA)
What are the common RMAN errors (with solutions)? (for DBA)
How can you execute the user defined triggers in forms 3.0 ? 
What is hit ratio ?
How do u implement the If statement in the Select Statement 
How many types of Exceptions are there 
How does one manage Oracle database users? (for DBA)
What is the difference between DBFile Sequential and Scattered Reads?(for DBA)
How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA)
 Explain different isolation levels
Explain the storage models of OLAP
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Are there any undocumented commands in Oracle? (for DBA)
What is the function of Optimizer ?
What is Execution Plan ? 
Can one resize tablespaces and data files? (for DBA) 
What is SAVE POINT ? 
BETWEEN ... AND operators in SQL.
Explain acid properties?
What is ACID property?
Which SQL Server database does not follow ACID properties?
What is rollback and roll forward?
How can one recover the database via reprocessing?
How to check whether the product is install,shared and Not installed in Apps.?
How to find a file version in Application DB:
What are the real time problems you have encountered and how you trouble shooted that?
What is an Oracle instance?
What is referential integrity?
Why Use Sql* Loader in Oracle Database?
How does one create a standby database? (for DBA) 
How does one give developers access to trace files (required as input to tkprof)? (for DBA) 
What are the responsibilities of a Database Administrator ? 
What is a trace file and how is it created ? 
What are the roles and user accounts created automatically with the database? 
What are the minimum parameters should exist in the parameter file (init.ora) ? 
Why and when should I backup my database? (for DBA)
What strategies are available for backing-up an Oracle database? (for DBA)
What is a Query Record Group? 
Give the stages of instance startup to a usable state where normal users may access it. 
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. 
What is the difference between the SQL*Loader and IMPORT utilities? 
What are the different types of segments?
What is a data segment? 
What is an index segment? 
What is rollback segment? 
What are the uses of rollback segment? 
What is a temporary segment? 
What is a datafile? 
What are the characteristics of data files? 
What is a redo log? 
What is the function of redo log? 
What is the use of redo log information? 
What does a control file contains? 
What is the use of control file? 
Explain the difference between a hot backup and a cold backup and the benefits associated with each. 
Explain the difference between a data block, an extent and a segment. 
Compare and contrast TRUNCATE and DELETE for a table. 
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each? 
How many types of columns are there and what are they 
Describe Referential Integrity ? 
What is row chaining? 
How to define data block size? 
What is path setting for DLL? 
What are key-mode and locking mode properties? level ? 
What does invoke built-in do? 
What are OPEN_FORM,CALL_FORM,NEW_FORM? diff? 
Diff. between VAT and Property Class? 
Which trigger related to mouse? 
What is Current record attribute property? 
What are the steps involved in Database Startup 
which system variables can be set by users? 
What are referenced objects? 
Can you store objects in library? 
Can you issue DDL in forms? 
What are the types of triggers and how the sequence of firing in text item 
What are record groups ? * Can record groups created at run-time? 
What are ALERT? 
Table Space,Data Files,Parameter File, Control Files 
What is a 2 Phase Commit 
What is pseudo columns ? Name them? 
What are Database Triggers and Stored Procedures 
What are the Different Optimization Techniques 
How does one create and drop database users? 
How does one stop and start the OMS? (for DBA)
What is CYCLE/NO CYCLE in a Sequence ? 
What are the Back ground processes in Oracle and what are they. 
How many types of Sql Statements are there in Oracle 
What are different Oracle database objects? 
What are the cursor attributes used in PL/SQL ? 
Find out nth highest salary from emp table 
Explain the difference between a data block, an extent and a segment.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
How do you increase the performance of %LIKE operator?  
What is Cache Fusion Technology?  
What is simple replication and advance replication?  
How are the indexes updated? 
How many memory layers are in the oracle shared pool? Explain them  
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?  
Explain the concept of the DUAL table.  
What are the ways tablespaces can be managed and how do they differ?  
Explain what are Oracle Catalog and Oracle Archive log?  
What are PCT Free and PCT Used? What is PCT increase parameter in segment?
What is dump destination? What are bdump, cdump and udump?
What is the difference between Cloning and Standby databases?  
What is Materialized views? Explain its uses.
Why and how the deadlock situation arises? 
What are the steps to take to improve performance of a poor performing query?
What is blocking and how would you troubleshoot it?
Explain the different types of BACKUPs available in SQL Server.
Explain how to create a Scrollable Cursor with the SCROLL Option.
What is database designing? | Oracle DBA
What is functional dependency?
What is data modeling?
What is transitive dependency?
What are the components of an Oracle instance?
What is full backup?
Which tools can you use for full backup?
What is the control file? How is it used?
What is Oracle Streams?
What is an interconnect network?
What is the use of LMD?
What is the use of RSMN?
What is Optimal Flexible Architecture (OFA)? Why is it important to use OFA? 
What is the difference between a soft link and a hard link? 
What is OERR?
What is the use of recording information about current session?
How can you record information about current session?
Name some of the procedures available in the dbms_appIication_info package. 
List some of the procedures provided by the dbms_aq package
How can you use the dbms„redefinition package?
Suppose you have developed a script to redefine a table after confirming that the table can be redefined; however, the redefinition process fails in the middle and further attempts show that it cannot be redefined as materialized view exists on the table. Why did this happen and how can you recover from the situation? 
There are 50 columns in a table. Write a query to get first 25 columns
Difference between Delete and Truncate?
What are global variables? Tell me some of them?
What is use of shrink database?
How the Exists keyword works in SQL Server?
How can I send a message to user from the SQL Server? 
How to find dependents of a table?
sp_who
What is the difference between a CONSTRAINT AND RULE?
Difference between sysusers and syslogins?
What is #, ##, @, @@ means?
Give the basic block structure of a subprogram.
What are function purity levels?
What is the difference between local and global variables within a package?
What does the REPLACE option indicates in the procedure definition? 
What is the meaning of disabling a trigger?
What is a database event trigger?
In what condition is it good to disable a trigger? 
Which column of the USERJTRIGGERS data dictionary view displays the database event that will fire the trigger? 
How the concept of overloading is implemented within a package?
What is the significance of AUTHID property while creating a procedure?
What is the use of the USERJERRORS data dictionary view?
Is DROP PACKAGE command used to drop the package specification or the package body? 
What is a One-Time-Only procedure and how is it declared within a package?
Give the block structure of an exception section within the PL/SQL code
What are the different types of exceptions?
Can the PL/SQL block process more than one exception at a time?
What are statistics, under what circumstances they go out of date, how do you update them?
What is sorting and what is the difference between sorting & clustered indexes?
How GUID becoming unique across machines?
Why one should not prefix user stored procedures with sp_?
How you will return XML from Stored Procedure?
What is a canvas-view? 
Explain the following file extension related to library? 
What is Oracle Financials? (for DBA)
Select all employees who doesn't have phone?
Table A contains column1 which is primary key and has 2 values (1, 2) and Table B contains column1 which is primary key and has 2 values (2, 3). Write a query which returns the values that are not common for the tables and the query should return one column with 2 records.
How to delete the rows which are duplicate (don’t delete both duplicate records).
What are various components in Application/Middle Tier.
What is APPL_TOP, COMN_TOP, ORA_TOP.....
What is the MultiOrg and what is it used for? (for DBA)
Whats things you do to reduce patch timing ? You can take advantage of following ?
How you put Applications 11i in Maintenance mode ?
Where is applications start/stop scripts stored ?
What is difference between .xml file & AutoConfig ?
What is FNDSM ?
What is GSM in Oracle application E-Business Suite ?
When you apply C driver patch does it require database to be Up & Why ?
What is content of dbc file & why its important ?
What is iAS Patch ?
What is RRA/FNDFS ?
What is PCP is Oracle Applications 11i ?
How to confirm if Report Server is Up & Running ?
Whats is TWO_TASK in Oracle Database ?
How to compile an Oracle Reports file ?
How can you call a PL/SQL procedure from SQL?
Which three of the following are implicit cursor attributes?