0

databases Online Quiz - 45

Description: databases Online Quiz - 45
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which of the following statements gets the total value of the column 'Price' in the 'Sales' table

  1. SELECT ADD(Price) FROM Sales

  2. SELECT TOTAL(Price) FROM Sales

  3. SELECT SUM(Price) FROM Sales

  4. SELECT SUM(Price) WHERE Sales


Correct Option: C

AI Explanation

To answer this question, you need to understand how to calculate the total value of a column in a table using SQL.

Let's go through each option to understand why it is correct or incorrect:

Option A) SELECT ADD(Price) FROM Sales - This option is incorrect because there is no SQL function called ADD that can be used to calculate the total value of a column.

Option B) SELECT TOTAL(Price) FROM Sales - This option is incorrect because there is no SQL function called TOTAL that can be used to calculate the total value of a column.

Option C) SELECT SUM(Price) FROM Sales - This option is correct because the SUM function in SQL is used to calculate the sum of a column. By selecting SUM(Price) FROM Sales, you will get the total value of the 'Price' column in the 'Sales' table.

Option D) SELECT SUM(Price) WHERE Sales - This option is incorrect because the WHERE clause is missing a condition. The WHERE clause is used to filter rows based on a condition, but it needs to be followed by a condition. For example, WHERE Sales > 0. Without a condition, this query is invalid.

The correct answer is C) SELECT SUM(Price) FROM Sales. This option is correct because it uses the SUM function to calculate the total value of the 'Price' column in the 'Sales' table.

The difference between the DELETE and TRUNCATE SQL clauses is

  1. The TRUNCATE clause deletes all rows in a database table, while the DELETE clause can have a WHERE condition and might or might not delete all rows in a table

  2. The TRUNCATE clause is identical to the DELETE clause

  3. The DELETE clause deletes all rows in a database table, while the TRUNCATE clause can have a WHERE condition and might or might not delete all rows in a table

  4. None of these


Correct Option: A

Values specified in the between condition are exclusive

  1. True

  2. False


Correct Option: B

select lpad(3400,10,*) from dual returns

  1. ******3400

  2. 3400******

  3. 3400

  4. Error


Correct Option: D

select trunc(760.5,-2) from dual returns

  1. Error

  2. 700

  3. 0

  4. 7


Correct Option: B

which one of the following is correct?

  1. to_char(sysdate,'mm/yy')

  2. to_char('sysdate','mm/yy')

  3. to_char(sysdate,mm/yy)

  4. All the above


Correct Option: A

select nvl2(exp1,exp2,exp3) from dual. In this if exp1 is null,what will be the output?

  1. exp1

  2. exp2

  3. exp3

  4. error


Correct Option: B

With SQL, how do you select all the records from a table named 'Persons' where the value of the column 'FirstName' starts with an 'a'?

  1. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

  2. SELECT * FROM Persons WHERE FirstName LIKE '%a'

  3. SELECT * FROM Persons WHERE FirstName='a'

  4. SELECT * FROM Persons WHERE FirstName='%a%'


Correct Option: A

Can a primary key contain more than one columns?

  1. True

  2. False


Correct Option: A

Can 2 functions have same name & input parameters but differ only by return data type?

  1. True

  2. False


Correct Option: B

Which figure represents Terabyte

  1. 10^3

  2. 10^10

  3. 10^9

  4. 10^12


Correct Option: D

Teradata considered as fastest OLAP based RDBMS because of

  1. Parall architecture

  2. Serial architecture

  3. Scalability

  4. Performacnce


Correct Option: A

Which OS does not support teradata RDBMS installation

  1. UNIX-MPRAS

  2. UNIX-LINUX

  3. UNIX-AIX

  4. UNIX-HP-UX


Correct Option: C,D

Which is not a member of TTU(teradata tools and utilizes)?

  1. Fastload

  2. Multiload

  3. FastExport

  4. Datastage


Correct Option: D

which table supports duplicate rows insertion?

  1. Set

  2. Multiset

  3. Volatile

  4. Temporary


Correct Option: B

which one is used to monitor performance of teradata processes?

  1. SQL assistant

  2. BTEQ

  3. PMON

  4. Statistics wizard


Correct Option: C

How many codd rules are applied in Teradata?

  1. 7

  2. 8

  3. 12

  4. 10


Correct Option: C

How many sessions can be handled in single session?

  1. 60

  2. 120

  3. 80

  4. 30


Correct Option: B

What type of distributions are there?

  1. SMP

  2. PMP

  3. MPP

  4. PPP


Correct Option: A,C
- Hide questions