SQL, Databases

Question: Which component of an RDBMS validates the syntax of the user's query?
A
Query Parser

B
The Database Manager

C
Query Optimization

D
Database Administrator

Note: Not available
1. Report
Question: What does the term DDL stand for?
A
Data Description Language

B
Dynamic Data Language

C
Data Definition Language

D
Data Derived Language

E
Descriptive Data Language

Note: Not available
1. Report
Question: Which of the following can be used to uniquely identify a row?
A
Primary Key

B
Unique Key

C
Foreign Key

D
All of the above

Note: Not available
1. Report
Question: ________ is an operation that displays rows which meet a condition.
A
Restriction

B
Extraction

C
Projection

D
Intersection

E
Union

F
Minus

G
None of the above

Note: Not available
1. Report
Question: A table Students has a column called name which stores the names of the students. What will be the correct query to display the names of the students in reverse order?
A
Select name from students reverse;

B
Select name from students reverse name;

C
Select name from students order by name descending;

D
Select name from students order by name reverse;

E
Select name from students order by name desc;

F
Select desc name from students

G
Select reverse name from students;

Note: Not available
1. Report
Question: What items, other than column names can be included in the select clause?
A
Arithmetic expressions

B
Column aliases

C
Concatenated columns

D
None of the above

Note: Not available
1. Report
Question: Which of the following statements is true? (a)The Insert statement creates new rows (b)The Update statement modifies the table structure
A
only (a) is true

B
only (b) is true

C
both (a) and (b) are true

D
both (a) and (b) are false

Note: Not available
1. Report
Question: Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp
A
+

B
-

C
/

D
*

Note: Not available
1. Report
Question: What are the columns of a table called in a relational model?
A
Attributes

B
Rows

C
Tuples

D
Constraints

E
Keys

F
Indexes

G
Sets

H
Elements

Note: Not available
1. Report
Question: The level of data abstraction which describes how the data is actually stored is?
A
Physical level

B
Conceptual level

C
Storage level

D
File level

Note: Not available
1. Report

First Prev 1 2 3 4 Next Last

Question: Which component of an RDBMS validates the syntax of the user's query?

Question: What does the term DDL stand for?

Question: Which of the following can be used to uniquely identify a row?

Question: ________ is an operation that displays rows which meet a condition.

Question: A table Students has a column called name which stores the names of the students. What will be the correct query to display the names of the students in reverse order?

Question: What items, other than column names can be included in the select clause?

Question: Which of the following statements is true? (a)The Insert statement creates new rows (b)The Update statement modifies the table structure

Question: Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp

Question: What are the columns of a table called in a relational model?

Question: The level of data abstraction which describes how the data is actually stored is?