Solved MCQ of Oracle and Distributed Databases set-3

1. The …………………… consists of physical files and memory components.

A) Oracle Client

B) Oracle Server

C) Oracle Middleware

D) Oracle Instance


2. The ……………………… consists of the memory components of Oracle and various background processes.

A) Oracle Parameter

B) Oracle Profile

C) Oracle Process

D) Oracle Instance


3. The Oracle Instance is made up of the ………………………. and the background processes.

A) System Global Area (SGA)

B) Oracle Global Area (OGA)

C) Program Global Area (PGA)

D) Private SQL Area (PSA)


4. The background processes of the Oracle instance are responsible for performing …………………. I/O functions.

A) Synchronous

B) Asynchronous

C) Both of the above

D) None of the above


5. The PGA is used to process ………………………… and to hold logon and other session information.

A) SQL Statements

B) Server Processes

C) User Processes

D) Shared Statements


6. In SGA, the contents of the memory area are shared by multiple users is called as …………………..

A) Redo Log Buffer

B) Database Buffer Cache

C) Shared Pool

D) Large Pool


7. In Oracle Database ………………….. Contain the data dictionary and user created data.

A) Data Files

B) Control Files

C) Redo Log Files

D) Password Files


8. The ………………………….. keeps a record of the names, size locations different physical files of the Oracle Database.

A) Data File

B) Control File

C) Redo Log File

D) Password File


9. In Oracle Database, ……………………………… is used to hold the names of privileged users who have been granted the SYSDBA or SYSOPR roles.

A) Data File

B) Control File

C) Redo Log File

D) Password File


10. In Oracle, the end of the transaction is recorded in the ……………………….. files.

A) Data

B) Control

C) Redo Log

D) Password

Answers:

1. B) Oracle Server
2. D) Oracle Instance
3. A) System Global Area (SGA)
4. B) Asynchronous
5. A) SQL Statements
6. C) Shared Pool
7. A) Data Files
8. B) Control File
9. D) Password File
10. C) Redo Log

You Might also view the following Related Posts

• Solved MCQ of PL/SQL and Oracle set-1
• MCQ of PL/SQL and Oracle With Answer set -2
• Solved MCQ of SQL Server set-1
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of Data Structure Set-2  
• Solved MCQ of Data Structure Set-1
• Solved MCQ of Oracle and Distributed Databases set-4
• MCQ of Structured Query Language(SQL) With Answer Set -2
• Solved MCQ of Database Management System (DBMS) Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of Java for Java Proficiency test set-3
• MCQ of C++ with answer Set-2
• Solved MCQ of C set-1
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here

MCQ of Java With Answer set-7

1. The .................. and .................... classes are abstract classes that support reading and writing of byte streams.
A) reader, writer
B) inputstream, outputstream
C) objectinputstream, objectoutputstream
D) none

2. What is the error in the following code?
     class Test
     {
         abstract void display( );
     }

A) No error
B) Method display( ) should be declared as static
C) Test class should be declared as abstract
D) Test class should be declared as public

3. A package is a collection of
A) classes
B) interfaces
C) editing tools
D) classes and interfaces

4. Which of the following methods belong to the string class?
A) length( )
B) compare To ( )
C) equals ( )
D) All of them

5. What will be the output of the following code?
    byte x=64, y;
    y= (byte) (x<<2);
    System.out.println(y);

A) 0
B) 1
C) 2
D) 64

6. If m and n are int type variables, what will be the result of the expression
    m%n
    when m=5 and n=2 ?
A) 0
B) 1
C) 2
D) None of the above

7. Which of the following control expressions are valid for an if statement?
A) An integer expression
B) A Boolean expression
C) Either A or B
D) Neither A nor B

8. The concept of multiple inheritance is implemented in Java by
A) extending two or more classes
B) extending one class and implementing one or more interfaces
C) implementing two or more interfaces
D) both B and C

9. Which of the following do not represent legal flow control statements?
A) break;
B) return;
C) exit();
D) continue outer;

10. Data input is
A) an abstract class defined in java.io
B) a class we can use to read primitive data types
C) an interface that defines methods to open files.
D) an interface that defines methods to read primitive data types.

Answers:

1.  B) inputstream, outputstream

2.  C) Test class should be declared as abstract

3.  D) classes and interfaces

4.  D) All of them 

5.  A) 0

6.  B) 1

7.  B) A Boolean expression

8.  D) both B and C

9.  C) exit();

10.D) an interface that defines methods to read primitive data types.

You Might also view the following Related Posts

• Solved MCQ of Java Set-1
• MCQ of Java with answer set-2
• Solved MCQ of Java for Java Proficiency test set-3
• Solved MCQ of Java set-4
• Java MCQ Questions and Answers set-5
• Java Multiple Choice Questions With Answers set-6
• Java MCQ Questions and Answers set-5
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of C set-1
• Solved MCQ of DBMS Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of SQL Server set-1
• MCQ of C++ with answer Set-2
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here

Solved Multiple Choice Questions of C++ set-4

1. In C++ ..................... operator is used for Dynamic memory allocation.
A) Scope resolution
B) Conditional
C) New
D) Membership access

2. Operators such as ...................... cannot be overloaded.
A) +
B) ++
C) : :
D) = =

3. The ...................... objects have values that can be tested for various error conditions.
A) osstream
B) ofstream
C) stream
D) ifstream

4. Which function return the current position of the get or put pointer in bytes.
A) tellg( )
B) tellp( )
C) tell( )
D) Both A and B

5. The first index number in an array starts with ............................ and the index number of an array of size n will be ............
A) 0, n-1
B) 1, n-1
C) 0, n
D) 1, n

6. To overload an operator ..................... keyword must be used along with the operator to be overloaded.
A) Over
B) Overload
C) Void
D) Operator

7. What is the output of the program
#include<iostream.h>

void main()
{
     int n=1;
     cout<<endl<<"The numbers are;"<<endl;
     do
           {

cout <<n<<"\t";
n++;
           } while (n<=100);
     cout <<endl;
 }

A) Print natural numbers 0 to 99
B) Print natural numbers 1 to 99
C) Print natural numbers 0 to 100
D) Print natural numbers 1 to 100

8. Everything defined at the program scope level (ie. outside functions and classes) is said to be ...............
A) local scope
B) regional scope
C) global scope
D) static scope

9. Because the lifetime of a local variable is limited and determined automatically, these variables are also called ............................
A) automator
B) automatic
C) dynamic
D) static

10. ................ allows that a section of a program is compiled only if the defined constant that is specified as the parameter has been defined, independently of its value.
A) #ifdef
B) #if
C) #define
D) #ifd

Answers

1. C) New
2. C) : :
3. D) ifstream
4. B) tellp( )
5. A) 0, n-1
6. D) Operator
7. D) Print natural numbers 1 to 100
8. C) global scope
9. B) automatic
10. A) #ifdef

You Might also view the following Related Posts

• Solved MCQ of C++ Set-1
• MCQ of C++ with answer Set-2
• MCQ Questions of C++ With Answers set-3
• Solved MCQ of Java Set-1
• MCQ of Java with answer set-2
• Solved MCQ of Java set-4
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of C set-1
• Solved MCQ of DBMS Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of SQL Server set-1
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here

MCQ Questions of C++ With Answers set-3

1. When a function is defined inside a class, this function is called ………….

A) Inside function

B) Class function

C) Inline function

D) Interior function

2. Which of the following cannot be passed to a function?

A) Reference variable

B) Arrays

C) Class objects

D) Header files

3. State true of false.

i) We cannot make the function inline by defining a function outside the class.

ii) A member function can be called by using its name inside another member function of the same class, this is known as nesting of member function.

A) True, True

B) True, False

C) False, True

D) False, False

4. Which of the following operators could be overloaded?

A) Size of

B) +

C) +=

D) ::

5. Which of the following is true about the static member variable in C++.

i) It is initialized to zero when the first object of its class is created. Other initialization is also permitted.

ii) It is visible only within the class, but its lifetime is the entire program.

A) i-True, ii-True

B) ii-False, ii-True

C) i-True, ii-False

D) i-False, iii-False

6. Which of the following keywords are used to control access to a class member?

A) default

B) break

C) protected

D) goto

7. What will be the values of x, m and n after execution of the following statements?

Int x, m, n;

 m=10;

n=15;

                x= ++m + n++;

A) x=25, m=10, n=15

B) x=27, m=10, n=15

C) x=26, m=11, n=16

D) x=27, m=11, n=16

8. The major goal of inheritance in C++ is

A) To facilitate the conversion of data types

B) To help modular programming

C) To facilitate the re usability of code

D) To extend the capabilities of a class

9. A variable is defined within a block in a body of a function. Which of the following are true?

A) It is visible throughout the function.

B) It is visible from the point of definition to the end of the program.

C) It is visible from the point of definition to the end of the block.

D) It is visible throughout the block.

10. The friend functions are used in situations where

A) We want to exchange data between classes

B) We want to have access to unrelated classes

C) Dynamic binding is required

D) We want to create versatile overloaded operators.

Answers

1. C) Inline function

2.   D) Header files

3.   C) False, True

4.   B) +

5.   B) ii-False, ii-True

6.   C) protected

7.   C) x=26, m=11, n=16

8.   C) To facilitate the reusability of code

9.   D) It is visible throughout the block.

10.  A) We want to exchange … classes

You Might also view the following Related Posts

• Solved MCQ of C++ Set-1
• MCQ of C++ with answer Set-2
• Solved Multiple Choice Questions of C++ set-4
• Solved MCQ of Java Set-1
• MCQ of Java with answer set-2
• Solved MCQ of Java set-4
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of C set-1
• Solved MCQ of DBMS Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of SQL Server set-1
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here

Java Multiple Choice Questions With Answers set-6

1. JSP embeds in ................ in ......................

A) Servlet, HTML

B) HTML, Java

C) HTML, Servlet

D) Java, HTML

2. The class at the top of exception class hierarchy is ..........................

A) ArithmeticException

B) Throwable

C) Class

D) Exception

3. In a java program, package declaration .................... import statements.

A) must precede

B) must succeed

C) may precede or succeed

D) none

4. The class string belongs to ................... package.

A) java.awt

B) java.lang

C) java.applet

D) java.string

5. ............... package is used by compiler itself. So it does not need to be imported for use.

A) java.math

B) java.awt

C) java.applet

D) java.lang

6. State true or false for the following statements in Java.

i) Java beans slow down software development process.

ii) Java Servlets do not have built in multithreading feature.

A) i-false, ii-false

B) i-false, ii-true

C) i-true, ii-false

D) i-true, ii-true

7. State whether true or false.

i) init( ) of servlet is called after a client request comes in 

ii) Servlets are ultimately converted into JSP

A) i-false, ii-false

B) i-false, ii-true

C) i-true, ii-false

D) i-true, ii-true

8. What will be the result of compiling following code.

public class MyClass{
     public static void main(String args[]){
           System.out.println("In first main()");
     }
public static void main(char args[]){
          System.out.println('a');
     }
}

A) Code will not compile and will give "Duplicate main() method declaration" error

B) Code will compile correctly but will give a runtime  exception

C) Code will compile correctly and will print "In first main()" (without quotes) when it is run

D) Code will compile correctly and will print "a" (without quotes) when it is run

9.Match the following. 

a) Java                      1) is a tool for debugging java program

b) Javah                    2) is a tool for creating C-like header files

c) Javap                    3) runs java bytecode

d) jdb                        4) prints java code representation

A) a-3, b-2,c-1

B) a-3, b-2, c-4, d-1

C) a-1, b-2, c-3, d-4

D) a-2, b-1, c-3, d-4

10.State true or false.

i) init() is called after start() in applet

ii) applets are used for networking

iii) inheritance is a part of Java Foundation Classes

iv) final does not prevent inheritance

A) i-true, ii-true, iii-false, iv-true

B) i-false, ii-false, iii-false, iv-false

C) i-true, ii-true, iii-true, iv-true

D) i-true, ii-false, iii-false, iv-false

Answers:

1.  D) Java, HTML

2.  B) Throwable

3.  A) must precede

4.  B) java.lang

5.  D) java.lang

6.  A) i-false, ii-false

7.  A) i-false, ii-false

8.  C) Code will compile correctly and will print "In first main()" (without quotes) .. run

9.  B)  a-3, b-2, c-4, d-1

10.B) i-false, ii-false, iii-false, iv-false

You Might also view the following Related Posts

• Solved MCQ of Java Set-1
• MCQ of Java with answer set-2
• Solved MCQ of Java for Java Proficiency test set-3
• Solved MCQ of Java set-4
• Java MCQ Questions and Answers set-5
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of C set-1
• Solved MCQ of DBMS Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of SQL Server set-1
• MCQ of C++ with answer Set-2
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here

Java MCQ Questions and Answers set-5

1. Preparedstatement Object in JDBC is used to execute ........................... queries.
A) executable
B) simple
C) high level
D) parameterized

2. In JDBC ........................ imports all Java classes concerned with database connectivity.
A) javax.sql.*
B) java.mysql.*
C) java.sql.*
D) com.*

3. MS-SQL stores data in a ........................ file format.
A) .DAT
B) .MDB
C) .MSSQL
D) .OBJ

4. Ingres is a ........................
A) Socket
B) Compiler
C) Database
D) Web server

5. In Java servlet method init( ) is called ..................... times.
A) 1
B) 2
C) 0
D) multiple

6. State true or false for Java Program.
i) All class variables are instance variables
ii) All protected methods are friendly methods
A) i-false, ii-false
B) i-false, ii-true
C) i-true, ii-false
D) i-true, ii-true

7. State true or false for Java Program.
i) Data members of an interface are by default final
ii) An abstract class has implementations of all methods defined inside it.
A) i-false, ii-false
B) i-false, ii-true
C) i-true, ii-false
D) i-true, ii-true

8. ........................ of a remotely accessible object must implement ................
A) all methods, RemoteException
B) class, RemoteException
C) class, RemoteInterface
D) all methods, RemoteInterface

9. ......................is the key to ........................
A) Serialization, persistence
B) Persistence, inheritance
C) Inheritance, object
D) Persistence, serialization

10. A method name myMethod( ) that needs two integer arguments is declared as
A) public void myMethod( );
B) public void myMethod(int a, int b);
C) public void myMethod(int a, b);
D) public int myMethod(a, b);

Answers:

1.  D) parameterized
2.  C) java.sql.*
3.  A) .DAT
4.  C) Database
5.  A) 1
6.  B) i-false, ii-true
7.  C) i-true, ii-false
8.  C) class, RemoteInterface
9.  A) Serialization, persistence
10.B) public void myMethod(int a, int b);

You Might also view the following Related Posts

• Solved MCQ of Java Set-1
• MCQ of Java with answer set-2
• Solved MCQ of Java for Java Proficiency test set-3
• Solved MCQ of Java set-4
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of C set-1
• Solved MCQ of DBMS Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of SQL Server set-1
• MCQ of C++ with answer Set-2
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here

Solved MCQ of Java set-4

1. In Java variables, if first increment of the variable takes place and then the assignment occurs. This operation is also called ............................. .
A) pre increment
B) post increment
C) incrementation
D) pre incrementation

2. When the operators are having the same priority, they are evaluated from .................  ............. in the order they appear in the expression.
A) right to left
B) left to right
C) any of the order
D) depends on compiler

3. In java,  ............. can only test for equality, where as ............ can evaluate any type of the Boolean expression.
A) switch, if
B) if, switch
C) if, break
D) continue, if

4. The ....................... looks only for a match between the value of the expression and one of its case constants.
A) if
B) match
C) switch
D) None of the above

5. System.in.read() is being used, the program must specify the .................. clause.
A) throws.java.out.IOException
B) throws.java.in.IOException
C) throws.java.io.IOException
D) throws.java.io.InException

6. By using ................... you can force immediate termination of a loop, by passing the conditional expression and any remaining code in the body of the loop.
A) Break
B) Continue
C) Terminate
D) Loop Close

7. The out object is an object encapsulated inside the ................. class, and represents the standard output device.
A) standard
B) local
C) globlal
D) system

8. The third type of comment is used by a tool called .................. for automatic generation of documentation.
A) Java commenting
B) Java generator
C) Java doc
D) Java loc

9. In the second type the information written in java after // is ignored by the .......................
A) Interpreter
B) Compiler
C) Programmer
D) All of the above

10. The compiled java program can run on any ..................... plateform having Java Virtual Machine (JVM) installed on it.
A) program
B) java
C) hardware
D) non java

Answers:

1.  A) pre increment
2.  B) left to right
3.  A) switch, if
4.  C) switch
5.  C) throws.java.io.IOException
6.  A) Break
7.  D) system
8.  C) Java doc
9.  B) Compiler
10.C) hardware

You Might also view the following Related Posts

• Solved MCQ of Java Set-1
• MCQ of Java with answer set-2
• Solved MCQ of Java for Java Proficiency test set-3
• Solved MCQ of SQL Server set-1
• MCQ of SQL With Answer Set -2
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of C set-1
• Solved MCQ of DBMS Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of Java for Java Proficiency test set-3
• MCQ of C++ with answer Set-2
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here