Question 1

If a table is dropped, then triggers created on it will also be dropped.

technology databases

True
False

Answer

Correct Option: A

Question 2

Select belongs to which type of language?

technology databases

DDL
DML
DCL
None of the Above

Answer

Correct Option: D

Question 3

DESC belongs to

technology databases

DDL
DCL
DML
None the above

Answer

Correct Option: D

Question 4

Dropped table can be got back without recreating it.

technology databases

True
False

Answer

Correct Option: A

Question 5

How can we calculate average of a column?

technology databases

using AVG () function
Using AVERAGE() function
using SUM() and Count() functions
using Total() function

Answer

Correct Option: A,C

Question 6

what are the functions used for calculating sub totals ?

technology databases

Using Rollup() function
Using SUBTOT() function
Using SUBSUM() function
All the above

Answer

Correct Option: A

Question 7

Which process registers the logfile in a standby database ?

technology databases

RFS
MRP
ARCH
LGWR

Answer

Correct Option: C

Question 8

Which process reads data from the data file into the database buffer cache ?

technology databases

Server process
DBWR
CKPT
PMON

Answer

Correct Option: A

Question 9

There is no entry in the file listener.ora. You issue the command "lsnrctl start". Which process will register the running instance with the listener?

technology databases

It will give an error
PMON
Default listener is started but the instance wont be registered.
CJQn

Answer

Correct Option: B

Question 10

what happens if the listener currently running for prod database is terminated due to some reason?

technology databases

The currently connected users will be disconnected.
There will be no effect on users.
remote users will not be allowed to spawn sessions.
None of the above

Answer

Correct Option: C

Question 11

Is it possible to resize the size of redo logs while the database is running?

technology databases

True
False

Answer

Correct Option: B

Question 12

Code Name of SQL Server 2005?

technology databases

Aegan
Yukon
Kilimanjaro
MSSQL

Answer

Correct Option: B

Question 13

Which recovery model doesn't allow Log backups?

technology databases

Full
Simple
Bulk-Logged
None of the above

Answer

Correct Option: B

Question 14

This database will be flushed when SQL Server restarts

technology databases

model
msdb
tempdb
MSSQLSystemResource

Answer

Correct Option: C

Question 15

Which table has all the users of a server?

technology databases

sysusers
syslogins
sysserverusers
None of the above

Answer

Correct Option: B

Question 16

Which of the following option helps to execute a stored procedure when the server instance starts?

technology databases

sp_procoption
sp_serverstartup
sp_autoexecute
None of the above

Answer

Correct Option: A

Question 17

Which database holds the information of all the jobs in a server?

technology databases

master
model
sysjobs
msdb

Answer

Correct Option: D

Question 18

If a sysadmin is granted with "db_denydatareader" role for a database he will not be able to access the data from that database.

technology databases

True
False

Answer

Correct Option: A

Question 19

What does the OUT= represents in PROC SORT ?

technology databases

Output dataset
Inputdataset
Both
Output window

Answer

Correct Option: A

Question 20

BY statement specifies one or more variables whose values are used to order the data in PROC SORT?

technology databases

True
False

Answer

Correct Option: A

Description: databases Online Quiz - 108
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 108

Find more quizzes from top tags