Bissoy.com
Doctors Medicines MCQs Q&A

_______________ allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation.

_______________ allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation. Correct Answer Virtual Private Database (VPD)

Some database systems provide mechanisms for fine-grained authorization.

Related Questions

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
Study the following information carefully and answer the questions that follows. 5 persons Anil, Bhagat, Ishan, Deepak and Parmish use 5 different apps namely, WhatsApp, Instagram, Twitter, Facebook and LinkedIn. They all wear different brands of shoes namely, Adidas, Reebok, Nike, Puma and Vans. The person who wears Puma shoes does not uses Facebook. Parmish wear Nike shoes and uses LinkedIn app. Anil who wear Adidas shoes but neither uses Facebook nor Twitter. Ishan neither wear Vans nor Puma shoes but he uses Twitter app. The person who uses WhatsApp doesn’t wear Adidas shoes. Bhagat uses Facebook app. Deepak wear which shoes brand, and also determine who uses Instagram?
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?
You are a network administrator for your company. The company is currently configuring its branch offices with a Windows 2000 Server computer at each office. Each branch office has a technical-support department but not a network administrator. You want to configure the remote Windows 2000 Server computers so that whenever a new Microsoft driver becomes available, the branch offices are notified automaticaly when the administrator logs onto the server. What should you do?
h,J,K,L,M,N and O are the only legislators eligible to vote on Bills 1,2 and 3, each of which will be passed if at least four legislators eligible vote in favor of it. each legislator must vote on all three bills; on abstentions are possible. The following is known : *H must vote against all three bills; each of the other legislators must vote in favor of at least one bill and against at lest one bill. *j must vote against Bills 1. *O Must vote against Bills 2 and 3. * L must the same way that K dose on all three bills.*N must vote the same way that O dose on all three bills. If any bill is to be passed,which of the following must be among the legislators who vote in favor of it?
Which one of the following predicate formulae is NOT logically valid? Note that W is a predicate formula without any free occurrence of x.
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?
h,J,K,L,M,N and O are the only legislators eligible to vote on Bills 1,2 and 3, each of which will be passed if at least four legislators eligible vote in favor of it. each legislator must vote on all three bills; on abstentions are possible. The following is known : *H must vote against all three bills; each of the other legislators must vote in favor of at least one bill and against at lest one bill. *j must vote against Bills 1. *O Must vote against Bills 2 and 3. * L must the same way that K dose on all three bills.*N must vote the same way that O dose on all three bills. which of the following must vote in favor of Bill 1 ?
Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
You are an administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.
- A BULK INSERT job imports data at 10:00 P.M
- Indexes are rebuilt at 10:15 P.M
- Data integrity checks are performed at 10:30 P.M
- A differential backup is performed at 10:45 P.M
- A DBCC SHRINKDATABASE job runs at 11:00 P.M.
You notice that the final job often fails and returns the following error message: "Server: Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."You need to ensure that the final job runs without errors. What should you do?