SQL, Databases

Question: A table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: Select distinct(department) from employees;
A
marketing, production, sales

B
marketing, production, sales, NULL

C
marketing, production, sales, NULL, NULL

D
marketing, production, sales, NULL, Marketing

E
marketing, production, sales, NULL, NULL, Marketing

Note: Not available
1. Report
Question: Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005 ?
A
select * from Pers where joining_date from '1/1/2005' to '1/2/2005', job='Analyst' or 'Clerk' or 'Salesman'

B
select * from Pers where joining_date between '1/1/2005' to '1/2/2005', job='Analyst' or job='Clerk' or job='Salesman'

C
select * from Pers where joining_date between '1/1/2005' and '1/2/2005' and (job='Analyst' or 'Clerk' or 'Salesman')

D
None of these above

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 which Authors have written at least 1 book with a popularity rating of less than 5?
A
select authorname from authors where authorid in (select authorid from books where popularityrating<5)

B
select authorname from authors where authorid in (select authorid from books where popularityrating<=5)

C
select authorname from authors where authorid in (select BookId from books where popularityrating<5)

D
select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5))

Note: Not available
1. Report
Question: Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in descending order of the CurrentStock column.
A
Select * from Products order by CurrentStock,ProductGroup

B
Select * from Products order by CurrentStock DESC,ProductGroup

C
Select * from Products order by ProductGroup,CurrentStock

D
Select * from Products order by ProductGroup,CurrentStock DESC

E
None of these above

Note: Not available
1. Report
Question: Which of the following statements are incorrect regarding definition of simple and complex views?
A
A simple view is one which derives data from only one table

B
A simple view is one which contains no functions or groups of data

C
A complex view is one which derives data from many tables

D
A complex view is one which may contain functions

E
A complex view cannot contain groups of data

F
A complex view is a combination of more than one simple view

G
A table can either have a simple or complex view, not both

Note: Not available
1. Report
Question: What is a cluster?
A
Group of users

B
Group of indexes

C
Method of storing tables that are intimately related and often joined together into the same area of the disk

D
Compressed datafile

E
Segment of a partitioned table

F
Group of constraints

G
Group of databases

H
Group of roles

Note: Not available
1. Report
Question: The purpose of the domain is to constrain the set of valid values. True or false?
A
True

B
False

Note: Not available
1. Report
Question: Consider the following two tables: 1. customers( customer_id, customer_name) 2. branch ( branch_id, branch_name ) What will be the output if the following query is executed: Select *, branch_name from customers, branch
A
It will return the fields customer_id, customer_name, branch_name with a cartesian join

B
It will return the fields customer_id, customer_name, branch_id, branch_name with a cartesian join

C
It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name with a cartesian join

D
It will return an empty set since the two tables do not have any common field name

E
It will return an error since * should be for queries involving one table only

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

First Prev 7 8 9 10 Next Last

Question: A table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: Select distinct(department) from employees;

Question: Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005 ?

Question: Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in descending order of the CurrentStock column.

Question: Which of the following statements are incorrect regarding definition of simple and complex views?

Question: What is a cluster?

Question: The purpose of the domain is to constrain the set of valid values. True or false?

Question: Consider the following two tables: 1. customers( customer_id, customer_name) 2. branch ( branch_id, branch_name ) What will be the output if the following query is executed: Select *, branch_name from customers, branch

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.