1. What is a database?
– A database is described as an organized way of collection of DATA. It is the collection of schemes, tables, queries, reports, views and other objects.
Syntax: Example: CREATEDATABASE abcd
2. What is SQL?
– Structured Query Language (SQL) is a standardized query language for requesting information from a database. SQL is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update and modify data. This is the language used to manage and administer the database server. SQL Server has been broken into two terms, a “relational database” and a “management system”.
3. What is PL/SQL?
– PL/SQL is a Procedural Language (PL) that extends the Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language. PL/SQL is a portable and standard language for Oracle development. With PL/SQL, you can use SQL statements to manipulate Oracle data and flow of control statements to process the data.
4. What Are DMVs In SQL Server ?
– Dynamic management views (DMVs) and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. DMV queries return information about operations and resource consumption that are not available through other means.
SELECT * FROM $System.<schemaRowset>
5. How can SQL Server instances be hidden?
– To hide a SQL Server instance, we need to make a change in SQL Server Configuration Manager. To do this launch SQL Server Configuration Manager and do the following:
In SQL Server Configuration Manager, expand SQL Server Network Configuration, right-clickProtocols for <server instance>, and then select Properties.
On the Flags tab, in the HideInstance box, select Yes, and then click OK to close the dialog box. The change takes effect immediately for new connections
6. What are the two authentication modes in SQL Server?
– SQL Server supports two authentication modes –
Windows Mode : Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication.
Mixed Mode : Mixed mode enables both Windows Authentication and SQL Server Authentication.
Note: With Windows authentication, users are already logged onto Windows and do not have to log on separately to SQL Server.. Modes can be changed by selecting the tools menu of SQL Server configuration properties and choosing security page.
7. What Is SQL Profiler?
– SQL profiler is a tool which is used to create traces for DBA activity. It is a graphical user interface (GUI) software tool in Microsoft’s SQL Server relational database management system (RDBMS) that enables you to monitor events within your SQL Server (or more specifically, a SQL Server instance). SQL Profiler may be used to monitors, analyzes, troubleshoots and tunes SQL databases and their environment and capture data for real-time or future review.
To access SQL Profiler:
Open Enterprise Manager
Select Tools > SQL Profiler menu
To create a trace:
Open SQL Profiler as demonstrated above
Select File > New > Trace…
Select the SQL Server you’d like to connect to, provide authentication details, then click OK
8. Which TCP/IP port does SQL Server run on? How can it be changed?
– SQL Server runs on port 1433 (TCP/IP port ). It can be changed from the Network Utility TCP/IP properties.
9. What are the different index configurations a table can have?
– A table can have one of the following index configurations:
More on Nxtechnp.com