TRB-CS-VIP ONLINE COACHING CENTER ( TEST-4) *RDBMS Fundamentals*

TRB-CS-VIP ONLINE COACHING CENTER ( TEST-4) *RDBMS Fundamentals*

TRB-CS-VIP ONLINE COACHING CENTER ( TEST-4) *RDBMS Fundamentals*

Quiz

 

1. Director's Salary details are hidden from the employee, that is :
   1.   Physical level data Hiding
   2.   External level data hiding
   3.   Conceptual level Hiding
   4.   None of above
2. Which of the following is record based logical model(s)?
   1.   Relational Model
   2.   Network Model
   3.   Both (a) and (b)
   4.   E-R Model
3. The distinguishable parts of a record are called
   1.   fields
   2.   Data
   3.   files
   4.   All of above
4. . Embedded pointers provide
   1.   a secondary access path
   2.   a physical record key
   3.   an inverted index
   4.   all of above
5. Which database handles full text data, image, audio and video?
   1.   Video on demand database
   2.   Multimedia database
   3.   Transaction database
   4.   Graphics database
6. A data dictionary does not provide information about
   1.   who owns it
   2.   How the data is used
   3.   Where data is located
   4.   size of disk storage device
7. Data item characteristics that are important in data management include
   1.   Width
   2.   spelling
   3.   language
   4.   all of above
8. A schema describes
   1.   data elements
   2.   record & files
   3.   record relationships
   4.   all of the above
9. Data security threat include
   1.   Hardware failure
   2.   Privacy invasion
   3.   Fraudulent manipulation of data
   4.   All of above
10. Which language is used by most of dbms's for helping their users to access data?
    1.   Query languages
    2.   SQL
    3.   HLL
    4.   4GL
11. Which of the following is at highest level in the hierarchy of data organization?
    1.   Data File
    2.   Database
    3.   Data Bank
    4.   Data Record
12. The logical data structure with one to many relationship is a
    1.   Tree
    2.   Chain
    3.   Network
    4.   All of above
13. An entry in a telephone book can be compared to a
    1.   Record
    2.   Database
    3.   Field
    4.   File
14. Aggregate functions are functions that take a ___________ as input and return a single value.
    1.   Aggregate value
    2.   Collection of values
    3.   Single value
    4.   Both b & c
15. Select __________ from instructor where dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary ?
    1.   Avg(salary)
    2.   Mean(salary)
    3.   Count(salary)
    4.   Sum(salary)
16. All aggregate functions except _____ ignore null values in their input collection.
    1.   Sum
    2.   Count(attribute)
    3.   Count(*)
    4.   Avg
17. A Boolean data type that can take values true, false, and________ .
    1.   0
    2.   1
    3.   Null
    4.   Unknown
18. Select count (____ ID) from teaches where semester = ’Spring’ and year = 2010; If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
    1.   Distinct
    2.   Primary key
    3.   Count
    4.   Avg
19. The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.
    1.   In, not in
    2.   In, or
    3.   Not in, in
    4.   Or, in
20. We can test for the nonexistence of tuples in a subquery by using the _____ construct.
    1.   Exist
    2.   Exists
    3.   Not exist
    4.   Not exists
21. This set of Database Questions & Answers focuses on “SQL Data Types and Schemas” Dates must be specified in the format
    1.   yyyy/mm/dd
    2.   mm/dd/yy
    3.   yy/dd/mm
    4.   dd/mm/yy
22. . An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without s
    1.   Assertion
    2.   Reference
    3.   Timestamp
    4.   Index
23. Which of the following is used to store movie and image files ?
    1.   Clob
    2.   Blob
    3.   All of the above
    4.   None
24. The user defined data type can be created using
    1.   Create type
    2.   Create data
    3.   Create datatype
    4.   Create definetype
25. Values of one type can be converted to another domain using which of the following ?
    1.   Convert
    2.   Cast
    3.   Alter type
    4.   Drop type