Kashipara.com is a community of ONE million programmers and students, Just like you, Helping each other.Join them. It only takes a minute: Sign Up
Job Resume TemplateWhy don't preparation your interviews. Best and top asking questions sql database questions and answers. Prepare your job sql database interview with us. Most frequently asked questions in sql database interview. Top 10 most common sql database interview questions and answer to ask. sql database most popular interview question for fresher and experiences. We have good collection of sql database job interview questions and answers. Ask interview questions and answers mnc company.employee ,fresher and student. sql database technical questions asking in interview. Complete placement preparation for major companies tests and sql database interviews,Aptitude questions and answers, technical, interview tips, practice tests, assessment tests and general knowledge questions and answers.
sql database 2013-07-08 18:04:02
sql database 2013-07-08 18:00:04
sql database 2013-07-05 07:06:31
sql database 2013-07-08 17:59:11
datedifffor Eg: select datediff (dd,'7-08-2013','13-08-2013')output is 5
SQL Database Interview Question.
sql database 2013-05-04 11:19:48
sql database 2013-07-08 17:55:28
sql database 2013-07-05 07:10:46
sql database 2013-07-08 17:57:12
sql database 2013-07-05 07:09:21
sql database 2013-07-08 17:57:57
Primary keyAdvantages1) It is a unique key on which all the other candidate keys are functionally dependentDisadvantage1) There can be more than one keys on which all the other attributes are dependent on.Foreign KeyAdvantage1)It allows refrencing another table using the primary key for the other table
SQL Database Interview Question.
sql database 2013-05-04 11:18:56
The main difference of DBMS & RDBMS isRDBMS have Normalization. Normalization means to refining the redundant and maintain the stablization. the DBMS hasn't normalization concept.
SQL Database Interview Question.
sql database 2013-05-04 11:18:22
Clustered Index:- A Clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table may have only one clustered index.Non-Clustered Index:- A Non-Clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows in the disk. The leaf nodes of a non-clustered index does not consists of the data pages. instead the leaf node contains index rows.
SQL Database Interview Question.
sql database 2013-05-04 11:17:46
sql database 2013-07-05 07:05:18
we can call stored procedure explicitly.but trigger is automatically invoked when the action defined in trigger is done.ex: create trigger after Insert onthis trigger invoked after we insert something on that table.Stored procedure can't be inactive but trigger can be Inactive.Triggers are used to initiate a particular activity after fulfilling certain condition.It need to define and can be enable and disable according to need.
Sql Database interview question
sql database 2013-05-01 18:24:50
sql database 2013-07-05 07:02:31
sql database 2013-07-05 06:56:52
SQLServer is an RDBMS just like oracle,DB2 from Microsoftwhereas Structured Query Language (SQL), pronounced "sequel", is a language that provides an interface to relational database systems. It was developed by IBM in the 1970s for use in System R. SQL is a de facto standard, as well as an ISO and ANSI standard. SQL is used to perform various operations on RDBMS.
SQL Database Interview Question.
sql database 2013-05-04 11:13:24
An index helps to faster search values in tables. The three most commonly used index-types are: - B-Tree: builds a tree of possible values with a list of row IDs that have the leaf value. Needs a lot of space and is the default index type for most databases. - Bitmap: string of bits for each possible value of the column. Each bit string has one bit for each row. Needs only few space and is very fast.(however, domain of value cannot be large, e.g. SEX(m,f); degree(BS,MS,PHD) - Hash: A hashing algorithm is used to assign a set of characters to represent a text string such as a composite of keys or partial keys, and compresses the underlying data. Takes longer to build and is supported by relatively few databases.
Sql Database interview question
sql database 2013-05-01 18:15:58
sql database best Interview Questions have been designed especially to get you acquainted with the nature of questions you may encounter during your interview for the subject of sql database Programming Language. here some questions that helpful for your interview. sql database 2024 job interview questions with answers. sql database for employee and fresher. Here we present some more challenging practice sql database interview questions and answers that were asked in a real interview for a sql database developer position. These questions are really good to not just test your sql database skills, but also your general development knowledge. sql database programming learning. we hope this sql database interview questions and answers would be useful for quick glance before going for any sql database job interview.