Oracle SQL Essentials Quiz

Test

Parties jouées 0

Créer une copie

À propos de cette activité

Test your Oracle SQL basics.

Créé par

Moses John Prakash

India

Téléchargez la version pour jouer sur papier

Top 10 résultats

Il n'y a toujours pas de résultats pour ce jeu. Soyez le premier à apparaître dans le classement! Connectez-vous pour vous identifier.

Créez votre propre jeu gratuite à partir de notre créateur de jeu

Affrontez vos amis pour voir qui obtient le meilleur score dans ce jeu

Créer un défi

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

Oracle SQL Essentials Quiz


Oracle SQL Essentials QuizVersion en ligne Test your Oracle SQL basics. par 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

Vous pouvez intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

Oracle SQL Essentials Quiz

Test

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Test

UPS 5 Seeing Habits Quiz

Test

Practice Quiz - Punnett Square, Variation, and Mutations

Test

Photosynthesis vs Cellular Respiration - Practice Quiz

Test

Tissues - Practice Quiz

Test

Spanish Alphabet Listening

Oracle SQL Essentials QuizVersion en ligne

par 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?