Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
F5_Infoman
| Question | Answer |
|---|---|
| The most common way of achieving serialization is locking mechanism. Group of answer choices True False | True |
| What is a mechanism for storing a database quickly inaccurately after a loss or damage? Group of answer choices database recovery integrity controls Triggers Functions | database recovery |
| A shared lock is used when just reading to prevent another user from placing an exclusive lock on the record. Group of answer choices True False | True |
| Installing or upgrading DBMS is one of the traditional database administration functions Group of answer choices True False | True |
| A hot backup is a backup facility wherein the system is or can still be available during back up. Group of answer choices True False | True |
| Passwords can be flawed wherein users share them with each other or they get written down or could be copied Group of answer choices True False | True |
| What is a security feature is database that sets domains, assertions and triggers to protect from unauthorized use? Group of answer choices views user-defined procedures authorization rules integrity controls | integrity controls |
| What is a transaction ACID property where in the database changes are permanent? Group of answer choices isolated consistent durable atomic | durable |
| UN exclusive lock is used when preparing to update. Group of answer choices True False | True |
| What is a software that is alternative to a proprietary software? Group of answer choices Microsoft SQL free open source Oracle | Open Source |
| Create an index when a column contains a wide range of values. Group of answer choices True False | True |
| An advantage of a view is that it ____ access to the data because it displays selected columns from the table. | RESTRICT |
| One advantage of a view is through district data access. Group of answer choices True False | False |
| What is a logically represented subset of data from one or more tables? Group of answer choices synonym index sequence table view | View |
| A row cannot be removed if there is a distinct keyword. Group of answer choices True False | True |
| There are one or more number of tables in complex views. Group of answer choices True False | True |
| You cannot remove a row if the view contains a group function. Group of answer choices True False | True |
| A sequence can be used to create a primary key value. Group of answer choices True False | True |
| A row cannot be removed if the view has a group by function. Group of answer choices True False | True |
| If a view has a WITH READ ONLY option, this means that any DML operations can occur in the view. Group of answer choices True False | True(Sa formative?) |
| PL/SQL enables you to handle exceptions efficiently Group of answer choices True False | True |
| What is an explicit numeric, character string, date, or Boolean value that is not represented by an identifier? Group of answer choices literal blocks functions non-PL/SQL variable | Literal |
| Only the TRUE and FALSE values can be assigned to a Boolean variable. Group of answer choices True False | False |
| LOBs are meant to store large amount of data. Group of answer choices True False | True |
| What symbol to use when making a single line comment on the code? Group of answer choices -- ! /* */ * | -- |
| What type of PL/SQL variable that contains internal elements that are either scalar or composite. Group of answer choices composite Large object(LOB) scalar reference | Composite |
| Which of the following code will assign a value of “Hello there” to a variable? Group of answer choices myName varchar2(100) assigned “Hello there”; myName varchar2(100) default “Hello there”; myName varchar2(100) default Hello there; | myName varchar2(100) default “Hello there”; |
| Special characters like $, _ and # can be included in naming variables. Group of answer choices True False | True |
| What are building blocks of any PL/SQL block? Group of answer choices lexical units block structure variables bind variables | Lexical Units |
| Variables are passed as parameters to PL/SQL subprograms. Group of answer choices True False | True |
| The DECODE and group functions are available when using procedural statements. Group of answer choices True False | False |
| multiple dissimilar data definitions that is caused by data integration problems or poor data value is a result of an ineffective data management Group of answer choices True False | True |
| A cold back up is a back-up facility wherein the database is shut down. Group of answer choices True False | True |
| Poor response time an excessive downtime could result to better data quality. Group of answer choices True False | False |
| What is the kind of recovery and restart procedure in which you can commit or abort all transaction changes? Group of answer choices rerun transaction integrity disk mirroring restore | transaction integrity |
| Data warehouse administration is similar to the database management administration roles Group of answer choices True False | True |
| The technical data administration is responsible for physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery. Group of answer choices True False | |
| The most common way of achieving serialization is locking mechanism. Group of answer choices True False | True |
| What is a mechanism for storing a database quickly inaccurately after a loss or damage? Group of answer choices database recovery integrity controls Triggers Functions | database recovery |
| A shared lock is used when just reading to prevent another user from placing an exclusive lock on the record. Group of answer choices True False | True |
| Installing or upgrading DBMS is one of the traditional database administration functions Group of answer choices True False | True |
| A hot backup is a backup facility wherein the system is or can still be available during back up. Group of answer choices True False | True |
| Passwords can be flawed wherein users share them with each other or they get written down or could be copied Group of answer choices True False | True |
| What is a security feature is database that sets domains, assertions and triggers to protect from unauthorized use? Group of answer choices views user-defined procedures authorization rules integrity controls | integrity controls |
| What is a transaction ACID property where in the database changes are permanent? Group of answer choices isolated consistent durable atomic | durable |
| UN exclusive lock is used when preparing to update. Group of answer choices True False | True |
| What is a software that is alternative to a proprietary software? Group of answer choices Microsoft SQL free open source Oracle | Oracle? |
| Create an index when a column contains a wide range of values. Group of answer choices True False | True |
| An advantage of a view is that it ____ access to the data because it displays selected columns from the table. | RESTRICT |
| One advantage of a view is through district data access. Group of answer choices True False | True |
| What is a logically represented subset of data from one or more tables? Group of answer choices synonym index sequence table view | View |
| A row cannot be removed if there is a distinct keyword. Group of answer choices True False | True |
| There are one or more number of tables in complex views. Group of answer choices True False | True |
| You cannot remove a row if the view contains a group function. Group of answer choices True False | True |
| A sequence can be used to create a primary key value. Group of answer choices True False | True |
| A row cannot be removed if the view has a group by function. Group of answer choices True False | True |
| If a view has a WITH READ ONLY option, this means that any DML operations can occur in the view. Group of answer choices True False | False(FORMATIVE IS CONFUSING) |
| PL/SQL enables you to handle exceptions efficiently Group of answer choices True False | True |
| What is an explicit numeric, character string, date, or Boolean value that is not represented by an identifier? Group of answer choices literal blocks functions non-PL/SQL variable | Literal |
| Only the TRUE and FALSE values can be assigned to a Boolean variable. Group of answer choices True False | FALSE(THERE IS NULL) |
| LOBs are meant to store large amount of data. Group of answer choices True False | True |
| What symbol to use when making a single line comment on the code? Group of answer choices -- ! /* */ * | -- |
| What type of PL/SQL variable that contains internal elements that are either scalar or composite. Group of answer choices composite Large object(LOB) scalar reference | Composite |
| Which of the following code will assign a value of “Hello there” to a variable? Group of answer choices myName varchar2(100) assigned “Hello there”; myName varchar2(100) default “Hello there”; myName varchar2(100) default Hello there; | myName varchar2(100) default “Hello there”; |
| Special characters like $, _ and # can be included in naming variables. Group of answer choices True False | True |
| What are building blocks of any PL/SQL block? Group of answer choices lexical units block structure variables bind variables | Lexical Units |
| Variables are passed as parameters to PL/SQL subprograms. Group of answer choices True False | True |
| The DECODE and group functions are available when using procedural statements. Group of answer choices True False | False |
| multiple dissimilar data definitions that is caused by data integration problems or poor data value is a result of an ineffective data management Group of answer choices True False | True |
| A cold back up is a back-up facility wherein the database is shut down. Group of answer choices True False | True |
| Poor response time an excessive downtime could result to better data quality. Group of answer choices True False | False |
| What is the kind of recovery and restart procedure in which you can commit or abort all transaction changes? Group of answer choices rerun transaction integrity disk mirroring restore | transaction integrity |
| Data warehouse administration is similar to the database management administration roles Group of answer choices True False | True |
| The technical data administration is responsible for physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery. Group of answer choices True False | True |
| Ineffective data management may result in poor data quality. Group of answer choices True False | True |
| What is an audit trail of transactions in database updates? Group of answer choices Integrity Control Back-up facility Journalizing facility Views | Journalizing facility |
| Synonyms are database objects that enable you to call a table by another name. Group of answer choices True False | True |
| Which among the following code will create a sequence that starts with 2, has highest value of 100 and has an increment of 2 Group of answer choices create sequence INC2 increment by 2 start with 2 maxvalue 100 nocache nocycle; | create sequence INC2 increment by 2 start with 2 maxvalue 100 nocache nocycle; |
| Create an index when an indexed column are referenced as part of an expression. Group of answer choices True False | False |
| When altering or modifying a sequence, the previous sequences are also affected. Group of answer choices True False | False |
| Caching sequence values in memory gives faster access to those values. Group of answer choices True False | True |
| Having more indexes on a table does not produce faster queries Group of answer choices True False | True |
| Which part of the block structure of PL/SQL you can find SQL statements or PL/SQL statements? Group of answer choices exception declare end begin | begin |
| DECLARE v_name varchar2(100); BEGIN v_name := 'Juan Dela Cruz'; dbms_output.put_line(v_name); END; Which part of the code assigns new values to variables? Group of answer choices Executable section Declarative section | Executable section |
| A variable name must start with a letter in PL/SQL. Group of answer choices True False | True |
| Special characters like $, _ and @ can be included in naming variables. Group of answer choices True False | True |
| Variables are used to hold the output of a PL/SQL subprograms. Group of answer choices True False | True |
| What are temporary storage of data in PL/SQL? Group of answer choices reusable data variables temp sorted data | Variables |
| A %TYPE is prefixed with either a database table or a column name. Group of answer choices True False | True |
| What is a data type conversion that converts values from one data type to another, and it is used in built-in function. Group of answer choices collaboration comparable conversion explicit conversion implicit conversion | explicit conversion |
| Scalar data types are also known as collections. Group of answer choices True False | False |
| The %Type attribute is used to declare variable according to a database column definition. Group of answer choices True False | True |
| A backward recovery is another term for rollback wherein it applies before images. Group of answer choices True False | True |
| inappropriate data sources and timing, causes lowered reliability therefore it is an ineffective data management. Group of answer choices True False | True |
| In locking mechanism, what is the type of lock that is read but no update is permitted. Group of answer choices common lock database locking level shared lock exclusive lock | Shared Lock |
| What is a transaction ACID property where in a transaction cannot be subdivided? Group of answer choices durable isolated consistent atomic | Atomic |
| What is a record of essential data for each transaction process against the database? Group of answer choices packet message control unit recorded message transaction log | transaction log |
| What is a database object that improves the performance of data retrieval queries? Group of answer choices sequence index view synonym table | index |
| Given the SQL statement to create a view: create or replace view as select count(salary) from employees where employee_id = 1900; Analyze what type of view it will generate. Choices: It will create a complex view. It will create a simple view. | It will create a complex view. |
| The pseudocolumn nextval must be issued for the sequence before CURRVAL contains a value. Group of answer choices True False | True |
| A row can be removed if there is a distinct keyword. Group of answer choices True False | False |
| Create view View1 (id,name) as select employee_id, last_name from employees where department_id = 90; , Group of answer choices it creates a view called view1 with 2 columns it creates a view called view1 with no columns | it creates a view called view1 with 2 columns |
| A simple view has only one number of table. Group of answer choices True False | True |
| Given the SQL statement to create a view: create or replace view as select sum(salary) from employees where employee_id = 1900 group by sum(salary); Group of answer choices It will create a simple view. It will create a complex view. | It will create a complex view. |
| In a PL/SQL block, the keywords DECLARE, BEGIN, and EXCEPTION are terminated by a semicolon. Group of answer choices True False | False |
| Bind variables are also called host variables. Group of answer choices True False | True |
| A variable name may or may not start with a letter in PL/SQL. Group of answer choices True False | False |
| The operations in an expression are performed in a particular order depending on their precedence. Group of answer choices True False | True |
| If you do not assign an initial value during declaration and initialization of the variables, the new variable contains NULL by default until you assign a value. Group of answer choices True False | True |
| What is a data type conversion that converts data types dynamically if they are mixed in a statement? Group of answer choices collaboration comparable conversion explicit conversion implicit conversion | implicit conversion |
| Which of the following code will assign the value 10 to a variable? Group of answer choices 10; 10; num1 numeric(11) : num1 numeric(11) 10; num1 varchar2(10) : num1 numeric(11); | ????? |
| In constant declarations, the CONSTANT keyword must precede the type specifier. Group of answer choices True False | True |
| A proprietary database management system has its source code available for anyone to modify. Group of answer choices True False | False |
| In an open source database management system, there is always an available documentation attached to it. Group of answer choices True False | False |
| An exclusive lock is used when just reading to prevent another user from placing an exclusive lock on the record. Group of answer choices True False | False |
| Whare are enforced database conditions in an integrity control security feature? Group of answer choices Domains Assertions Functions Triggers | Assertions |
| What is a transaction ACID property where in the database changes are not revealed to the users until after transaction has been completed? Group of answer choices atomic durable consisten isolated | Isolated |
| Open source software are less expensive than the proprietary packages Group of answer choices True False | True |
| Use the delete statement to delete a sequence. Group of answer choices True False | False |
| The pseudocolumn nextval returns the next available sequence value. It returns a unique value every time it is referenced, even for different users. Group of answer choices True False | True |
| If a view has a WITH READ ONLY option, this means that no DML operations can occur in the view. Group of answer choices True False | True |
| A row in a view cannot be modified if it contains a group function. Group of answer choices True False | True |
| A row in a view cannot be modified if it contains a group function. Group of answer choices True False | True |
| A PL/SQL program comprises one or more blocks Group of answer choices True False | True |
| Every PL/SQL variables has a data type, which specifies a storage format, constraints, and a valid range of values Group of answer choices True False | True |
| The bind variables are non PL/SQL variables. Group of answer choices True False | True |
| An image is represented as a BLOB in PL/SQL. Group of answer choices True False | True |
| Variables are reusable. Group of answer choices True False | True |
| The value 20000.08 represents a NUMBER data type with precision and scale. Group of answer choices True False | True |
| Which of the following code will declare and initialize a variable that accepts date datatype? Group of answer choices thisDate date thisDate date : sysdate; thisDate date : system; thisDate date : sysdate; 7; | |
| A programming guideline to make code maintenance easier in PL/SQL is documenting code with comments. Group of answer choices True False | True |
| Delimiters are simple or compound symbols that have special meaning in PL/SQL. Group of answer choices True False | True |
| An open source database management system has its source code available for anyone to modify. Group of answer choices True False | True |
| An example of an open source database management system is the mySQL Group of answer choices True False | True |
| Analyzing and designing databases is one of the traditional Database administration functions Group of answer choices True False | True |
| The technical data administration is responsible for the overall management of data resources in an organization, including data definitions and standards. Group of answer choices True False | True |
| Identify which among the following will create a view that is complex. CREATE OR REPLACE VIEW MYVIEW AS SELECT AVG(SALARY) FROM EMPLOYEES; CREATE OR REPLACE VIEW MYVIEW AS SELECT MIN(SALARY), MAX(SALARY) FROM EMPLOYEES GROUP BY MAX(SALARY); | CREATE OR REPLACE VIEW MYVIEW AS SELECT MIN(SALARY), MAX(SALARY) FROM EMPLOYEES GROUP BY MAX(SALARY); Mali sa Formative |
| A complex view contains ___ | FUNCTIONS |
| The pseudocolumn nextval obtains the current sequence value. Group of answer choices True False | False |
| Another event that can cause gaps in the sequence is a system crash. If the sequence caches values in memory, those values are lost if the system crashes. Group of answer choices True False | True |
| Exception handling is one the benefits of PL/SQL. Group of answer choices True False | True |
| What type of PL/SQL variable that are also called pointers. Group of answer choices composite reference scalar Large object(LOB) | reference, Large object(LOB) |
| PL/SQL variables include host language variables declared in pre-compiler programs, screen fields in Forms applications, and host variables. Group of answer choices True False | True |
| PL/SQL supports five data type categories--scalar, composite, reference, large object (LOB), and bind variables—that you can use to declare variables, constants, and pointers. Group of answer choices True False | False |
| What is a security feature in database that uses subset of the database that is presented to one or more users. Group of answer choices views integrity controls user-defined procedures authorization rules | views |
| What is a transaction ACID property where in Constraints do not change from before transaction to after transaction? Group of answer choices atomic consistent durable isolated | Consistent |
| Managing data security, privacy, and integrity is one of the traditional database administration functions Group of answer choices True False | True |
| Create an index only when the table is updated frequently. Group of answer choices True False | False |
| A simple view has the ___ operations | DML |
| ______ can be declared as either a procedure or as functions. Write in capital letters. | Subprograms? |
| In Oracle Database 11g, you can use the NEXTVAL and CURRVAL pseudo-columns in any PL/SQL context where an expression of NUMBER data type may legally appear. Group of answer choices True False | True |
| The exception section can contain nested blocks. Group of answer choices True False | True |
| LOB data types hold values, called locators, that specify the location of large objects (such as graphic images) that are stored outside the table. Group of answer choices True False | True |
| Selecting DBMS in software tools is one of the traditional database administration functions Group of answer choices True False | True |
| Troubleshooting and tuning database performance are traditional database administration functions Group of answer choices True False | True |
| The managerial data administration is responsible for physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery. Group of answer choices True False | False |
| A gap can occur when a rollback occurs when caching sequence values. Group of answer choices True False | True |
| A unique index is created automatically when you define a PRIMARY KEY or UNIQUE constraint in a table definition. Group of answer choices True False | True |
| The statement drop view viewname; is going to remove the view from the database. Group of answer choices True False | True |
| PL/SQL is not portable Group of answer choices True False | False |
| Variables are declared and initialized in the declarative section of a PL/SQL block. Group of answer choices True False | True |
| Initialized variables designated as NOT NULL and CONSTANT when declaring and initializing PL/SQL variables. Group of answer choices True False | True |
| Serializability is the process we're in A transaction is finished before starting another. Group of answer choices True False | False |
| What is a kind of recovery and restart procedure in which it can switch between identical copies of databases? Group of answer choices transaction integrity restore rerun disk mirroring | disk mirroring |
| What prevents inappropriate Actions, invoke special handling procedures, and write to log files? Group of answer choices Triggers Domains Functions Assertions | Triggers |
| A hot back up is a back-up facility wherein the database is shut down. Group of answer choices True False | False |
| What is a database object that generates numeric values. Group of answer choices sequence table index view synonym | sequence |
| Given the SQL statement to create a view: create or replace view as select first_name, last_name from employees where employee_id = 1900; Analyze what type of view it will generate. | It will create a simple view. |
| Users can create nonunique indexes on columns to speed up access to the rows. Group of answer choices True False | True |
| PL/SQL blocks can be entirely separated or ___ within another block. | nested |
| A value of TRUE represents a DATE value. Group of answer choices True False | False |
Created by:
user-1776272