Types of indexes. What is the default key created when a
primary key is created in a table ?
Answer Posted / sdp
A unique index is created when a primary key is created in
a table.
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
Is sqlexception checked or unchecked?
How do you write a complex sql query?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is data type in sql?
How do you explain an index?
What is a sql schema used for?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?
Can we create clustered index without primary key?
What is trigger types in sql?
What are sql ddl commands?
how does a local variable is defined using t-sql? : Transact sql
What is sql key?
How can a pl sql block be executed?
what is self-join? : Sql dba