What will answer for the below question.

Qn $1$ :$-------$database link or PL$/$SQL subprograms in the schema can use this link to access database objects in the corresponding remote database.

$1)$ Private $---$Correct

$2)$ Global

$3)$ Self

$4)$ Public

Qn $2$ : How the parameter atomic$\_$refresh in dbms$\_$mview.refresh will make the refresh faster?

$1)$ When atomic$\_$refresh is set to TRUE, the materialized view is deleted with DELETE command.

$2)$ When atomic$\_$refresh is set to FALSE, the materialized view is deleted with TRUNCATE command.

$3)$ When atomic$\_$refresh is set to FALSE, the materialized view is deleted with DROP command.

$4)$ When atomic$\_$refresh is set to TRUE, the materialized view is deleted with TRUNCATE command.

Qn $3$ : Which is the default level in a TRACE file

$1)$LEVEL$1$

$2)$LEVEL$8$

$3)$LEVEL$64$

$4)$LEVEL$4$

Qn $4$ : Different ways to access tables from another database

$1)$ Use the DB link which is created at destination database

$2)$ Use GRANT WITH GRANT option

$3)$ GRANT option to required tables

$4)$ All of the above

Qn $5$ : What is the purpose of SMON background process?

$1)$ Writes redo log entries to disk

$2)$ Performs crash recovery when a failed instance starts up again

$3)$ None of the mentioned

$4)$ Performs recovery when a user process fails

Qn $6$ : Which of the following is one of the most crucial performance counters for monitoring?

$1)$ Memory Queue Length

$2)$ All of the mentioned

$3)$ Virtual Memory

$4)$ Disk Write Bytes$/$sec

Qn $7$ : How can we insert a row for identity column implicitly?

$1)$ We cannot insert a row for identity column

$2)$ SET IDENTITY$\_$INSERT TABLE$1$

INSERT INTO TABLE$1($ID$,$NAME$)$ SELECT ID$,$NAME FROM TEMPTB$1$

$3)$ None of the above

$4)$ SET IDENTITY$\_$INSERT TABLE$1$ ON

INSERT INTO TABLE$1($ID$,$NAME$)$ SELECT ID$,$NAME FROM TEMPTB$1$; SET IDENTITY$\_$INSERT OFF

Qn $8$ : Which is the best way to fetch hierarchial data from an Oracle table

$1)$ Join the tables using left or Right join

$2)$ None of the above

$3)$ Join the tables using Self join

$4)$ Join the tables using CONNECTBY PRIOR

Qn $9$ : Which of the following statements are true about Dblinks?

$1)$ Cannot execute operations on the remote table

$2)$ All of the above

$3)$ Can analyse remote objects

$4)$ Cannot perform grant privileges on remote objects

Qn $10$ : SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called $\_\_\_\_\_\_\_\_\_$

$1)$ Vector Subqueries

$2)$ Scalar Subqueries

$3)$ Exact Subqueries

$4)$ Positive Subqueries

Qn $11$ : We can use NVL$()$ to assign default value as NULL to the variable$/$column

$1)$ TRUE

$2)$ FALSE

Qn $12$ : How Tkprof will help to increase the performance $?$

$1)$ The TKPROF program converts Oracle trace files into a more readable form.

$2)$ Tkprof gives number of physical reads of buffers from disk

$3)$ Tkprof gives number of rows processed by the fetch or execute call

$4)$ All of the above

Qn $13$ : Which of the following statements are true about Dblinks?

$1)$ Cannot execute operations on the remote table

$2)$ Can analyse remote objects

$3)$ Cannot perform grant privileges on remote objects

$4)$ All of the above

Qn $14$ : Which of the following OLAP systems do not exist?

$1)$ ROLAP

$2)$ MOLAP

$3)$ HOLAP

$4)$ None of the mentioned

Qn $15$ : Which system table will help to Description table for privilege type codes and Maps privilege type numbers to type names

$1)$ TABLE$\_$PRIVILEGES

$2)$ TABLE$\_$PRIVILEGE$\_$MAP

$3)$ SESSION$\_$PRIVS

$4)$ SYSTEM$\_$PRIVILEGE$\_$MAP

Qn $16$ :SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called $\_\_\_\_\_\_\_\_\_$

$1)$ Vector Subqueries

$2)$ Positive Subqueries

$3)$ Exact Subqueries

$4)$ Scalar Subqueries

Qn $17$ : How the parameter atomic$\_$refresh in dbms$\_$mview.refresh will make the refresh faster?

$1)$ When atomic$\_$refresh is set to TRUE, the materialized view is deleted with TRUNCATE command.

$2)$ When atomic$\_$refresh is set to FALSE, the materialized view is deleted with TRUNCATE command.

$3)$ When atomic$\_$refresh is set to FALSE, the materialized view is deleted with DROP command.

$4)$ When atomic$\_$refresh is set to TRUE, the materialized view is deleted with DELETE command.

Qn $18$ : The Activity Monitor in SQL Server Management Studio graphically displays information about $\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$1)$ User activity

$2)$ All of the mentioned

$3)$ Locks

$4)$ Blocked processes

Qn $19$ : Which of the following Constraints ensures that all values in a column satisfies a specific condition

$1)$ CHECK

$2)$ WHERE

$3)$ WHEN

$4)$ HAVING

Qn $20$ : Choose the correct option regarding the following query WITH max$\_$marks $($VALUE$)$ AS $($SELECT MAX$($marks$)$ FROM student$)$ SELECT studentID FROM student,max$\_$marks WHERE student.marks $=$ max$\_$marks.value;

$1)$ The query is syntactically wrong

$2)$ The query gives the maximum marks amongst all the students

$3)$ The query gives t