Q. “model” system DB is down and we are trying to create a new database. Is it possible to create a new database when model DB is down? Ans: We can’t create a new database when model database is down. SQL Se
The use of comparison operators like <,> or = can be done in a subquery. These kinds ofSQL Interview Questionsare a bit difficult to understand and answer accordingly. There are a lot ofSQL Interview Questionsapart from this, which the candidates must practice qualifying for the interview. Fo...
24. Given this table: Testdb=# Select * FROM "Test"."EMP"; ID --- 1 2 3 4 5 (5 rows) What will be the output of below snippet? Select SUM(1) FROM "Test"."EMP"; Select SUM(2) FROM "Test"."EMP"; Select SUM(3) FROM "Test"."EMP"; View answer 5 10 15 25...
Interviews DB Programming SQL SQL (Structured Query Language) Interview Questions And AnswersSharpen your SQL interview expertise with our handpicked 172 questions. Each question is crafted to challenge your understanding and proficiency in SQL. Suitable for all skill levels, these questions are ...
14. Why resourceDB introduced? 15. How to move master database? 16. How to rebuild master database and what are the considerations? 17. What is a boot page? 18. What is fragmentation? 19. What is edition limitation in sql server 2008 for database mirroring with asynchronous mode?
CLICK HERE TO GET INTERVIEW QUESTIONS FOR TCS… Following are some important Interview Questions for SQL : 1.What is SQL?Where SQL is used? Answer: SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in relational database.SQL can...
Many of us are used to craeting databases from the Enterprise Manager or by just issuing the command: CREATE DATABAE MyDB. But what if you have to create a database with two filegroups, one on drive C and the other on drive D with log on drive E with an initial size of 600 MB ...
DBCC CHECKALLOC – To check that all pages in a db are correctly allocated. DBCC CHECKFILEGROUP – Checks all tables file group for any damage. What is a Linked Server? Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL ...
Oracle has an OLE-DB provider that Microsoft provides to add it as a linked server to the SQL Server group.Day09 What is BCP? When is it used? BCP (BulkCopy) is a tool used to copy huge amount of data from tables and views. It does not copy the complete structure from source to...
SQL Server: You must know about the sys.dm_os_wait_statsSQL Server Interview: How to prevent 'SELECT *' using T-SQL Script? Anvesh Patel Database Engineer ImageFebruary 18, 2017SQL Server,SQL Server InterviewAnvesh Patel,Clustered Inded,database,database research and development,...