SQL Data Manipulation Language Trivia Quiz!
Welcome to the SQL data manipulation quiz. It is designed to test out just how much you understand when it comes to data manipulation, which is essentially editing, deleting, or changing the data as well as you can. It is perfect for all the programmers who are wishing to test themselves. Do give it a try and all the best!
- 1.A DML command that inserts, updates, or deletes database data
- A.
Alias
- B.
Inner join
- C.
Action query
- 2.An alternative name for a query column
- A.
Alias
- B.
Action query
- C.
LOB locator
- 3.To save changes in a transaction
- A.
Format model
- B.
Linking table
- C.
Commit
- 4.Combines multiple search conditions using the AND, OR, and NOT logical operators
- A.
Nested query
- B.
Complex search condition
- C.
Group function
- 5.An alphanumeric character string used to specify an output format
- A.
Format model
- B.
Inner join
- C.
Linesize
- 6.Performs an operation on a group of queried rows and returns a single result
- A.
Format model
- B.
Commit
- C.
Group function
- 7.Join two tables based on values in one table being equal to values in another table
- A.
Join
- B.
Nested query
- C.
Inner join
- 8.Combine data from multiple database tables using foreign key references
- A.
Join
- B.
Inner Join
- C.
Outer join
- 9.A property of the SQL*Plus environment that specifies how many characters appear on a display line
- A.
Pseudocolumn
- B.
Linesize
- C.
LOB locator
- 10.Used in a join; does not contribute any columns as display columns or search condition columns, but contains join columns that link the other tables through shared foreign key values
- A.
Linking table
- B.
Group function
- C.
Roll back
- 11.A structure that contains information identifying the LOB data type and points to the alternate memory location
- A.
Pagesize
- B.
Linesize
- C.
LOB locator
- 12.A main query and one or more subqueries
- A.
Pseudocolumn
- B.
Nested query
- C.
Nested subquery
- 13.A subquery that contains a second subquery that specifies its search
- A.
Nested query
- B.
Outer join
- C.
Nested subquery
- 14.Returns all rows from one table, and retrieves matching rows from a second table
- A.
Outer join
- B.
Inner Join
- C.
Join
- 15.A property of the SQL*Plus environment that specifies how many lines appear on a SQL*Plus page
- A.
Query
- B.
Pagesize
- C.
Linesize
- 16.Acts like a column in a database table, but is actually a command that returns a specific value
- A.
Table alias
- B.
Search condition
- C.
Pseudocolumn
- 17.A DML command that allows database users to view database data
- A.
Pseudocolumn
- B.
Transaction
- C.
Query
- 18.To undo changes in a transaction
- A.
Roll back
- B.
Pseudocolumn
- C.
Table alias
- 19.A bookmark that designates the beginning of an individual section of a transaction
- A.
Search condition
- B.
Truncate
- C.
Savepoint
- 20.An expression that seeks to match specific table records
- A.
LOB Locator
- B.
Search condition
- C.
Nested query
Back to top