Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM 'd:bulkaccts143_10142000.txt'WITH DATAFILETYPE = 'char', FIELDTERMINATOR = 't', ROWTERMINATOR = 'n', TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?

A

Add the BATCHSIZE option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.

B

Add the ROWS_PER_BATCH option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.

C

Drop the indexes for the Customers table before the data load, and then re-create the indexes after the data load is complete.

D

Remove the TABLOCK option from the BULK INSERT statement.

The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________

A

TCL (Transaction Control Language)

B

DCL (Data Control Language)

C

DDL (Data Definition Langauge)

D

DML (Data Manipulation Langauge)

Let relation R2 has a Foreign Key that refers to Primary Key of relation R1. Which of the following operations may cause violation of referential integrity constraints? I: insert into R1 II: insert into R2 III: delete from R1 IV: delete from R2

A

II and III

B

I and IV

C

I, II and III

D

III and IV

Point out the correct statement. * executes a Hive query and prints results to standard output b) executes a Hive query and prints results to standard output c) executes a Hive query and prints results to standard output d) All of the mentioned

A

list FILE * executes a Hive query and prints results to standard output

B

S

C

S

D

S

Which set of statements will describe the nature and characteristics of the Emotional Intelligence of a person? Choose the correct answer from the code given below. i) Ability to act purposefully ii) Ability to handle fear and anxiety iii) Ability to think abstractly iv) Ability to promote the feeling of satisfaction v) Ability to see others point of view vi) Ability to learn from past experiences

A

i, ii and v

B

ii, iv and v

C

iii, iv and vi

D

i, iii and v

Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn; Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn; Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?

A

Query 1

B

Query 2

C

Query 3

D

Query 4

Which of the following languages is used in application programs, to retrieve, store, modify, delete, insert and update data in database?

A

DML

B

DDL

C

DCL

D

TCL

Consider two database relations R and S having 3 tuples in R and 2 tuples in S. what is the maximum number of tuples that could appear in the natural join of R and S?

A

2

B

5

C

3

D

6

You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?

A

EXEC sp_defaultdb 'Andrew','FinanceData'

B

GRANT ALL ON FinanceData TO Andrew

C

EXEC sp_addlogin 'Andrew'

D

EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew'

Match the following two sets. In Set - I the different Guidance Services are given and in Set - II the Role/Functions of these Guidance Services are described. Select the correct answer from the given alternatives. Set - I (Guidance Services) Set - II (Role / Function) (a) Occupational Information Service i) Gives information about the characteristics - strength and weaknesses of a person (b) Placement Service (ii) Provides information about world of work (c) Follow-up Service (iii) Provides suitable engagement as per the vocational preparedness (d) Individual Inventory Service (iv) Takes up a view of how things are going on after entry into the specific job (v) Provides opportunity for understanding oneself in a realistic way

A

(a) - (ii), (b) - (iii), (c) - (iv), (d) - (i)

B

(a) - (iii), (b) - (ii), (c) - (iv), (d) - (v)

C

(a) - (i), (b) - (iii), (c) - (v), (d) - (ii)

D

(a) - (ii), (b) - (iv), (c) - (v), (d) - (i)

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

Related Questions