- MERGE Statement - Insert or Update ("Upsert"):
- What is virtual table?
- Delete duplicate records without using "rowid"
- How to delete duplicate rows in a table
- cursors
- Rdbms
- What is a join?
- How do you retrieve the first 5 characters of FIRSTNAME
- Is DECLARE CURSOR executable?
- Can you have more than one cursor
- What is VDL
- What happens when you say
- What is meant by Isolation?
- What is meant by a database
- What is the main use of B & B+
- Explain how a database could be recovered
- What is a relationship set ?
- What is degree of Relationship type?
- What is an Aggregation?
- What is meant by entity integrity?
- What is a key?
- What is meant by Atomicity?
- In the WHERE clause what is
- How would you find out the total number
- How do you concatenate the FIRSTNAME and
- What is the use of VALUE function?
- Which system table contains information
- What is meant by Table?
- What is a results table?
- What synonym can do in sql?
- Why SELECT * is not preferred in
- What are some SQL aggregates and
- What is a Cartesian product?
- How is the data structure of System
- What is DDL Interpreter?
- What is the restriction on using
- What is meant by non-serial
- Compare a subselect to a join?
- What is UNION,UNION ALL?
- When you COMMIT, is the cursor
- Is BETWEEN inclusive of the range
- Explain STOGROUP?
- What are the different types of joints?
- How do you specify and use a cursor in
- What is meant by serializability?
- What is meant by Durability?
- What is Transaction?
- What is an object?
- What is Relational Calculus?
- What is Set-at-a-time or Set-oriented?
- What is VDL (View Definition Language)?
- What is the difference between IN subselects
- What is meant by Data Definition
- Apart from cursor, what other ways are available
- How would you retrieve rows from
- What is the syntax for a CREATE
- What is meant by null?
- How do you eliminate duplicate values
- What are aggregate functions?
- What is the foreign key?
- What is an Entity type?
- What is the meaning of domain of
- What is the meaning of DBMS?
- What are the three levels of data
- Explain the difference between a database
- What is an entity set?
- What is degree of a Relation?
- What is Relationship type?
- What is an Entity?
- Describe referential integrity?
- What is a Candidate key?
- Explain 2nd Normal Form?
- What is the use of the Normalization?
- Explain Boyce-Codd Normal Form
- What is the difference between the Union
- My SQL statement SELECT AVG(SALARY) FROM
- What is the meaning of underscore
- What is the difference between the following
- After a table is defined, can columns
- Explain index in SQL?
- What are the column name qualifiers?
- What is the difference between group
- Explain the use of the WHERE
- Explain Alter and Drop statements
- How is the SUBSTR keyword used
- Define the "integrity rules"?
- What is Data Storage - Definition Language?
- What is Query evaluation engine?
- What is Record-at-a-time?
- What is the difference b/w the
- How does Tuple-oriented relational calculus
- Explain Encapsulation?
- In general, how should the boundaries of
- Explain schedule?
- What is meant by View serializability?
- What is a cursor? Why should it
- When is it necessary to create
- How is the SUBSTR keyword
- Can you use MAX on a CHAR column?
- How do you specify and use a cursor in
- Explain the necessity of defining processing
- What is Data Storage - Definition
- What is the basic difference between
- Explain an outer join?
- What are the different Concurrency
- What are the different types of equivalences?
- What is meant by serial schedule?
- What is meant by Atomicity?
- Explain the difference between an explicit and
- Explain Modularity?
- What is class?
- Explain Domain relational calculus?
- What is Relational Algebra?
- Select name from employee where salary=salary.
- What is DML Compiler?
- What is a view? How it is related to
- What is extension and intension?
- Explain the EXPLAIN statement?
- What will GRANT option do?
- Describe the elements of the SELECT query
- What is meant by embedded SQL?
- What is minimum authority required for
- Can one add columns to a table after
- How to copy SQL table?
- What do you accomplish by GROUP
- How do you select a row using
- How do you find the maximum value in
- What is the difference between Oracle,
- Explain 3rd Normal Form?
- What is Normalization?
- What are the tools to create E-R
- What is a Weak entity set?
- What is an Attribute?
- What is data model?
- How can you define a data base?
- What are the advantages of DBMS?
- Disadvantage in File Processing System?
- Describe the advantages and disadvantages
- Why is it important to write to the log before
- What are the different types of entities?
- What is a relation?
- What is meant by relation schema?
- What is the meaning of Relationship
- What are the different types of
- What are the super key and key?
- What is an Extension of entity type?
- What are the some design issues of
- What is a Super key?
- When is a functional dependency F said
- What are the different normal forms?
- Explain 5th Normal Form?
- What is Fully Functional dependency?
- Explain 4th Normal Form?
- Explain Lossless-join dependency?
- When using count(distinct) it is better to use a
- What is 'LIKE' used for in WHERE clause
- How do you retrieve the first 5 characters of
- When do you use a LIKE statement?
- Define rollback and roll forward?
- What are correlated sub queries?
- Explain Table space?
- Where in a table are added columns
- What authority is required to create
- What alias can do?
- What is a correlation name?
- What is a subselect? Is it different from
- What keyword does an SQL SELECT statement use
- Explain ORDER BY clause?
- What does the term "grant privileges
- How to find out the database name from
- What is the difference between the co-related
- What is System R? What are its two major
- What is Data Independence?
- What is DML
- Explain Data Manipulation Language?
- What is RDBMS?
- What is meant by tuple relational calculus?
- What are the different types of authorities in
- What is an object-oriented analysis?
- Explain Abstraction?
- What is lock granularity?
- Explain the meaning of the expression ACID
- What is meant by Consistency?
- What are the different types of
- What is meant by Conflict serializability?
- Explain the necessity of defining processing rights
- What is a cursor?
- What techniques are used to retrieve data from
- What is degree of Relationship type?
- In general, how should the boundaries of a
- Specify UNION to eliminate the duplicate
- My SQL statement SELECT AVG(SALARY) FROM
- What is an alias and how does it differ from
- What is the meaning of the functional
- What is the difference between static and
- Explain Multi-valued Dependency?
- Explain 1st Normal Form?
- What is Multivalued dependency?
- What is a Primary Key?
- What is Object Oriented model?
- What are the some utilities of E-R
- Can you define the existence
- What is DML Compiler
- What is normalization
- What is Relationship
- Define the "integrity rules"
- What is database
- What is a query
- What is Relational Algebra
- What is DBMS
- What is 3NF
- What is an Oracle Instance
- What is File Manager
- What is "transparent DBMS"
- What is Relational Calculus
- What is Relationship set
- What is an Entity
- Advantages of DBMS
- What do you mean by flat file
- What is Buffer Manager
- Name the sub-systems of
- What is a Phantom Deadlock
- What is DDL Interpreter
- What is Relationship type
- What is Data Model
- What is a Database system
- What is an Entity set
- What is 4NF
- What is meant by query
- What is database Trigger
- What are Armstrong rules
- What is E-R model
- What is extension and intension
- What is an Entity type
- What is degree of Relationship
- What is Functional Dependency
- What is a checkpoint and When
- How do you communicate with an
- What is Storage Manager
- What are stand-alone procedures
- What do you mean by Correlated
- What is join dependency and inclusion
- What is Lossless join property
- What is DDL
- What is an attribute
- What is Data Independence
- Disadvantage in File Processing
- What is Object Oriented
- What is VDL
- What is Record-at-a-time