Databases - Upwork

Question: With regard to statement (a) and statement (b), Which of the following option is correct. (a)The FLOOR function returns the smallest integer greater or equal to the argument. (b)The CEIL function gives the largest integer equal to or less that the argument.
A
is true

B
is true

C
both (a) and (b) are true

D
both (a) and (b) are false

Note: Not available
1. Report
Question: The Employee table uses alphanumeric characters for their Employee ID field, which contains 7 digits prefixed with 3 characters. The alphanumeric characters refer to the department code. You want to generate a list of all the department codes displayed in capital letters. Which function(s) you will use for this query?
A
CONCAT()

B
SUBSTR()

C
UPPER()

D
LOWER()

E
REPLACE()

Note: Not available
1. Report
Question: Which of the following is not a SQL operator?
A
Between..and..

B
Like

C
In

D
Is null

E
Having

F
Not in

Note: Not available
1. Report
Question: Which of the following is not a feature of SQL?
A
SQL is a non-procedural language

B
SQL processes sets of records rather than a single record at a time

C
SQL can be used by a range of users including DBA's, application programmers, management personnel and many other types of end users

D
Procedures and functions can be written with SQL

E
SQL provides commands for a variety of tasks including querying data and inserting, updating and deleting data

F
SQL can retrieve data from more than one table

Note: Not available
1. Report
Question: How can data be accessed by users who do not have direct access to the tables?
A
By creating views

B
By creating triggers

C
By creating stored procedures

D
None of these above

Note: Not available
1. Report
Question: The simplest query must include at least________ and _________.
A
A select clause

B
A where clause

C
A from clause

D
A group by clause

E
A having clause

F
An order by clause

Note: Not available
1. Report
Question: Every Boyce-Codd Normal Form(BCNF)is in:
A
First Normal Form

B
Second Normal Form

C
Third Normal Form

D
None of the above

Note: Not available
1. Report
Question: Identify the incorrect statement/s regarding constraints.
A
A primary key constraint can be disabled

B
Information about the constraints on a table can be retrieved from the data dictionary

C
Information about the columns on which the constraints have been applied can be retrieved from the data dictionary

D
There can be only one unique key in a table

E
If a column has null values then the not null constraint cannot be applied to that column

F
There can be more than one primary key

Note: Not available
1. Report
Question: Which of the following is not the benefits of views?
A
Restricting access to database

B
Allowing users to make simple queries to retrieve the results from complicated queries

C
Providing data independence for adhoc users and application programs

D
Faster retrieval of records

E
Views allow the same data to be seen by different users in different ways

Note: Not available
1. Report
Question: _________ is the operation that displays certain columns from the table.
A
Restriction

B
Intersection

C
Join

D
Union

E
Projection

F
Selection

G
Extraction

H
SubQuery

Note: Not available
1. Report

First Prev 34 35 36 37 38 Next Last

Question: With regard to statement (a) and statement (b), Which of the following option is correct. (a)The FLOOR function returns the smallest integer greater or equal to the argument. (b)The CEIL function gives the largest integer equal to or less that the argument.

Question: Which of the following is not a SQL operator?

Question: Which of the following is not a feature of SQL?

Question: How can data be accessed by users who do not have direct access to the tables?

Question: The simplest query must include at least and _.

Question: Every Boyce-Codd Normal Form(BCNF)is in:

Question: Identify the incorrect statement/s regarding constraints.

Question: Which of the following is not the benefits of views?

Question: _________ is the operation that displays certain columns from the table.

Question: With regard to statement (a) and statement (b), Which of the following option is correct. (a)The FLOOR function returns the smallest integer greater or equal to the argument. (b)The CEIL function gives the largest integer equal to or less that the argument.

Question: Which of the following is not a SQL operator?

Question: Which of the following is not a feature of SQL?

Question: How can data be accessed by users who do not have direct access to the tables?

Question: The simplest query must include at least________ and _________.

Question: Every Boyce-Codd Normal Form(BCNF)is in:

Question: Identify the incorrect statement/s regarding constraints.

Question: Which of the following is not the benefits of views?

Question: _________ is the operation that displays certain columns from the table.

Question: The simplest query must include at least and _.