Opening the paper…
Database Management Systems, Quiz 1
Which level of abstraction is responsible for providing data security by limiting access to specific data views?
Which level of abstraction is responsible for providing data security by limiting access to specific data views? Consider the relation **student** shown in Table 5. | roll_no | name | house_name | |---|---|---| | 1 | John | Nilgiri | | 2 | Ramesh | Nilgiri | | 3 | Dilip | Arawali | | 4 | Suresh | Shiwalik | | 5 | Kiran | Udaygiri | | 6 | Vijay | Nilgiri | Table 5: Relation **student** Which of the following SQL command is used to provide INSERT authorization of the table **student** to **instructor**. Consider the tables **Products** and **Suppliers** given below: | P_ID | P_Name | S_ID | |---|---|---| | 1 | Laptop | 3 | | 2 | Smartphone | 2 | | 3 | Tablet | 3 | | 4 | Headphones | 1 | Table 1: Products | S_ID | S_Name | |---|---| | 1 | Sony | | 2 | Samsung | | 3 | Apple | Table 2: Supplier Now consider the SQL query given below: Select * From Products P, Supplier S Where P.P_ID<>S.S_ID How many attributes and rows will be present in the resultant output table?