Recent questions tagged databases

6 votes

4 answers

2311

Normalization
Which of the following normal forms has dependency-preserving property? a) 1NF b) 2NF c) 3NF d) BCNF

Which of the following normal forms has dependency-preserving property?a) 1NFb) 2NFc) 3NFd) BCNF

10.3k views

Shyam Singh 1 asked Sep 4, 2016

2 votes

3 answers

2312

doubt | ER Diagram
wat does arrow represent in er diagram when can we many to one or one to many by seeing arrows

wat does arrow represent in er diagramwhen can we many to one or one to many by seeing arrows

__

2.1k views

__ asked Sep 2, 2016

1 votes

1 answer

2313

UGC NET CSE | June 2011 | Part 2 | Question: 33
Which of the following permanent database that has an entry for each terminal symbol ? Literal table Identifier table Terminal table Source table

Which of the following permanent database that has an entry for each terminal symbol ?Literal tableIdentifier tableTerminal tableSource table

1.5k views

makhdoom ghaya asked Aug 30, 2016

2 votes

3 answers

2314

UGC NET CSE | June 2011 | Part 2 | Question: 20
Decomposition help in eliminating some of the problems of bad design Redundancy Inconsistencies Anomalies All of the above

Decomposition help in eliminating some of the problems of bad designRedundancyInconsistenciesAnomaliesAll of the above

2.4k views

makhdoom ghaya asked Aug 23, 2016

3 votes

2 answers

2315

UGC NET CSE | June 2011 | Part 2 | Question: 19
A transaction can include following basic database access operations : Read_item(X) Write_item(X) Both (A) and (B) None of these

A transaction can include following basic database access operations :Read_item(X)Write_item(X)Both (A) and (B)None of these

1.5k views

makhdoom ghaya asked Aug 23, 2016

2 votes

2 answers

2316

UGC NET CSE | June 2011 | Part 2 | Question: 18
The basic variants of time-stampbased method of concurrency control are Total time stamp-ordering Partial time stamp ordering Multiversion Time stamp ordering All of the above

The basic variants of time-stampbased method of concurrency control areTotal time stamp-orderingPartial time stamp orderingMultiversion Time stamp orderingAll of the abov...

1.3k views

makhdoom ghaya asked Aug 23, 2016

2 votes

3 answers

2317

UGC NET CSE | June 2011 | Part 2 | Question: 17
Which of the following is the process by which a user’s privileges ascertained ? Authorization Authentication Access Control None of these

Which of the following is the process by which a user’s privileges ascertained ?AuthorizationAuthenticationAccess ControlNone of these

2.4k views

makhdoom ghaya asked Aug 23, 2016

2 votes

2 answers

2318

UGC NET CSE | June 2011 | Part 2 | Question: 16
Which of the following is the recovery management technique in DDBMS ? 2PC (Two Phase Commit) Backup Immediate update All of the above

Which of the following is the recovery management technique in DDBMS ?2PC (Two Phase Commit)BackupImmediate updateAll of the above

2.9k views

makhdoom ghaya asked Aug 23, 2016

0 votes

2 answers

2319

Which Tuple Relation calculus query is correct?
Schema student (rollNo, name, degree, year, sex, deptNo, advisor) course (courseId, cname, credits, deptNo) enrollment (rollNo, courseId, sem, year, grade) Obtain the names of courses enrolled by student named Mahesh {c.name | course(c) ^ (∃s) (∃e ... (s) ^ c.courseId = e.courseId ^ e.rollNo = s.rollNo ^ s.name = "Mahesh" } Are both correct?

Schemastudent (rollNo, name, degree, year, sex, deptNo, advisor)course (courseId, cname, credits, deptNo)enrollment (rollNo, courseId, sem, year, grade)Obtain the names o...

GateAspirant999

1.1k views

GateAspirant999 asked Aug 21, 2016

3 votes

3 answers

2320

UGC NET CSE | June 2016 | Part 3 | Question: 39
Which of the following statements is correct? Aggregation is a strong type of association between two classes with full ownership Aggregation is a strong type of association between two classes with partial ownership Aggregation is ... two classes with partial ownership Aggregation is a weak type of association between two classes with full ownership

Which of the following statements is correct?Aggregation is a strong type of association between two classes with full ownershipAggregation is a strong type of associatio...

2.3k views

go_editor asked Aug 20, 2016

3 votes

2 answers

2321

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.

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...

2.6k views

makhdoom ghaya asked Aug 17, 2016

2 votes

1 answer

2322

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

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...

1.5k views

makhdoom ghaya asked Aug 17, 2016

2 votes

3 answers

2323

UGC NET CSE | December 2011 | Part 2 | Question: 23
Data security threats include Privacy invasion Hardware failure Fraudulent manipulation of data Encryption and decryption

Data security threats includePrivacy invasionHardware failureFraudulent manipulation of dataEncryption and decryption

2.5k views

makhdoom ghaya asked Aug 17, 2016

1 votes

0 answers

2324

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

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

1.3k views

makhdoom ghaya asked Aug 17, 2016

3 votes

2 answers

2325

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

What deletes the entire file except the file structure ?ERASEDELETEZAPPACK

3.8k views

makhdoom ghaya asked Aug 17, 2016

5 votes

4 answers

2326

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

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...

5.5k views

go_editor asked Aug 17, 2016

1 votes

3 answers

2327

UGC NET CSE | June 2016 | Part 3 | Question: 10
Which of the following statements is true? $D_1$: The decomposition of the schema R(A, B, C) into R$_1$(A,B) and R$_2$(A,C) is always lossless $D_2$: The decomposition of the schema R(A, B, C, D, E) having AD $\rightarrow$ B, C $\rightarrow$ DE ... and R$_2$(A, C, C, D, E) is lossless Both $D_1$ and $D_2$ Neither $D_1$ nor $D_2$ Only $D_1$ Only $D_2$

Which of the following statements is true?$D_1$: The decomposition of the schema R(A, B, C) into R$_1$(A,B) and R$_2$(A,C) is always lossless$D_2$: The decomposition of t...

4.0k views

go_editor asked Aug 17, 2016

3 votes

2 answers

2328

UGC NET CSE | June 2016 | Part 3 | Question: 9
Consider the relations $R(A, B)$ and $S(B, C)$ and the following four relational algebra queries over R ans S $\pi_{A, B} (R \bowtie S)$ $R \bowtie \pi_B(S)$ $R \cap (\pi_A(R) \times \pi_B (S))$ ... III and IV are the same query II, III and IV are the same query I, II and IV are the same query I, II and III are the same query

Consider the relations $R(A, B)$ and $S(B, C)$ and the following four relational algebra queries over R ans S$\pi_{A, B} (R \bowtie S)$$R \bowtie \pi_B(S)$$R \cap (\pi_A(...

5.7k views

go_editor asked Aug 17, 2016

7 votes

2 answers

2329

UGC NET CSE | June 2016 | Part 2 | Question: 20
Consider the following database table having $\text{A, B, C}$ and $\text{D}$ as its four attributes and four possible candidate keys $\text{(I, II, III and IV)}$ ... ? $\text{I}$ and $\text{III}$ only $\text{III}$ and $\text{IV}$ only $\text{II}$ only $\text{I}$ only

Consider the following database table having $\text{A, B, C}$ and $\text{D}$ as its four attributes and four possible candidate keys $\text{(I, II, III and IV)}$ for this...

6.6k views

go_editor asked Aug 16, 2016

3 votes

1 answer

2330

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

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...

2.8k views

go_editor asked Aug 14, 2016

4 votes

1 answer

2331

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

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) ...

4.8k views

go_editor asked Aug 14, 2016

4 votes

2 answers

2332

UGC NET CSE | June 2016 | Part 2 | Question: 17
Which of the following statement(s) is/are FALSE in the context of Relational DBMS? Views in a database system are important because they with access control by aloowing users to see only a particular subset of the data in the databse E-R diagrams are ... SQL is a procedural language I and IV only III and IV only I, II and III only II, III and IV only

Which of the following statement(s) is/are FALSE in the context of Relational DBMS?Views in a database system are important because they with access control by aloowing u...

4.9k views

go_editor asked Aug 14, 2016

4 votes

1 answer

2333

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

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

2.6k views

go_editor asked Aug 14, 2016

2 votes

2 answers

2334

UGC NET CSE | December 2015 | Part 3 | Question: 63
Consider the following three tables $R, S$ and $T.$ In this question, all the join operations are natural joins $(\bowtie )$. $(\pi )$ ... (a) (b) (c) (d)

Consider the following three tables $R, S$ and $T.$ In this question, all the join operations are natural joins $(\bowtie )$. $(\pi )$ is the projection operation of a re...

4.2k views

go_editor asked Aug 11, 2016

2 votes

3 answers

2335

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$

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}>...

5.1k views

go_editor asked Aug 11, 2016

2 votes

2 answers

2336

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

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...

7.8k views

go_editor asked Aug 11, 2016

1 votes

1 answer

2337

UGC NET CSE | December 2015 | Part 3 | Question: 58
Which of the following statements regarding the features of the object-oriented approach to databases are true? The ability to develop more realistic models of the real world The ability to represent the world in a non-geometric way The ability to develop databases using ... $\text{ii, iii and iv}$ $\text{i, iv, and v}$ $\text{iii, iv, and v}$

Which of the following statements regarding the features of the object-oriented approach to databases are true?The ability to develop more realistic models of the real wo...

4.2k views

go_editor asked Aug 11, 2016

1 votes

1 answer

2338

UGC NET CSE | December 2015 | Part 2 | Question: 19
A data which improves the performance and accessibility of the database are called: Indexes User Data Application Metadata Data Dictionary

A data which improves the performance and accessibility of the database are called:IndexesUser DataApplication MetadataData Dictionary

2.4k views

go_editor asked Aug 8, 2016

3 votes

1 answer

2339

UGC NET CSE | December 2015 | Part 2 | Question: 18
Which of the following provides the best description of an entity type? A specific concrete object with a defined set of processes (e.g. Jatin with diabetes) A value given to a particular attribute (e.g. height - 230 cm) A thing ... it may exist A template for a group of things with the same set of characteristics that may exist in the real world

Which of the following provides the best description of an entity type?A specific concrete object with a defined set of processes (e.g. Jatin with diabetes)A value given ...

2.6k views

go_editor asked Aug 8, 2016

1 votes

1 answer

2340

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';

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...

2.4k views

go_editor asked Aug 8, 2016

Page:

« prev
1
...
73
74
75
76
77
78
79
80
81
82
83
...
97
next »