RABIA ATTACH

  1> In the context of data warehousing, data map or 'data about data' is known as ....a) tupleb) attributec) metadatad) teradataAns: C) metadata 2> Which of the following normal form deals with the anomaly of multivalue dependency?a) 1NFb) 2NFc) 4NFd) 5NFAns: c) 4NF 3> Which of the following normal form deals with the repeating group anomaly?a) 1NFb) 2NFc) 4NFd) 5NFAns: a) 1NF 4> ___ is a database language used to define data structures in SQL?a) Sybaseb) Oraclec) DDLd) MySQLAns: c) DDL 5> The ___ is a database file that contains metadata.a) data indexb) data repositoryc) data dictionaryd) noneAns: a) data index 6> Which of the following is not the state of a transaction in the database?a) Activeb) Committedc) Terminatedd) NullifiedAns: d) Nullified 7> The __ file saves the recovery scenario in Quick Test Professional (QTP) environment.a) QRSb) JPEGc) DOCd) TSRAns: a) QRS 8> Which of the following is not a command in SQL?...

  In this tutorial, we are going to learn how to use SQL in PL/SQL . SQL is the actual component that takes care of fetching and updating of data in the database whereas PL/SQL is the component that processes these data. Further, in this article, we will also discuss how to combine the SQL within the PL/SQL block. YOU MIGHT LIKE: https://www.shoutcoders.com/xamppsqlset2/ https://www.shoutcoders.com/sqlexampleset1/ EXAMPLE 3: 1> Create the following tables: i ) Hotel (H_no, Name, Address) create table Hotel (H_no char(4), Name varchar(20), address varchar(20)) OUTPUT: Table created. ii) Room (R_no, Rtype, H_no, Price) create table Room (R_no char(4), Rtype char(6), H_no char(4), Price int(6)); OUTPUT: Table Created. iii) Book (H_no, G_no, R_no, Dt_from, Dt_to ) create table Book (H_no char(4), G_no char(4), R_no char(6), dtfrom date, dtto date) OUTPUT: Table Created. iv) Guest (G_no, G_name, G_address) create table guest (...