SQL Quiz 2 Copy

Question 1 of 15

1. Question

What is a database ?

an organized collection of structured information
software testing that checks the schema, tables, triggers, etc
provides an interface to perform various operations
all of the above

Question 2 of 15

2. Question

What are tables in database ?

Specify both the column names and the values
statement used to select data from a database
objects that contain all the data in a database
reserved words that are used to perform various operations in the database

Question 3 of 15

3. Question

What are the core concepts of the SQL ?

Tables
Relationship
Ordinality
Cardinality

Question 4 of 15

4. Question

Vertical sets of cells in tables are known as

Rows
Columns
sequence
series

Question 5 of 15

5. Question

What is the functionality of DBMS Engine?

an organized collection of structured information
command or code we write on SQL
Converts the written query to machine language
Executes the query and performs the desired action on the database

Question 6 of 15

6. Question

What is the functionality of Query language processor ?

an organized collection of structured information
command or code we write on SQL
Converts the written query to machine language
Executes the query and performs the desired action on the database

Question 7 of 15

7. Question

What is the functionality of SQL Query?

command or code we write on SQL
an organized collection of structured information
Converts the written query to machine language
Executes the query and performs the desired action on the database

Question 8 of 15

8. Question

Which of the following about machine language is/are true?

elemental language of computers
type of artificial intelligence
composed of digital binary numbers
very long sequence of zeros and ones.

Question 9 of 15

9. Question

Which of the following platforms can implement SQL queries?

Oracle
Aquafold
Microsoft SQL Server
MySQL

Question 10 of 15

10. Question

Portion in Microsoft SQL server management studio where you can edit the queries is known as

Results and messages tab
Object explorer
Query editor
Environment

Question 11 of 15

11. Question

Portion in Microsoft SQL server management studio where you can view the output of the queries is known as

Results and messages tab
Object explorer
Query editor
Environment

Question 12 of 15

12. Question

Portion in Microsoft SQL server management studio where you can view the output of the queries is known as

Results and messages tab
Object explorer
Query editor
Environment

Question 13 of 15

13. Question

Which of the following are part of data definition language ?

Drop
Create
Select
grant

Question 14 of 15

14. Question

DELETE falls under which category

data definition language
data manipulation language
data query language
data control language

Question 15 of 15

15. Question

SELECT falls under which category

data definition language
data manipulation language
data query language
data control language