PostgreSQL
 

  1. Question: How can data be accessed by users who do not have direct access to the tables?

    A
    By creating views

    B
    By creating triggers

    C
    By creating stored procedures

    D
    None of these above

    Note: Not available
    1. Report

  2. Question: Which of the following statements are incorrect regarding referential integrity?

    A
    A foreign key can refer to a primary key

    B
    A foreign key can refer to a unique key

    C
    The on delete cascade clause will work only if there is a reference to a primary key

    D
    The referred key can either be in the same table or in some other table

    E
    A foreign key can be composite

    F
    Referential integrity can only be applied while creating the table

    Note: Not available
    1. Report

  3. Question: Which of the following statements regarding views are incorrect?

    A
    A view is like a window through which data in tables can be viewed or changed

    B
    A view is derived from another table

    C
    A view cannot be derived from another view

    D
    A view is stored as a select statement only

    E
    A view has no data of its own

    F
    A view is another name for a table

    Note: Not available
    1. Report

  4. Question: Which of the following statements is correct?

    A
    PostgreSQL is written in C

    B
    PostgreSQL can dynamically load compiled code for C on the fly

    C
    All the users are allowed to use CREATE FUNCTION to link to a C function

    D
    All of these above

    Note: Not available
    1. Report

  5. Question: Which statements hold true for Partition Tables?

    A
    A table may be split into several independent pieces

    B
    All pieces must have the same size

    C
    A partition may be analyzed and exported

    D
    A partition cannot be truncated

    E
    When one partition goes offline, other partitions still remain available

    Note: Not available
    1. Report

  6. Question: Which of the following is correct regarding VACUUM?

    A
    It deletes the temporary data and recovers the disk space

    B
    The table identifier must be provided

    C
    A VACUUM statement will clean up each table in the presently connected database

    D
    All of these above

    Note: Not available
    1. Report

  7. Question: Which of the following techniques can be used to obtain a result which is based on comparing one row of a table with another row of the same table?

    A
    Equi-join

    B
    Inner Join

    C
    Outer Join

    D
    Self Join

    E
    Correlated Subquery

    Note: Not available
    1. Report

  8. Question: Which method should be used to drop the master table if its primary key is being referenced by a foreign key in some other table?

    A
    Use cascade constraints clause with drop table

    B
    Disable the foreign key of the detail table

    C
    Drop the primary and foreign key constraints of both the tables

    D
    None of these above

    Note: Not available
    1. Report

  9. Question: There is a column c1 in the table t to which a primary key pk is to be added. What will be the correct syntax?

    A
    Alter table t add primary key(c1);

    B
    Alter table t add constraint pk primary key(c1);

    C
    Alter table t add (constraint pk primary key(c1));

    D
    Alter table t add pk constraint primary key(c1);

    Note: Not available
    1. Report

  10. Question: Which of the following are not DCL operations?

    A
    Insert

    B
    Grant

    C
    Delete

    D
    Update

    E
    Revoke

    F
    Commit

    G
    Rollback

    Note: Not available
    1. Report
First1234Last
/9
Copyright © 2024. Powered by Intellect Software Ltd