Oracle SQL Essentials Quiz

Quiz

Played 0

Create copy

About this activity

Test your Oracle SQL basics.

Created by

Moses John Prakash

India

Download the paper version to play

Top 10 results

There are still no results for this game. Be the first to stay in the ranking! Log in to identify yourself.

Make your own free game from our game creator

Compete against your friends to see who gets the best score in this game

Make challenge

Practice Quiz - Punnett Square, Variation, and Mutations

Benjamin D Morgan

United States

(14)

Practice Quiz - Punnett Square, Variation, and Mutations
UPS 5 Seeing Habits Quiz

Heather Bell

United States

(12)

Test your knowledge about the 5 seeing habits discussed in the text 'UPS 5 seeing habits'.
Spanish Alphabet Listening

Falkenberg Falkenberg

United States

(87)

Spanish alphabet, listening-based assessment
Photosynthesis vs Cellular Respiration - Practice Quiz

Benjamin D Morgan

United States

(39)

Photosynthesis vs Cellular Respiration - Practice Quiz
Tissues - Practice Quiz

Benjamin D Morgan

United States

(16)

Tissues - Practice Quiz

		%
	Anonymous	%
		%
		%

Print your game

Oracle SQL Essentials Quiz


Oracle SQL Essentials QuizOnline version Test your Oracle SQL basics. by Moses John Prakash 1 What is true about WHERE clause and HAVING clause? a Both are same. Can be used interchangeably b WHERE clause is used to filter the output before grouping. HAVING clause is used to filter the output after grouping c Can use group functions in WHERE clause d None of the above is true 2 Which constraint ensures all values in a column are unique? a NOT NULL constraint b CHECK constraint c FOREIGN KEY constraint d UNIQUE constraint 3 Which DML statement inserts new rows into a table? a ADD ROW b INSERT INTO c DELETE d UPDATE 4 Which CLAUSE lets you limit results to the first N rows? a ROW COUNT b TOP c ROWNUM d LIMIT 5 What does COMMIT do in Oracle? a Saves all changes permanently b Releases locks c Starts a new transaction d Undoes changes 6 Which constraint links a column to a key in another table? a PRIMARY KEY constraint b CHECK constraint c UNIQUE constraint d FOREIGN KEY constraint 7 Which three actions can you perform by using the ALTER TABLE command? a Add or drop coumns from a table b change the values of the existing records c Remove the table from the database d Drop all columns simultaneously from a table. 8 Which statement adds a new column to an existing table? a ALTER TABLE ... ADD b APPEND COLUMN c MODIFY COLUMN d CREATE TABLE 9 Which option prevents deleting a parent row when child rows exist? a NO ACTION b SET NULL c ON DELETE CASCADE d ON DELETE RESTRICT 10 What keyword is commonly used to assign a label to a column in a SELECT? a FROM b BY c AS d TO

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

Oracle SQL Essentials Quiz

Quiz

About this activity

Created by

Download the paper version to play

Top Games

Quiz

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

UPS 5 Seeing Habits Quiz

Quiz

Spanish Alphabet Listening

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Quiz

Tissues - Practice Quiz

Oracle SQL Essentials QuizOnline version

by Moses John Prakash

What is true about WHERE clause and HAVING clause?

Which constraint ensures all values in a column are unique?

Which DML statement inserts new rows into a table?

Which CLAUSE lets you limit results to the first N rows?

What does COMMIT do in Oracle?

Which constraint links a column to a key in another table?

Which three actions can you perform by using the ALTER TABLE command?

Which statement adds a new column to an existing table?

Which option prevents deleting a parent row when child rows exist?

What keyword is commonly used to assign a label to a column in a SELECT?