CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. NR0-014

Free NR0-014 Exam Braindumps (page: 3)

Page 2 of 26
PDF with 100 Questions

What are two effective ways of limiting the growth of the AccessRights table? (Choose two.)

  1. assign users to one or more roles
  2. grant all privileges at the database level
  3. grant all necessary privileges to each user on individual database objects
  4. ensure that all users belong to a profile and inherit the profile's access rights

Answer(s): A,B



What default value is assigned as the user's default database if no value is specified in the user's profile parameter or the CREATE USER statement?

  1. a NULL value
  2. database DBC
  3. the user's username
  4. the default database of the user's parent

Answer(s): C



Which two statements are true about ownership privileges? (Choose two.)

  1. They must be explicitly granted.
  2. They cannot be explicitly revoked.
  3. They cannot be taken away unless ownership is transferred.
  4. They can be explicitly revoked by the Database Administrator.

Answer(s): B,C



Which statement removes the profile Acct_User from UserA?

  1. DROP USER UserA;
  2. MODIFY USER UserA AS PROFILE=NULL;
  3. REMOVE USER UserA FROM PROFILE Acct_User;
  4. MODIFY PROFILE Acct_User AS ACCOUNT=NULL;

Answer(s): B






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

NR0-014 Discussions & Posts