Free NR0-014 Exam Braindumps (page: 4)

Page 3 of 26

The database administrator created User A and assigned that user 90 MB of spool. A month later, the database administrator creates Profile B with 50 MB of spool. User A is then assigned to Profile B. Which system view would you use to determine how much spool User A now has access to?

  1. DBC.Users
  2. DBC.ProfileInfo
  3. DBSessionInfo
  4. DBC.Accountinfo

Answer(s): B



Which is updated when you change password features such as expiration, reuse, minimum and maximum length?

  1. DBC.Users
  2. DBC.LogOnOff
  3. DBLogonRules
  4. DBC.SysSecDefaults

Answer(s): D



User A creates Database X.
Which three rights are automatically granted to User A on Database X? (Choose three.)

  1. CREATE USER
  2. CREATE TABLE
  3. CREATE INDE X
  4. CREATE DATABASE
  5. CREATE REFERENCES

Answer(s): A,B,D



Which clause in a CREATE VIEW statement restricts the rows in a table that can be inserted by users?

  1. USING
  2. WHERE
  3. SELECT
  4. WITH CHECK OPTION

Answer(s): D






Post your Comments and Discuss TeraData NR0-014 exam with other Community members:

NR0-014 Discussions & Posts