Learn Database: Sql

Define SQL?

Define Dbms?

What is the purpose of Database systems?

State the different between Security and Integrity?

Define Normalisation?

What are the purpose of Normalisation?

Define Primary Key?

Define Unique Key?

Define Foreign Key?

Define View?

Compare and contrast TRUNCATE and DELETE for a table?

What is cursors?

Define SubQuery?

What are the different types of subquery?

What are the different types of replication?

What is User Defined Functions?

Define Self Join?

Define Sequence?

Define Joins?

What is a JOIN? Explain types of JOIN in oracle.

What are the types of Joins?

Define Equi Joins?

Define Cartesian Join?

What are three SQL keywords used to change or set someone's permissions?

What are primary keys and foreign keys? 

Define data model?

What is an Entity?

What is BCP? When does it used?

Explain the use of the by GROUP BY and the HAVING clause?

What is DataWarehousing?

What are advantages of Using Oracle

What are the advantages of Database?

What are the advantage of SQL?

What is the difference between join and outer join?

what is  Boyce coded normal form in oracle?

Define Boyce coded normal form?

What are the transaction properties?

What is data mining?

Compare DBMS versus object oriented DBMS?

What are the types of SQL Commands?

What is an attribute?

What are the different types of data models?

What is an active database?

What are ACID properties?

Description of the properties
ACID stands for Atomicity 
Consistency 
Isolation 
Durability

Define Self Join?

What is a tuple?

What is SQL ?

What is meant by embedded SQL?

What is Functional Dependency?

What are the different phases of transaction?

What the difference between UNION and UNIONALL?

What is diffrence between Co-related sub query and nested sub query?

What is DBCC? 

What is the use of DBCC commands?

What is a Linked Server?

What is Collation?

What are different type of Collation Sensitivity?

What is the difference between a primary key and a unique key?

What is the difference between Function and Stored Procedure?

What command do we use to rename a db?

What command do we use to rename a db, a table and a column?

What is BCP?

What is Cross Join?

What is Storage Manager?

What are stored-procedures? And what are the advantages of using them?

what are advantages and Disadvantages of Stored Procedure

What is database Trigger?

What is trigger

What is OLTP?

Difference between OLTP and OLAP ?

What is DDL (Data Definition Language)?

What are the difference between DDL, DML and DCL commands?

What is Weak Entity set?

What is the difference between weak entity set & strong entity set ?

What is a deadlock?

What is Flat File?

What is database?

What do you mean by flat file database?

What is Index?

What is the difference between clustered and a non-clustered index?

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

What is log shipping?

What are primary keys and foreign keys?

What are check constraint?

What are the type of Synonyms?

What is an Integrity Constrains?

What is Table?

What is Rollback Segment?

What does COMMIT do?

What is a Database instance?

What are Roles?

What is SQLPlus?

What is the difference between normalization and denormalization?

What is the difference between static and dynamic SQL?

What is NOT NULL Constraint?

What is meant by query optimization?

The phase that identifies an efficient execution plan for evaluating a query that has the least estimated cost is referred to as query optimization.

What is a data model?

What are types of schema?

What are different types of DBMS?

What is a lock?

What are the different types of cursors?

What is a Catalog?

What is a view?

What are different types of end users?

What are cursors?

What is a weak entity types?

What are defaults?

What is specialization?

What is RAID?

What is database replication?

What is RAID controller technology?

Define candidate key, alternate key, composite key?

What is the use of DESC in SQL?

Define candidate key, alternate key, composite key?

What is the difference between TRUNCATE and DELETE commands?

Describe the three levels of data abstraction?

How to copy the tables, schema and views from one SQL server to another?

What's the maximum size of a row?

What is the difference between a local and a global variable?

What is an Data Abtration?

What is SQLPlus?

What is Transaction Manager?

What kind of User-Defined Functions can be created?

What are defaults? Is there a column to which a default can't be bound?

What is De-normalization?

What are types of sub-queries?

What is referential integrity?

What is the difference between static and dynamic SQL?

Define Unique Key?

Define Indexes?

What does teh term upsizing refer to? 

What is difference between TRUNCATE & DELETE? 

What command is used to create a table by copying the structure of another table? 

Examine this function 

Why is an event driven program referred to a passive program? 

What is the difference between file server and a database server? 

What is sql BREAK? 

What is sql JOIN? 

What is sql Consistency?

Explain Order of SQL statement execution? 

What are the advantages of VIEW? 

Why does the following command give a compilation error? 

What is SQL Mutating Table? 

What are the data types allowed in a table? 

What is SQL*Loader? 

What is the SQL*Plus? 

What is sql BREAK? 

What is a database link? 

What is sql Synonyms? 

What is sql Set Transaction? 

What is CYCLE/NO CYCLE in a Sequence? 

Where the integrity constraints are stored in data dictionary? 

What is sql Multiple columns? 

Which three of the following are implicit cursor attributes? 

Which line in the following statement will produce an error? 

Which line in the following statement will produce an error? 

What is sql Locking? 

How to Select last N records from a Table? 

Which of the Oracle supplied package will enable this feature? 

Which system table contains information on constraints on all the tables created? obtained? 

What does preemptive in preemptive multitasking mean? 

What is sql Savepoint? 

What is the most important requirement for OLTP? 

Sort the Rows: 

Why is the most of the processing done at the sever? 

BETWEEN ... AND 

Why does the following command give a compilation error? 

What command is used to get back the privileges offered by the GRANT command? 

State true or false. !=, <>, ^= all denote the same operation? 

What will be the output of the following query? 

What is the advantage of specifying WITH GRANT OPTION in the GRANT command? 

What is the parameter substitution symbol used with INSERT INTO command? 

What is sql inheritance? 

What is an sql integrity constraint?

What is the use of the DROP option in the ALTER TABLE command? 

Explain CONNECT BY PRIOR? 

What description of a data source is required for ODBC? 

What is the fastest way of accessing a row in a table? 

What is referential integrity constraint? 

You want to include a carriage return/linefeed in your output from a SQL script, how can you do this? 

How can you call a PL/SQL procedure from SQL? 

What is SQL ROWID? 

How do you execute a host operating system command from within SQL? 

What is ON DELETE CASCADE? 

You want to use SQL to build SQL, what is this called and give an example? 

What SQLPlus command is used to format output from a select? 

You want to group the following set of select returns, what can you group on? Max(sum_of_cost), min(sum_of_cost), count(item_no), item_no? 

What special Oracle feature allows you to specify how the cost based system treats a SQL statement? 

You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done? 

What is a Cartesian product? 

You are joining a local and a remote table, the network manager complains about the traffic involved, how can you reduce the network traffic? 

What is tkprof and how is it used? 

What is explain plan and how is it used? 

How do you set the number of lines on a page of output? The width? 

Write a query to retrieve the employee third highest salary 

What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type? 

If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE? 

How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value? 

Can a view be updated/inserted/deleted? If Yes - under what conditions?

For which trigger timing can you reference the NEW and OLD qualifiers? 

When invoking this procedure, you encounter the error? 

Which Oracle supplied package will enable this feature? 

What are the two components of ODBC? 

Most important DDL statements in SQL are: 

SELECT statements: 

The INSERT INTO Statements: 

What is the use of DESC in SQL?