Databases

SQL, relational design, normalization, and database concepts.

Quizzes

Questions

eBooks

Articles

Likes

117

Views

More topics in Computer Science

All

Computer Science

AJAX

00 Quizzes

Angular JS

00 Quizzes

ASP .NET

00 Quizzes

Bootstrap

00 Quizzes

C

00 Quizzes

C#

00 Quizzes

C++

00 Quizzes

CodeIgniter

00 Quizzes

Computer Networks

01 Quizzes

CSS

01 Quizzes

Data Structures & Algorithms

02 Quizzes

Databases

01 Quizzes

Go Lang

00 Quizzes

HTML

01 Quizzes

Java

00 Quizzes

JavaScript

01 Quizzes

JQuery

00 Quizzes

Laravel

00 Quizzes

Node JS

00 Quizzes

Operating Systems

01 Quizzes

PHP

00 Quizzes

Python

01 Quizzes

React JS

00 Quizzes

React Native

00 Quizzes

Ruby on Rails

00 Quizzes

Software Engineering

01 Quizzes

Tailwind CSS

00 Quizzes

Vue JS

00 Quizzes

Explore

QUESTION NO 01

A transaction that commits means?

Answer: Changes are permanently saved

COMMIT makes the transaction's changes durable.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 02

ACID in databases stands for?

Answer: Atomicity, Consistency, Isolation, Durability

ACID properties guarantee reliable transactions.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 03

An index is used primarily to?

Answer: Speed up lookups

Indexes help the engine find rows faster (at a write/storage cost).

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 04

Normalization mainly reduces?

Answer: Data redundancy

Normalization organizes data to minimize duplication and anomalies.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 05

A foreign key references a?

Answer: Primary (or unique) key in another table

Foreign keys enforce referential integrity between tables.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 06

SQL stands for?

Answer: Structured Query Language

SQL is Structured Query Language for relational databases.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 07

A primary key must be?

Answer: Unique and not null

A primary key uniquely identifies each row and cannot be NULL.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 08

Which SQL command retrieves data?

Answer: SELECT

SELECT queries rows from tables.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 09

DELETE vs TRUNCATE: TRUNCATE typically?

Answer: Removes all rows and resets identity (faster, DDL-like)

TRUNCATE clears the table quickly; DELETE can remove specific rows with WHERE.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

QUESTION NO 10

Which JOIN returns matching rows from both tables?

Answer: INNER JOIN

INNER JOIN keeps rows with matching join keys in both tables.

Shahzad Mahota @shahzad-mahota

302 Quizzes

2930 Questions

00 Likes

Databases

More topics in Computer Science

All

AJAX

Angular JS

ASP .NET

Bootstrap

C

C#

C++

CodeIgniter

Computer Networks

CSS

Data Structures & Algorithms

Databases

Go Lang

HTML

Java

JavaScript

JQuery

Laravel

Node JS

Operating Systems

PHP

Python

React JS

React Native

Ruby on Rails

Software Engineering

Tailwind CSS

Vue JS

Explore

A transaction that commits means?

Explanation

ACID in databases stands for?

Explanation

An index is used primarily to?

Explanation

Normalization mainly reduces?

Explanation

A foreign key references a?

Explanation

SQL stands for?

Explanation

A primary key must be?

Explanation

Which SQL command retrieves data?

Explanation

DELETE vs TRUNCATE: TRUNCATE typically?

Explanation

Which JOIN returns matching rows from both tables?

Explanation