Databases - Upwork

Question: Which of the following statements regarding views are incorrect?
A
A view is like a window through which data on tables can be viewed or changed

B
A view is derived from another table

C
A view cannot be derived from another view

D
A view is stored as a select statement only

E
A view has no data of its own

F
A view is another name for a table

Note: Not available
1. Report
Question: Consider the following tables: Books ------ BookId BookName AuthorId SubjectId PopularityRating (the popularity of the book on a scale of 1 to 10) Language (such as French, English, German etc) Subjects --------- SubjectId Subject (such as History, Geography, Mathematics etc) Authors -------- AuthorId AuthorName Country What is the query to determine the names of the Authors who have written more than 1 book?
A
select AuthorName from Authors where AuthorId in (select AuthorId from Books group by AuthorId having count(*)>1)

B
select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId and count(BookId)>1

C
select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId group by AuthorName having count(*)>1

D
select AuthorName from Authors where AuthorId in (select AuthorId from Books having count(BookId)>1)

Note: Not available
1. Report
Question: When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?
A
Removes all rows from the table

B
Drops all the table's indexes

C
Removes all dependent views

D
Removes all dependent procedures

Note: Not available
1. Report
Question: Which of the following statement is correct regarding table creation?
A
Tables once created cannot be modified to add columns

B
Constraints can only be given while table creation

C
One can easily create a table from a given table

D
When a table is created from another table, all the constraints are copied as well

E
The width of the columns cannot be modified

F
Columns cannot be removed from a table

Note: Not available
1. Report
Question: A production house has two sales outlets. Both outlets are maintaining their data separately in schemas A and B respectively. The Management wants to see the sale of both outlets in one report. Both outlets are using tables called Sales which have identical structure. Which method you will adopt to create the report?
A
Select * from A.Sales join B.Sales

B
Select * from A.Sales union all B.Sales

C
Select * from A.Sales, B.Sales

D
None of the above

Note: Not available
1. Report
Question: What are the programs that execute automatically whenever DML operations are performed on tables called?
A
Triggers

B
Procedures

C
Functions

D
None of the above

Note: Not available
1. Report
Question: Which of the following is not a type of constraint?
A
Primary key

B
Unique

C
Check

D
Distinct

E
Default

Note: Not available
1. Report
Question: Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?
A
Names starting with "a"

B
Names containing "a" as the second letter

C
Names starting with "a" or "A"

D
Names containing "a" as any letter except the first

Note: Not available
1. Report
Question: A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?
A
select * from orders where sum(amount) > 20000

B
select orderdate, sum(amount) from orders where sum(amount) > 20000 order by OrderDate

C
select orderdate, sum(amount) from orders group by orderdate having sum(amount) > 20000

D
select orderdate, sum(amount) from orders group by OrderDate where sum(amount) > 20000

Note: Not available
1. Report
Question: Which character function should be used to return a specified portion of a character string?
A
CONCAT

B
LENGTH

C
SUBSTR

D
INITCAP

Note: Not available
1. Report

First Prev 28 29 30 31 32 Next Last

Question: Which of the following statements regarding views are incorrect?

Question: When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?

Question: Which of the following statement is correct regarding table creation?

Question: What are the programs that execute automatically whenever DML operations are performed on tables called?

Question: Which of the following is not a type of constraint?

Question: Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?

Question: A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?

Question: Which character function should be used to return a specified portion of a character string?