4. I have an instance on which there are databases in both FULL and SIMPLE recovery models. If I restart the sql service, what is the difference between these databases in recovering or what happens while restarting the services? 5. I have a log file which is of 250 GB. Log is full....
therefore, are not assigned an instance ID. Non-instance-aware components are installed to the same directory by default: <system drive>:\Program Files\Microsoft SQL Server\90\. Changing the installation path for one shared component also changes it for the other shared components...
SQL Interview Questions http://career.guru99.com/top-50-sql-question-answers/ 1. What is DBMS? A Database Management System (DBMS) is a program that controls creation, maintenance and use of a database. DBMS can be termed as File Manager that manages data in a database rather than savi...
SQL Interview Question 面试的时候发现会问一些SQL的基本问题,在此总结一下。 ProgramInterview/SQL这个网站上的问题还比较全。 1. Join type INNER JOIN: Returns all rows when there is at least one match in BOTH tables LEFT JOIN: Return all rows from the left table, and the matched rows from the...
Now, one more question to you guys. If you have heap table, what ?, Can anyone share their thoughts via putting some comments? Create a sample table: 1 2 3 4 5 6 7 CREATE TABLE tbl_Students ( StudID INT IDENTITY(1,1) ,Name VARCHAR(10) ...
These kinds ofSQL interview questionsconfuse the candidate at times. So, coming to the question, there are three different kinds of operators available in SQL. They are: Arithmetical operators Logical operators Comparison operators 4) Are the terms zero or blank space the same as that of NULL ...
16. What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version? This question is generally asked to see how current is your knowledge. Generally...
Before jumping into solving a problem, you need to understand the question. You simply need to create a boolean function that will return True if by shifting the alphabets in String B, you get String A. A = 'abid' B = 'bida' can_shift(A, B) == True Powered By Return false if...
9. What is a child in PostgreSQL? 10. What is difference between PostgreSQL and MySQL? 11. What is table partitioning in PostgreSQL? 12. What is the Maximum size for a table in PostgreSQL? 13. What are the difference between PostgreSQL and SQL Server? 14. What are the difference between...
Gk Questions with Answers Welcome to a2zinterviews.com Aptitude Problems on Train Partnership Time & Distance More ... Database SQL Server MYSQL ORACLE More ... General Knowledge Branches of Science Computer Quiz Famous Personalities More ... ...