Question 1

We can not execute a stored procedure on either local or remote SQL Server.

technology databases

True
False

Answer

Correct Option: B

Question 2

Stored procedures are compiled the first time they’re run but are not stored in a system table of the current database.

technology databases

True
False

Answer

Correct Option: B

Question 3

'Select Into'Statement retrieves rows and columns from one source table to a target table.

technology databases

True
False

Answer

Correct Option: A

Question 4

__is an interface you can use to write both SQL and PL/SQL scripts

technology databases

PL/SQL
SQL
SQL*PLUS
JAVA

Answer

Correct Option: C

Question 5

___is the language used to put data into the database, retrieve data from the database, control transactions, and administer your database

technology databases

PL/SQL
SQL
SQL*PLUS
JAVA

Answer

Correct Option: B

Question 6

__is the procedural programming language of Oracle, and with it you can write custom programs and procedural code for execution inside the database

technology databases

PL/SQL
SQL
SQL*PLUS
JAVA

Answer

Correct Option: A

Question 7

____setting that indicates the number of records that must be returned in the query results for SQL*Plus to show the message

technology databases

LINESIZE
FEEDBACK
PAGESIZE
PAUSE

Answer

Correct Option: B

Question 8

PAUSE command is useful, when you execute a query that is longer than a page in size, the output will stop until you hit the Enter key.

technology databases

True
False

Answer

Correct Option: A

Question 9

Main functions in parsing process are____

technology databases

Syntax Checking
Semantic Analysis
Both
Checking the shared pool
All of the above

Answer

Correct Option: E

Question 10

___is the act of breaking the submitted statement down into its component parts, determining what type of statement it is (query, DML, or DDL), and performing various checks on it

technology databases

Parsing
Optimization
Row source generation
Statement execution
All of the above

Answer

Correct Option: A

Question 11

Select the steps involved in executing statements in Oracle

technology databases

Parsing
Optimization
Row source generation
Statement execution
All of the above

Answer

Correct Option: E

Question 12

View has no physical existence until it is called upon in a query

technology databases

True
False

Answer

Correct Option: A

Question 13

What is a catalog??

technology databases

Multiple rows
Multiple coulumns
Multiple schemas
Multiple tables

Answer

Correct Option: C

Question 14

How many default instances can you install on a single SQL Server server?

technology databases

1
2
3
4

Answer

Correct Option: A

Question 15

Which authentication mode lets you use both SQL Server logins and Windows logins?

technology databases

Kerebos authentication
Windows
Mixed Mode
Network Service account

Answer

Correct Option: C

Question 16

Which SQL Server 2005 services require that you install them with their own account? (Choose all that apply.)

technology databases

SQL Server Agent
Log Reader Agent
SQL Server
Replication Agent

Answer

Correct Option: A,C

Question 17

The term “in-place upgrade” refers to which type of upgrade?

technology databases

Installing SQL Server 2005 in the same directory as the current installation and replacing the SQL Server files
Installing a new instance of SQL Server 2005 and sharing the older databases between the new instance and the old instance
Installing a new instance of SQL Server 2005 on the same server as the old instance and moving the databases from the old instance to the new instance
Installing a new instance of SQL Server 2005 on a different server from the old instance and moving the databases from the old server to the new server

Answer

Correct Option: A

Question 18

Which upgrade data-movement method requires that users not be accessing the database you want to upgrade?

technology databases

Copy Database Wizard
Detach/attach
Backup/restore
Manual scripting

Answer

Correct Option: B

Question 19

Which of the following statements can you use to create a filegroup?

technology databases

ALTER DATABASE … ADD FILE
ALTER DATABASE … MODIFY FILEGROUP
ALTER DATABASE … ADD FILEGROUP
ALTER DATABASE … REMOVE FILEGROUP

Answer

Correct Option: C

Question 20

Which of the following are valid filegroup types? (Choose all that apply.)

technology databases

Read-only
Write-Only
Default
Primary

Answer

Correct Option: A,C,D

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

databases Online Quiz - 130

Find more quizzes from top tags