Q.1

We can modify an existing Company from

  • Company Info > Alter
  • Gateway of Tally > Modify Company
  • Company Info > Alter Company
  • All of the above
Q.2

The arranging of data in a logical sequence is called

  • Summarizing
  • Classifying
  • Sorting
  • Rearranging
Q.3

Which of the following is not a relational database?

  • 4th Dimension
  • Reflex
  • dBASE IV
  • FoxPro
Q.4

Embedded SQL is which of the following?

  • The process of making an application capable of generating specific SQL code on the fly.
  • Hard-coded SQL statements in a trigger.
  • Hard-coded SQL statements in a program language such as Java.
  • Hard-coded SQL statements in a procedure.
Q.5

Which operator performs pattern matching ?

  • LIKE operator
  • EXISTS operator
  • BETWEEN operator
  • None of these
Q.6

Which of the following is a comparison operator in SQL?

  • =
  • <>
  • `
  • /
Q.7

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables ?

  • Data Manipulation Language(DML)
  • Data Definition Language(DDL)
  • Both A & B
  • None
Q.8

A subquery in an SQL SELECT statement is enclosed in

  • [ ]
  • { }
  • < >
  • ( )
Q.9

A UNION query is which of the following?

  • Combines the output from multiple queries and does not include the same number of columns.
  • Combines the output from multiple queries and must include the same number of columns.
  • Combines the output from no more than two queries and does not include the same number of columns.
  • Combines the output from no more than two queries and must include the same number of columns.
Q.10

A database is used to

  • store data
  • modify data
  • extract data
  • All of the above
Q.11

AND, OR and NOT are examples of

  • Clauses
  • Boolean operators
  • Conjuctive operators
  • Exclusive operators
Q.12

Which of the following statements is true concerning subqueries?

  • Does not start with the word SELECT.
  • Involves the use of an inner and outer query.
  • Cannot return the same result as a query that is not a subquery.
  • All of the above
Q.13

The SQL SELECT statement is capable of

  • Projection
  • Selection
  • Protection & Security
  • Both A & B
Q.14

Which one of the following sorts rows in SQL?

  • ORDER BY
  • GROUP BY
  • SORT BY
  • ALIGN BY
Q.15

A DBMS query language is designed to

  • Specify the structure of a database
  • Support in the development of complex applications software
  • Support end users who use English-like commands
  • All of the above
Q.16

SQL views can be used to hide?

  • Complicated SQL syntax
  • Rows
  • Columns
  • All of the above
Q.17

Which SQL keyword is used to sort the result-set?

  • ORDER
  • ORDER BY
  • SORT BY
  • SORT
Q.18

What operator tests column for the absence of data?

  • NOT operator
  • IS NULL operator
  • EXISTS operator
  • All of the above
0 h : 0 m : 1 s