Upwork Databases

/Upwork Databases

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

MS SQL Server 2005 Test

1. Which of the following clauses are not allowed in a single row sub-query? Answers: From Where Group by Having Order by 2. What is the function of "DBCC CHECKDB" command? Answers: It checks the allocation of all the objects in the specified database It checks the structural integrity of all the objects in the [...]

By | October 1st, 2015|Upwork Databases|0 Comments

MS Access 2003 Test

1. A query that uses the BETWEEN syntax for two numbers is identical to: Answers: >= and <= > and < >= and < > and <= No such synta 2. How can the duplicate data on a report be hidden? Answers: By Setting the HideDuplicates property to Yes By Setting the DuplicateRecords property to [...]

By | October 1st, 2015|Upwork Databases|0 Comments

Data Warehousing Test

1. Which of the following are the modes of OLAP? Answers: MOLAP ROLAP KOLAP 2. OLAP queries can be characterised as on-line transactions that do not: Answers: Access small amounts of data Analyse the relationships between many types of business elements e.g. sales, products, regions, and channels Compare aggregated data over hierarchical time periods e.g. [...]

By | September 30th, 2015|Upwork Databases|0 Comments

Data Structures Test

1. Which graph traversal algorithm uses a queue to keep track of the vertices which need to be processed? Answers: Breadth-first search Depth-first search 2. A simple graph with n vertices and k components can have at the most _______. Answers: n edges n-k edges (n-k)(n-k-1)/2 edges (n-k)(n-k+1)/2 edges 3. What is the minimum number [...]

By | September 30th, 2015|Upwork Databases|0 Comments