NVAEducation

NVAEducation

SQL Constraints - SQL Index - Quiz No.1

gs gs115 SQL Constraints - SQL Index - Quiz No.1

gs gs115 Structured Query Language Quiz

Online Quizzes Preparation

This quiz belongs to book/course code gs gs115 Structured Query Language of gs organization. We have 79 quizzes available related to the book/course Structured Query Language. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL Constraints. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.

NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.

Question 1: Which of the following optional structure is used to improve the performance of a query performed on a table in SQL?
View
Index
Constraint
Table
Question 2: Which of the following statement can be used to create an INDEX in SQL?
INSERT INDEX index_name table_name;
INSERT INDEX index_name ON table_name;
CREATE INDEX index_name table_name;
CREATE INDEX index_name ON table_name;
Question 3: Which of the following index is created on only one column of a table.
Implicit
Unique
Single-column
Composite
Question 4: Which of the following index is created on more than one column of a table.
Implicit
Unique
Single-column
Composite
Question 5: Which of the following statement is used to create a UNIQUE Index in SQL?
CREATE INDEX index_name ON table_name (column_name);
CREATE UNIQUE INDEX index_name ON table_name (column_name);
CREATE INDEX UNIQUE index_name ON table_name (column_name);
CREATE UNIQUE INDEX index_name ON (column_name);
Question 6: How many types of indexes are present in SQL?
3
4
2
5
Question 7: In SQL, Indexes can also be used on the columns containing null values.
True
False
Question 8: Which of the following statement is used to create a BIT-MAP Index in SQL?
CREATE INDEX index_name ON table_name (column_name);
CREATE BITMAP INDEX index_name ON (column_name);
CREATE INDEX BITMAP index_name ON table_name (column_name);
CREATE BITMAP INDEX index_name ON table_name (column_name);
Question 9: Which of the following statement can be used to delete an INDEX in SQL?
DROP INDEX table_name;
DROP INDEX index_name;
DROP INDEX index_name ON table_name;
DELETE INDEX index_name;
Question 10: Which of the following pair of indexes can be created when there is a partition in a table?
Global and Local
Single and Composite
Clustered and Non-Clustered
Unique and Bitmap

Online Quizzes of gs115 Structured Query Language

Online Quizzes
PL/SQL Basics - PL/SQL Basics - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Basics - PL/SQL Syntax - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Constants and Operators - PL/SQL Conditions - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Constants and Operators - PL/SQL Constants and Literals - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Constants and Operators - PL/SQL Operators - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Data Types and DBMS Output - PL/SQL Date and Time - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Data Types and DBMS Output - PL/SQL DBMS Output - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Data Types and Variables - PL/SQL Data Types - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Data Types and Variables - PL/SQL Variables - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Loops, Strings and Arrays - PL/SQL Arrays - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Loops, Strings and Arrays - PL/SQL Loops - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Loops, Strings and Arrays - PL/SQL Strings - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Packages, Collections and Transactions - PL/SQL Collections - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Packages, Collections and Transactions - PL/SQL Packages - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Packages, Collections and Transactions - PL/SQL Transactions - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Procedures, Functions and Cursors - PL/SQL Cursors - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Procedures, Functions and Cursors - PL/SQL Function - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Procedures, Functions and Cursors - PL/SQL Procedure - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Records, Exceptions and Triggers - PL/SQL Exceptions - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Records, Exceptions and Triggers - PL/SQL Records - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
PL/SQL Records, Exceptions and Triggers - PL/SQL Triggers - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Basics - SQL Basics - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Basics - SQL Syntax - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Clause, Operators and Keywords - SQL And, Or, Not - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Clause, Operators and Keywords - SQL Null Values - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Clause, Operators and Keywords - SQL Order By Clause - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Clause, Operators and Keywords - SQL Select Top Clause - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Clause, Operators and Keywords - SQL Where Clause - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Auto Increment - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Check Constraint - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Constraints - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Default Constraint - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Foreign Key - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Index - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Not Null - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Primary Key - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Constraints - SQL Unique Constraint - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Data Types, Views and Injection - SQL Dates - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Data Types, Views and Injection - SQL Injection - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Data Types, Views and Injection - SQL Views - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Database - SQL Alter Table - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Database - SQL Alter Table - Quiz No.2 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Database - SQL Create Table - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Database - SQL Database - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Database - SQL Drop DB - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Database - SQL Drop Table - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Hosting, Operators and Data Types - SQL Data Types - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Hosting, Operators and Data Types - SQL Hosting - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Hosting, Operators and Data Types - SQL Operators - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Joins - SQL Full Join - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Joins - SQL Inner Join - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Joins - SQL Joins - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Joins - SQL Left Join - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Joins - SQL Right Join - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Joins - SQL Self Join - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Joins - SQL Union - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Joins - SQL Union - Quiz No.2 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL MCQs on Select Statement - SQL Select Distinct - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL MCQs on Select Statement - SQL Select Statement - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Numeric Functions - SQL Avg & Sum Functions - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Numeric Functions - SQL Count Function - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Numeric Functions - SQL Min and Max Functions - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Operators and Wildcards - SQL Aliases - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Operators and Wildcards - SQL Between Operator - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Operators and Wildcards - SQL In Operator - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Operators and Wildcards - SQL Like Operator - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Operators and Wildcards - SQL Wildcards - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Questions on Data Retrieval Techniques - SQL Any & All - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Questions on Data Retrieval Techniques - SQL Exists - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Questions on Data Retrieval Techniques - SQL Group By - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Questions on Data Retrieval Techniques - SQL Having Clause - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Statements - SQL Delete Statement - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Statements - SQL Insert Into Statement - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Statements - SQL Update Statement - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Subqueries - SQL Comments - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Subqueries - SQL Insert Into Select - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Subqueries - SQL Null Functions - Quiz No.1 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Subqueries - SQL Null Functions - Quiz No.2 gs gs115 Structured Query Language Online Quizzes
Online Quizzes
SQL Subqueries - SQL Subqueries - Quiz No.1 gs gs115 Structured Query Language Online Quizzes

Other DB related online quizzes

gs gs112 Online Quizzes
gs112 - gs
gs gs112 MongoDB Online Quizzes
gs gs113 Online Quizzes
gs113 - gs
gs gs113 MySQL Online Quizzes
gs gs114 Online Quizzes
gs114 - gs
gs gs114 Relational Database Management System Online Quizzes
gs gs115 Online Quizzes
gs115 - gs
gs gs115 Structured Query Language Online Quizzes
gs gs116 Online Quizzes
gs116 - gs
gs gs116 Microsoft SQL Server Online Quizzes
gs gs117 Online Quizzes
gs117 - gs
gs gs117 Database Management System Online Quizzes
gs gs127 Online Quizzes
gs127 - gs
gs gs127 SQLite Online Quizzes

Other categories of gs Online Quizzes

gs-gs125 online quizzes
AI - Artificial Intelligence
gs AI online quizzes
gs-gs101 online quizzes
CSF - Computer Science Fundamentals
gs CSF online quizzes
gs-gs112 online quizzes
DB - Databases
gs DB online quizzes
gs-gs118 online quizzes
DS - Data Science
gs DS online quizzes
gs-gs108 online quizzes
LANG - Programming Languages
gs LANG online quizzes
gs-gs122 online quizzes
NC - Networking and Cybersecurity
gs NC online quizzes
gs-gs104 online quizzes
WEB - Web Development
gs WEB online quizzes

Other organizations

Virtual University

Virtual University
Gegasoft

Gegasoft
Theme Customizer

Gaussian Texture

Gradient Background