3i Infotech Placement: Sample Questions 373 - 375 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 373

Edit

Describe in Detail

Essay▾

Write program for string reversal & palindrome check.

Explanation

  1. #include<stdio.h>
  2. #include<string.h>
  3. main()
  4. {
  5.     charstr[50], revst [50];
  6.     inti=0, j=0;
  7.     printf(“enterthestringtoreversed:“);
  8.     scanf(“%s”, str);
  9.     for(i=strlen(str)-1;i>0;i--)
  10.     {
  11.         revst[j]=str[i];
  12.         j++;
  13.     };
  14.     revstr[j]=”;
  15.     printf(“inputstring :%s”, str);
  16.     printf(“outputstring:%s”, revstr);
  17.     getch();
  18. }

Question 374

Edit

Describe in Detail

Essay▾

What are the privileges that can be granted on a table by a user to others?

Explanation

  • User requires ADMIN privilege to grant privileges to others. For example:
    • Delete:
      • Delete rows from tables within the schema.
    • Insert:
      • Insert rows of data into tables within the schema.
  • References:
    • Set up references to primary keys within the schema.
  • Select:
    • To select rows from tables within the schema.
  • Trigger:
    • To create triggers on tables within the schema.
  • Update:
    • Update rows in tables within the shaman.
  • Execute:
    • Execute functions or stored procedure within the shaman.

Question 375

Question

MCQ▾

Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger?

Choices

Choice (4)

a.

No

b.

Yes

c.

All of the above

d.

None of the above

Answer

a.

Explanation

  • No, we cannot use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger.
  • Restricted package procedure affect the basic functions of SQL ⚹ From.
  • It cannot be use in any triggers except key trigger.

    Bellow the list of restricted packaged procedure:

    • Up
    • Execute Query
    • Message
    • Exit_form
    • Post

Developed by: