Databases - Upwork

Question: What exactly is a Foreign key?
A
A Foreign key is a column or a set of columns that uniquely identifies rows in a table

B
A Foreign key checks the number of columns in a table which have non-null values

C
A Foreign key is used to match columns in other tables

D
A Foreign key checks the number of rows in a table which have non-null values

Note: Not available
1. Report
Question: Which of the following is not a relational operation?
A
Restriction

B
Extraction

C
Projection

D
Intersection

E
Union

Note: Not available
1. Report
Question: Which of the following statements regarding Trigger and Stored Procedures is correct?
A
Triggers are fired manually and Stored Procedures are fired automatically

B
Triggers can call Stored Procedures but Stored Procedures cannot call Triggers

C
Both Stored Procedures and Triggers can pass parameters

D
None of These

Note: Not available
1. Report
Question: A table of employees has the following values for its salary field: 10000, 11000, 12000, 10000, 14000, 12000, 13000, 10000, 14000, 10000 What will the following query return? Select distinct (salary) from employees
A
10000, 14000, 12000, 10000, 11000

B
10000, 11000, 12000, 10000, 14000, 12000

C
10000, 11000, 14000, 12000, 13000, 10000

D
10000, 11000, 12000, 13000, 10000, 14000

E
10000, 11000, 12000, 14000, 13000

Note: Not available
1. Report
Question: Which one of the following statements regarding "views" is incorrect?
A
A view is like a window through which data on tables can be viewed or changed

B
A view is stored as a select statement only

C
A view cannot be derived from another view

D
A view has no data of its own

Note: Not available
1. Report
Question: What will the following query do? Delete Orders
A
It will remove the Orders Table from the database

B
It will remove up to 1000 rows from the Orders Table

C
It will remove all rows from the Orders Table

D
It will remove all the rows as well as the indexes and constraints from the Orders Table

E
It will produce error on execution

Note: Not available
1. Report
Question: The - (Negative) and ~(Bitwise NOT) are examples of the _________ type of operators.
A
logical

B
arithmetical

C
assignment

D
unary

Note: Not available
1. Report
Question: You have a table "engineers" with the following table structure: enggid int(4) deptname varchar(50) salary int(4) You want to display the minimum and maximum salaries of the individual departments. Which of the following queries will fetch the desired results?
A
select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers

B
select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers group by deptname

C
select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers group by salary

D
select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers order by deptname

E
None of these

Note: Not available
1. Report
Question: Which of the following are correct?
A
With DDL, you can create and remove tables, schemas, domains, indexes and views

B
Select, Insert and Update are DCL commands

C
Grant and Revoke are DML commands

D
Commit and Rollback are DCL commands

Note: Not available
1. Report
Question: We have a table named "Customer" which has a column named "Customerid" having datatype Integer. We need to fetch the output with column title: 'Customer id is (value of customerid from the table)'. What will be the query?
A
Select 'Customer id is' + customerid From Customer

B
Select 'Customer id is' + CAST(customerid AS varchar) From Customer

C
Select 'Customer id is' + CAST(customerid AS integer) From Customer

D
Both

E
None of these

Note: Not available
1. Report

First Prev 61 62 63 64 65 Next Last

Question: What exactly is a Foreign key?

Question: Which of the following is not a relational operation?

Question: Which of the following statements regarding Trigger and Stored Procedures is correct?

Question: A table of employees has the following values for its salary field: 10000, 11000, 12000, 10000, 14000, 12000, 13000, 10000, 14000, 10000 What will the following query return? Select distinct (salary) from employees

Question: Which one of the following statements regarding "views" is incorrect?

Question: What will the following query do? Delete Orders

Question: The - (Negative) and ~(Bitwise NOT) are examples of the _________ type of operators.

Question: You have a table "engineers" with the following table structure: enggid int(4) deptname varchar(50) salary int(4) You want to display the minimum and maximum salaries of the individual departments. Which of the following queries will fetch the desired results?

Question: Which of the following are correct?

Question: We have a table named "Customer" which has a column named "Customerid" having datatype Integer. We need to fetch the output with column title: 'Customer id is (value of customerid from the table)'. What will be the query?