MySQL PostgreSQL MongoDB Oracle SQL Server SQLite Redis Elasticsearch
Categories
All Categories
Aptitude & Reasoning
All Aptitude & Reasoning Quantitative Aptitude Logical Reasoning Verbal Reasoning Data Interpretation Critical Thinking
Artificial Intelligence
All Artificial Intelligence Machine Learning Deep Learning Natural Language Processing Computer Vision Neural Networks AI Ethics Robotics Expert Systems AI Algorithms
Backend Development
All Backend Development CakePHP Django Flask FastAPI Laravel Spring Boot ASP.NET Ruby on Rails CodeIgniter Symfony
Business & Management
All Business & Management Project Management Business Analysis Digital Marketing SEO/SEM E-commerce
Cloud Computing
All Cloud Computing AWS Azure Google Cloud Docker Kubernetes Serverless Microservices CI/CD DevOps Terraform
Computer Science Fundamentals
All Computer Science Fundamentals Data Structures Algorithms Operating Systems Computer Networks Software Engineering System Design
Cybersecurity
All Cybersecurity Ethical Hacking Penetration Testing Network Security Web Security Cryptography Security Auditing
Data Science & Analytics
All Data Science & Analytics Data Analysis Statistics R Programming Pandas NumPy Matplotlib Data Science
Database Management
All Database Management MySQL PostgreSQL MongoDB Oracle SQL Server SQLite Redis Elasticsearch
ERP Systems
All ERP Systems Odoo SAP Oracle ERP Microsoft Dynamics NetSuite Salesforce ERP Implementation
General Knowledge
All General Knowledge Basic General Knowledge General Science Inventions Current Affairs Science & Technology History Geography Sports Politics Mixed Questions
HR & Soft Skills
All HR & Soft Skills Communication Skills Leadership Skills Team Management Time Management Problem Solving HR Interview
Interview Preparation
All Interview Preparation Technical Interview Coding Interview System Design Interview Behavioral Interview
Mathematics
All Mathematics Algebra Calculus Statistics Probability Discrete Mathematics Linear Algebra
Mobile Development
All Mobile Development React Native Flutter Swift Kotlin Ionic Xamarin Android Development iOS Development
Programming Languages
All Programming Languages PHP JavaScript Python Java C++ C# C Go Rust COBOL Pascal Delphi VBScript JCL CICS DB2 Mainframe
Web Development
All Web Development React.js Vue.js Angular Node.js Next.js Nuxt.js Express.js FastAPI Svelte TypeScript JavaScript ES6+ HTML/CSS jQuery Bootstrap Sass/SCSS AJAX

Database Management Questions - SQL Server

Download PDF (5 Sample Questions)
Which locks the item from access of any type?
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
What is the overall responsibility of the DBA?
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
The size of a lock is called:
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
Locks placed by the DBMS are called ________ .
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
Which occurs when one transaction reads a changed record that has not been committed to the database?
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
A cursor type in which the application can only move forward through the recordset is called:
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
A transaction in which either all of the database actions occur or none of them do is called:
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
Which disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
Which refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application acce...
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
The advantage of optimistic locking is that:
Database Management SQL Server Objective
Posted: Feb 25, 2013 View Details
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Database Management SQL Server Objective
Posted: Feb 24, 2013 View Details
A transaction for which all committed changes are permanent is called:
Database Management SQL Server Objective
Posted: Feb 24, 2013 View Details
Which locks the item from change but not from read?
Database Management SQL Server Objective
Posted: Feb 24, 2013 View Details
Showing 1 to 15 of 50 results
Feedback