1. Make a note of all node names (and/or IP addresses), SQL Server virtual names along with preferred nodes. If there are more than three nodes you may need to also take note of possible owners for each SQL resource group. For my example assume that I have a cluster with node1 and...
Interview Questions sql server experienced interview questions Hello All, I have been collecting interview questions from the people who given interviews at various organizations. Below are the list of questions. It includes, SQL DBA, MSBI, SQL Developer, SQL Server. 1 SSRS: 1. How to rend...
Expected answer: Oracle provides a number of packages in the form of the DBMS_ packages owned by the SYS user. The packages used by DBAs may include: DBMS_SHARED_POOL, DBMS_UTILITY, DBMS_SQL, DBMS_DDL, DBMS_SESSION, DBMS_OUTPUT and DBMS_SNAPSHOT. They may also try to answer with the...
Server?Oracle DBA Job Interview Questions and Answers 1 :: When using Oracle export/import what character set concerns might come up? How do you handle them? Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit...
Last week, I attended a walk-in interview for DBA position at Tech Mahindra Hyderabad, India. They asked few questions on Clustered Index, and I was empty entirely. Questions were: Can we disable the Clustered Index? Have you ever tried to disable Clustered Index?
Important thing to note: By default a clustered index gets created on the primary key, unless specified otherwise. 10. What's the maximum size of a row? 8060 bytes. Don't be surprised with questions like 'what is the maximum number of columns per table'. Check out SQL Server books ...
💬 2020-01-15Madhuri: please provide interview questions on selenium Interview question - Order Process Automation An ecommerce transaction starts on an instance of SAP Hybris at the frontend (browser-based). The order then flows through a bespoke SQL Server based Data Hub, into MS Dynamics 36...
Larget collection of Microsoft ASP.NET, C#, SQL Server Interview Questions and answers, articles books and video tutorials.
Oracle Application DBA 11i Interview Questions – I 1. I am applying a patch , can I open another session and run adadmin ? Ans: Yes, unless you are running a process where workers are involved 2. I am applying a patch , can I open another session in another node and run adpatch?
Unstructured Data Classification | PostgreSQL | Blockchain Intermedio | SQL DBA MCQ | ArangoDB | DataBase Term | Amazon Neptune | MarkLogic | DB2 | Storytelling with Data | Database Security | Structured Data Classification | Teradata | SQL Query | sql questions | MySQL | DBMS | Data...