• Breaking News

    Sunday, 31 July 2016

    Computer Awareness (Advance Level-DBMS) for Upcoming Latest Bank Jobs

    Q.1 ODBC stands for _________.
    (1) Object Database Connectivity
    (2) Oral Database Connectivity
    (3) Oracle Database Connectivity
    (4) Open Database Connectivity

    Q.2 In an E-R diagram attributes are represented by _________.
    (1) rectangle
    (2) square
    (3) ellipse
    (4) triangle

     


    Q.3 A DBMS query language is designed to _________.
    (1) support end users who use English-like commands
    (2) support in the development of complex applications software
    (3) specify the structure of a database
    (4) all of the above

    Q.4 SET concept is used in_________.
    (1) Network Model
    (2) Hierarchical Model
    (3) Relational Model
    (4) None of these

    Q.5 The full form of DDL is _________.
    (1) Dynamic Data Language
    (2) Detailed Data Language
    (3) Data Definition Language
    (4) Data Derivation Language

    Q.6 Which of the following is a legal expression in SQL?
    (1) SELECT NULL FROM EMPLOYEE;
    (2) SELECT NAME FROM EMPLOYEE;
    (3) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
    (4) None of the above

    Q.7 A primary key is combined with a foreign key creates_________.
    (1) Parent-Child relation ship between the tables that connect them
    (2) Many to many relationship between the tables that connect them
    (3) Network model between the tables that connect them
    (4) None of the above

    Q.8 Cross Product is a_________.
    (1) Unary Operator
    (2) Ternary Operator
    (3) Binary Operator
    (4) Not an operator




    Q.9 A logical schema _________.
    (1) is the entire database
    (2) is a standard way of organizing information into a accessible part
    (3) describe how data is actually stored on disk
    (4) none of these

    Q.10 A table joined with itself is called_________.
    (1) Join
    (2) Self Join
    (3) Outer Join
    (4) Equi Join




    Answer Key:
    1. 4
    2. 3
    3. 4
    4. 1
    5. 3
    6. 2
    7. 1
    8. 3
    9. 4
    10. 2

    No comments:

    Post a Comment

    Fashion

    Beauty

    Culture