databases Online Quiz - 62
Description: databases Online Quiz - 62 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
What is the result of a full table scan occurring on Teradata? (Choose two)
Of the following which is a true statement with regard to a primary index operation?
Which are two exclusive features of Teradata? (Choose two)
Queries based on set threshold are restricted by which tool?
You are an administrator at CertKiller.com. CertKiller.com has a Teradata system with 100 GB of permanent space, of which 50 GB is reserved for spool space. The system currently has 30 GB of user data. What is the total available spool space for user queries?
In which way is data distributed with a Partitioned Primary Index?
A Partitioned Primary Index should be used for what two reasons? (Choose two)
An example of an OLTP environment is _____
You are an administrator at CertKiller.com. CertKiller.com has a Teradata system with 100 GB of permanent space and creates User A with 30 GB permanent space. How much spaces will User A have, if User A creates User B with 20 GB permanent space?
When utilizing a unique secondary index, how may AMP (s) is usually accessed?
How would you define a transaction?
Consider the emp table having columns empno, ename Which of the following SQL query fetches empno that occur more than twice in the emp table.
In a database row is also called as
which of the following denote single value function used in SQL
While creating tables the concept that is used to reduce redundancy in data is called
A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in the where clause then result will have
Which isolation level doesn't exists
Which normal forms require that non-key columns be functionally dependent solely on the primary key?
Which of the following options is FALSE about unchained mode in ASE
The modulos operator (%) CANNOT be used on the _____ datatype.