Question 1

In NPS, in the expression 'NULL = NULL' results in a value of 'true'

technology databases

0
NULL=NULL
1
2

Answer

Correct Option: B

Question 2

In NPS, you can use datasliceid to view distribution

technology databases

No
Yes
0
1

Answer

Correct Option: B

Question 3

Which operators can be used for a subquery to return multiple rows? (MCQ)

technology databases

IN
ALL
<>
ANY

Answer

Correct Option: A,B,D

Question 4

Choose the options which represent true statements? (MCQ)

technology databases

SQL is a language for accessing data from an Oracle server
iSQL*Plus cannot be abbreviated
SQL cannot be abbreviated.
iSQL*Plus is a language for accessing data from an Oracle

Answer

Correct Option: A,C

Question 5

Which of the following options IS NOT represent types of Single-Row functions?

technology databases

Number functions
Conversion functions
Date Functions
Compute functions

Answer

Correct Option: D

Question 6

Which of the following options represent explicit data-type conversion functions?

technology databases

TO_CHAR
TO_VALUE
TO_DATE
TO_ERROR

Answer

Correct Option: A,C

Question 7

What can NOT you accomplish using a SQL SELECT statement?

technology databases

Creation of a new table based off of the output of SELECT statements
Return information from specific columns
Return information from specific rows
The combination of values in different tables

Answer

Correct Option: A

Question 8

A subquery can consist of a statement located within a clause from a parent statement?

technology databases

Creation of a new table based off of the output of SELECT statements
Return information from specific columns
Return information from specific rows
The combination of values in different tables

Answer

Correct Option: B,C,D

Question 9

Which Script creates objects owned by the user SCOOT/TIGER..?

technology databases

dbmobld.sql
utlsampl.sql
autoextend.sql
whocan.sql

Answer

Correct Option: B

Question 10

which one is not the oracle database component type...

technology databases

memory
disk
tape
processes

Answer

Correct Option: C

Question 11

SGA means..?

technology databases

system global area
shared global area
source global area
synthetic global area

Answer

Correct Option: B

Question 12

which one is not mandatory file in Disk Components

technology databases

data files
redo logs
password files
control files

Answer

Correct Option: C

Question 13

To see the back ground processes in UNIX, use ps - ________command

technology databases

fu oracle
cu oracle
au oracle
cp oracle

Answer

Correct Option: A

Question 14

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?

technology databases

Multiprotocol
TCP/IP
Shared Memory
Virtual Interface Adapter (VIA)

Answer

Correct Option: B

Question 15

You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most likely cause of the connection issues. What should you do first?

technology databases

Ensure that port 1433 is open in your firewall.
Ensure that port 443 is open in your firewall.
Ensure that client computers connect by using Shared Memory protocol.
Ensure that the server is not paused.

Answer

Correct Option: A

Question 16

Companyxyz.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins. You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do?

technology databases

Ensure that both SQL1 and SQL2 use the same login name as the security context for each
Configure SQL2 as a remote server. Write the query on SQL1.
Configure SQL2 as a linked server to impersonate the remote login.
Configure SQL2 as a distributed server. Use pass-through authentication.

Answer

Correct Option: C

Question 17

You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do?

technology databases

Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a
Create a job for each task that runs once a day. Use a Transact-SQL statement to check the
Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is
Create a job for each task that runs once a week on Sunday. Add a second job schedule that

Answer

Correct Option: A

Question 18

You discover that the msdb database on a SQL Server 2005 computer is corrupt and must be restored. Databases are backed up daily. The database backup files are written to a network share, but the file names do not clearly indicate which databases are in each file. You need to locate the correct backup file as quickly as possible. The first file in the list is named DB_Backup.bak. Which Transact-SQL statement should you use?

technology databases

RESTORE LABELONLYFROM DISK = N\Server1\Backup\DB_Backup.bak
RESTORE HEADERONLYFROM DISK = N\Server1\Backup\DB_Backup.bak
RESTORE VERIFYONLYFROM DISK = N\Server1\Backup\DB_Backup.bak
RESTORE DATABASE MSDBFROM DISK = N\Server1\Backup\DB_Backup.bak

Answer

Correct Option: B

Question 19

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?

technology databases

Back up the current transaction log. Restore the database with a different name and stop at
Back up the current transaction log. Restore the database to the point just before the data loss.
Restore the database from the existing backup files to a time just before the data loss.
Restore the database to the point of the last full backup.

Answer

Correct Option: A

Question 20

A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located. You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?

technology databases

Execute DBCC CHECKFILEGROUP for each filegroup.
Execute DBCC CHECKCATALOG.
Execute DBCC CHECKDB.
Execute DBCC CHECKTABLE for each table.

Answer

Correct Option: C

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

databases Online Quiz - 224

Find more quizzes from top tags