برجاء المساعدة فى حل هذا الاختبار عن قواعد البيانات للأهمية... مع الشكر

حسناً أين هو الإختبار كي يتسنى للأعضاء المساعدة

 

 

 

1-         bit permission attributes are not used for defining which of the below user types permissions?

Select one:

 a. Owner

 b. Administrator

 c. Group

 d. Other

 

2-           To protect a database from instance failure, in which of the below mode database should run?

Select one:

 a. ARCHIVELOG Mode

 b. NONARCHIVELOG Mode

 c. Restricted Mode

 d. SAFE Mode

 

3-         What will be the output of command "$ vmstat 4 3" on linux system?

Select one:

 a. Display summary of CPU activity three times, at four-second intervals

 b. Display summary of CPU activity four times, at three-second intervals

 c. Display summary of Input-Output activity four times, at three-second intervals

 d. Display elapsed execution time three times, at four-second intervals

 

 

 

4-         Which users can perform SYSDBA database administration operations after removing password file in Oracle?

Select one:

 a. Security Officers

 b. Users which are authenticated by the Operating System

 c. Users which are existing in EXCLUSIVE password file

 d. No one can access.

 

 

5-         Which of the following comes under Performance Tuning of Memory in Oracle?

Select one or more:

 a. Controlling Paging

 b. Using Automatic Storage Management

 c. Adjusting Oracle Block Size

 d. Choosing Appropriate File System Type

 

6-         Which of the below statements are true for a Linux shared mount?

Select one:

 a. A point that is shared may be replicated as many times as needed, and each copy will continue to be the exact same.

 b. Sharing of mount point information happens in one direction.

 c. Will not be shown elsewhere in the other replicated mount points unless they are explicitly mounted.

 d. Cannot be replicated elsewhere through the use of the bind flag of the mount system call or command.

 

 

 

7-         While configuring failover of connection between primary and standby database, If you are using ODP.Net clients, which of the below must be enabled?

Select one:

 a. FAN events

 b. Oracle ASM

 c. Oracle Enterpise Manager

 d. Oracle Advanced Queuing

 

8-         While creating a database, If we combine FORCE LOGGING and NOARCHIVELOG mode, it results:

Select one:

 a. Performance upgrade with more benefits

 b. Performance upgrade with less benefits

 c. Performance Degrade with more benefits

 d. Performance Degrade with less benefits

 

9-         To create a Database, If you create initialization parameter file manually Which of the below parameter names are mandatory?

Select one:

 a. DB_NAME

 b. MEMORY_TARGET

 c. CONTROL_FILES

 d. All of the above

 

 

 

 

 

10-       SELECT ID, YEAR(BillDate) AS BillYear

FROM Invoices

WHERE BillYear >= 2010;

What is wrong in this SQL statement?

Select one:

 a. You can't define an Alias like this

 b. Comparison operators can't be used like this in Where clause

 c. Expression in where clause is incorrect

 d. No error in statement

 

11-       Which of the below can be used to start the database, if it is not managed by Oracle Restart?

 

Select one:

 a. SQL*Plus

 b. Recovery Manager

 c. Enterprise Manager

 d. SRVCTL

 e. A,B

 f. A,B,C Only

 

12-       To display the environment variables of Oracle ASM instance or listener, which of the below can be used?

Select one:

 a. config

 b. status

 c. getenv

 d. modify

 

13-       To monitor the load on a dispatcher to setup Oracle database in shared envioronment, which of the below is not a valid view name?

Select one:

 a. V$QUEUE

 b. V$DISPATCHER

 c. V$DISPATCHER_RAT

 d. V$Max_Dispatcher

 

14-       If you have to take backups in Linux, How do you make script to run automatically every week?

Select one:

 a. dd

 b. Rsync

 c. tar/gzip

 d. crontab

 

15-       If you want one process to run in background in Unix system even after you logoff, which command should be used?

Select one:

 a. using &, bg command

 b. nokill command

 c. nohup command

 d. ps command

 

 

 

 

16-       Which link you can confidently delete when you don't require it?

Select one:

 a. Alias Link

 b. Cache Memory Link

 c. Soft Link

 d. Hard Link

 

17-       A job which typically starts another process and exits, and remain in running state after that is known as?

Select one:

 a. Chain Job

 b. Destination Job

 c. External Jobs

 d. Database Jobs

 e. Detached jobs

 

18-       Which of the below enables DBA Administrator to change initialization parameters and persists the changes across database shutdown and start up?

Select one:

 a. PFILE

 b. SPFILE

 c. ORADIM

 d. CONTROL_FILES

 

 

 

 

19-       Which of the following two conditions should be met to be able to use 'Union' in a SQL query?

Select one:

 a. a) The two results sets be logically connected data The two sets of data should have Foreign Key defined between them

 b. a) The two results need not necessarily be logically connected data The two sets of data should have Foreign Key defined between them

 c. a) The two results should have the same number of columns in the result set The two sets of data should have Foreign Key defined between them

 d. a) The two results should have the same number of columns in the result set The data types of all the columns in both the result set should be the same

 

 

 

 

20-       While changing the Initialization parameters values for SPFILE and MEMORY using Scope clause, which of the below specification is only applicable to static parameters?

Select one:

 a. SCOPE=SPFILE

 b. SCOPE=MEMORY

 c. SCOPE=BOTH

 d. All of them

 

21-       To allow a DBA to perform actions that fail if concurrent user transactions access the same object, which of the below method can be best suited?

Select one:

 a. Quiescing a Database

 b. Shut down the database and reopen it in restricted mode

 c. Stop the Database and Start again

 d. None of the above

22-       When a table is often queried with equality queries. For such queries you should specify cluster key value as:

Select one:

 a. Aggregate Cluster

 b. Index Cluster

 c. HASH Cluster

 d. B and C

 

23-       Which of the memory area holds the most recently requested structural information between users and structural information about the database?

 

Select one:

 a. Program Global Areas (PGA)

 b. Shared Pool

 c. Buffer Cache

 d. Shared Global Areas (SGA)

 e. Fixed SGA

 

 

24-       If your database is down and you can find sgadef file exists in the default directory, what could be the probable cause?

Select one:

 a. Memory segment addressed in the file doesn't exist

 b. The sgadef.dbf file is moved to different location

 c. ${ORACLE_HOME}/dbs directory is corrupted

 d. None of the above

 

 

 

 

25-       If one interface got failed in data integrator, which table is used to check session log details?

Select one:

 a. SNP_SESSION

 b. SNP_SESSION_Log

 c. snp_sess_step

 d. snp_sess_Log

 e. snp_sess_Log_Interface