What is the fully qualified naming convention to

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the fully qualified naming convention to specify a table in a linked Oracle database from MS SQL server?

[linked server name].[catalog].[owner].[table] is fully qualified name in a distributed query for an Oracle database table.

(Continued on next question...)

Other Job Interview Questions

• What is a simple way to rename a database in MS SQL Server?
• What is a simple way to detach a database that is not in use in MS SQL Server?
• What is a Named Pipe in MS SQL Server?
• Is it true that MS SQL Server is sharing work load between the server and client computers?
• What is a simple way to detach a database that is not in use in MS SQL Server?
• What does Default Object refers to in MS SQL Server?
• What does Field refers to in MS SQL Server?
• If you finish installing MS SQL Server as Named Instance, what would be the default path name on the hard disk where the server will be installed to?
• If you finish installing MS SQL Server as Named Instance, what would be the default path name on the hard disk where the server will be installed to?
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• More...