1. In the relational model, cardinality is termed as:
(A) A number of tuples.
(B) A number of attributes.
(C) A number of tables.
(D) A number of constraints.
Ans: A
2. Relational calculus is a
(A) Procedural language.
(B) Non Procedural language.
(C) Data definition language.
(D) High-level language.
Ans: B
3. The view of total database content is
(A) Conceptual view.
(B) Internal view.
(C) External view.
(D) Physical View.
Ans: A
4. Cartesian product in relational algebra is
(A) a Unary operator.
(B) a Binary operator.
(C) a Ternary operator.
(D) not defined.
Ans: B
5. DML is provided for
(A) Description of the logical structure of a database.
(B) The addition of new structures in the database system.
(C) Manipulation & processing of the database.
(D) Definition of a physical structure of the database system.
Ans: C
6. ‘AS’ clause is used in SQL for
(A) Selection operation.
(B) Rename operation.
(C) Join operation.
(D) Projection operation.
Ans: B
7. ODBC stands for
(A) Object Database Connectivity.
(B) Oral Database Connectivity.
(C) Oracle Database Connectivity.
(D) Open Database Connectivity.
Ans: D
Q.8 Architecture of the database can be viewed as
(A) two levels.
(B) four levels.
(C) three levels.
(D) one level.
Ans: C
Q.9 In a relational model, relations are termed as
(A) Tuples.
(B) Attributes
(C) Tables.
(D) Rows.
Ans: C
Q.10 The database schema is written in
(A) HLL
(B) DML
(C) DDL
(D) DCL
Ans: C
Q.11 In the architecture of a database system external level is the
(A) physical level.
(B) logical level.
(C) conceptual level
(D) view level.
Ans: D
Q.12 An entity set that does not have sufficient attributes to form a primary key is a
(A) strong entity set.
(B) weak entity set.
(C) simple entity set.
(D) primary entity set.
Ans: B
Q.13 In Hierarchical model records are organised as
(A) Graph.
(B) List.
(C) Links.
(D) Tree.
Ans: D
Q.14 In an E-R diagram attributes are represented by
(A) rectangle.
(B) square.
(C) ellipse.
(D) triangle.
Ans: C
Q.15 In case of entity integrity, the primary key maybe
(A) not Null
(B) Null
(C) both Null & not Null.
(D) any value.
Ans: A
Q.16 In tuple relational calculus P1 ®P2 is equivalent to
(A) ¬P1 Ú P2
(B) P1 Ú P2
(C) P1 Ù P2
(D) P1 Ù¬P2
Ans: A
Q.17 The language used in application programs to request data from the DBMS is referred to as the
(A) DML
(B) DDL
(C) VDL
(D) SDL
Ans: A
Q.18 A logical schema
(A) is the entire database.
(B) is a standard way of organising information into accessible parts.
(C) describes how data is actually stored on disk.
(D) both (A) and (C)
Ans: A
Q.19 Related fields in a database are grouped to form a
(A) data file.
(B) data record.
(C) menu.
(D) bank.
Ans: B
Q.20 The database environment has all of the following components except:
(A) users.
(B) separate files.
(C) database.
(D) database administrator.
Ans: A.
Q 21. Which of the following queries cannot be expressed using the basic relational algebra
operations (U, -, x, π, σ, p)? (GATE CS 2000)
(a) Department address of every employee
(b) Employees whose name is the same as their department name
(c) The sum of all employees’ salaries
(d) All employees of a given department
Answer: (c)
Q 22. Given the following relation instance.
x y z
1 4 2
1 5 3
1 6 3
3 2 2
Which of the following functional dependencies are satisfied by the instance? (GATE CS 2000)
(a) XY -> Z and Z -> Y
(b) YZ -> X and Y -> Z
(c) YZ -> X and X -> Z
(d) XZ -> Y and Y -> X
Answer: (b)
23. Given relations r(w, x) and s(y, z), the result of
select distinct w, x
from r, s
is guaranteed to be same as r, provided (GATE CS 2000)
(a) r has no duplicates and s is non-empty
(b) r and s have no duplicates
(c) s has no duplicates and r is non-empty
(d) r and s have the same number of tuples
Answer: (a)
24. What do you mean by one to many relationship between Teacherand Class table?A. One class may have many teachers B. One teacher can have many classes C. Many classes may have many teachers D. Many teachers may have many classes Answer : One teacher can have many classes [Option : B] |
25.What are the different view to present a Table ?A. Datasheet View B. Design View C. Pivote TableView D. All Of Above Answer : All Of Above [Option : D] |
26. In one-to-many relationship the table on 'many' side is called _______A. Parent B. Child C. Sister D. Master Answer : Child [Option : B] |
27. In which state one gathers and list all the necessary fields forthe database design project.A. Data Definition B. Data Refinement C. Establishing Relationship D. None Of The Above Answer : Data Definition [Option : A] |
28. Which of the following enables us to view data from a tablebased on a specific criterionA. Form B. Query C. Macro D. Report Answer : Query [Option : B] |
29.Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is (GATE CS 2001)
a) dependency preserving and loss less join
b) loss less join but not dependency preserving
c) dependency preserving but not loss less join
d) not dependency preserving and not loss less join
Answer: (c)
30. Which database object is ideal to view, change, andanalyze datain different ways ?
Answer : Query [Option : C]
31. In one-to-many relationship the table in 'one' side is called _______A. Child B. Owner C. Parent D. Owner Answer : Parent [Option : C] |
32) Which of the following statements are TRUE about an SQL query?
P: An SQL query can contain a HAVING clause even if it does not a GROUP BY clause
Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause
R: All attributes used in the GROUP BY clause must appear in the SELECT clause
S: Not all attributes used in the GROUP BY clause need to apper in the SELECT clause
(A) P and R
(B) P and S
(C) Q and R
(D) Q and S
Answer (C)
33. Which data type allows alphanumeric characters and special symbolsto be entered?A. Text B. Memo C. Auto number D. Mixed Answer : Text [Option : A] |
34. It is used to establish an association between related tables.A. Line B. Relationship C. Primary Key D. Records Answer : Relationship [Option : B] |
35. This key that uniquely identifies each record is called :A. Primary Key B. Key Record C. Unique Key D. Field Name Answer : Primary Key [Option : A] |
36. Which name must be unique within a database ?A. Table B. Field C. Record D. Character Answer : Table [Option : A] |
37. Which level of RAID refers to disk mirroring with block striping?
a) RAID level 1
b) RAID level 2
c) RAID level 0
d) RAID level 3
38) Which of the following is TRUE?
(A) Every relation in 2NF is also in BCNF
(B) A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R
(C) Every relation in BCNF is also in 3NF
(D) No relation can be in both BCNF and 3NF
Answer (C)
39. A unit of storage that can store one or more records in a hash file organization is denoted as
a) Buckets
b) Disk pages
c) Blocks
d) Nodes
Answer: a
40. The third stage of designing a database is when we create___________ between tables
Answer : Relationship [Option : A]
41. Two tables can be linked with relationship to _____
Answer : Ensure data integrity [Option : B]
42. In a database Table, the each category of information Is called __________A. Tuple B. Field C. Record D. All Of Above Answer : Field [Option : B] |
43. Which of the following fields has width of 8 bytes?A. Memo B. Number C. Date/time D. Hyperlink Answer : Date/time [Option : C] |
44. The file organization which allows us to read records that would satisfy the join condition by using one block read is
a) Heap file organization
b) Sequential file organization
c) Clustering file organization
d) Hash file organization
45. What are the correct features of a distributed database?
a) Is always connected to the internet
b) Always requires more than three machines
c) Users see the data in one global schema.
d) Have to specify the physical location of the data when an update is done
46. which of the following is not a database object?A. Tables B. Queries C. Relationships D. Reports Answer : Relationships [Option : C] |
47. Consider the above tables A, B and C. How many tuples does the result of the following SQL query contains?
SELECT A.id
FROM A
WHERE A.age > ALL (SELECT B.age
FROM B
WHERE B. name = "arun")
(A) 4
(B) 3
(C) 0
(D) 1
Answer (B)
48. Which one is the guideline of Referential integrity in a relationship ?
Answer : Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table [Option : C]
49. Which of the following is not a database modelA. Network Database Model B. Relational Database Model C. Object Oriented Database Model D. None Answer : None [Option : D] |
50. The overall description of a database is called______.
Answer : Database schema [Option : C]
1 Comments
Nice guru ji
ReplyDelete