Recent questions tagged sql

386 views

Rahul Jain25 asked Oct 5, 2016

1 votes

0 answers

366

Databse test

320 views

Rahul Jain25 asked Oct 5, 2016

1 votes

3 answers

367

Database test

1.6k views

Rahul Jain25 asked Oct 5, 2016

3 votes

1 answer

368

Cardinality of a table

UGC NET CSE | August 2016 | Part 3 | Question: 11
Consider the following ORACLE relations : One $(x, y) = {, , , , , }$ Two $(x, y) = {, , , , , , , }$ Consider the following two $SQL$ queries $SQ1$ and $SQ2$ : SQ1 : SELECT * FROM One) EXCEPT (SELECT ... ) of the result obtained when applied to the instances above ? 2 and 1 respectively 1 and 2 respectively 2 and 2 respectively 1 and 1 respectively

4.2k views

Rahul Jain25 asked Oct 4, 2016

2 votes

1 answer

369

Consider the following ORACLE relations : One $(x, y) = {, , , , , }$ Two $(x, y) = {, , , , , , , }$ Consider the following two $SQL$ queries $SQ1$ and $SQ2$ :SQ1 : ...

UGC NET CSE | August 2016 | Part 2 | Question: 20
Consider a database table $R$ with attributes $A$ and $B$. Which of the following $SQL$ queries is illegal ? SELECT A FROM R; SELECT A, COUNT(*) FROM R; SELECT A, COUNT(*) FROM R GROUP BY A; SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

838 views

makhdoom ghaya asked Sep 30, 2016

1 votes

1 answer

370

Consider a database table $R$ with attributes $A$ and $B$. Which of the following $SQL$ queries is illegal ?SELECT A FROM R;SELECT A, COUNT(*) FROM R;SELECT A, COUNT(*) F...

sql query
Consider the following table Mystery Mystery A B 1 Null 2 4 3 5 Null 6 select count() from Mystery where A not in( select B from Mystery) (A) 1 (B) 0 (C) 4 (D) 3 ans is B given please explain how??

1.7k views

makhdoom ghaya asked Sep 24, 2016

6 votes

1 answer

371

Consider the following table MysteryMysteryAB1Null2435Null6select count() from Mysterywhere A not in( select B from Mystery)(A) 1(B) 0(C) 4(D) 3ans is B givenplease expla...

indrajeet

790 views

indrajeet asked Sep 22, 2016

4 votes

3 answers

372

Sql Query
Let R(a,b) be a schema and Q1 and Q2 are queries on R. Q1: SELECT * FROM R; Q2: (SELECT * FROM R) INTERSECT (SELECT * FROM R); Which of the following statements is true? (A) Q1 and Q2 produce the same answer. (B) The answer to Q1 is always ... The answer to Q2 is always contained in the answer to Q1. (D) Q1 and Q2 produce different answers. ans = C given please explain the logic behind

Let R(a,b) be a schema and Q1 and Q2 are queries on R.Q1: SELECT * FROM R;Q2: (SELECT * FROM R) INTERSECT (SELECT * FROM R);Which of the following statements is true?(A) ...

indrajeet

2.2k views

indrajeet asked Sep 22, 2016

4 votes

1 answer

373

Which of the following statements are TRUE/FALSE?
Which of the following statements are TRUE/FALSE? S1: SQL permits attributes names to be repeated in the same relation S2: The power of DRC and TRC is same as that of relational algebra S3: The project operation (pi) cometimes only distributes over join ... (D) <T,F,T> Sol. I dont understand what it is meant by S3. I feel first two are false.

Which of the following statements are TRUE/FALSE?S1: SQL permits attributes names to be repeated in the same relationS2: The power of DRC and TRC is same as that of relat...

GateAspirant999

2.3k views

GateAspirant999 asked Sep 15, 2016

1 votes

1 answer

374

UGC NET CSE | June 2010 | Part 2 | Question: 20
The PROJECT Command will create new table that has More fields than the original table More rows than original table Both (A) & (B) None of these

The PROJECT Command will create new table that hasMore fields than the original tableMore rows than original tableBoth (A) & (B)None of these

UGC NET CSE | June 2010 | Part 2 | Question: 19
Which data management language component enabled the DBA to define the schema components ? DML Sub-schema DLL Schema DLL All of these

2.1k views

makhdoom ghaya asked Sep 15, 2016

0 votes

1 answer

375

Which data management language component enabled the DBA to define the schema components ?DMLSub-schema DLLSchema DLLAll of these

UGC NET CSE | December 2011 | Part 2 | Question: 25
The $SQL$ Expression Select distinct $T$. branch name from branch $T$, branch $S$ where $T$. assets $> S$. assets and $S$. branch-city = DELHI, finds the name of All branches that have greater asset than any branch ... in DELHI. The branch that has the greatest asset in DELHI. Any branch that has greater asset than any branch located in DELHI.

2.5k views

makhdoom ghaya asked Sep 15, 2016

0 votes

4 answers

376

#sql #dbms

saket nandan

528 views

saket nandan asked Sep 6, 2016

3 votes

2 answers

377

The $SQL$ Expression Select distinct $T$. branch name from branch $T$, branch $S$ where $T$. assets $ S$. assets and $S$. branch-city = DELHI, finds the name ofAll branch...

UGC NET CSE | December 2011 | Part 2 | Question: 24
Which of the following statements is true, when structure of database file with 20 records is modified ? ? EOF ( ) Prints. T ? BOF ( ) Prints F ? BOF ( ) Prints T ? EOF ( ) Prints F

2.6k views

makhdoom ghaya asked Aug 17, 2016

2 votes

1 answer

378

Which of the following statements is true, when structure of database file with 20 records is modified ?? EOF ( ) Prints. T? BOF ( ) Prints F? BOF ( ) Prints T? EOF ( ) P...

UGC NET CSE | December 2011 | Part 2 | Question: 22
Which command classes text file, which has been created using "SET ALTERNATIVE" "Command" ? SET ALTERNATE OFF CLOSE DATABASE CLOSE ALTERNATE CLEAR ALL

1.5k views

makhdoom ghaya asked Aug 17, 2016

1 votes

0 answers

379

Which command classes text file, which has been created using "SET ALTERNATIVE" "Command" ?SET ALTERNATE OFFCLOSE DATABASECLOSE ALTERNATECLEAR ALL

UGC NET CSE | December 2011 | Part 2 | Question: 21
What deletes the entire file except the file structure ? ERASE DELETE ZAP PACK

1.3k views

makhdoom ghaya asked Aug 17, 2016

3 votes

2 answers

380

What deletes the entire file except the file structure ?ERASEDELETEZAPPACK

UGC NET CSE | June 2016 | Part 3 | Question: 11
Consider the following ORACLE relations: R(A, B, C)={<1, 2, 3>, <1, 2, 0>, <1, 3, 1>, <6, 2, 3>, <1, 4, 2>, <3, 1, 4>} S(B, C, D)={<2, 3, 7>, <1, 4, 5>, <1, 2, 3>, <2, 3, ... of tuples returned by SQ$_1$ and If N is the number of tuples returned by SQ$_2$ then M=4, N=2 M=5, N=3 M=2, N=2 M=3, N=3

3.8k views

makhdoom ghaya asked Aug 17, 2016

5 votes

4 answers

381

Consider the following ORACLE relations:R(A, B, C)={<1, 2, 3>, <1, 2, 0>, <1, 3, 1>, <6, 2, 3>, <1, 4, 2>, <3, 1, 4>}S(B, C, D)={<2, 3, 7>, <1, 4, 5>, <1, 2, 3>, <2, 3, 4...

UGC NET CSE | June 2016 | Part 2 | Question: 19
Consider the following two comments C1 and C2 on the relation R from an SQL database: C1 : drop table R; C2 : delete from R Both C1 and C2 delete the schema R C2 retains relation R, but delets all tuples in R C1 deletes not only all tuples, but also the schema for R I only I and II only II and III only I, II and III only

5.5k views

go_editor asked Aug 17, 2016

3 votes

1 answer

382

Consider the following two comments C1 and C2 on the relation R from an SQL database: C1 : drop table R;C2 : delete from RBoth C1 and C2 delete the schema RC2 retains rel...

UGC NET CSE | June 2016 | Part 2 | Question: 18
In a relational database model, NULL values canbe used for all but which one of the following? To allow duplicate tuples in the table by filling the primary key column(s) with NULL To avoid confusion with actual legitimate data ... is unknown To fill a column in a tuple when that column does not really "exist" for that particular tuple

2.8k views

go_editor asked Aug 14, 2016

4 votes

1 answer

383

In a relational database model, NULL values canbe used for all but which one of the following?To allow duplicate tuples in the table by filling the primary key column(s) ...

UGC NET CSE | June 2016 | Part 2 | Question: 16
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: Referential integrity Multi-valued dependency Entity integrity Functional dependency

4.8k views

go_editor asked Aug 14, 2016

4 votes

1 answer

384

In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:Referential integrityMulti-valued dependencyEntity integrityFunctional dependency

UGC NET CSE | December 2015 | Part 3 | Question: 61
Consider the following three SQL queries (Assume the data in the people table): Select Name from people where $\text{Age}>21$; Select Name from people where $\text{Height}>180$; Select Name from people where $(\text{Age}>21)$ ... respectively, then what is one possible number of rows returned by the SQL query $c$? $3$ $7$ $10$ $21$

2.6k views

go_editor asked Aug 14, 2016

2 votes

3 answers

385

Consider the following three SQL queries (Assume the data in the people table):Select Name from people where $\text{Age}>21$;Select Name from people where $\text{Height}>...

UGC NET CSE | December 2015 | Part 3 | Question: 60
Suppose ORACLE relation $R(A,B)$ currently has tuples $\{(1,2), (1,3), (3,4)\}$ and relation $S(B,C)$ currently has $\{(2,5), (4,6), (7,8)\}$.Consider the following two SQL queries SQ1 and SQ2: SQ1: Select * From R ... SQL query SQ2 are given by: $2$ and $6$ respectively $6$ and $2$ respectively $2$ and $4$ respectively $4$ and $2$ respectively

5.1k views

go_editor asked Aug 11, 2016

2 votes

2 answers

386

Suppose ORACLE relation $R(A,B)$ currently has tuples $\{(1,2), (1,3), (3,4)\}$ and relation $S(B,C)$ currently has $\{(2,5), (4,6), (7,8)\}$.Consider the following two S...

UGC NET CSE | December 2015 | Part 2 | Question: 13
Consider a "CUSTOMERS" database table having a column "CITY" filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have "GAR" somewhere in its name ... * from customers where city like '%GAR%'; D. select * from customers where city as'%GAR';

7.8k views

go_editor asked Aug 11, 2016

1 votes

1 answer

387

Consider a "CUSTOMERS" database table having a column "CITY" filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that...

UGC NET CSE | Junet 2015 | Part 3 | Question: 8
The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT_Name). COnsider the following SQL Query: SELECT DEPT_Name from STUDENT where SEX='M' group by DEPT_Name having avg(Marks)> ... the university The average marks of Male students is more than the average marks of male students in the university

2.4k views

go_editor asked Aug 8, 2016

2 votes

1 answer

388

The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT_Name). COnsider the following SQL Query:SELECT DEPT_Name from STUDENT where...

UGC NET CSE | Junet 2015 | Part 2 | Question: 18
Drop Table cannot be used to drop a Table referenced by _______ constraint Primary key Sub key Super key Foreign key a a, b and c d a and d

3.1k views

go_editor asked Jul 31, 2016

1 votes

1 answer

389

Drop Table cannot be used to drop a Table referenced by _______ constraintPrimary keySub keySuper keyForeign keyaa, b and cda and d

UGC NET CSE | Junet 2015 | Part 2 | Question: 16
An Assertion is predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is: CREATE ASSERTION 'ASSERTION Name' CHECK 'Predicate' CREATE ASSERTION 'ASSERTION Name' CREATE ASSERTION, CHECK 'Predicate' SELECT ASSERTION

2.6k views

go_editor asked Jul 30, 2016

2 votes

1 answer

390

An Assertion is predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is:CREATE ASSERTION 'ASSERTION Name' CHECK 'Predicat...