PLSQL Quiz 1 | Englishfreetest.com

  • Do test 20 minutes
  • Number Questions: 10 questions
  • By: englishfreetest.com
Do test

Here's the exercise 'PLSQL Quiz 1 | Englishfreetest.com' about Technical Quiz - Technical Tests.


Put your knowledge about all things technology to the test Because everything tech, from computers and the internet to software and big data, changes rapidly on a day-to-day basis, it’s now a must to stay up to date with the technology that dominates our modern day lives. Are you up to speed on what’s going on in the tech industry today? Take our quiz to find out. Test how much you know about technology

You can find more to the lesson and more exercises. Technical Quiz - Technical Tests in here.

Finally, click here to "Test" for start practice exercise .

  • Test content
    Question 1: Which of the following is not true about PL/SQL constants and literals?
    A. A constant holds a value that once declared, does not change in the program
    B. The CONSTANT declaration cannot impose the NOT NULL constraint
    C. A constant is declared using the CONSTANT keyword
    D. A CONSTANT declaration requires an initial value
    Question 2: Select invalid variable types
    A. CHAR
    B. VARCHAR1
    C. VARCHAR2
    D. INTEGER
    Question 3: Which of the following is not true about the PL/SQL data structure VARRAY?
    A. It is a fixed-size sequential collection of elements
    B. The elements can of various data types
    C. It is used to store an ordered collection of data
    D. Each element in a VARRAY has an index associated with it
    Question 4: Which of the following is used to declare a record?
    A. %ROWTYPE
    B. %TYPE
    C. Both A & B
    D. None of the above
    Question 5: PL/SQL is completely portable, high-performance transaction processing language that offers which of the following advantages -
    A. Tight Integration with SQL
    B. Better Performance
    C. Higher Productivity,Full Portability,Tight Security
    D. All mentioned above
    Question 6: PL/SQL supports datatype(s)
    A. Scalar datatype
    B. Composite datatype
    C. All of the above
    D. None of the above
    Question 7: From the following PL/SQL Delimiters which symbol is exponentiation operator
    A. <>
    B. ~=
    C. **
    D. –
    Question 8: Which of the following is true concerning systems information in an RDBMS?
    A. RDBMS store database definition information in system-created tables
    B. This information can be accessed using SQL
    C. This information often cannot be updated by a user
    D. All of the above
    Question 9: In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is first used in the executable section of the PL/SQL block?
    A. NULL
    B. 0
    C. Results in a compilation error
    D. An exception will be raised
    Question 10: Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
    A. Data Definition Language(DDL)
    B. Data Manipulation Language(DML)
    C. Both of above
    D. None