Databases - Upwork

Question: Select all the appropriate options.
A
A table is a multiset of rows

B
A table is a two-dimensional array of rows and columns

C
A table is always dependent on other tables

D
A third normal form table is a table free of redundant data

E
A table must have a primary key

Note: Not available
1. Report
Question: Which of the following field names are correct?
A
EmpNo

B
25Block

C
#AccountID

D
_CustomerName

E
Product.Name

Note: Not available
1. Report
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

First Prev 26 27 28 29 30 Next Last

Question: Select all the appropriate options.

Question: Which of the following field names are correct?

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