Database

Topic: SQL

What is RAID?

RAID, an acronym for Redundant Array of Independent Disks (sometimes incorrectly referred to as Redundant Array of Inexpensive Disks), is a technology that provides increased storage functions and reliability through redundancy.

Browse random answers:

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 does teh term upsizing refer to? 
What do you mean by flat file database?
What is difference between TRUNCATE & DELETE? 
What is Index?
What command is used to create a table by copying the structure of another table? 
What is the difference between clustered and a non-clustered index?
Examine this function 
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
Why is an event driven program referred to a passive program? 
What is log shipping?
What is the difference between file server and a database server? 
What are primary keys and foreign keys?
What is sql BREAK? 
What are check constraint?
What is sql JOIN? 
What are the type of Synonyms?
What is sql Consistency?
What is an Integrity Constrains?
Explain Order of SQL statement execution? 
What is Table?
What are the advantages of VIEW? 
What is Rollback Segment?