Daily Archives: October 2, 2015

SQL Test

1. Which are not DCL operations? Answers: Insert Grant Delete Update Revoke Commit Rollback 2. Which of the following is not a DML command? Answers: Set transaction Explain plan Update Grant Insert Create Alter Revoke 3. Which of the following is not a DDL command? Answers: Drop Create Alter Revoke Explain plan Insert Update Delete [...]

By | October 2nd, 2015|Upwork Databases|0 Comments

PostgreSQL Test

1. Which of the following are supported by PostgreSQL? Answers: Multi version concurrency control transactions Multi-user support Declarative SQL queries Query optimization 2. Point out the incorrect statement regarding group functions: Answers: Group functions act on a group of rows Group functions return one result for all the rows operated upon Group functions ignore the [...]

By | October 2nd, 2015|Upwork Databases|0 Comments

Postgre SQL RDBMS Test

1. Which authentication methods are supported by PostgreSQL? Answers: Trust PAM LDAP Radius Password 2. Which index types are supported by PostgreSQL? Answers: A-tree B-tree GiST Hash GIN None of the above 3. Out of the following backup approaches, which ones are applicable to PostgreSQL? Answers: SQL dump File system level backup Real cluste Continuous [...]

By | October 2nd, 2015|Upwork Databases|0 Comments

Oracle SQL 9i Test

1. Which of the following constitute the correct guidelines for naming database tables? Answers: Must begin with either a number or letter Must be 1-30 characters long Should not be an Oracle Server reserved word Must contain only A-Z, a-z, 0-9, _,*, and # Must contain only A-Z, a-z, 0-9, _, $, and # Must [...]

By | October 2nd, 2015|Upwork Databases|0 Comments

Oracle PL/Sql 10g Test

1. Which two among the following programming constructs can be grouped within a package? Answers: Cursor Constant Trigger Sequence View 2. Which two statements, among the following, describe the state of a package variable after executing the package in which it is declared? Answers: It persists across transactions within a session It persists from session [...]

By | October 2nd, 2015|Upwork Databases|0 Comments

MySQL Test

1. What is the correct order of clauses in the select statement? Answers: Indexes can have NULL values BLOB and TEXT columns can be indexed Indexes per table cannot be more than 16 Columns per index cannot be more than 16 2. Below is the table “messages,” please find proper query and result from the [...]

By | October 2nd, 2015|Upwork Databases|2 Comments