Bissoy.com
Doctors Medicines MCQs Q&A

Which of the following schemas does define a view or views of the database for particular users?

Which of the following schemas does define a view or views of the database for particular users? Correct Answer External schema

An externally-defined schema can provide access to tables that are managed on any PostgreSQL, Microsoft SQL Server, SAS, Oracle, or MySQL database.

Related Questions

The ratio of iPhone users to Oneplus users is 4 ∶ 5 and the ratio of Oneplus user to Xiaomi users is 6 ∶ 7. If iPhone users increased 25%, Oneplus users increased in the ratio 3 ∶ 4 and the Xiaomi increased by 20%. What is the ratio of iPhone, Oneplus and Xiaomi users after increased?
Five Lakes Publishing has a Windows 2000 network serving 200 users. A server named User_srv is used to hold users' files. User_srv is configured with a single, large NTFS volume. Every user has a home folder on User_srv. Users can also use a shared folder named IN_PROGRESS to store files for books that are being prepared. The network administrator at Five Lakes Publishing configured disk quotas for the NTFS volume on User_srv. All users have a default limit of 100 MB, and the option to deny space to users who exceed their limit has been enabled. When a user named Amy Jones attempts to save a chapter of a new book to her home folder on the server, she receives the following error message: "The disk is full or too many files are open." What should Amy do to allow this document to be saved?
If the number of Facebook, Instagram and twitter users are in the ratio 2 ∶ 3 ∶ 4. If Facebook users increased in the ratio 3 ∶ 4, Instagram users increased in the ratio 2 ∶ 3 and twitter users increased in the ratio 5 ∶ 6. What will be the new ratio of respective social website users after increments?
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 database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUMBER, STARTPAGE, ENDPAGE) and the following functional dependencies exist in the schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → TITLE (VOLUME, NUMBER) → YEAR (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → PRICE The database is redesigned to use the following schemas. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE) (VOLUME, NUMBER, YEAR) Which is the weakest normal form that the new database satisfies, but the old one does not?  
In the given question, a part of the sentence is printed in bold. Below the sentence three alternatives to the bold part are given which may help improve the sentence. Choose the option that reflects the correct use of the phrase in the context of the sentence. In case the given sentence is correct, your answer is (E) i.e. No correction required. Historians believe that much of Jesus story can be reconstructed, without the help of Bible, and with just the views of historians who lived during his time. I. without the help of Bible, and by just the views II. without the help from Bible, and with just the views III. without the help of the Bible, and with just the views
A circle is represented as a “top view”, “front view” and “side view”. If all these views are converted into isometric views then:
You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?
In Delhi - NCR, out of the total metro card users, 12% live in Noida, 9% live in Ghaziabad, x% live in Gurugram and rest live in Delhi. The ratio of number of male and female metro card users which are residents of Noida is 6 ∶ 5. Find the value of x, if there are 22500 female users of the metro card in Noida and Delhi has 222750 more users than Ghaziabad.
You are the administrator of the Windows 2000 Server network shown in the exhibit. Users in the Research group and the Executive group have permission to access the Internet through a Windows 2000 Server computer running Microsoft Proxy Server. These users must enter their proxy server user names and passwords to connect to the proxy server, to the Internet, and to your local intranet server. The users who do not access the Internet do not have user accounts on the proxy server and, therefore, cannot connect to the intranet server. You want all users to be able to connect to the intranet server without entering a separate user name and password. What should you do?