Other IT & Programming Subjects
Oracle
What is the purpose of the Rollback command?
Explanation:
Bin function converts integer to binary string. Syntax: bin(integer). Example: bin(10) returns '0b1010'. 0b prefix indicates binary. Negative: '-0b...'. Base-2 representation.
In business, what is the most common definition for ERP?
Explanation:
Int function converts to integer. Syntax: int(value, base=10). Example: int('10', 2) returns 2. Truncates floats. Base for string conversion. Integer conversion.
What is true about this set of statements? CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT;
Explanation:
Help function displays documentation. Syntax: help(object). Example: help(str.split). Shows docstrings. Interactive helper. Pager for long docs. Documentation viewer.
In business, what is the most common definition for CRM?
Explanation:
Ascii function returns ASCII string representation. Syntax: ascii(object). Example: ascii('café') returns "'caf\xe9'". Escapes non-ASCII characters. Like repr() but ASCII-only. Safe string representation.
What is the number of user defined triggers in Oracle?
Explanation:
Dictionary setdefault() atomically gets or creates. Example: counts.setdefault(word, 0) returns existing value or sets and returns 0. Single operation. Alternative to if-else. Atomic get-or-set.
The basic units that make up a PL/SQL are called:
Explanation:
Dictionary update() merges dictionaries. Example: d1.update(d2) adds d2's items to d1. Existing keys overwritten. In-place modification. Python 3.9+: d1 | d2 creates new merged dict. Merging dictionaries.
In terms of Oracle, what is the most common meaning of OEM?
Explanation:
Divmod function returns quotient and remainder. Syntax: divmod(a, b). Example: divmod(10, 3) returns (3, 1). Equivalent to (a//b, a%b). Single operation. Combined division operation.
What is the definition of data buffer cache?
Explanation:
Tuple function creates tuple. Syntax: tuple(iterable). Example: tuple([1,2,3]) returns (1,2,3). Immutable sequence. Empty: tuple(). Tuple constructor.
What is Extended Rowid?
Explanation:
String join() called on separator. Example: ','.join(['a','b','c']) returns 'a,b,c'. Common mistake: list.join(','). Separator is method caller. Join pattern convention.
Which one of the following is not a DDL (Data Definition Language) command?
Explanation:
Bytes function creates immutable byte sequence. Syntax: bytes(source, encoding). Example: bytes('hello', 'utf-8') or bytes([65,66,67]). Immutable like tuple. Binary data.
The IN operator is used when you are using a subquery which returns more than one record. What is the operator used in a correlated subquery?
Explanation:
Property function creates property attribute. Syntax: property(fget, fset, fdel, doc). Example: name = property(get_name, set_name). Decorator form more common: @property. Managed attribute.
Which DATETIME data types cannot be used when specifying column definitions?
Explanation:
Dictionary items() returns view object. Example: d.items() returns dict_items. Dynamic: reflects dict changes. Iterate for key-value pairs: for k, v in d.items():. View not list.
Filter by Difficulty
Difficulty Filter
Sign in to unlock
Sign in to unlock