Advanced Query Optimization MCQ

Test your knowledge with important Advanced Query Optimization MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Advanced Query Optimization MCQs at Bissoy

• In ________________ of Oracle, the database administrator creates a user account in the database for each user who needs access.
  ক

  Database Authentication

  খ

  Operating System Authentication

  গ

  Internal Authentication

  ঘ

  External Authentication
• In _______________ the management of the password for the account can be handled outside of oracle such as operating system.
  ক

  Database Authentication

  খ

  Operating System Authentication

  গ

  Internal Authentication

  ঘ

  External Authentication
• _________________ is a sequence of zero or more characters enclosed by single quotes.
  ক

  Integers literal

  খ

  String literal

  গ

  String units

  ঘ

  String label
• If no header is specified, the block is said to be an _______________ PL/SQL block.
  ক

  Strong

  খ

  Weak

  গ

  Empty

  ঘ

  Anonymous
• A ___________________ is an explicit numeric, character, string or Boolean value not represented by an identifier.
  ক

  Comments

  খ

  Literals

  গ

  Delimiters

  ঘ

  Identifiers
• We use ______________ name PL/SQL program objects and units.
  ক

  Lexical Units

  খ

  Literals

  গ

  Delimiters

  ঘ

  Identifiers
• A line of PL/SQL text contains groups of characters known as
  ক

  Lexical Units

  খ

  Literals

  গ

  Textual Units

  ঘ

  Identifiers
• _______________ has made PL/SQL code run faster without requiring any additional work on the part of the programmer.
  ক

  SQL Server

  খ

  My SQL

  গ

  Oracle

  ঘ

  SQL Lite
• ___________ combines the data manipulating power of SQL with the data processing power of Procedural languages.
  ক

  PL/SQL

  খ

  SQL

  গ

  Advanced SQL

  ঘ

  PQL
• _______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.
  ক

  SQL

  খ

  PL/SQL

  গ

  Advanced SQL

  ঘ

  PQL