what are the features and data management strategies of SQL Server?

what are the features and data management strategies of SQL Server?
by

1 Answer

Answer :

SQL is one of the most demanding skill in the current world. Every day a huge amount of data is collected and one have to deal with these databases to make an insightful information. Hence it is important for us to learn SQL as it is a special-purpose database programming language which help to generate useful strategies from a database and can easily interact with large and massive database, no matter what is the size. These features of SQL make SQL a most powerful tool. Hence, here are some of the major SQL features which makes it a successful database programming language: High Performance High Availability Scalability and Flexibility Robust Transactional Support High Security Management Ease Open Source
by

Related questions

Why can I not install MS SQL Server Express 2008 R2?

Description : Why can I not install MS SQL Server Express 2008 R2?

Last Answer : Please provide details on what and how it fails the precheck.

Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?

Description : Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?

Last Answer : answer:The SQL code IS different. Oracle and SQL Server syntax can differ from the ANSI version of SQL. For example, when you write a JOIN in SQL, you MUST use the OUTER JOIN ON syntax, where ... can also use the Query Builder to write queries for you by dragging and dropping - just like Access.

How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Description : How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Last Answer : try to see if you have volume optimization enabled, it prevents certain changes from happening and really gives the user a hell of alot more trouble than it is worth.

When to use stored procedure and when function in SQL Server 2008?

Description : When to use stored procedure and when function in SQL Server 2008?

Last Answer : There’s no technically right answer here – I think I’d do the SP calling SP.

Learning SQL Server 05

Description : Learning SQL Server 05

Last Answer : http://www.sqlcourse.com/

Points to resolve corruption of SQL server database?

Description : Points to resolve corruption of SQL server database?

Last Answer : Often the corruption for the SQL server database can't be resolved. And the best thing one can do is just roll over the past backup. And by that there is going to be certain amount of the data loss. But you have to make use of that instead of losing everything.

How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Description : How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Last Answer : Execute the "ORADEBUG HELP" command from svrmgrl or sqlplus to obtain a list of valid ORADEBUG commands. Look at these examples: SQLPLUS> REM Trace SQL statements with bind variables SQLPLUS> oradebug ... oradebug lkdebug -a convres SQLPLUS> oradebug lkdebug -r (i.e 0x8066d338 from convres dump)

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Description : Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Last Answer : Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

What connections does Microsoft SQL Server support?

Description : What connections does Microsoft SQL Server support? 

Last Answer : Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password). 

Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Description : Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Last Answer : Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

What connections does Microsoft SQL Server support?

Description : What connections does Microsoft SQL Server support?

Last Answer : Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password).

The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : MySQL

The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : Oracle

Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content

Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content

n which SQL Server version report builder introduced?

Description : n which SQL Server version report builder introduced?

Last Answer : Report builder introduced in SQL Server 2005. While creating or deploying report model project on report server you can get error or it might not get created. For this you need to

............... joins are SQL server default A) Outer B) Inner C) Equi D) None of the above

Description : ............... joins are SQL server default A) Outer B) Inner C) Equi D) None of the above

Last Answer : B) Inner

SQL server stores index information in the ………… system table A) systindexes B) systemindexes C) sysind D) sysindexes

Description : SQL server stores index information in the ………… system table A) systindexes B) systemindexes C) sysind D) sysindexes

Last Answer : D) sysindexes

………….. is a utility to capture a continuous record of server activity and provide auditing capability. A) SQL server Profile B) SQL server service manager C) SQL server setup D) SQL server wizard.

Description : ………….. is a utility to capture a continuous record of server activity and provide auditing capability. A) SQL server Profile B) SQL server service manager C) SQL server setup D) SQL server wizard.

Last Answer : B) SQL server service manager

………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

Description : ………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

Last Answer : A) Standard query language

Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud c) Enables support for outbound sockets using the language – specific, built in libraries. d) Lets developers factor large applications into logical components that can be share stateful services and communicate in secure fashion.

Description : Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully -managed web service that allows you to create , ... large applications into logical components that can be share stateful services and communicate in secure fashion.

Last Answer : A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud

Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Description : Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Last Answer : A) i, ii, and iv only

adjusting timber management strategies to address long term shortfalls will -General Knowledge

Description : adjusting timber management strategies to address long term shortfalls will -General Knowledge

Last Answer : Adjustments to timber management strategies meant to address long-term shortfalls will result in immediate increases in available supplies.

Three Classroom Management Strategies for Your Classroom?

Description : Three Classroom Management Strategies for Your Classroom?

Last Answer : In today’s classrooms, there are diverse learners that may not always have a structured environment at home, especially a learning environment.Teaching the content is not a challenge, it’s the classroom management ... need, he or she may need to display an hour by hour agenda so that students

Inquiries directed towards those charged with governance may most likely a. Relate to their activities concerning the design, and effectiveness of the entity's internal control and whether management has satisfactorily responded to any findings from these activities. b. Help the auditor understand the environment in which the financial statements are prepared. c. Relate to changes in the entity's marketing strategies, sales trends, or contractual arrangements with its customers. d. Help the auditor in evaluating the appropriateness of the selection and application of certain accounting policies

Description : Inquiries directed towards those charged with governance may most likely a. Relate to their activities concerning the design, and effectiveness of the entity's internal control and ... the auditor in evaluating the appropriateness of the selection and application of certain accounting policies

Last Answer : Help the auditor understand the environment in which the financial statements are prepared.

These are the operational approaches by which management intends to achieve its objectives. a. Business risk approaches b. Strategies c. Planning methods d. Operational plans.

Description : These are the operational approaches by which management intends to achieve its objectives. a. Business risk approaches b. Strategies c. Planning methods d. Operational plans.

Last Answer : Strategies

The Strategic Management process should be addressed only by top-level Executives. Mid-level and Low-level Employees are best equipped to implement Co’s Strategies

Description : The Strategic Management process should be addressed only by top-level Executives. Mid-level and Low-level Employees are best equipped to implement Co’s Strategies

Last Answer : False

Identifying an Organization’s existing Vision, Mission, Objectives and Strategies is the final step for the Strategic Management Process

Description : Identifying an Organization’s existing Vision, Mission, Objectives and Strategies is the final step for the Strategic Management Process

Last Answer : False

Which of the following terms refers to a process by which an individual receives education about recognition of stress reactions and management strategies for handling stress?

Description : Which of the following terms refers to a process by which an individual receives education about recognition of stress reactions and management strategies for handling stress? a. Defusing Defusing is a ... jobs but that can also occur to anyone involved in a disaster or mass casualty incident.

Last Answer : a. Defusing Defusing is a process by which the individual receives education about recognition of stress reactions and management strategies for handling stress. It is a component of critical incident stress management (CISM).

Marketing management is ________. A. Managing the marketing process B. Monitoring the profitability of the company’s products and services C. Selecting target markets D. Developing marketing strategies to move the company forward E. The art and science of choosing target markets and getting, keeping, and growing customers through creating, delivering, and communicating superior customer value

Description : Marketing management is ________. A. Managing the marketing process B. Monitoring the profitability of the company's products and services C. Selecting target markets D. Developing ... , keeping, and growing customers through creating, delivering, and communicating superior customer value

Last Answer : E. The art and science of choosing target markets and getting, keeping, and growing customers through creating, delivering, and communicating superior customer value

Ratios help the management in evolving market strategies through ----------- a) Inter firm comparison b) Intra firm comparison c) Ratios d) None of the above

Description : Ratios help the management in evolving market strategies through ----------- a) Inter firm comparison b) Intra firm comparison c) Ratios d) None of the above

Last Answer : a) Inter firm comparison

The final step of the strategic management process is ___________. (a) Doing an internal analysis ; (b) Formulating strategies ; (c) Implementing strategies (d) Evaluating results

Description : The final step of the strategic management process is ___________. (a) Doing an internal analysis ; (b) Formulating strategies ; (c) Implementing strategies (d) Evaluating results

Last Answer : (d) Evaluating results

Is it possible to insert comments into sql statements return in the data model editor?

Description : Is it possible to insert comments into sql statements return in the data model editor?

Last Answer : Yes

In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Description : In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Last Answer : to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace

Is it possible to prompt a user for data when running a SQL script?

Description : Is it possible to prompt a user for data when running a SQL script?

Last Answer : Yes, prefix the column name with & or &&.

MS-SQL stores data in a ........................ file format. A) .DAT B) .MDB C) .MSSQL D) .OBJ

Description : MS-SQL stores data in a ........................ file format. A) .DAT B) .MDB C) .MSSQL D) .OBJ

Last Answer : A) .DAT

An outstanding functionality of SQL is its support for automatic ………… to the target data. A) programming B) functioning C) navigation D) notification

Description : An outstanding functionality of SQL is its support for automatic ………… to the target data. A) programming B) functioning C) navigation D) notification

Last Answer : C) navigation

Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height>180); If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Description : Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height ... number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Last Answer : (C) 10

In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats

Description : In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats 

Last Answer : (B) Fragments

What are the features of client server network ?

Description : What are the features of client server network ?

Last Answer : Client Server Network Features The client-server network is easily expandable. This can be done for tens of thousands of users. Such networks have servers. Server computer hardware is generally advanced and these servers ... why the skills of network users are not so important.

Intranetsand extranets can use their network fire walls andother security features to establish secureInternet links within an enterpriseor with its trading partners. Select the best fit for answer: A. Network Server B. Virtual Private Network C. Networkoperating system D. OS

Description : Intranetsand extranets can use their network fire walls andother security features to establish secureInternet links within an enterpriseor with its trading partners. Select the best fit for answer: A. Network Server B. Virtual Private Network C. Networkoperating system D. OS

Last Answer : Virtual Private Network

Use computers for storage and retrieval of the data for the process plans are? a.Lower-level strategies b.Intermediate strategies c.Higher-level strategies d.Morden-level strategies

Description : Use computers for storage and retrieval of the data for the process plans are? a.Lower-level strategies b.Intermediate strategies c.Higher-level strategies d.Morden-level strategies

Last Answer : a.Lower-level strategies

The transport The transportation method may be used to determine ation method may be used to determine the costs of the costs of alternati alternative strategies for ve strategies for anticipation inventory when which of the following data are available? a)work-force capacity per planning period b)Aggregate demand per planning period c)Beginning inventory d)All of the above

Description : The transport The transportation method may be used to determine ation method may be used to determine the costs of the costs of alternati alternative strategies for ve strategies for anticipation ... planning period b)Aggregate demand per planning period c)Beginning inventory d)All of the above

Last Answer : d)All of the above

What is virtual mart? a. Framework b. Content Management System c. Platform d. Cloud server

Description : What is virtual mart? a. Framework b. Content Management System c. Platform d. Cloud server

Last Answer : a. Framework

Point out the wrong statement. a) Distributed transaction systems such as internetworks or cloud computing systems magnify the difficulties faced by identity management systems b) Services that provide digital identity management as a service have been part of internetworked systems from Day One c) IDaaS Server establishes the identity of a domain as belonging to a set of assigned addresses d) None of the mentioned

Description : Point out the wrong statement. a) Distributed transaction systems such as internetworks or cloud computing systems magnify the difficulties faced by identity management systems b) Services that provide digital ... a domain as belonging to a set of assigned addresses d) None of the mentioned

Last Answer : IDaaS Server establishes the identity of a domain as belonging to a set of assigned addresses

Which of the following simply means to hardware or software load over web servers, that improver's the efficiency of the server as well as the application? A. Amazon Cloud-front B. Elastic Load Balancer C. Load Balancing D. Security Management

Description : Which of the following simply means to hardware or software load over web servers, that improver's the efficiency of the server as well as the application? A. Amazon Cloud-front B. Elastic Load Balancer C. Load Balancing D. Security Management

Last Answer : Load Balancing

Point out the wrong statement. a) Google App Engine lets you deploy the application and monitor it b) From the standpoint of the client, a cloud service provider is different than any other networked service c) The full range of network management capabilities may be brought to bear to solve mobile, desktop, and local server issues d) All of the mentioned

Description : Point out the wrong statement. a) Google App Engine lets you deploy the application and monitor it b) From the standpoint of the client, a cloud service provider is different than any other networked ... be brought to bear to solve mobile, desktop, and local server issues d) All of the mentioned

Last Answer : From the standpoint of the client, a cloud service provider is different than any other networked service

I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Description : I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Last Answer : answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?