aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Oracle Database and PL/SQL with C Programming Basics
  • % rowtype dynamic data type is used in oracle PL/SQL to a...
Multiple choice

% rowtype dynamic data type is used in oracle PL/SQL to access

  1. single variable

  2. entire row of a table

  3. entire column of a table

  4. entire table

  5. multiple row

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

%rowtype is used to select entire row of a table. It does not consider the datatype of the individuals cells.

Keep practicing — related questions

  • What is the use of %ROWTYPE in PL/SQL?
  • %ROWTYPE attribute is used to declare a variable and associate it's data type with the TABLE/CURSOR object.
  • %TYPE attribute is used to declare a variable and associate its data type with the COLUMN of a TABLE OR pre...
  • You are declaring a variable of data type NUMBER in a PL/SQL block. During the execution of the PL/SQL bloc...
  • You are declaring a variable of data type NUMBER in a PL/SQL block. During the execution of the PL/SQL bloc...
  • In a PL/SQL program, to declare a variable with the same data type as a column of a table (anchored declara...
  • The __________ attribute is used to declare variables based on definitions of columns in table
  • The __________ attribute is used to declare variables based on definitions of columns in table.
Play the full quiz 🎤 Practise this topic out loud

Practice this topic

  • Database and SQL (3929 questions)
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy