3i Infotech Placement: Sample Questions 66 - 67 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 66

Edit

Describe in Detail

Essay▾

Which system tables contain information on privileges granted and privileges obtained?

Explanation

  • USER_TAB_PRIVS_MADE and USER_TAB_PRIVS_RECD are system tables containing information on privileges granted and privileges obtained.
  • USER_TAB_PRIVS_MADE:
    • Describe the object for which the current user is the object owner.
    • Columns are the same as those in ALL_TAB_PRIVS_MADE.

      Select privileges granted to others on tables in our schema

      SQL > SELECT ⚹ FROM USER_TAB_PRIVS_MADE;

  • USER_TAB_PRIVS_RECD:
    • Describe object grants for which the current user is the grantee.
    • Its columns are the same as those in ALL_TAB_PRIVS_RECD.

Types of grants:

  • Object grants for which the current user is the grantee.
  • Object grants for enabled role or PUBLIC is the grantee.

Question 67

Edit

Write in Short

Short Answer▾

What is the output of the following program?

  1. main ()
  2. {
  3.     char ⚹str1 =“abcd” ;
  4.     charstr2[] =“abcd”;
  5.     printf ( “%d %d %d” sizeof (str1), sizeof (str2), sizeof ( “abcd” ) );
  6. }

Explanation

In a program,

Table Shows the Program
char ⚹ str1 = “abcd” ;Given the character pointer
char str2 [] = “abcd” ;Given the name of the array
printf ( “% d % d % d” sizeof (str1) , sizeof (str2) , sizeof ( “abcd” ) ) ;
  • In first sizeof, str1 is a character pointer so it gives you the size of the pointer variable.
  • In second sizeof the namestr2 indicates the name of the array whose size is 5 (including the ‘⧵0’ termination character) .
  • The third sizeof is similar to the second one.

Developed by: