Data Administration 5 Welcome to Shaheen Leader Academy We expect 100% result. Click on Start Button. Your time is Ended. Thanks Data Administration Data Administration Quiz 1 / 25 Insertion of large number of entries at a time into an index is referred to as ________ of the index;- Bulk loading Bulk insertion Loading 2 / 25 Which view that contains more than one table in the top level FROM clause of the SELECT statement :- updatable join view detable join view join view 3 / 25 Which function is used to find  the count of distinct department:- count distinct dist 4 / 25 A search key containing  more than one attributes is referred to as a _________ search key ;- Compund Simple Composite 5 / 25 In a relational model, relations are termed as:- Tuples Tables Attribute 6 / 25 For each attribute of a relation , there is a set of permitted values called ____________:- Set Domain Relation 7 / 25 How many types of indexes are there in SQL server:- 3 2 1 8 / 25 SQL can be used to :- all of them query database data create database structure 9 / 25 How can the value in the  relation teaches be deleted;- drop table teaches delete from teaches purge table teaches 10 / 25 An oracle object type has two parts ;- True False 11 / 25 Who proposed the relational model;- bill gates herman hollerith e f codd 12 / 25 An operation is said to be __________ if executing it several  times in a row  gives the same result as  executing it once :- idempotent changed repititive 13 / 25 A collection of interrelated records is called a:- Text file DAtabase Spreadsheet 14 / 25 Fifth normal form is concerned  with ;- Join dependency Multileveled dependency Functional dependency 15 / 25 When performance and reliability  are both important, Raid level __________ is used :- 0 1 0 +1 2 16 / 25 Mirrored database are almost always provided high availability system:- False True 17 / 25 Which is not an outer join:- Right outer join Left outer join all of them 18 / 25 A CRM system organizes information on:- Consulates Customers Computer register 19 / 25 Which commands are included in general purpose programming language:- SDL DDL DML 20 / 25 A CRM system organizes and track information on:- Customer Consulates Computer resgister 21 / 25 Which could cause data to be unavailable:- The database server Data becomming lost Planned database maintenance all of them 22 / 25 One approach to standardization storing of data ;- codasyl specification mis Structured programming 23 / 25 Which is not a secondary storage :- magnetic disk Magnetic tape ram 24 / 25 DBMS is a software :- True False 25 / 25 A_______on the attribute A of  relation r consist of  one bitmap for each value that A can take :- bitmap index bitmap index Your score is Restart quiz Subscribe our Channel Here